Need Trial Balance report as region wise

[brijessh]

Dear Sir/Ma'am,

I have four queries, I request you to please help me out:

1. Trial Balance report (All region wise)

2. P&L Statement separate for all region and product wise

3. Cash Flow details in ERP.

Thanks in advance.

Regards,

Brijesh Singh

[ajaycwa1981 · Accepted solution]

Hi Brijesh

First of all, may I request you to be a Good User of SCN and Close your threads once they are resolved. You will be doing a service to the community, if you indicate which reply resolved your issue (Mark as Correct Answer". Others can follow that in future.. Hope you will do that.

For your issue,

1. Usually, you create Business Areas for Regions in FI. So, you can extract financial statements at BA level.. If you are using Profit Center for that purpose, you can extract it at PC

2. P&L Account can also be extracted at BA or PC level.. P&L Statement can be extracted from COPA at Product Level

3. Cash Flow reports are available from FF7A and FF7B. You need BAs for that in my opinion.. you can explore the forum more for that

Ajay M

[Former Member · Accepted solution]

Hi Ajay,

FF7A and FF7B are cash or bank balance and liquidity forecast reports in FSCM.

Cash flow report is part of final accounts and a statutory requirement. In SAP, you can create a form via FGI5 and then report via FGI1. You will also be requiring a separate FSV in this form.

Thanks and regards

Sonu Tomar

[brijessh · Accepted solution]

Sure sir, I'll do.

[Former Member]

Hi Brijesh,

Please share your organization structure then we will be able to tell exactly how you can get region wise TB.

What are the regions? do you require books of accounts at regions level? are these regions physically offices with proper sales tax, service tax, etc registration? OR these are just marketing/sales regions.

If these regions are marketing and sales regions only then their profitability should be checked in COPA reports.

Generally, with standard configuration, you can get final accounts (TB PL BS) on segment, CoCd, Profit Center and Business Area level.

As far as product wise PL is concerned, it should be achieved in COPA reports/BI reports.

Individual product wise (material code wise) PL in FI module is not at all suggestible.

You can think of getting Product Group wise PL via FI module (if it is really required via FI only), then you have to have Product groups as profit centers and business users must be able to identify PC either at the time of entry or can do so via periodic allocation of cost.

If region and product group wise TB is really required in FI module then go for PC, you can define two types of PC hierarchy:

1. Regions

         Product groups

2. Product groups

         Regions

Cash flow report can be created in report painter or in BI (if SAP BI is available).

I hope that it will help.

Thanks and regards

Sonu Tomar