Skip to Content
avatar image
Former Member

Expiration date of invoices

Hello,

I want to create a query that gives me all the customer invoices of a sales organisation that are expired per customer. Which tables do I have to use? Do I have to use a function to calculate the expiration date??

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Aug 12, 2008 at 01:43 PM

    Hi

    Please run the report 'RFDOPR10' in SE38 for 'Customer Open Item AnalysisBy Balance of Overdue Items'.

    Alternatively you can also try the report S_ALR_87012178

    Thanks,

    Ravi

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello,

      this is a little too complicated. I need a list that gives me:

      - invoice number, expiration date, payment term, customer

      The list in the report is too difficult to export to excel. I want to export a flat file.

  • Aug 12, 2008 at 03:00 PM

    Dear David

    What do you mean by invoice expiration date ?? On what basis, you calculate the period ??

    For information, for all billing related queries, you can use tables VBRK for header related datas and VBRP for item related datas.

    thanks

    G. Lakshmipathi

    Add comment
    10|10000 characters needed characters exceeded