You’re offline. This is a read only version of the page.
7,986
Good day,
I have an unposted SOP document where there is no customer number, name, just the SOP number and the item numbers. I did a check links and reconcile on Sales and Inventory.
From the Sales Transaction work table abandoned records were deleted, but if I go to the item inquiry, in the item allocation inquiry window and search one of the items the document number is being referenced but if I try to drill down it says the document has been removed from Sales Order Processing.
The item numbers did not show up on the Inventory reconcile report.
Physically we have this quantity as per item, allocated to actual SOP document that was messed up. I am going to run another check links and reconcile again on SOP and Inventory and see what happens.
Has anyone seen this issue where even though the document has been removed the allocation is still there.
Regards
Rosemary
Thank you for your response, and yes the document was in the SOP10200 table. I did over the check links and reconcile, Sales first and then Inventory, that cleared the allocation and also removed the problem SOP document.
Thanks again for your assistance.
Regards
I believe you need to remove the invalid data from the SOP unposted tables via SQL. If you are comfortable with SQL and the GP table structures, you'll want to concentrate on the data in the SOP10100 and SOP10200 tables. Verify if you have a valid backup, run the SQL cleanup scripts to remove the invalid data and then run Check Links (Sales Work) and Item Reconcile to get things re-calculated.
Expect some Check Links messages related to the document(s) your SQL script deleted.
As Becky noted, reconcile will most likely fix this. I will add that Inventory Reconcile is the one reconcile I try to make sure to do every month before closing. The item quantities, especially allocations, get off more often than other areas in GP. If you have users who insert or delete rows in SOP and POP documents, that is one way it can happen. If your inventory reconcile takes a long time, I recommend checking out the PSTL version as it will be much faster.
Hello Rosemary,
You will need to verify the SOP document is no longer in the SOP10200, and then run an Inventory Reconcile for the items.
Becky
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 (