Inventory Valuation by Lot Number

nav13

Is there a standard NAV 2013 report that will display on hand inventory quantities with lot number and lot unit cost from an "as of date"? This report is necessary to help reconcile month end inventory.

Thanks,
NAV 2013

Alex_Chow

<edit>

davmac1

In Classic, the inventory valuation report had a hidden detail section you could turn on, and report by item ledger entry.
In NAV 2013, it is in the dataset, but not in the report layout.
Because it is in the dataset, you can run the report, do a help about this report, and export the results to Excel, where you can sort and sum by lot no.
Take a look at this and see if it gives you the results you want.