Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Unanswered

Allocated quantity

Posted on by 2

Good day,

A receipt was done for an item, which according to the system posted though. I am unable to invoice the item because it is saying 'qty allocated'. I am unable to view where it is allocated. I have run check links and reconcile but the scenario was not fixed. We use Field Service but the receipt was not done via In Transit.

I have run the scripts to view allocation as per module, didn't come up with any results.

The only other solution, I am thinking, is an update statement, but I am unsure what I am changing, am I just updating the allocated quantity per site to '0'

Regards

Rosemary

Categories:
  • Rosemary Profile Picture
    Rosemary 2 on at
    RE: Allocated quantity

    Thanks, maybe you can post the link.

    Regards

  • Joseph Markovich Profile Picture
    Joseph Markovich 3,863 on at
    RE: Allocated quantity

    Hi Rosemary!

    I remember reading a support document from Microsoft the order you should run reconcile when something is not right. 

    When I have to run reconcile about some data not being correct -- especially with inventory numbers or something like it, this is what I always do:

    First run reconcile on sales, then on purchasing, then finally inventory. They all touch inventory numbers, so better safe than sorry.

    Joe

  • Rosemary Profile Picture
    Rosemary 2 on at
    RE: Allocated quantity

    Thank you Richard for mentioning the SOP table, it appears the allocation was due to the invoice. I had initially only did the reconcile on Purchasing and Inventory. But when I did the Sales, it pulled the invoice number and cleared the allocated quantity.

    Regards

    Rosemary

  • Rosemary Profile Picture
    Rosemary 2 on at
    RE: Allocated quantity

    No problem, don't envy you guys.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Allocated quantity

    Sorry for the typo. We are in the middle of an ice storm and it is 12 degrees.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Allocated quantity

    The allocated quantity is in IV00102. That is what the Quantity/Site screen will display.  Running IV reconcile should fix this if there are no lines allocated in the sales order work tables.

  • Rosemary Profile Picture
    Rosemary 2 on at
    RE: Allocated quantity

    Thank you Richard for your response, but I am not seeing that field in IV00101. The Item number is there though in that table. Via item inquiry the item number is there 1 'on hand', 1 'allocated'.

    Regards

    Rosemary

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Allocated quantity

    It is most likely referring to IV00101.ATYALLOC having a value with no matching line in SOP10200. Pull up the item in GP and go to quantity/item. You will most like see a qty there.

    You can run item reconcile under GP Inventory Utilities to correct this.

  • Rosemary Profile Picture
    Rosemary 2 on at
    RE: Allocated quantity

    Good day,

    I ran an Item Reconcile from PSTL and received this message relative to the item number,

    'IV00102 has allocations with no matching detail', how do I work around this?

    What 'detail' is it referring to?

    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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,645 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans