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

(0) Share

Report

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

All responses (3)

Answers (0)

Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 32,738 on at

Like (0)

Report

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