1. Navigate to Lists > Search > Saved Searches > New
2. Select Transaction
3. In the Criteria tab > set the following:
--Posting = is Yes
--Main Line = is False
--Account = Select the appropriate Inventory Asset Account(s)
--Location = Select the appropriate Location
--Date = is on or before (select specific date)
4. Click Results tab > set the following:
--Item > Summary Type = Group
--Quantity > Summary Type = Sum
--Amount > Summary Type = Sum
5. Rename Search Title
6. Click Save & Run
7. Run an Inventory Valuation Report by following the steps below:
--Navigate to Reports > Inventory/Items > Inventory Valuation > Customize Detail
--In the Edit Columns > Highlight the Qty column > mark the Add Running Balance checkbox
--Click Filters > Select the Date Range (similar to the date range in the Saved Search)
--Then set Location > Select specific Location (same as Location set in the search builder)
--Enter Name for the report
--Click Save
8. Lastly, notice that Quantity between the report and the Saved Search are the same.
Related enhancement request is Enhancement 175902.
No comments:
Post a Comment