cancel
Showing results for 
Search instead for 
Did you mean: 

Expiration date of invoices

Former Member
0 Kudos

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??

Accepted Solutions (0)

Answers (2)

Answers (2)

Lakshmipathi
Active Contributor
0 Kudos

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

former_member184555
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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.