How To: Running the Inventory Valuation Report (03-63)
Overview
This tutorial describes how to run the Inventory Valuation Report (03-63).
Step-by-Step
- From the ‘Region’ drop-down list, select a region for the report. Select ‘All’ to include all regions.
NOTE: If a region is selected, the report will automatically be sorted ‘By Region’.
- Select a branch for the report from the ‘Store’ drop-down list. Select ‘All’ to include data from all branches on the report.
NOTE: If a branch is selected, the report will automatically be sorted ‘By Branch’.
- From the ‘Brand’ drop-down list, select a brand for the report. Select ‘All’ to include data from all brands on the report.
- In the ‘Beg Dept’ field, select the department to start the report with. Select ‘All’ to start the report with the first department on file.
- In the ‘End Dept’ field, select the department to end the report with. Select ‘All’ to end the report with the last department on file.
- To filter the report by Priority Flag, enter a priority flag in the ‘Priorities’ field.
NOTE: Priority codes are assigned to items in Field 8 of Inventory Master File Inq/Maint (03-01).
- Select whether you want to sort the report ‘By Company’, ‘By Region’, or ‘By Branch.’
- Check the boxes next to the inventory type(s) you want to include on the report. Each inventory type appears on its own tab on the screen and on a separate section of the report:
When this box is checked, a tab labeled ‘InShipping’ also displays on the report. It includes all items that are on shipped, but not updated orders in Order Processing (orders with a status of ‘2,’ ‘4,’ or ‘5’). For these items, quantity onhand has been reduced, but the customer has not received them.
If this box is checked and the ‘Regular Stock’ box is unchecked, Floor/Damaged quantities appear on a separate tab labeled ‘Floor/Dam,’ and are printed on a separate section of the report.
Special Order items are products that you normally do not stock, and are ordered for a customer on a one-time basis.
Trade Ins are items that your company purchases from a customer. Most of the time these are used items, which you may or may not decide to resell. Trade in items have a ‘T’ in the ‘Floor Plan’ field (Field 7) of Inventory Master File Inq/Maint (03-01). Please see the ‘Accepting a Trade In’ tutorial for more information.
Items are loaned to a customer using Loaner Processing.
Installed items appear on a tab labeled ‘Installed.’
Onhand parts inventory appears on a tab labeled ‘Service Parts.’
Unreturned cores that are not included in installed parts, appear on a tab labeled ‘Cores.’
This valuation is based on Vendor Price and can be used for Month End processing rather than the Negative Qty On Hand report (03-67).
- Click ‘Refresh.’ The report displays. Tabs appear for the inventory types you selected, as well as a Company Summary tab.
- Click the ‘Print’ button to print a paper or digital copy of the report (optional). At the prompt, enter the ID of a physical printer, or enter “PDF” to save the report to a PDF file.
IMPORTANT: When printing to PDF, you must have a ‘Miscellaneous’ folder specified in Company PDF/Export Directory (30-04) or By Term PDF/Export Directory (30-05) in order for the PDF to save successfully to your computer.
- Click ‘Export Excel’ open the report in Excel and also save it to your computer (optional).
IMPORTANT: You must have a ‘Miscellaneous’ folder specified in Company PDF/Export Directory (30-04) or By Term PDF/Export Directory (30-05) or a folder named “tyler” in the root directory of your C drive (“C:\tyler”) in order for the report to open correctly in Excel and save successfully to your computer.