on 04-24-2019 3:45 PM
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!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Dis you check FBL1N report?
Regards,
Prasoon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.