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
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,
Thanks for the quick reply - do you know of a way to adjust this within GP rather than doing a script?
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,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156