Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Quantity Allocated issue
Microsoft Dynamics GP (Archived)

Quantity Allocated issue

(0) ShareShare
ReportReport
Posted on by Aaron Back 455

I have a user trying to do an Item Transfer Entry. The Qty on Hand shows 98 are available. But, the system prompts with a message, "The quantity entered is greater than the quantity available." After looking into this, it is showing that there is a Qty Allocated of 5, but when you click the Allocated link to show the allocated items, there is nothing allocated.

How do I fix this without running a Reconcile? This will require the users exiting GP which means shutting down many parts of our company because users cannot work.

What is the solution? It would great if there was a simple SQL Script solution.

Please Help!!!

*This post is locked for comments

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Quantity Allocated issue

    Hi,

    You might also run the PSTL reconcile. PSTL is free and is faster.

    If you want to do it from SQL, I think the only tables that have that field are the ones listed below. When I have had an allocation problem that reconcile didn't fix, I have just modified the IV00102, IV00112 and IV00300 tables. You might not need to adjust anything beyond the IV00102 table, it just depends on what modules you have running.

    Whatever you do BACKUP YOUR COMPANY DATABASE before doing ANY adjustments via SQL.

    BM10300

    IV00102

    IV00112

    IV00300

    IVC10101

    IVC30102

    SOP10200

    SOP30300

    SVC00203

    SVC00502

    SVC00710

    SVC06101

    SVC30203

    Kind regards,

    Leslie

  • Suggested answer
    Zhigang Lu Profile Picture
    Zhigang Lu 795 on at
    RE: Quantity Allocated issue

    I had the same issue before and I repeated to reconcile 2-3 times for that item. Finally it is fixed.

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: Quantity Allocated issue

    Are you comfortable working in SQL?

    I have a script that shows all records in all tables that contribute to the allocation.  Email me at rwhaley@accoladepublications.com and I will send you a copy.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Quantity Allocated issue

    hi ,

    I have the same issue and I tried to reconcile the Inventory and nothing Happened , still have the Quantity Allocated

    So Please help me

  • Dan Liebl Profile Picture
    Dan Liebl 7,320 on at
    Re: Quantity Allocated issue

    I agree with Heather on the reconcile.  Depending on how many modules you use, this could be many tables.    Cleaning up allocations via SQL is dangerous as it is easy to miss a table.   Let's start with what modules do you use that involve IV?  Mfg, Field Service, Project, any ISV's?  

    Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com

  • veeyeskay Profile Picture
    veeyeskay on at
    Re: Quantity Allocated issue

    Aaron

    There is also a Inventory reconcile in the Project Accounting module under Tools >> Utilities >> Projects >> PA Reconcile IV. Try running that and see if it fixes the problem.

    Let us know if you need further assistance.

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,142 on at
    Re: Quantity Allocated issue

    I personally would only ever try and fix with a reconcile.  You can just do a reconcile on the one item which would probably mean all users out for about 5 - 10 mins.

    Do you ever run reconcile on the inventory system?  It is certainly a process that should be run before stocktakes.

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans