How to clear Hash Orders in Sage 200


Have you seen a order number in the system that looks like this, ###45645154651 ?

If so then it looks as if that order has been hashed. Hash Orders in Sage 200 generally occur if the system has not been able to save the order correctly.

As a result, it is unable to produce an order number so it supplies the hash number instead.

You may find it in some workspace screens or reports but not on your Sales List view, and often it’s holding on to an allocation of stock that is needed elsewhere.

These Hash Orders in Sage 200 can cause a headache when trying to get stock out of the door quickly, so find out how to get them out of the way!

What is a hash order?

Sage 200 creates a hash number for orders when they are in the middle of being created, this is then changed to a normal order number when saved. Allowing any allocations of stock to be given a reference in the stock item history before a real order number is created. If the sales order is not saved properly then the sales order and stock allocations remain in limbo with this hash order number.

Clearing a hash order

You can clear a hash order number from your Sage 200 system.

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.

Published by ctayts

My name is Craig Taylor and I am currently the Implementations Manager at Smith Cooper System Partners, based in Derby. My responsibilities include Pre-sales support, Project Management, Internal/External Project Handovers, Scoping, Installations, Training, Configuration, Data migration and ongoing support assistance. I have implemented Sage 200/MMS for over 10 years, including new installations and upgrades (including from Line 100 and Sage 50). My Sage 200 Accreditations include: Financials Commercials Bill of Materials Project Accounting Web Time & Expenses (WTE) Manufacturing Business Intelligence Installation Report Designer I also have a decent knowledge of other Sage products: Sage CRM Sage 50 Sage Financial Forecasting Aswell as the following Sage 200 add-ons: Spindle Professional (Draycir) Spindle Professional Document Capture (Draycir) Credit Hound (Draycir) Data Exchange (Eureka Solutions) Plus Pack for Sage 200 (Eureka Solutions) Sales Order Plus (Eureka Solutions) Purchase Order Plus (Eureka Solutions) Sales Ledger Head Office (Eureka Solutions) Stock Kitting (Eureka Solutions) Sicon Document Manager (Sicon) Sicon Enhancement Pack (Sicon) Sicon Fixed Assets (Sicon)

Leave a comment