Skip to Content
0

Profit Center wise Balance sheet by SQVI ,GRR1

Nov 14, 2016 at 03:33 AM

65

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Murali Raju Nov 14, 2016 at 03:55 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Eli Klovski
Nov 14, 2016 at 08:44 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded