S_ALR_87012169 R3 FCC 6.0 drill down help (AR account balance)

[Former Member]

Can anyone teach me how to display 87012169 Classic Drill Down Report? I need check the history data from Oct. 2010 to Feb. 2012 AR transactions. The Help > Application Help showed "No documentation available", I believe we did not install the help data.

I tried to use ALR_87012173 for Customer Open Items (the partical payment did not deduct from original invoice) or 87012177 (did not setup the layout yet).

Thanks,

[Former Member · Accepted solution]

Seem like you are looking for a report to display customer payments for specific periods.

One easy way is to extract from tables BSAD and KNB1. Link tables with customer number.

BSAD-AUGBL clearing document

BSAD-AUGDT clearing date

BSAD-BELNR accounting document

Accounting/billing documents are usually cleared by incoming payments or cancellation. Filter payment documents by selecting specific document number range.

[Former Member · Accepted solution]

Hi Stacy: i am new for R3 3 weeks and we do not have report wrtier only use SAP canned reports. Can you teach me how to display detail AR transaction from Oct. 2010 to Feb. 2012? Thanks,

[former_member184701]

try to use t-code FBL5N - it is very simple and clear.

regards,

[Former Member]

Hi PPIO: I used FBL5N but all partial payment did not deduct from original invoice if you short of 0.01 cent, that is why I am trying other reports from SAP. How you retrieve data and create your customized reports in R3? We will implement BW in April 2012 but do we need any report tool to create our own reports?

Our internal SAP administrator told me the FBL5N can NOT display correct balance due that is can not do task. I can not believe it, Can you teach me why we got incorrect balance due and what caused the problem? Tks.