AP aging report from SAP

[kandarpa_anand]

We found that AP aging report from SAP is not tie with Balance in Balance sheet. Please advise how to find the report which match with our requirement.

Concept of the AP aging report is to age outstanding AP as at the end of month (Open item date). We found that A/P aging report which we currently use is cannot match to balance per G/L. (Please see detail in attached file). And the balance in AP aging report is always changes if we retrieve data on difference timing.

Additionally, this report is not show the reconciliation account, please advise whether it is possible to show summary line which sum by reconciliation account.

Please advise if you have another SAP transaction or any advise on this.

kindly suggest

[kandarpa_anand]

solved

[durgasankar_innamuri]

Hi,

For ageing report please go to fbl3n and go for change layout there is a option for ageing and posting period choose those two and subtotal it according to posting then you will get period wise meand month wise ageing report for vendor.

S_ALR_87012078 - Due Date Analysis for Open Items

Hope this is clear if yes assign points

Regards,

Sankar

[Former Member]

Hi,

i entered FBL1N and selected change layout (ctrl+f8) bu it is showing only posting period but not showing ageing. plz give correct path so i can see ageing report for vendor. i hope i can get answer asap.

Thanks & Regards

Shruthi

[Former Member]

Anand if you can provide with t.code it would be helpful for us to answer you question, because we dont know what you are using as an aging report,

[Former Member]

The standard aging report should match with the GL account balance.

Are you using Special GL where certain vendor invoices will be in a different GL account? If so you need add these balances to the normal reconciliation account balance in order to tie up to the aging report balace.

Rgds

Nadini