Inventory Rounding

Apprise stores inventory costs in six decimals, but stores transactions and balances in two decimals. As a result, small rounding amounts may accumulate over time and cause discrepancies when reconciling inventory with the general ledger.

Example The following is an example of  inventory rounding that occurs when three units of a product are bought at a total cost of 10, and then sold individually.

Transaction

Transaction Quantity

Quantity on Hand

Transaction Cost

Unit Cost

Inventory General Ledger Balance

Inventory Value Rounded

Difference

Receipt

3

3

10

3.333333

10.00

10

0

Sale

-1

2

-3.33

3.333333

6.67

6.67

0

Sale

-1

1

-3.33

3.333333

3.34

3.33

-.01

After the second sale, the inventory and general ledger no longer match, and there is a difference of -.01.

Apprise tracks the inventory rounding amounts, which you can view in Inventory Rounding Inquiry and on inventory valuation reports output in Inventory Valuation Report.

Inventory rounding amounts that are greater than .005 are posted automatically in Inventory Adjustment Post if the Post Inventory Rounding Differences check box is selected in Warehouse Management Control Maintenance. If this check box is cleared and inventory rounding amounts greater than .005 exist, you must perform one of the following:

When the Post Inventory Rounding Differences check box is selected and rounding amounts are posted, the following accounts are used for the posting:

Note If you change the account resolution for a product/location, the inventory account for the last inventory rounding record is used for the posting.

When a rounding amount is posted, a new rounding amount may be calculated to account for any remaining rounding difference.