Inventory cost posting by lot

(0) Share

Report

Posted on by Samantha73

2,453

Hi All

I'm trying to get Item cost by LOT and tie it back to COGS. The system is setup with FIFO costing. Can I confirm that the system post FIFO irrespective of the actual LOT number selected in a transaction. For example:

If LOT1 is purchased $100 per unit and then Lot2 purchased $200 per unit. When you sell LOT2 it takes $100? as below example:

So the system ignores the actual cost of selected lot as this FIFO is only at Item level

All responses (5)

Answers (0)

Suggested answer

YUN ZHU 74,036 Super User 2024 Season 2 on at

Like (1)

Report

RE: Inventory cost posting by lot

Hi, I agree with Kim, can you confirm after running Adjust Cost - Item Entries? If there is a cost adjustment, new Value Entries will be added.

Hope this helps as well.

Thanks.

ZHU
Suggested answer

Dallefeld 11,425 User Group Leader on at

Like (0)

Report

RE: Inventory cost posting by lot

Please remember that the cost that posts with the transaction is always average (when using FIFO) and that when Adjust cost runs, the system then matches the FIFO layers. Can you run adjust cost on the above and do the results change?
Samantha73 2,453 on at

Like (0)

Report

RE: Inventory cost posting by lot

I think the issue in my example is that I have used Item Journal to take stock out and in that scenario item cost by LOT does not apply. In Sales Invoices it works
Suggested answer

Manan_Shah 1,457 on at

Like (2)

Report

RE: Inventory cost posting by lot

Hi Samantha,

Please check below attach link for more info on Lot Specific Costing.

https://www.inecta.com/dynamics-365-business-central-item-costing-part-17

Hope this will help.

Many Thanks,
Manan
Suggested answer

DAnny3211 9,272 Super User 2024 Season 1 on at

Like (0)

Report

RE: Inventory cost posting by lot

hi

look this

community.dynamics.com/.../inventory-valuation---costing-method-fifo

DANiele