OSAdmin
Valued Contributor

Efficiency Measure: Inventory period is a measure of the average number of days inventory is held. Formula: Average Inventory/ (Annual COGS/365) or
365/ Inventory Turnover

'Calculate Inventory Period
'Formula: Average Inventory/ (Annual COGS/365) or 
365/ Inventory Turnover

Return api.Data.GetDataCell("Divide(365, A#[YourInventoryTurnoverAccount])")

Source:   Snippet Editor:  Finance - Common  Accounts - Efficiency Measures 

Version history
Last update:
‎03-25-2022 10:27 AM
Updated by: