Need Receivables to Sales Ratio Calculated over la...
# accountinga
Ahmad Muneeb
08/28/2021, 10:43 AMNeed Receivables to Sales Ratio Calculated over last 30 days
c
CD
08/28/2021, 11:31 AMYou’ve spammed this loads of times over the last few days - it probably hasn't been answered because there are no requirements. What is a sale? A sales order? A fulfilled sales order? An invoiced sales order? An estimate/quote? Receivables - is this all $ hitting a certain G/L account? Or just paid invoices? Do you factor any margins into this? Or is it cash flow, so you’re also bothered about vendor bills? Is it 30 days or a period? Which date do you want to use on the transaction? Etc etc
a
Ahmad Muneeb
08/30/2021, 6:40 AM@CD I'll Specify It more.
Ahmad Muneeb
08/31/2021, 8:17 AMSales = Invoiced Sales order
Receivables = All open sale invoices
Should be a period from date to date
For calculation of desired results Sales and Receivables should be of that specified period.