For many businesses, February marks their financial year-end. Salespeople are going above and beyond to break sales records, accountants carefully review any open transactions, and special attention is allocated to inventory levels at the various warehouses and storage locations. Inventory is an asset. Its value is recorded in the financial reports, it influences insurance costs, storage rates, and much more. Considering the importance of inventory, businesses conduct periodical inventory counting to ensure the actual inventory reflects in the records. Depending on the business and the nature of the goods, it might be reasonable to expect some gaps between the quantities calculated throughout the year and the actual inventory. To help identify the unusual gaps, SAP Business One enables you to set a threshold for an acceptable variance rate:

When a higher variance rate is calculated, the respected rows in the Inventory Counting document are highlighted:

You can set different variance rates for single counter and multiple counter use cases, as well as define a threshold for differences found between counters.

Available in Web Client for SAP Business One 10.0, and SAP Business One 10.0 version for SAP HANA. Please get in touch if you would like to upgrade to version 10.0.

We hope that you find this tip helpful. For more information on Business One, please visit our webpage.

Source: Ari Schapira | SAP Business One – The Tip of the Week