|
|
 |
|
|
How Stock Card Works Stock Card reads the ICILOC file to obtain the current Quantity on Hand by location for each item. Stock Card then builds the UCSUM file from the ICHIST file. For each item, Stock Card uses the current quantity on hand with costs as a starting point and uses the historical transactions in ICHIST to calculate the opening quantity and cost for each fiscal year/fiscal period. Essentially it works backwards through the data. Stock Card stores the opening balance for each item/location/fiscal year/fiscal period. It does not have a field for closing balance. In this way Stock Card may determine that there is a non-zero opening balance for the item. For example: Item A - Qty on Hand - 10 each Last FY/FP - Sales of Item A - 5 sold Stock Card does the following calculation. Item A - Opening balance for last FY/FP - 15 Transaction = 5 sold Closing balance for last FY/FP - 10 If no other transactions for this item are found in ICHIST, then Stock Card will report a non-zero opening balance for this item. This situation will occur if IC History Transactions have been purged from the ACCPAC data. When a data integrity check is performed with the Fix Errors option selected, and non-zero opening balances are found, Stock Card creates a correcting entry in ICHIST. A rebuild of the UCSUM file is required to 'use' that correcting transaction and therefore calculate the opening balances. During the data integrity check, Stock Card also creates transactions for items to fill in periods where there has been no activity for that item. This is to report correct opening and closing balances on the StockCard reports. A Stock Card rebuild clears the UCSUM file of all records and sets the flag in ICHIST to allow the transactions to be retrieved again. This function is found in Stock Card Data Integrity Check Menu options. Stock Card retrieves the ICHIST transactions and creates the entries in UCSUM to display the transactions on the Stock Card Inquiry screens. In MS SQL Version 5.0 and 5.1, Stock Card Retrieve is triggered by Day End processing. In MS SQL Version 5.2 and 5.3, a retrieve should be performed when new entries are written to the ICHIST table. In
Pervasive, a retrieve should be performed when new entries are written to the ICHIST file.
|
|
|
