here’s a fun one on a Friday. If I use FIFO, and ...
# inventory
p
here’s a fun one on a Friday. If I use FIFO, and therefore have multiple FIFO layers for a given product (assume for funzies that every time I buy it the cost swings dramatically), then create a transfer order for that item with a quantity that crosses multiple FIFO layers, does NS MAINTAIN the FIFO layers for costing when I receive the product into the destination? Or does it just wash it all out as a receipt on date {today} for value as set in {transfer price}?
d
Cost is calculated at the Location level, so your cost layer from Location A is decremented and Location B's cost layer is incremented via Item Fulfillment and Item Receipt (Location B cost layer will reflect the IR transaction date).
for determining the actual cost value, if you have 'Use Item Cost as Transfer Cost' then the source location cost is transferred to the destination location. With this box unchecked, the destination location takes the 'Transfer Price' value
p
Okay, so based on the accounting preference the cost is either the transfer price or the original receipt price based on FIFO, but the action of receiving an inventory transfer order creates a NEW FIFO layer at that amount dated today? Do I have that right?
To be more specific, if I have two FIFO layers, quantity 10 $200 each (first) and quantity 20 $500 each (second) and then transfer 17 (so 10 from first layer and 7 from second) should I end up with 10 items costed at $200 and 7 at $500 OR 17 items costed at $323.53 (average cost of the 17 - (10*200+7*500)/17)? My testing is showing the latter….just wondering if I’m misinterpreting.
and then if I turn around and sell 5 after that receipt, my cost is $1617.65 whereas if I had just sold those 5 from the ORIGINAL location the cost would have been $1000….
something seems off there but I’m not an accountant….maybe that’s just how it’s supposed to work?
d
I havent seen this exact scenario but from what I can tell, the receiving location is going to average out the cost if you shipped/received all 17 units together in this example. The IR essentially treats the single line as as Amount / Quantity rather than respecting the originating Location's cost layers
it seems odd for this to be the case, though.
it is possible to fix cost layers with Inventory Adjustments, though. Likely not the most ideal workaround, but if you're in a pinch then it can hopefully make the accountants happy 🙃