What can be the Custom Formulas?
🔸

What can be the Custom Formulas?

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.