03-31-2022 10:36 AM - edited 03-31-2022 10:40 AM
Efficiency Measure: The receivables turnover ratio is an activity ratio, measuring how efficiently a firm uses its assets. Formula: Net Credit Sales/ Average Accounts Receivable
'Calculate Receivables Turnover
'Formula: Net Credit Sales/ Average Accounts Receivable
Return api.Data.GetDataCell("Divide(A#[YourNetCreditSalesAccount], A#[YourAccountReceivableAccount]:V#YearAvgToDate)")
Source: Snippet Editor: Finance - Common Accounts - Efficiency Measures