Credit Management Reports

[Former Member]

Guys i have been looking for SAP reports that give me the following information;

- Customer Average invoice vs payment days per month and YTD.

- Company code level % of invoices paid outside payment terms vs inside payment terms

I dont think there is a standard report but any advice would be much appreciated.

Thanks

[Lakshmipathi]

What do you mean by Customer Average Invoice and Payment Days per month ?   

• Is it number of invoices generated per month or
• is it number of invoices falling due during month end
• is it number of invoices falling overdue during month end

Similarly, Payment Days per month. 

Are the customer making payment on any particular day?  If so, how it is inwarded?  Lumpsum or invoice wise the payment is accounted?

Also I am not clear on what do you mean by Inside and outside payment term

G. Lakshmipathi

[Former Member]

Our customers all have a payment term of 30 days which means they have to pay within that payment term otherwise the invoice goes overdue. invoices can go overdue throughout the month there is no standard as goods go on invoice everyday. payments can also come in anytime.

I am trying to create a report where i can see the average days a customer takes to pay its invoices, so lets say customer pays 2 invoice that are dated july and pays them that month i want to see the average days it took the customer to pay. this monthly and YTD figures

[Lakshmipathi]

Ideally, you should have checked with your Finance team or posted in FI forum.   You have also not explained how your client are updating the incoming payments; whether lumpsum or line item wise.  Nevertheless, there are some standard TCodes which may suit your requirement.  Have a look at the following TCodes

• S_ALR_87012168       Due date analysis for open items
• S_ALR_87012178       Customer open items analysis by balance of overdue items
• S_ALR_87012175       Open items customer due date forecast

G. Lakshmipathi

[moazzam_ali]

Hi Robbert

Yes you are right. There is no standard report which shows such information. You have to develop this report with the help of ABAPER. He has to use tables VBRK, VBRP, BSEG and BKPF.

Thank$