Process

1. Delete Detail Records from Cycle Count and Warehouse Transaction tables

Specify whether the system deletes detail records from the F4141 and F4142 tables after processing. Detail records contain the on-hand quantities and amounts that are stored in the general ledger. They also contain the quantities that were counted for locations, the unit cost, the name of the person who performed the count, and the date. Values are:

Blank: Do not delete detail records. You can use file utilities or create a batch program to delete the detail records from the Cycle Count Transaction File and Warehouse Count Transaction tables at a later time.

1: Delete detail records from the Cycle Count Transaction File table and the Warehouse Count Transaction table. You must run a variance report before you run the Cycle Count Update (R41413) program. After you run the program, no detail records will exist to calculate the variance.

2. Create Item Ledger Records for zero variances

Specify whether the system creates records in the F4111 table for transactions with variances of zero. Values are:

Blank: Do not create records for variances of zero.

1: Create records for variances of zero.

3. Dual Unit of Measure G/L Variance Offset Account

Specify how the system calculates variances and creates GL entries for an offset account for an item with a dual unit of measure. You can use this account to track losses, such as those from theft or shrinkage. The system uses AAI 4156 for the offset entries. Values are:

Blank: The system does not use AAI 4156.

1: Calculate a variance based on the difference between the primary quantity and the secondary quantity in the cycle count transaction.

2: Calculate a variance based on the secondary quantity in the cycle count transaction.