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 / Microsoft Dynamics GP forum (Archive) / Item Allocation Inquiry
Microsoft Dynamics GP forum (Archive)
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:
Distribution
  • rcr123 Profile Picture
    rcr123 7,986 on at
    RE: Item Allocation Inquiry

    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

  • Verified answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 2,976 on at
    RE: Item Allocation Inquiry

    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.

  • Verified answer
    StefanieC Profile Picture
    StefanieC 432 on at
    RE: Item Allocation Inquiry

    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
    Becky Berginski Profile Picture
    Becky Berginski on at
    RE: Item Allocation Inquiry

    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

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

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

more Community News

Leaderboard > Microsoft Dynamics GP forum (Archive)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans