Applies to: RollMaster (RM) Core
This article covers the Inventory Valuation report, including report navigation, filtering options, print/export behavior, and available selection criteria used to generate Inventory Valuation listings from Catalog Maintenance data.
Does Not Cover: Catalog Maintenance record creation/editing.
Menu Path: Inventory Control > Reports > Inventory Valuation
For other Inventory Control programs, refer to the Inventory Contol module documentation.
This report will print a listing of each inventory record in the system with a corresponding value. The report prints by Product Code and lists each roll or inventory record individually under the style name. In addition to the roll or identification number and the dye lot number, the system shows how much of the inventory record is on hand, how much is still available, the unit cost, the total cost of the inventory record, and the age of the inventory record. At the end of each product listing, the report gives a total of all inventory on hand for that product, a total of all available inventory for that product, and a total value of the inventory for that product. At the end, the report totals the value of all available inventory, the value of all reserved or assigned inventory, and a grand total of all inventory on hand. Also, this report will indicate if an inventory item is tied to an Inactive Catalog Item by placing an “*” to the right of the On Hand quantity on the printed report. An Inactive column appears on the Excel export data next to the On Hand column and will display “INACTIVE.”
When you enter the Inventory Valuation report module, the system will display a Report Selection screen as follows:
The default settings in the screenshot above will produce a report with all existing inventroy in the system if you click the Generate Report button without making any changes. However, the Print Options are designed to allow you to customize the report based on a variety of scenarios. At the Branch (1) field, click the down arrow to select a specific Branch. At the Product Code (2) field, click the down arrow to select a specific Product Code. To print the report by a specific Product Type (3), click the down arrow at this field. At the Beginning and Ending Style fields (4), you will need to type a specific Style Name without the benefit of a Look-up screen in order to print for just one Style or a range of Styles. The Vendor (5) button will prompt a Vendor Lookup if you need to customize by Vendor ID. At the Age (6) field, the drop-down menu options include an Age of 0-180 days, 181-365 days, and 366 days and Older. The Min On Hand Qty (7) field can be set to any number above 0.00, if you wish to exclude small roll balances; however, if you print for all styles, adding a number to this field could adversely impact your valuation.
The next box of options (8) can be checked or left unchecked based on your needs. The Exclude Items with No P.O. option, if checked, will leave off any records that are not tied to a system PO or contain a PO # in the inventory record. The Include Memo on Print option will include the Memo field on the report where data exists. The Available Inventory Only option should be checked if you do not wish to display inventory that is assigned to a job. The Group Branch on Print option will group together data by Branch, if you are printing for All Branches. The Use Private Label Name option defaults to checked, so you will need to uncheck it if you do not want to see Private Label names on the printed report.
At the Stocking Option box (9), the default is Both. You can change to either of the other two options to customize the report. At the Direct Print Options (10) box, if you click Product Type Totals, the report will bypass the screen display and print the total of each Product Type directly to paper. The Short Version option will switch the program to the Inventory Valuation – Short report format (see explanation in next section below). The Comment Template (11) option at the top left of the screen will prompt an Adjustment Comment Maintenance box as follows:
This option was added to allow you to create standard comments for adjusting small inventory balances in this module from the Generate Report screen. In this box, you can click the Home Key Programs (1) option to pull up the Home Key Menu. Any Existing Comments will appear in the screen above. To add a new comment, type the comment in the Enter New Comment field and then click the Add button. Once a comment has been added, you can highlight the comment and click the Delete (3) button to remove it from the program.
Once you have made your selections in the Report Selection screen above, click the Generate Report button to prompt the data in the Inventory Valuation Results screen as follows:
From this screen, the system will total the results of your selections at the bottom right of the screen. You can also export the data to Excel or click the Print button to print to paper. Additionally, there are a few columns you can click in and make adjustments. These include: Invoice #, On Hand, Unit Cost, and Freight. When you make an adjustment, the system will prompt an Update Inventory box as follows:
You can click the down arrow to select an existing Adjustment Comment, or you can type a new comment in the User Defined Reason field. Click the Save button to continue. The system will prompt an Enter Adjustment Date field with the current date as the default. You can override this date or hit enter to continue. Returning to the Inventory Valuation Results screen, you can right-click with your mouse on any item to view the Pointer Record detail in the Inventory Pointer View screen as follows:
Click the Exit button to return to the previous screen. You can then export the data to Excel or click the Print button to print to paper.