Inventory Value Report

< Previous section  |  Table of Contents  |  Index  |  Next section >

The inventory value report lists the value of inventory materials in stock.

The first step to printing an inventory value report is to select Inventory —> Reports —> Inventory Value from the menu. MainBoss displays a window that contains the following:

• Inventory Item: Lets you restrict the report to a given range of items.
• Inventory Category: Lets you restrict the report to items in a given range of categories.
• Building: Lets you restrict the report to a given range of buildings.
• Storeroom: Lets you restrict the report to a given range of storerooms.
• Location: Lets you restrict the report to items in a given range of locations within storerooms. The "From" and "To" fields are used alphabetically; for example, if you specify A for "From" and F for "To", the report will include items whose "Location" field falls in the range A through F. (Note that a location that starts with FA comes after the letter F, so the report would not include such a location. If you want all locations beginning with the letters A through F, specify G in the "To" field; that way, the report will include all F locations.)
• Value Date: Lets you get a report as of a specific date. For example, if you specify December 31 of the previous year, the report will give you inventory totals as of that date. You can specify any date—even dates in the future if you have created postdated inventory transactions.

  If you leave this field blank, MainBoss gives you grand totals of all known inventory transactions, including any transactions you have dated in the future. Therefore, leaving the field blank is not the same as asking for inventory totals as of the current date.

• Grouping: The options in this area specify how the report should be organized.
  • Building and Storeroom: If you select this, the report is divided into sections, with each section representing a storeroom within a particular building. Inside each section, there is a line for each item contained in that storeroom. There is a value total line for each storeroom section, plus a grand total line at the end.
  • No Grouping: If you select this, the report is divided into sections, with each section representing a single inventory item. Inside each section, there is a line for each storeroom that contains the item. There is a value total line for each item section, plus a grand total line at the end.
• Inventoried Items: Checkmark this if you want the report to include inventoried items.
• Non-Inventoried Items: Checkmark this if you want the report to include non-inventoried items.
• Preview: Displays the report on the screen. This gives you a chance to see what will be printed out when you click Print.
• Print: Prints the report on the current printer. (The name of the current printer is shown above the row of buttons.)
• Print Setup: Lets you change printers if your computer is connected to more than one printer. It also lets you change the page setup for the printer, including paper size, margin size, and so on.
• Export: Writes report information to a file, in a format that can be used by other programs. There are two possible formats:
  • Text format writes the information as plain text.
  • DBF format writes the information as a DBF database. This can be opened by programs like Microsoft Excel and Access. For more information, see Exporting Data.
• Close: Closes the print window.

< Previous section  |  Table of Contents  |  Index  |  Next section >