Customize the Inventory Valuation report and add a column to show the valuation per lot number, but don’t see this column available.
Answer:
The reason why you aren’t seeing any column to show the valuation per lot number is because it is a current system limitation, thus a standard behavior in the system.
This is currently an enhancement request logged on the following enhancements:
- Enhancement # 375203 Inventory Number Search > Ability to Display Inventory Value per Lot Number per Location
- Enhancement # 133646 Report> Inventory/Items> Inventory Valuation Detail: add a column for Serial/Lot Numbers and filter it by location – shows serial/lot numbers on all location.