IVT - INVENTORY TOTALS
To open IVT, press <Alt M> ("Menu") and follow the Menu path illustrated below, then press <Enter>, or simply enter <IVT> in the "Enter Program Name" field and press <Enter>.
"Are you sure?" will be displayed. When you select Yes, "Now Compiling Report" will display on the screen. Then the report will appear as follows:
This report gives you the number of items in stock, on order, stock needed, and special orders needed, with the retail value of each. It will display the number of items that are not priced on your inventory, LIFO at Cost, FIFO at Cost, and/or Ave. Cost at Cost, depending upon how you have it set in your SYS, Config File, Change Misc. Configurations, number 2003. The report also gives you the retail value of all items in stock in each specific department. This is only for inventory that is on your computer.
Will print the report. This printout will give you an "Open to Buy" stock report if you have set up your budget in SYS, Config, Change Misc. Configurations, numbers 2037 through 2040. The report will include retail/wholesale dollar amounts on-hand and on-order, model wholesale and needed retail. Model wholesale is the dollar amount of all items, if the on-hand was equal to the min/max settings. Each department is broken down into Model A, B, C and other, as set up in SYS, Config File, Change Misc. Configurations, numbers 2043 and 2044.
The printout also gives you by category, the retail/wholesale dollar amount on hand, the month-to-date sales, quarterly sales and total sales for the year.
The total year sales column does not include the month-to-date sales.
Creates a graph of this report if you have the graphics program (GRAPH).
This option gives you the same information as "Complete," except the information is for items for a particular vendor. The vendor number has to be in the "Vend 1" field on IVM ("Inventory Maintenance").
Before selecting this option, enter a vendor number. "Are you sure?" will be displayed. Select Yes, and the inventory totals for the vendor will then be calculated.
IVT totals are saved by date in a lookup file. This allows for comparing inventory totals on selected dates. Multi-Store users can use to compare inventory totals of two different stores on a certain date.
IVT may be run more than once a day. The file saved for comparison will be the last IVT run. The printout will show the categories by department, beginning inventory retail (first date entered), ending inventory retail (second date entered), beginning inventory cost (first date entered), and ending invoice cost (second date entered). Each column will be totaled.
This option will display to the screen the average inventory for each department for the year specified.