2,267
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
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?
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
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
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...
290,558
Super User 2024 Season 2
#2
Martin Dráb
228,647
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (