web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Item Allocation Inquiry
Finance | Project Operations, Human Resources, ...
Answered

Item Allocation Inquiry

(0) ShareShare
ReportReport
Posted on by rcr123 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

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    Becky Berginski Profile Picture
    Becky Berginski on at

    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

  • Verified answer
    StefanieC Profile Picture
    StefanieC 434 on at

    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.

  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 933 Super User 2025 Season 2 on at

    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.

  • rcr123 Profile Picture
    rcr123 7,986 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 646 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans