The Physical Count Variance Register should only show you items that have a variance - hence the name of the register. After counts have been entered or imported we only need to see the items that had a variance so they can be counted again to confirm. Having this report show ALL items makes it very tedious to identify only the items that have a variance.

Comments

  • I have modified this report through Crystal to obtain these results.

  • Doing this means you have no record that the count for those items was verified to be correct at a specific point in time. The Variance Register is the audit trial for the count. If you filter out some items your audit trail will be incomplete. Without that, since there's no transaction or anything tagged on a non-variant item to know it was counted, you have nothing to indicate you did. We created a report to list only the items that are variant to make it easier to do recounts and reconciliations, but left the register in tact for the audit trail.