Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Inventory Transfer for Type of return - zero quantity but has value

Posted on by Microsoft Employee

I have a client that is FIFO perpetual and did a number of transfers trying to get everything out of the Returns type in a given warehouse. They have two GL accounts with this item and one is showing a quantity of zero and a value of $24,102 and the other is showing a quantity of 1 and a value of ($24,000). The net of the two is a quantity of 1 and a value of $102 which is correct. Any ideas on how to get the two together so there is one GL account with a quantity and the value of $102 to show on the Historical Inventory TB? Thanks!

*This post is locked for comments

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Inventory Transfer for Type of return - zero quantity but has value

    Any record with a quantity can be adjusted using the Inventory Cost Adjustment utility which can be reached from (Microsoft Dynamics GP > Tools > Utilities > Inventory > Adjust Cost)

    On the other hand, adjusting the records with the zero quantity and associated value on the HITB report can never be done from the application level, you will have to manipulate it on the database level.

    As a work around solution in your case, you can consider adjusting the record with the quantity of 1 to get the overall correct cost.

    Your feedback is highly appreciated,

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory Transfer for Type of return - zero quantity but has value

    Thanks for the quick reply - do you know of a way to adjust this within GP rather than doing a script?

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Inventory Transfer for Type of return - zero quantity but has value

    Hello Shiggins

    I have always dealt with such cases including a zero quantity with zero value, the resolution for me is to manually handle the HITB as compared to the inventory purchase receipt. The result of this is determined by the creation of a cost adjustment for an unreachable quantity, leaving a value with no associated quantity

    Here is a script on how to get this handled HITB Essentials Series – Zero Quantity and Negative/Positive Cost

    Your feedback is highly appreciated,

    HITB Essentials Series – Zero Quantity and Negative/Positive Cost - See more at: http://mahmoudsaadi.blogspot.com/2013/10/hitb-essentials-series-zero-quantity.html#sthash.AsqvdYNV.dpuf

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans