Notifications
Announcements
No record found.
Where does GP pull the current cost from? We have a cost that is incorrect. All manufacturing batches look fine. We use FIFO perpetual. We do have negative inventory.
*This post is locked for comments
The current cost can also come your last PO invoice match receipt or someone can simply enter the cost.
The current cost on the item card is set everytime the quantity on hand goes up. The cost that was used on the transaction that made the quantity go up is the current cost. Remember that GP rounds goofy and you may get a last cost that is for 1 item that is very wrong.
Consider PO Receipt (could be a work order / assembly order) for an item with two decimal precision;
Quantity Received = 80
Cost = 125
That is a unit cost of 1.5625. Ahh but says GP you have two decimal precision on this item so you really have
79 @ 1.56 and 1 @ 1.56 + 79 X .0025 = 1.76
Being the last one to come in the current cost becomes 1.76, which is clearly wrong, but how GP works.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1
