Stock Card Recommended Procedures (Versions 5.0, 5.1 and 5.2 Pervasive/MS SQL and Version 4.2 MS SQL)

1.       Install and activate

2.       Retrieve data - Pervasive.  Retrieve data function performed during Activation  - MS SQL

3.       Run Inventory Control current inventory valuation report.  Run Stock Card valuation report for current period and compare.

4.       Run Stock Card Summary - Costs and Quantities for all fiscal years and fiscal periods.

5.       Run Stock Card Item Valuation reports by period.

6.       Check opening and closing balances by fiscal year/fiscal period.

7.       Run Stock Card Data Integrity Check.  Log results to FILE.  Choose DO NOT FIX option to review errors.

StockCard Data Integrity Check will perform the following functions:

1.       Fills in missing periods.  Extends opening and closing balances for items without transactions in that year and period.

2.       Checks the current balance by item in UCSUM (Stock Card file) with current balance in ICILOC (Inventory Control  Item-Location file)

3.       Checks the opening balance for each item for the first fiscal year/period when transactions for that item occur.  Reports non-zero opening balances.

4.       Reports blank locations.

If errors are reported, run the StockCard Data Integrity Check with the FIX Option.  Errors will be corrected if possible.  Log the results to FILE only.

  1. If non-zero opening balances are found,  Stock Card will 'fix' by adding a balancing transaction to the ICHIST file, in       the very first period found in the ICHIST file. A rebuild is required when non-zero opening balances are corrected.   This option is offered immediately following the data integrity check.

  2. If records with blank locations are found,  Stock Card will ignore those transactions and report them as unfixable errors.   This situation may occur when ACCPAC DOS data has been converted to Windows. 

To correct blank locations, the ICHIST must be edited.  As Location is an index field, this cannot be done using Pervasive utilities.  Contact a data repair facility for assistance.

After  adding a location code, a rebuild must be performed in  Stock Card.  A data integrity check should be run after the rebuild and any subsequent issues addressed.

 

 

or email info@unidevco.com with questions or comments about this web. Last modified: November 22, 2006 Copyright © 2000 - 2005 Uni Development Company Inc. All rights reserved.  All other marks are trademarks or registered trademarks of their respective companies.