80
i got sales transaction lines aren’t allowing me to close/ cancel. – The orders don’t reference a customer, or a user to enter either. When I attempt to open the sales document it notes them as history, but when searching sales transaction inquiry, they’re in the unposted area. any ideas on how to close them please ??
Thanks
can you please let me know how i can remove ORD sale document from SQL ??
I think you are saying that you have a SOP document that is showing in work not history when you search for it or items on it. However when you try to actually go into the order to edit it, the order complains that it is already posted. You are also noting that the header record has missing key fields.
This happens when a client machine crashes or disconnects after creating an order and lines but before saving the full header record. It is now a corrupted order.
You may choose another header record and copy the information using SQL from a good header record in to the fields of the bad header record, this will allow you to access the order in order to delete the items, then void or delete the order.
I do not recommend processing that order any further as it has been damaged and will be unpredictable.
Alternatively you can delete the order using SQL but you will need to reconcile your inventory to correct the qtys for the deleted records.
Tim.
yes i am using dynamics GP
Thank you
what do you mean by which application ? those sales orders are appearing on the smartlist
Thanks
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...
290,558
Super User 2024 Season 2
#2
Martin Dráb
228,645
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (