2,395
Hi all, we use FIFO perpetual, what would it happens if I make an inventory transaction to decrease the qty for a part number, would all the transaction be on the same cost or it would respect the different costs that it was received at?
*This post is locked for comments
Hey Mahmoud,
I was aware of how the inventory adjustments work in this regard, but I have a different issue that I'm wondering if you know of a workaround. My client is using FIFO perpetual, and we have a scenario where they received some inventory in at a higher cost before realizing it should have been lower. If they want to adjust those specific items without impacting previously received inventory or other FIFO layers, what options do they have? As you said, if they do a simple inventory adjustment it will withdraw the first cost layers first. We want to adjust only the latest cost layer, or even a layer somewhere in between.
The only thing I could think of is doing a Purchasing Return to return the inventory received on the specific PO at the wrong price. I'm thinking that will ensure that the correct cost layer and items are removed. Then cut a new PO and receive the inventory in at the correct cost. Do you see any issues with this method or have any ideas of another way to accomplish this?
Thank you in advance for your advice.
Tanner Ties
Thanks again Mahmoud.
Best regards.
With FIFO Perpetual, when an adjustment out is posted, the unit cost will be as per cost layers were received (first cost layers will be withdrawn first). Consider the following reference for further illustration on the FIFO valuation method;
It will use the FIFO costs for the decrease adjustment. This is the case any time inventory is decremented - the system uses the valuation method to determine the total value of the transaction.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (