Note: The update of the Stock File is made by the Daemon and therefore this must be running prior to the update.
The Update stock file program updates the stock file and provides an audit of stock movement. It does not require exclusive access to the stock file, so it can be run at any time. However, any part numbers in use at the time are not updated.
NOTE: The update program ignores any part set up as either a Serial or Batch part number. Adjustments to be made on these parts must be processed via Point-of-Sale using the Stock Adjustment account.
The program scans the stock check input file, processes all lines with an input status of C, and does the following:
Updates the quantity of the checked location of the stock record by any variance found between the frozen and counted stock in the check file (see Generating a check list)
Updates the total stock quantity of the stock record as above
Updates the date last checked against the checked location
Updates the date last moved if any movement is recorded
Generates a log file entry to reflect any movement. The account code is set to @check, the operator code is set to the value held in the Stock Management system parameters.
Updates the audit number in the stock record to record the log file entry
Enters a system status of U on the check file
Writes any value of variance to the write off account, as specified in the Stock Management System Parameters
There are other updates pertinent to Perpetual Inventory only, which are discussed in another topic.
Note: The program does not update the demand history.
To update the stock file:
From the Master Menu, select the Stock checking option and the Company you require.
You are prompted for the stock location.
Select the Stock Location.
The STOCK CHECKING menu is displayed.
Select the Update stock file option.
Warning: If the Merge rough sheets program has not been run, a Confirm input form is displayed with the message Check file and rough sheets have not been merged, giving you the options to Continue or Exit. To continue with the update, click the Continue button. To return to the STOCK CHECKING menu, click the Exit button.
The Update Stock Check form is displayed.
Click the Update button.
The Update Stock Check form is displayed when the Update stock file option is selected from the STOCK CHECKING menu and if, when prompted, you click the Continue button.
PUSH BUTTONS:
Exit: Returns you to the STOCK CHECKING menu
Help: Displays help on the current application in your company's default browser
Update: Updates the stock file. A report is produced in conjunction with the update showing net movement by quantity and value.
Note: This program only updates items not previously updated in the current check-file. Any item withheld is highlighted on the report. This is probably due to a stock record being in use at the time. Clicking the Update button again should overcome the problem.
