Finance: Inventory period

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