Skip to Content
0
Former Member
Nov 24, 2009 at 07:57 PM

Average Days to pay

316 Views

Hi,

My customer wants to include in the Customized Balance aging report a field Average Days to pay. The calculation ithat he wants is the average days that take to pay an invoice, taking the invoices from the last 6 months. Should include only invoices that are not Cash or COD.

I don't find the payment day of the invoice in the OINV table.

Does any one can help me with the tables that have to be considered or with a query already created?

Thanks

Regards

Adriana