[jwenzer]

I am sure this topic is covered elsewhere, but how can we create a serialized inventory valuation report as of a certain date (end of the year) that also shows the serial numbers of the item that were on hand at that time?
This is a cached copy. Click here to see the original post.

[JayJ]

RE: Serialized Inventory Valuation As Of Report

We’d love to have one for lot-numbered inventory like that. I think there’s an enhancement request in for this already?

[ecacho]

You can customize Inventory Valuation report. Please try the steps below:

1. Reports > Inventory/Items > Inventory Valuation > Customize Detail

2. On the Edit Columns page:

— Open the Inventory Item group/folder

— Click Serial/Lot Numbers and this will be added as a column

3. On the Filters page

— Open the Inventory Item group/folder

— Select Is Serialized Item and set the filter equal to True

4. Save and run the report

[Author]

Posts