Share
ReportAn SO is in SOP10200 but not SOP10100, will the Reconcile - Remove Sales Documents take care of this or is there another reconcile that will?
*This post is locked for comments
You’re offline. This is a read only version of the page.
An SO is in SOP10200 but not SOP10100, will the Reconcile - Remove Sales Documents take care of this or is there another reconcile that will?
*This post is locked for comments
Thank you for your interest Richard
You are truly an MVP, I was just about to say it was a crazy idea to try and create the header but decided to try it first. I just went to the sales transaction entry window, created the SO, and the line items appeared. In this case I simply voided the transaction as they have already replaced it. Great advice.
My question would be was this ever a valid order? Was it ever turned into an invoice? Did someone not receive their order? Either way will work. If you can add the sales order header and then delete or void the order then Inventory Reconcile would not be needed. Now the bigger question may be what else is missing? Were there other lines that are not there as well?
I don't see it when I do an inquiry of sales documents. It is not in the historic sales tables. It is actually similar to a situation we had before where inventory is allocated to this SO but attempting to view the SO from the allocation results in this message: "This document has been removed from sales order processing." We followed the advice here from R1012 to check links then inventory reconcile and it worked that time. The exception in this case is that I don't think the SO was missing from SOP10100 that time. We may need to "delete the lines using SQL" as Becky advised for this one.
Did this sales order get into sales order history? If you do Inquiry->Sales->Sales->Sales Documents do you see it. You try to enter the SOP header again, save it and then pull it up to see if you can now see the lines with the header. Depending on what has to be done you could delete or void this sales order or use Utilities->Sales->Remove Sales Documents to get it into history.
Thank you for using Community Forums. My name is Becky and I will assist you.
If you are missing a line in the SOP10100 but have lines in the SOP10200, I do not believe that the Reconcile-Remove Sales document will insert the missing record. My suggestion would be to delete the lines using SQL and then run an Inventory Reconcile to remove any allocations associated with the phantom sales document.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (