SECTION 3.3.3 - STOCK REVALUATION
USAGE: To update the value-on-hand values. This is often done as part of re-evaluation of old, or obsolete, stock. This allows proper evaluation of Inventory values for insurance purposes and it allows proper cost-of-sales calculations in Invoicing.
DISCUSSION: When you start the STOCK REVALUATION program, the computer will initially ask for an Inventory code. Insert the code and press <Enter>.
To return to the INVENTORY DATA ENTRY MENU, press <ESC>.
To search for an Inventory item, press <F9>. For further details on searches, see SECTION 1.2.
Having chosen an Inventory item, the screen will display as follows:
The following is a description of the fields displayed:
LOCATION This field is only relevant for companies using multi-location stock. Otherwise the prompt does not appear.
DATE This defaults to the system date (the date at the top of the screen). If you change it, HiFinance will retain the changed date until you exit to the INVENTORY DATA ENTRY MENU. You may press <F1> to insert today’s date.
STOCK-ON-HAND This field is displayed by the computer to show you the current status of the item.
CURRENT UNIT PRICE This field is displayed by the computer to show you the current status of the item.
NEW UNIT PRICE Here you enter new unit price of the item. This must be a positive value or zero. If necessary, you can press <F9> to enter calculator mode.
COMMENTS You must enter a description here. Normally you would enter something like OBSOLITE. Once you have entered this, HiFinance will remember the value and you can repeat it by pressing <F1> until you return to INVENTORY DATE ENTRY MENU. There are 2 lines of description. The first one is compulsory and the second may be left blank.
REVALUATION ACCOUNT This field will only appear if you have chosen Y or A in the utilities question ASK FOR G/LEDGER CODE IN INV. ADJ & REVAL? (see SECTION 7.1.2) Normally HiFinance will post to the Inventory Revaluation account as defined in CONTROL ACCOUNTS (see SECTION 6.5.2). If you enter a value here, it will override the value in CONTROL ACCOUNTS. This can be useful if you have a production department and you wish to purchase or sell stock internally posting to a specific account. The other side of the transaction will still post to the Stock-on-Hand account. You may use <F9> to search for an account.
At each point, you may cancel the transaction by pressing <ESC>. However, it is possible to return to a specific field by using <CsrUp> or <F8>. You can also finish the screen by pressing <F10>.
Finally you will be asked to confirm the update and the computer will update the relevant files. When this has completed, you will be returned to the Inventory code entry screen where you may either enter another transaction or press <ESC> to return to the INVENTORY DATA ENTRY MENU.
Files updated by the Revaluation program:
Inventory master-file: The total of the units will be unchanged. The value-on-hand will be recalculated based on the new unit-price.
Inventory transaction file: The current stock-on-hand will be removed with an adjustment transaction for the total units and value on hand (unless zero). Then HiFinance will insert an adjustment record bringing the stock level and value back up to where you have set them. This offers a better paper-trail to just inserting a transaction for the difference.
General Ledger master-file: The Stock-on-Hand and Inventory Revaluation (unless overridden) accounts are updated with the value of the transaction.
General Ledger transaction-file: A transaction is posted for each General Ledger account updated, above.