Remove posted open orders that have $0 amount

(0) Share

Report

Posted on by Community Member

There are several open orders that have already been posted. They are all $0.00. What is the best way to get rid of these and deleted so they no longer show on our smartlist reports?

Thanks!

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Tristan Clores 2,812 on at

Like (0)

Report

Hi Joe,

Are you referring to SOP Sales Orders?

If you are, just wanted to point that they do not get posted. It's either you transfer them to a Sales Invoice or Sales Backorders.

Sales Orders, once fully transferred (all quantities of each line items in the transaction) should automatically move to History. If they don't (for some reason), you can run the Reconcile - Remove Sales Document (Remove Completed Documents option). The report generated should give you an idea if the Sales Order was moved to History.

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

Better use filter in Smartlist with Order Amount <> 0.00. This will not give you the report for $0.00 amount orders.

Hope this helps!!!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Tristan - The reconcile - remove sales document option did not work. It appears that they somehow got posted with no customer listed and there is no option to try and transfer to an invoice. The document date is even 0/0/0000. When i go to sales order fufillment it says that it has already been posted.

Was this reply helpful? Yes No
Suggested answer

Richard Whaley 25,195 on at

Like (0)

Report

These are corrupt records in the tables. When you start to create a sales document, the system writes a record with the document number and almost nothing else to the tables. If you properly cancel out of the document, this record is removed. If you properly complete the transaction, the record is updated. If your workstation crashes or is closed down with a new sales order document number on the Sales Transaction Entry window, you will get these entries.

IF YOU KNOW SQL, you can simply go to the proper SOP table (SOP10100) and delete these specific lines. Make sure to do a backup first, make sure no on else is on the system, and be careful. If you are not comfortable using the SQL Management Studio, call IT or your GP support team.

Was this reply helpful? Yes No