You’re offline. This is a read only version of the page.
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
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.
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (