Customer Ageing Report with Profit Center

[Former Member]

Hi Experts,

Kindly suggest how can I derive Profit Center in customer Ageing Report.

a) We are developing Z Report for Customer Ageing. I used table BSID to pick up all open items.

b) My user want to see this Z report by Profit Center, Customer Wise.

c) I posted some entries (Customer Invoices FB70) Customer Dr and Cr to Sales A/C(used Profit Center) when I see BSID table this document I am not able to see Profit Center its showing as blank.

d) When I see the entry in FBL5N I can see Profit Center. in customer open items.

Please advise how can I pick customer documents along with Profit Center(used for Sales GLs) in my Z Report. we are using New GL ECC6.

Thanks in advance

Regards

Srini

[suma_mani]

Hi Srini,

Use FAGLFLEXA table where you can get the PRCTR against document numbers. Pass document numbers,Year in to above said table ,which you get from BSID table.

Regards

Mani Kumar