If you’ve ever seen an order number in your Sage 200 system that looks like this, ###45645154651, then it looks as if the order has been hashed.
These Hash Orders can cause a headache when trying to get stock out of the door quickly.
That’s why in this Tip of the Week, we show you how to clear hash orders in Sage 200.
Additionally, you can watch the short video here to help better your understanding.
What is a Hash Order?
In Sage 200, hash orders are temporary order records created when a sales order is in the process of being saved. The system assigns a placeholder “hash” number until a full order number is generated. This allows any stock allocations to be tracked in the meantime.
However, if something goes wrong—like a crash or a disconnect—the order may not save correctly. This leaves the hash order stuck in the system, sometimes still holding on to stock allocations, even though it doesn’t appear in your Sales Orders List. You might see it in workspaces or reports, but it won’t behave like a proper order.
How to Clear a Hash Order
Go to Sales Order Processing > Enquiries > Sales Document Status.
This will open a new workspace – this is the only place within Sage that you can view and amend the hash orders.
To locate the hash order number, click on the document number column header to sort the column into document number order.
Right click on the affected line and go to Actions > Sales Orders > Amend Order Status
A new window will pop up where you can click ‘Cancel Order’.
Any active orders with hash numbers which are currently being worked on will also show in this workspace.
If you try to cancel one of these by mistake the system will not let you, a message will be returned explaining that another user is accessing the order.
If you run into any of the following issues:
- You’re unsure how to clear disconnected logins
- The hash order doesn’t appear in the workspace
- The workspace fails to load
- You don’t have the correct permissions to access the workspace or cancel the order
please don’t hesitate to contact our support team at sagesupport@pkfscs.co.uk.
To stay in the loop about our latest tips, make sure you are following us on LinkedIn and Facebook!
