Stock Card Methods and Concepts
Stock Card data is
based on IC history transactions and will report correctly item valuations for
previous periods if IC history transactions are complete. Opening balances are
maintained in UCSUM and closing balances are calculated, based on opening
balance and all period transactions.
Initial Build
4.2 Pervasive - occurs on activation
4.2 MS SQL - occurs on activation
5.0 Pervasive - separate icon after activation
5.0 MS SQL - occurs on activation
5.1 Pervasive - separate icon after activation
5.1 MS SQL - occurs on activation
5.2 Pervasive - separate icon after activation
5.2 MS SQL - occurs on activation
5.3 Pervasive - separate icon after activation
5.3 MS SQL - occurs on activation
The initial build of UCSUM data starts by reading ICILOC to get the current
quantity on hand and cost on hand for each item. The process then reads ICHIST
transactions backwards and generates UCSUM transactions by item, location,
fiscal year, fiscal period. UCSUM records are created by taking opening balance
from this fiscal period and calculating opening balance for previous fiscal
period, using ICHIST transactions.
Once complete, an IC item valuation report for this period should be run to
compare to UniStockCard item valuation report for this period. The reports
should have the same value for inventory.
If Inventory history has never been purged and there are no missing
transactions, StockCard opening and closing balance by fiscal year, fiscal
period will match. If Inventory history transactions are missing, opening and
closing balances may not match.
Subsequent data retrieval after day end processing
4.2 Pervasive - option to retrieve is offered when StockCard programs are opened
4.2 MS SQL - occurs automatically when day end processing is run
5.0 Pervasive - option to retrieve is offered when programs are opened
5.0 MS SQL - occurs automatically when day end processing is run
5.1 Pervasive - option to retrieve is offered when programs are opened
5.1 MS SQL - occurs automatically when day end processing is run
5.2 Pervasive - option to retrieve is offered when programs are opened
5.2 MS SQL - option to retrieve is offered when programs are opened
5.3 Pervasive - option to retrieve is offered when programs are opened
5.3 MS SQL - option to retrieve is offered when programs are opened
Data Integrity Check
Data integrity checks the UCSUM file:
1. finds first record for this item, this location and checks balance if the
balance is zero.
2. checks opening balance for this fiscal period against the closing for
previous fiscal period.
3. checks closing balance for this item this location against ICILOC.
4.2 Pervasive - reports non-zero opening balances as errors and advises that IC
History is not complete. Sets the "Is IC history complete?" flag to NO.
4.2 MS SQL - reports non-zero opening balances once and advise that IC History
is not complete. Sets the "Is IC history complete?" flag to NO.
Run data integrity check with fix option, logging to file. 4.2 versions will
report non-zero opening balances but will not 'fix'.
5.0 Pervasive - creates an ICHIST transaction to return to zero, non-zero
opening balances
5.0 MS SQL - creates an ICHIST transaction to return to zero, non-zero opening
balances
5.1 Pervasive - creates an ICHIST transaction to return to zero, non-zero
opening balances
5.1 MS SQL - creates an ICHIST transaction to return to zero, non-zero opening
balances
5.2 Pervasive - creates an ICHIST transaction to return to zero, non-zero
opening balances
5.2 MS SQL - creates an ICHIST transaction to return to zero, non-zero opening
balances
5.3 Pervasive - creates an ICHIST transaction to return to zero, non-zero
opening balances
5.3 MS SQL - creates an ICHIST transaction to return to zero, non-zero opening
balances
5.x versions will 'fix' non-zero opening balances by creating an ICHIST
transaction in the fiscal period (by ICHIST fiscal year/fiscal period) prior to
the first fiscal year and period where it finds ICHIST transactions for that
item. This will return to zero the non-zero opening balances and opening and
closing balances for fiscal periods will now match.
For Pervasive 5.x only, when a data integrity check has been run and ICHIST
transactions are added, a rebuild MUST be done. This may be done immediately by
responding to the option offered or by using the Reset Menu option on the
UniStockCard data integrity screen.
Reports
For complete item valuations, UniStockCard must roll forward opening balances to
the next period for items that have no transactions during that period.
4.2 versions - this is done during reporting
5.x versions - this is done during StockCard data retrieval
