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?