Inventory Procedures
 

Home Up Contents Search

 

Inventory Control Policy

In order to control inventory more efficiently, prevent negative balances and margins, and increase our ability to serve our customers more effectively, the following procedures shall be followed.

Negative Inventory Balances

Inventory items that go into a negative balance indicate a problem has occurred with that item. Usually this is caused by the item being sold under the wrong unit of measure or the wrong part number, or inventory has not been received into the system (although the item is in the store).

bulletYour FACTS POS has a Negative Balance Report in the system that will alert you to the items that are in need of attention.
bulletTo access the report, type "RW" from any menu in the system. This will take you to the Report Writer.
bulletWhen the screen appears, hit enter. (Only one item is listed in this menu).
bulletA window will appear with eight choices. Make sure "Prompt" is selected and hit enter.
bulletStroke the F2 key, and scroll using the arrow keys until you come to the "Negative Balance Report". Hit the enter key. DO NOT MODIFY ANY FIELDS IN THIS REPORT.
bulletType "R" for "Run" and this will take you to an "Execute Options" window.
bulletHit the enter key again in the "Execute Options" window to run the report. Choice number 1 (Run report) should be selected by default. If it isn’t selected, scroll to that choice using the arrow keys.
bulletYou will have a choice of printing options. Scroll to the print option you desire. Either print the report or view it as video. This will give you the items that are in a negative balance status.
bulletAddress the incorrect balances and resolve them as appropriate. If you run the report again after doing this, there should be no items listed in the report.
bulletRun this report AT LEAST weekly to maintain your item file balances. It takes less than a minute to run, and can provide valuable information in assisting you in inventory control.

If you have any questions or encounter any problems, contact the home office.

Negative Margin Report

The Negative Margin Report will alert you to potential problems with the way your items are priced in the FACTS POS. Please follow the instructions below to maintain positive margins on the products you sell.

bulletYour FACTS POS has a Negative Margin Report in the system that will alert you to the items that are in need of attention.
bulletTo access the report, type "RW" from any menu in the system. This will take you to the Report Writer.
bulletWhen the screen appears, hit enter. (Only one item is listed in this menu).
bulletA window will appear with eight choices. Make sure "Prompt" is selected and hit enter.
bulletStroke the F2 key, and scroll using the arrow keys until you come to the "Negative Margin Report". Hit the enter key. DO NOT MODIFY ANY FIELDS IN THIS REPORT.
bulletType "R" for "Run" and this will take you to an "Execute Options" window.
bulletHit the enter key again in the "Execute Options" window to run the report. Choice number 1 (Run report) should be selected by default. If it isn’t selected, scroll to that choice using the arrow keys.
bulletYou will have a choice of printing options. Scroll to the print option you desire. Either print the report or view it as video. This will give you the items that are in a negative margin status.
bulletAddress the negative margins and resolve them as appropriate. If you run the report again after doing this, there should be no items listed in the report.
bulletRun this report AT LEAST weekly to prevent negative margins. It takes less than a minute to run, and can provide valuable information in assisting you in inventory control.

If you have any questions or encounter any problems, contact the home office.

Deleting Part Numbers

One problem that has been encountered with regard to negative balances is having multiple part numbers in the POS software for the same item. If this occurs, sales may be pulled from one part number when it was actually received into another part number, thus causing a negative balance. There are several ways to prevent this from occurring. One method is to "clean" your item file by deleting the "bad" part numbers. Please be aware that it is important to follow the following guidelines in order to maintain sales history on the items being deleted. As you contemplate making changes in your item file, remember the following points:

bulletPlease note when deleting a part number, the ledger cards, purchasing history and receiving history are lost and not transferable to the new part number. Only the sales history is transferred to the new part number.
bulletThere is no way to delete a part number without transferring the sales history. Therefore you should always know what part number you are transferring to before you begin the deletion process.

Below are error messages you may encounter, and the reasons associated with that error message. Review these so you will be familiar with them, then follow the instructions for deleting a part number.

Error Messages

bulletYou cannot delete a part number if there is a balance on hand. You must make the quantity on hand equal to zero or you will get the following message. Current quantities must equal zero. Cannot change. CR-Continue
bulletYou cannot delete a part number if the number is in the suggested PO report. You must delete the item from the suggested P. O. or you will get the following message. Item still in ‘POSUGG File.’ Cannot delete. CR-Continue
bulletYou cannot delete a part number if it is in an open purchase order. You must either receive the entire purchase order, or delete the purchase order. Simply receiving the line item of the part number you wish to delete is not enough. If you receive that line item, but the purchase order is still open, you will receive the following message: Item still in ‘POITMX’. Cannot delete. CR–Continue.
bulletIf you try to delete an item from the Item F/M area, and the item has not been deleted in the Warehouse F/M, then you will get the following message: Item still in ‘ICWHSX for WHSE 01’. Cannot delete. CR-Continue
bulletIf in the process of deleting a part number you encounter a message such as ERROR 47 occurred on line 29270 in program ICF920 STRING subscript Error, please consult your ProvideX manual - CONTACT THE HOME OFFICE.

Creating a Zero On-hand Balance

If you have a balance on hand in the part number you desire to delete, you cannot delete that part number until you do the following:

bulletTransfer the balance on hand to the new part number with an inventory adjustment.
bulletSell all the remaining items in the part number you wish to delete.
bulletAdjust the remaining quantity to make the balance zero.

Either sell the remaining items, or make an Adjustment Entry to remove or transfer the items. If an Adjustment Entry is made, you must run the Adjustment Register before you will be able to delete the part number.

Deleting Associated Interchanges

Once you get your balance on hand to zero, you should next delete your interchange code(s) for the item number you wish to delete. From the Main Menu (MM), follow this path:

2) Inventory Control
7) Inquiries
1) Item Inquiry

Cursor over to Interchange to find the correct interchange or barcode to delete. To delete the interchange hit F4 to go back to Inventory Control Inquiries Screen. Then hit F4 again to go back to the Inventory Control Master Menu. Then take option 10 (File Maintenance) and then option 5 (Item Interchange F/M). Type in the interchange or barcode of the part number that you wish to delete and hit enter key. When the associated item number populates line 2, hit D for delete and then hit the enter key. It will prompt you with the following: Are you sure you want to delete this record? (N/Y) Type Y for yes and hit the enter key. You must continue this process to delete all interchanges/barcodes for the part number you want to delete, otherwise you will not be allowed to delete the part number.

Deleting an Item Number From the Warehouse File

Once you have deleted all interchanges attached to the bad part number, hit F4 to get back to the Inventory Control File Maintenance Screen. You must now delete the bad part number in the Warehouse Item F/M – Option 2. When the Warehouse Item F/M screen comes up, hit enter at the Warehouse 01 prompt. When the prompt comes up in the item prompt, type in the number to be deleted and hit the enter key. When the blanks are filled in, type "D" and hit the enter key. A message will come up that says: SA History exists for this item Enter new item to store sales history under, F4 Backup. Also, a blank will come up that says: Attention! Enter New Item……………….. Type in the part number that you want to keep all the history under and hit the enter key. You will now see the following message: Are you sure you want to delete this record? (N/Y). Type a "Y" for yes and hit the enter key. The part number is no longer in the Warehouse File, but still remains in the Item File.

Deleting an Item Number From the Item File

From the Main Menu (MM), take option 2 – Inventory Control. Then take option 10 – File Maintenance, then option 1 - Item F/M. Type in the number you want to delete and hit the enter key. When the banks are filled in with the information on that item, type D for Delete and hit enter key. You will now see the following message: Are you sure you want to delete this record? (N/Y). Type a "Y" for yes and hit the enter key. You will see a statement that says: SA History exists for this item Enter new item to store sales history under, F4 Backup. Type in the new number that you want the sales history to go into and hit enter key. It will then take you back to the main screen to enter a new part number. The item number has now been deleted from the system.

Recording Changed/Deleted Item Numbers

Whenever you change or delete an item number, record that activity on the Item Number Transfer Log. Since we will only retain the sales history of an item when it is transferred, this will give us a record of changes made and the ability to trace any related issues that may turn up later. Please see the form shown below:

RLCB Base Supply Store Program

Item Number Transfer Log

Records must be maintained on all item numbers changed or deleted from your POS.

Log #

Original Item Number

New Item Number

Date Changed/Deleted

C/D?

Comments

1

077511583678

58367

April 11, 2002

D

Duplicate Part Number

2

75910

75610

April 12, 2002

C

Incorrect Item Number

3

7510002365894

N/A

April 16, 2002

D

No Activity, Never Ordered or Sold

4

. . . . .

5

. . . . .

6

. . . . .

7

. . . . .

8

. . . . .

9

. . . . .

10

. . . . .

11

. . . . .

12

. . . . .

13

. . . . .

14

. . . . .

15

. . . . .

16

. . . . .

17

. . . . .

18

. . . . .

19

. . . . .

20

. . . . .

21

. . . . .

22

. . . . .

23

. . . . .

24

. . . . .

25

. . . . .

26

. . . . .

intl.doc

Click here to obtain the form.  This is a generic form.  Please replace "RLCB Base Supply Store Program" with your store name.

 

Home ] Up ]

Web site designed and maintained by Night Sky Workshop.
Copyright © 1998 - 2008,  Raleigh Lions Clinic for the Blind, Inc.
Last modified: October 09, 2008 06:23:48 AM