Setting the Transaction Date Range of Actual vs. Theoretical Variance Reports

In general, a variance report is generated based on two consecutive Shelf-to-Sheet Count records. This leads to a case where the End Count Date of one report falls on the same date as the Start Count Date of another report, which causes data to overlap between the two reports. To avoid this, you can exclude from a variance report either the Start Count Date or the End Count Date of Shelf-to-Sheet Count records.

To Set the Transaction Date Range of Variance Reports:

  1. Go to Setup > Setup Manager > Company > Preferences > General Preferences. Click the Custom Preferences subtab and go to the General section.

  2. In the Transaction Date Range field, select any of the following options:

    • Select Exclude Start Date if you want the variance report to include transactions with dates from the day after the Start Count Date.

    • Select Exclude End Date if you want the variance report to include transactions with dates until the day before the End Count Date.

    • Select Include Start Date and End Date if you do not want any changes on the transaction date range of variance reports. This is the default option.

  3. Click Save.

Related Topics:

Actual vs. Theoretical Variance Reports
Granting Roles Access to Variance Reports and Related Features
Setting the Actual vs. Theoretical Email Group
Viewing the Dollar Variance Report
Viewing the Unit Variance Report

General Notices