Skip to Content
author's profile photo
Former Member

Report to show average days it takes customers to pay their invoices

I am wondering if there is a report in SAP that can help me determine the average days it takes customers to pay their invoices?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Posted on Apr 29, 2011 at 08:09 AM

    Hi,

    Try this query

    Select A.CardCode, A.CardName, Avg(A.Diff) [AverageDays] from 
    (SELECT T2.[CardCode], T2.[DocEntry], 
    T2.[CardName], max(T2.DocDate)[Inv], max(T0.DocDate) [Pay], 
    datediff(dd, max(T2.DocDate), max(T0.DocDate)) [Diff] 
    FROM ORCT T0  
    INNER JOIN RCT2 T1 ON T0.DocEntry = T1.DocNum 
    inner join OINV T2 on T1.DocEntry = T2.DocEntry
    Group by  T2.[CardCode], T2.DocEntry, T2.[CardName]) A
    Group by A.CardCode, A.CardName

    Regards,

    Bala

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Balakumar Viswanathan

      Hi,

      I have a few customers with this same request and it seems strange to me that it is not already set up in SAP Business One. We are exploring what is the best way to do it.

      There is a field on the BP Master Data Payment Terms Tab for "Average Delay'.

      From SAP help:

      Average Delay = Specify the average delay in days for payments from customers or to vendors.

      How do we populate this field automatically(legally without using transaction notification code) or are we allowed by SAP to use transaction notification for this purpose? It seems odd that this field is available but not automatically populated.

      Thanks in advance for your advice!

  • author's profile photo
    Former Member
    Posted on Apr 29, 2011 at 03:00 AM

    It can be done through user query.

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Apr 29, 2011 at 04:35 AM

    hi

    U can make the querry on the basis of Payment trems defined for each BP

    Hope it solved your person

    Regards,

    Manish

    Add comment
    10|10000 characters needed characters exceeded