Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

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 a 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
    Former Member
    Posted on Apr 29, 2011 at 03:00 AM

    It can be done through user query.

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.