Reconciliation account report

[former_member1279634]

Hi Experts,

Kindly advise if there's a standard report in SAP where we can generate the recon account balances with corresponding details of customer/vendor.

We are using FBL1n and FBL5n but there is no field/column available for the vendor and customer.

For ex. if we query GL recon account 171200 desired output will show the following details:

Recon account     Document No. Posting date     Amount     Vendor Code     Customer Code

171200                123456           12/1/2012         1,000.00     XXXXX

Thanks.

[milind_joshi7 · Accepted solution]

HI,

Kindly try with The SAP T- Code FAGLL03 with the all required field you will get the required output for the GL Scrutiny for End user.

Where as he get the details with line item along with Customer or Vendor Code the Name has to obtain from another T- code.

Regards

Milind Joshi

[former_member1279634 · Accepted solution]

Hi Milind Joshi,

Thanks for your reply. This already meet our requirement.

Regards.

[Former Member]

Hi,

You can check report S_ALR_87012169. You can use Dynamic Selection option in the selection screen. You can even call up line item reports also.

Regards,

Ravi Kumar

[former_member1279634]

Hi Ravi,

Kindly advise how can we filter the posting period.  In the dynamic selection, even if I input period 1 all the periods are still displayed in the report once executed.

Thanks.

[sampat_kumkar]

Hi,

Go to FBL1N/FBL5N, there is option on left side "Dynamic Selections".

Select Recon account field to move to right side. Type recon account & execute the report.

You can change the layout as per requirement.

Hope it will help

Regards

Sampath

[Former Member]

Dear Elli,

After generating FBL1N and FBL5N reports, go to Change layout (Ctrl+F8) and add Account from the Hidden Fields to the Report. It will display the Vendor Code and Customer Code.

Regards,

Naresh K.

[former_member1279634]

Hi Naresh,

The user wanted the other way around.  They wanted to run selected GL recon account and then display the corresponding vendor or customer accounts.

We tried it using FBL3n but customer and vendor field are not available in this report.

Thanks.