Skip to Content
avatar image
Former Member

Need Trial Balance report as region wise

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Apr 12, 2016 at 11:16 AM

    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. How to close a discussion and why

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 12, 2016 at 11:23 AM

    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

    Add comment
    10|10000 characters needed characters exceeded