Skip to Content
avatar image
Former Member

Profit Center wise Balance sheet by SQVI ,GRR1

Hi Knowledge ,

We have used the select query and generated the report for profit center balance sheet !

the performance is too low ,

is their any possibility from the SQVI and GRR1 tool to get the desire Results .

Requirements:

GL account Long Text Location 1 Location 2 Location 3 Total .

we were very by using SQVI ----But we need the report from report painter .

How to go with the GRR1 -- to achieve the desirable results .

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Nov 14, 2016 at 03:55 AM

    Hi All,

    Logic for the /output

    First we are passing Sys Date for valid from/To field in CEPC --

    Passing the above out put to FAGLFLEXT/FAGLFLEXA == With account number , Year , HSL,HSLVT Fields .

    How to join the tables in report painter for the above requirement .

    We have copied the standard library 8A0

    Thanks

    Murali.V

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 14, 2016 at 08:44 AM

    Hi,

    If you are working with NewGL, then you have standard report by profit centre. Even if you work with some other NewGL totals table, you can build your own report via FGI0. If you work with classical G/L, then you balance sheet by profit centre could be extracted only from EC-PCA module and there also you have standard reports. So, you question is not quite clear... What is sure, though, that you shouldn't make such a report simply by SQVI; this transaction is not suitable for this.

    Regards,

    Eli

    Add comment
    10|10000 characters needed characters exceeded