Adding stock balancing columns to inventory reports

See also: Stock Age

Stock Balancing is used when a supplier allows you to return product for a refund when it has been sitting on the shelf for a certain number of days.

On the inventory record in the extras tab you can specify the number of days in the Stock Balance field.

In the customized inventory reports, there are two columns that can be added: Stock Balance and Stock Balance Days. There is also an option "List items on Stock Balance Control" to only list items that have the stock balance field on the inventory item filled in (non zero).

The Stock Balance column will list the quantity of stock that has been in stock for more than the Stock Balance Days. The Stock Balance Days will simply report the stock balance field from the inventory record.

Also see the Stock Age columns which can also be used to determine the age of stock.