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) / Inventory Transfer for...
Microsoft Dynamics GP (Archived)

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

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • 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
  • Community Member Profile Picture
    Community Member 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

    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,

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