Scenario:
The user wanted to view inventory stock ledger information on a per lot number basis, including quantities and values tied to specific lots. Attempts to customize the Stock Ledger report by adding the Serial/Lot Number field did not work as expected because the report displayed all associated lot numbers for the item and did not support filtering by a specific lot number.
Solution:
Currently, NetSuite does not provide a native report that fully tracks inventory quantities and values by lot number for historical dates.
At this time:
- The Stock Ledger report does not support true lot-level historical valuation reporting
- No standard report can display lot number quantities for a specified past date
- Lot-based quantity reporting is only available for current on-hand inventory levels
This limitation is currently tracked under:
Enhancement Request 74661
Lot Tracking - Report displaying Lot Numbers and Current On Hand Count for a specified past date
As a workaround, users can create a saved search based on the Inventory Number record to review current lot-level inventory balances.
To create the saved search:
- Navigate to:
Transactions > Management > Saved Searches > New - Select search type:
Inventory Number - In the Results tab, add the following columns:
- Item
- Number
- On Hand
- Available
- Location (optional)
- Save and run the search.
Important Notes:
- This workaround only supports real-time/current on-hand quantities
- Historical lot balances for past dates are not currently supported through standard reporting
- Additional customization or external reporting solutions may be required for historical lot-level inventory valuation analysis.