An inventory-related variable allows using $ sign to apply formulas with your already accumulated inventory data on BoxHero. All variables are shown based on the designated period. Please refer to the below for more.

**Current quantity**Ā : Shows product/sub-itemās current quantity.**Number of days**Ā : Shows the number of days in a chosen period on Analysis.**Average quantity in a period**Ā : Shows the average quantity in the chosen period. The average is calculated by the quantity of 23:59:59 for each date.**Initial quantity in a period**Ā : Shows the quantity on 23:59:59 of the prior date from the chosen period.**Final quantity in a period**Ā : Shows the quantity on 23:59:59 of the day after from the chosen period.**Total stock-in quantity**Ā : Shows the total product/sub-item quantity from stock in.**Stock-in frequency**Ā : Shows the number of times stock in has been made.**Total stock-out quantity**Ā : Shows the total product/sub-item quantity from stock out.**Weighted stock-out average (linear, 2)**Ā : Shows the weighted average of product/sub-itemās stock out quantity by each date. Calculated by weighting the oldest dateās stock out quantity as 1 and, the recent dateās quantity as 2 in a linear function.**Weighted stock-out average (linear, 3)**Ā : Shows the weighted average of product/sub-itemās stock out quantity by each date. Calculated by weighting the oldest dateās stock out quantity as 1 and, the recent dateās quantity as 3 in a linear function.**Weighted stock-out average (linear, 4)**Ā : Shows the weighted average of product/sub-itemās stock out quantity by each date. Calculated by weighting the oldest dateās stock out quantity as 1 and, the recent dateās quantity as 4 in a linear function.**Stock-out frequency**Ā : Shows the number of times stock out has been made.**Variation quantity from audit**Ā : Shows the variation in quantity by subtracting the decreased quantity from increased quantity through auditing product/sub-item.**Decreased quantity from audit**Ā : Shows the decreased quantity from auditing product/sub-item.**Increased quantity from audit**Ā : Shows the increased quantity from auditing product/sub-item.**Audit frequency**Ā : Shows the number of times auditing product/sub-item has been made.**Variation quantity from move**Ā : Shows the variation in quantity by subtracting the decreased quantity from increased quantity through auditing product/sub-item on Location Mode.**Decreased quantity from move**Ā : Shows the decreased quantity from moving product/sub-item on Location Mode.**Increased quantity from move**Ā : Shows the increased quantity from moving product/sub-item on Location Mode.**Move-out frequency**Ā : Shows the decreased number of product/sub-item moves.**Move-in frequency**Ā : Shows the increased number of product/sub-item moves.

ā¬ Go back