Period Inventory Valuation Report with Lot & Serial Numbers
Summary:
Our Finance/Costing team requires a Period Inventory Valuation Report that includes lot and serial numbers. However, the standard out-of-the-box report does not provide this information.
We attempted to build a custom report but were unable to find a table that captures a snapshot of quantity, lot, and serial number for a specific period. We explored the INV_UNIT_TRANSACTIONS table, but the query runs for hours without yielding results. Additionally, the INV_SERIAL_NUMBERS table does not provide the desired output.
Could you please advise on the correct table(s) to use for generating this report efficiently?
Content (please ensure you mask any confidential information):
0