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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / unallocate items?
Microsoft Dynamics GP (Archived)

unallocate items?

(0) ShareShare
ReportReport
Posted on by Tami Farrelly 5,080

We have an issue where an invoice was entered with several lines and for some reason would not post....so user deleted to try again...although cannot attach the items as they show allocated?

I need to remove the allocation...reconcile and check links have no worked (test database)

Any suggestions....what tables should I be looking at?

tami

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: unallocate items?

    It seems you have tried the inventory reconcile solely, right ? If yes, please ensure to apply the reconcile in order: Sales then Inventory

    One question though, when you go to the "Item Inquiry", and click on the value beside "Allocated", any corresponding documents in the "Item Allocation Inquiry" ?

    The allocation is stored under a calculated field in IV00102 (ATYALLOC), this is the same number the shows on the "Item Inquiry" window. Although, on the reconcile, Dynamics GP will recalculates the allocated quantity and update this field accordingly.

    Your feedback is highly appreciated.

  • Tami Farrelly Profile Picture
    Tami Farrelly 5,080 on at
    RE: unallocate items?

    Item inquiry shows items allocated...but no document associated with the allocation?

  • Tami Farrelly Profile Picture
    Tami Farrelly 5,080 on at
    RE: unallocate items?

    that table shows the items in stock and allocated?

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: unallocate items?

    It shows all quantity types, from which the "Item Inquiry" retrieves data.

  • Tami Farrelly Profile Picture
    Tami Farrelly 5,080 on at
    RE: unallocate items?

    It is improperly allocated...how do I fix it?

    It is not allocated to any document?

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: unallocate items?

    As long as you are working on  "Test Environment". You could go through the following steps in order;

    • Run the following update statement on IV00102, to put the correct allocated Quantity Value as below
      • UPDATE IV00102
        SET ATYALLOC = Correct_Allocated_Value
        WHERE ITEMNMBR = '#ItemNumber' AND LOCNCODE = '#LocationCode'
    • Now, run a reconcile on this item specifically, and check the reconciliation report.
      • If the report rolled back to the original "incorrect" allocated quantity, then there must be a record (not necessarily saved, it could be corrupted)
      • If the report didn't rolled back the allocated quantity to the one before update, then you are just fine.
    • Proceeding with the first scenario above (if the reconciliation rolled back the update), then you need to check the work tables, in your case, you suspect a sales invoice, therefore, check the SOP10100 and SOP10200 by running the following script;
      • SELECT * FROM SOP10100 AS A
        LEFT OUTER JOIN SOP10200 AS B
        ON  A.SOPNUMBE = B.SOPNUMBE AND
            A.SOPTYPE  = B.SOPTYPE
        WHERE B.ITEMNMBR = '#ItemNumber'
    • If any documents are retrieved including this item number (check the following fields, QUANTITY, ATYALLOC for this item) then you got to deal with this document, as it could be one of the documents causing the "incorrect" allocation on this item number.

    Hope this helps,

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans