Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

unallocate items?

Posted on by 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

  • 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,

  • 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?

  • 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?

    that table shows the items in stock and allocated?

  • 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?

  • 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.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans