IVUL - MISC INVENTORY UTILITIES

The IVUL programs are utilities that may be used to simplify the process of entering data repeatedly. When using the various programs the item numbers may be typed or scanned with barcode readers.

IVUL #1 = Enter In Stock Items

Enter the item number to put in stock. The units will automatically put one in stock. Press <Enter> again and the units go to two in stock, etc. <Esc> will exit the program.

IVUL #2 = Zero Masterfile

This program is used only if you want to Zero all of your on hand quantities for a specific category or for all categories. Enter the category or press <Enter> for ALL categories. This will take to ZERO the on hand amount for all items in the category/s chosen, so you need to be sure you want to do this. Entering the category or pressing <Esc> will give you the option, All Ok? Y/N __. "Y" will give you a warning "Are you sure you want to do this? Y/N __", "N" will exit the program. "Y" will zero the on hand amount in the category/s chosen.

 

IVUL #3 = Upload from Portable Reader

Refer to the instructions for using Hand-Held Portable Reader. Enter the category number for the items on the file to be uploaded. Press <Enter> and the prompt All Ok? Y/N __ will be displayed. "N" will exit the program. "Y" will display, Upload File From Reader, Ready to Upload file from Reader. At the "Data Upload" prompt on the reader, press "YES". The screen on your computer will flash through the items. Press <Esc> when input has ended. You must choose IVUL #4 to build your inventory from the uploaded file.

 

IVUL #4 = Build from Portable Reader

Refer to the instructions for using Hand-Held Portable Reader. Enter the category number for the items to be entered on inventory from an uploaded file. Press <Enter> and "Now Building Masterfile" will flash on screen. Will exit program when finished.

 

IVUL #5 Change a Category Number

Enter the Old category number, press <Enter>. Enter the New Category number, press <Enter>. This will combine the items in the old category number with the items in the new category number. If switching category numbers around, make sure the new category number does not have any items in it before transferring in the items from the old category number. Entering the old and new category numbers and pressing <Esc> will give the prompt, All Ok? Y/N __. "Y" will change the category numbers, "N" will exit the program.

 

IVUL #6 = Change Masterfile Supplier #1 Assignment

Enter the Old Vendor # 1 number, press <Enter>. Enter the New Vendor # 1 number, press <Enter>. This will combine the items in the old vendor # 1 number with the items in the new vendor # 1 number. If switching vendor numbers around, make sure the new vendor number does not have any items in it before transferring in the items from the old vendor number. Entering the old and new vendor # 1 numbers and pressing <Esc> will give the prompt, All Ok? Y/N __. "Y" will change the vendor numbers, "N" will exit the program.

 

IVUL #7 = Set Begin/End Sale Dates

Enter the beginning sale date, press <Enter>, then enter the ending sale date, press <Enter>. Will go to All Ok? Y/N __. "N" will Exit the program. "Y" will display window asking for an item number.

Enter the item numbers for all items that will be on the sale and press <Enter>. The title and regular price will be displayed with the cursor in the sale price field. Enter the sale price, press <Enter>. The cursor will go to the enter item # field for the next item to be put on sale. This will put in the sale price, beginning sale date, and ending sale date on inventory maintenance record for the item. At the Point of Sale, the item will be rung up at the regular price with an asterisk to right of price, if verifying price, and will take off a sale discount amount, selling the item at the sale price during the sale dates.

<Esc> will exit the program.

IVUL # 8 = Reset Sale Dates to Zero

Enter the item numbers for items that have gone off sale. This will take out the sale price, beginning sale date, and ending sale date from the inventory maintenance record for the item. If the ending date of the sale has past, the item will not be sold at the sale price even though the item is still flagged. When the IVHR History Roll program is run, the flagged items that have gone off sale will be unflagged.

<Esc> to Quit.

 

IVUL #9 = Change an Item Number

Enter the Old Item Number, press <Enter> and the title will be displayed. If the item entered is not in inventory, Not on File - Press <ENTER> to Continue, will be displayed. Enter the New Item Number, press <Enter>. Enter the New Barcode Number, press <Enter>.

The prompt, All OK? Y/N/C [ ], will be displayed.

"Y" will accept information entered and the item number will be changed in the inventory maintenance record for the item.
"N" will allow you to edit information entered.
"C" will cancel information entered.

If the new number entered is already in the inventory, "UPDATE NO GOOD - PRESS ANY KEY TO CONTINUE", will be displayed.

Pressing <Esc> will exit the program at any time.

 

IVUL #10 = Display .00 price and bogus cost Items

Your inventory will be searched for items without a price on file and for items that have a bogus amount in the cost or retail price field. The first one found will be displayed to the screen and you may edit. Press <F4> for options: (S)ave, (D)elete, (C)ancel, (U)ndo, (Q)uit

(S)ave - (S) will save the information entered.
(D)elete - (D) will delete the item from inventory.
(C)ancel - (C) will cancel the Options window.
(U)ndo - (U) will undo the changes made or information entered.
(Q)uit - (Q) will exit the program.

You will be asked if you want to Continue? Y/N. "Y" will bring up the next item without a price on file. "N" will exit the program.

 

IVUL #11 = Input Qtys from a File

Quantities will be entered from a file. Used when a company such as REGIS takes a physical inventory.

 

IVUL #12 = Multi-Store Title Comparison

The IVMAST files for the stores being copied or changed must be in the BOOK directory.

This program is used to change Title and Author information from the Master Store to another Store. You may also choose to match the Categories, Pricing Information, Invoices, Supplier #1, and Supplier #2.

Enter Store # that is Master: - Enter the Store # you want to make the other Store the same.

Enter Store # you want the same as the Master.

Enter a "Y" if you want the categories, price information, invoices, Supplier #1, and Supplier #2 to be matched, also.

Enter a "N" if you do not want any one of the above changed.

All OK? Y/N -

"Y" runs the program.
"N" does not run program and exits.

 

IVUL #13 = Create All Key Word Tables

After running the "IVUP" Price Update, you may run this program to create all key word look up tables.

 

IVUL #14 = Create IVI Key Word Table Only

Run this program to create the key word table in inventory inquiry IVI.

 

IVUL #15 = Add IVM Items to IVDI File

When this program is run, it will add to the database all of the items in your inventory that are not on the database. RECORDS ADDED 0000XX will be displayed in the top left hand corner of your screen.

 

IVUL #16 = Purge BSMGR’s Database

This program deletes everything in BSMGR’s Database that is not flagged as currently available from a distributor. This will take out of the database items you may have added to the database. After running this option, to add the inventory items that are currently on your inventory back into the BSMGR Database, run option #15 = Add IVM Items to IVDI File.

 

IVUL #17 = Change Incorrect Invoice #s in IVM

This program allows you to change the invoice number entered when the purchase order was merged. Enter the purchase order number, the incorrect invoice number, and then the correct invoice number. This invoice number is entered on the Invoice History of an item on the inventory maintenance screen.

 

IVUL #18 = Change BSMGR’s Database Prices

If you have missed some price updates, this program will update the prices on your inventory items. Before you run the program you will have to call and download the current file for the new prices. The current file for the new prices will need to be set up by BSMGR to be downloaded, then you will need to run IVUL option 18.

 

IVUL #19 = Move Inventory History Totals

You may now move the sales history on inventory maintenance from one month to another.
Choose IVUL #19 and the following screen is displayed:

Enter the period # to move totals from, press <Enter>. Then enter the period # to move totals to, press <Enter>.

All ok? Y/C __

"Y" will run the program.
"C" will exit the program.

After choosing "Y" to run the program, "Now Moving Item __________" will be displayed with the item numbers that are being moved flashing. When finished, will exit program

 

IVUL #20 = Add Titles from Store xx to xx

This option is for Multi-Stores. Must have both store’s IVMAST files in the BOOK Directory. The following screen is displayed:

Enter the Store # that is the Master, the one you are reading from. Then enter the Store # that will be appended.

All Ok? Y/N

"Y" will run the program and add new items. The number of records read and number of records added will be shown.

"N" will not run the program and exit the program. The items that are not in the store appended will be added.

 

IVUL #21 = Clear Sale prices by Promo #

This will clear out the Sale Prices and Sale Dates for all items that have the Promotion Number entered in the item’s Promotion field. The Promotion field is also cleared.