cancel
Showing results for 
Search instead for 
Did you mean: 

Past Due Vendor Invoice

Hi There....i'm looking to work up a scorecard in excel using data from SAP for me to effectively report on all invoices for specific company codes.

Ideally, I would like to be able to input a company code, run the report wide open up to today's date and be able to use the data to show which invoices are past due, how much $$ is owed by vendor and manipulate that data in excel.

I tried using transaction S_ALR_87012078, but found that it did not meet the requirements of what data i need to see and it was not able to be customized.

Are there any transactions which I could use/customize to obtain this data?

Thank you!

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member365886
Contributor
0 Kudos

Hi Steve,

Please check t-code S_ALR_87010042 with wide selection criteria for Vendor open items,similar reports are present for Customer open items as well.

Regards,

Avik

Prasoon
Active Contributor
0 Kudos

Hi,

Dis you check FBL1N report?

Regards,

Prasoon