Use Case
User wants to get a list of lot numbers that are on hand as of a specified date.
Using the Inventory Valuation Report, you can add the Transaction Serial/Lot Numbers under the Quantity On Hand folder.
However, this would show like this on the report:
If there is more than lot number in the transaction, it would be presented in only one line which is separated by commas.
This is a known system limitation and there are some existing Enhancements related to this:
- Enhancement 74661: Lot Tracking - We need a report that displays Lot Numbers and the Current On HAnd Count for that number on a specified past date.
- Enhancement 133646: Inventory/Items> Inventory Valuation Detail: add a column for Serial/Lot Numbers to track movements for each lot/serial number.
- Enhancement 118755: Reports > Inventory Report > Customize > add a column to show serial numbers. The Serial Numbers should appear vertically and not separated by comma.
- Enhancement 130881: When running a physical inventory report you can set 'as of date' for on hand quantities. To be able to run the same report 'as of date' snapshot for lot numbers. Currently it only shows realtime quantities for lot numbers.
Workaround
As a workaround, you can create a Transaction Saved Search:
Note: You can also add other fields (such as Location) if necessary.
Basically, what this saved search does is it sums the quantity of all the posting transactions which used the Lot Number during the period.
Doing this should show which Lot Numbers were on hand as of the specified date.
-----
If you find this information useful, let us know by reacting or commenting on this post!