Inventory cost posting by lot

(0) Share

Report

Posted on by Samantha73

3,197

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

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

DAnny3211 11,382 on at

Like (0)

Report

RE: Inventory cost posting by lot

hi

look this

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

DANiele

Was this reply helpful? Yes No
Suggested answer

Manan_Shah 1,459 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

Was this reply helpful? Yes No
Samantha73 3,197 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

Was this reply helpful? Yes No
Suggested answer

Dallefeld 193 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?

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 93,208 Super User 2025 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

Was this reply helpful? Yes No