IVT - INVENTORY TOTALS

This program tells you the retail dollar amount of items in stock, on order, stock needed, and special orders needed. It tells you the number of items that are not priced. It also tells you the LIFO, FIFO, and/or Average cost at cost, according to how you have the SYS Config File, #5, Line 701. If you have a "C" in line 701, it will give you all three cost figures.

The screen will show the retail dollar amount of inventory on computer for each department on the Point of Sale.

Press <F2> to Print and you will get the above information plus the open to buy amount for each department if you have set up the Open to Buy in SYS Config File, #6 - Change Open to Buy Levels. You will also get the retail dollar figures for each category.

Inventory Evaluation Report
Options

1 = Entire Inventory
2 =
Entire Inventory (Lock File Fastest!)
3 =
Particular Vendor

<Esc> to Exit

 

IVT #1 = Entire Inventory

I n v e n t o r y E v a l u a t i o n

Now Being Calculated

 

The following screen will be displayed:

S t a t i s t i c s

Items in Stock : 19780 212,168.68 Items not Priced : 5
Items on Order : 5374 68,173.51 LIFE at Cost : .00
Stock Needed : 768 4,513.77 FIFO at Cost : .00
Special Orders : 34 239.23 Ave Cost at Cost : 127,301.21
         
BOOK 50,796.92   CHURCH SUPPL 269.50
BIBLE 57,329.62   CURRICULUM 436.25
TAPE/CD 55,163.72   CHORAL MUSIC 248.35
ACCOMP TAPE 15,219.15   JEWELRY 2,150.58
PRINTED MUSI 4,523.24   BIBLE SOFTWARE 1,860.00
GIFT / AWARD 3,136.26   SPOKEN WORD 918.32
S.S. SUPPLY 586.30   POSTAG/HANDL 0.00
VIDEO SALES 2,263.45   PICTURES 0.00
CHILDREN 9,985.19   VIDEO RENTAL 0.00
CARDS / CALE 3,145.63   PIANO METHOD 2,150.84
GAMES 0.00   NOVELTIES 0.00
BIBLE TAPES 1,985.36   IMPRINT 0.00

<F1> to Graph <F2> to Print <Esc> to Exit

This report gives you the number of items in stock, on order, stock needed, and special orders needed with the retail value of each. 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>tem Config File #5 = Change Misc Configuration Line #701. 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.

<F1> Creates a graph of this report if you have the graphics program.

<F2> Prints this report. This report will give you an Open to Buy Report if you have set up your budget in <SYS>tem Config File #6 = Change Open to Buy Levels. Also gives you the retail dollar amount on hand for all categories and the Month to Date, Quarterly Sales and Total Sales for the Year.

O p e n t o B u y R e p o r t
S t a t i s t i c s

Items in Stock : 19780 212,168.68 Items not Priced : 5
Items on Order : 5374 68,173.51 LIFE at Cost : .00
Stock Needed : 768 4,513.77 FIFO at Cost : .00
Special Orders : 34 239.23 Ave Cost at Cost : 127,301.21
  In Stk In Stk OnOr OnOr Budget Open to Buy Needed
Dept Retail Whsle Retail Whsle Whsle Whsle Retail
BOOK 50,796.92 30,478.15 18,125.60 10,877.06 45,000.00 3,644.79 212.06
BIBLE 57,329.62 34,397.77 23,150.11 13,890.06 50,000.00 1,712.17 273.59
TAPE/CD 55,163.72 33,098.23 25,863.59 15,518.15 52,000.00 3,383.62 2,352.58
Etc....              
               
Totals 212,168.68 127,301.20 68,173.51 40,904.10 180,000.00 11,797.70 6,658.25

Also gives you the retail dollar amount on hand for all categories and the Month to Date, Quarterly Sales and Total Sales for the Year.

Retail Inventory Dollars/Sales by Category

Category On Hand Mtd Sales Jan-Mar Apr-June Jul-Sep Oct-Dec Yr
001 BIBLES 44,129.62 3,536.41 6,358.46 8,152.43 7,574.12 11,875.45 33,960.46
002 REFERENCE 5,526.54 1,263.15 863.45 1,261.47 1,984.63 2,547.25 6,656.80
003 DEVOTIONAL 4,482.63 945.12 985.32 1,005.25 852.12 3,456.98 6,299.67
Etc ......              

Each category will show the retail dollar amount on hand, the month to date sales, the quarterly sales, and the total year sales. The total year sales does not include the month to date sales.

 

IVT #2 = Entire Inventory (Lock File Fastest!)

This option is the same as option #1 except it locks the inventory file so no one else may use the file. The program then runs faster. You cannot lock the file if someone is already using the file.

 

IVT #3 = Particular Vendor

This option gives you the same information as option 1 and 2 except the information is for items for a particular vendor. The vendor number has to be in the vendor #1 field on inventory maintenance.

After choosing option #3, you are asked to enter a vendor number. You may enter the vendor number or press <F1> to look up the vendor number. Enter the vendor name and a list of vendors in alphabetical order will be displayed. Highlight the vendor wanted and press <Enter>. The inventory totals for the vendor will then be calculated.