|
|
 |
|
UniStockCard Update and Rebuild Procedures and Technical NotesUniStockCard for Plus uses the IC History file (ICHIST) as it's only source of transactions for building and updating the Stock Card file for items. For this reason it is necessary to print and purge audit lists from IC, OE, IR and other products which adds records to the history file, regularly. If all transactions are not transferred to the IC History file before an update is run, the valuations and other data in UniStockCard will be incorrect. When assigning a period to any transaction, UniStockCard uses the period end dates from the IC global file on which IC period ends were run. Any third party software which ads transactions to the ICHIST file will be recognized and will be reflected correctly provided the program adheres to the rules for the history transaction format. If you have problems with transactions from other developers, contact UniDevCo and we will attempt to resolve the issue. 1. Update The update procedure will only add new ICHIST records since the last update was run. When this option is selected, the update routine will start at the "end" of the history file (the most recent records) and read backwards through the history file (towards the 'older' records). As records are processed the history file record will be marked. The update routine will continue to read and process records from the ICHIST file until it encounters the first record which has been marked by the previous update and will then stop. Any external program which re-sorts the file will therefore result in incorrect results as the update may terminate before all un-processed records have been dealt with. To allow for situations where a user does not want to update previous valuations and counts, irrespective of whether new transactions were added for previous periods, the "Update" option will add all transactions, regardless of their dates, to the current period. 2. Rebuild The "Rebuild" option will delete the current (old) UniStockCard files , create new ones and rebuild the entire stock card system. This will, for obvious reasons, take longer than the "Update" option. The ICHIST records will be processed and also marked as having been processed, irrespective of their current status. The "Rebuild" option will place transactions into the correct period based on the transaction date, and older transactions will be correctly placed in their respective periods based on the transaction date and irrespective of when the transaction was processed. When doing a rebuild, the user has to indicate if the ICHIST file is complete or not. If the history file is complete, i.e. all transactions since data creation were transferred to the the ICHIST file and this has not ever been purged, the update procedure will assume that all items have a quantity and value of zero before processing begins. As transactions are processed the balances are updated to achieve the final closing balance. This may, for various reasons, result in incorrect valuations of current inventory and this option should only be used to create a temporary system to be used as an audit tool for tracing incorrect posting etc. If the user selects "No", UniStockCard will start with current balances (quantity and cost) and will calculate opening and closing balances for prior periods 'backwards'. This means that the current valuation of inventory is always correct and will balance with the IC valuation lists. Since the "Rebuild" option creates new files, this should be used to correct data integrity problems with the UniStockCard files.
|
|
|
