Well, Almost! Let us see how. Have you been searching for the right report? You know what you want from the system. You need to know which TCode will get you the information you need. You just have to browse for the right reports from many SAP FI Standard Reports that come with SAP.
Let us discuss ‘Statement of Account!’
If you want just a GL Account Statement for a period quickly, YES, just with FEW parameters, then, the report is SAP Minimal Variant.
TCode – S_ALR_87012280
- GL Account,
- Company Code,
- Document date -From and To dates in Dynamic Selection,
Hit F8. Your report is ready!
Powerful Report for Statement of Account
If you are ready for a more powerful report, yes with more parameter choices to make, then read on… As an SAP FICO USER quite often you need statement of account for
- General Ledger Account
- Customer Account
- Vendor Account
and occasionally you may need to refer to the statement of account for
One Report that fulfills all the above requirements! You need to provide the respective parameters. That is it. It is interesting, isn’t it?
TCode – S_ALR_87012332
- Company Code
- Fiscal Year
General Selections – Posting Date– From & To Dates It is advisable to go for Document Date in most circumstances. Click ‘Dynamic Selection‘ Icon at the top and choose Document Date Range. Further Selections– Here you have the options to choose as required:
- GL Account Line Items (GL line item statement of account)
- Asset Line Items (Asset line item statement of account)
- Material Line Items (Transactions for a given material item)
- Customer Line Items (Customer statement of account)
- Vendor Line Items (Vendor statement of account)
- Standard Documents – Default selection
- Parked Documents
- Noted Items
- Recurring Entry Original Documents
Other parameter selections you can safely accept the defaults. You want a GL statement, check GL account line items and give the Account Code per your requirement, say 430000 Salary – Base wages. Now Hit F8. You have the report: Let us discuss more Standard Reports in the next posts! More About Reports:
Thank you for your time reading the post. Have you found this blog post useful? Please leave your comments … Thanks again!