Issue with Report Painter

Former Member — Wed, 28 Sep 2011 07:00:00 GMT

Hi All,

I have came across a strange problem in a current issue where a custom Repost Painter have been developed for 'New GL Reporting Library', it has to show Actual/Plan/ZGRS/FI10 outputs in a single report.

The report layout is like this,

Report                 ZPC-0001      ZGRS & FI10 Reporting - Act/Plan//Var                             Horizontal page 1  /
Section                0001          Act/Plan/Var - ZGRS
Standard layout        ZPC-001



Format group:                                      0                  0                  0                  0

Account Number/Account Description-ZGRS                  Actual              Plan            Var.(abs.)          Var.(%)

******       Goodwill Cost                            XXX,XXX,XXX.XX     XXX,XXX,XXX.XX     XXX,XXX,XXX.XX     XXX,XXX,XXX.XX
******       Goodwill Amort.                          XXX,XXX,XXX.XX     XXX,XXX,XXX.XX     XXX,XXX,XXX.XX     XXX,XXX,XXX.XX
*******      Goodwill NBV                             XXX,XXX,XXX.XX     XXX,XXX,XXX.XX     XXX,XXX,XXX.XX     XXX,XXX,XXX.XX
*****        Patents and Trademarks Cost              XXX,XXX,XXX.XX     XXX,XXX,XXX.XX     XXX,XXX,XXX.XX     XXX,XXX,XXX.XX
*****        Patents and Trademarks Amort.            XXX,XXX,XXX.XX     XXX,XXX,XXX.XX     XXX,XXX,XXX.XX     XXX,XXX,XXX.XX
******       Patents and Trademarks NBV               XXX,XXX,XXX.XX     XXX,XXX,XXX.XX     XXX,XXX,XXX.XX     XXX,XXX,XXX.XX
*****        Development Costs Cost                   XXX,XXX,XXX.XX     XXX,XXX,XXX.XX     XXX,XXX,XXX.XX     XXX,XXX,XXX.XX
*****        Development Costs Amort.                 XXX,XXX,XXX.XX     XXX,XXX,XXX.XX     XXX,XXX,XXX.XX     XXX,XXX,XXX.XX

Now, when we are executing the output transaction with the desired inputs we are getting correct data for fiscal year 2011 whereas for fiscal year 2010 we are not getting Sales Cost data for ZGRS output whereas for fiscal year 2012 we are not getting the Sales Cost in FI10 output, whereas as per the standard output both Sales Cost data present in ZGRS and FI10 have to be synchronous.

The selection screen is like below:

Fiscal Year                     2011
Plan Version                    0
From Period                       1
To Period                        16

Company Code                    0100               to
Profit Centre Group
Or value(s)                     1602               to
Financial Statement Version     ZGRS.Z
Or value(s)                                        to
Cost Element Group
Or value(s)                     841000             to

Target Currency (Local Crcy)    GBP
Exchange Rate Date              28.09.2011
Exchange Rate Type              M

Edited by: subhajit.roy on Sep 28, 2011 12:31 PM

Re: Issue with Report Painter

Former Member — Wed, 28 Sep 2011 07:04:53 GMT

The output for fiscal year 2011 is coming as :

Report: Plan/Act/Var - ZGRS                                                       Page:   2 /  4

Profit Centre/Group: 1602            Description: Speciality Legacy AR.
Reporting Period:   1 to 16          Report Executed On:   28.09.2011
Fiscal Year: 2011                    Time Report Executed: 07:55:35

Account Number/Account Description-ZGRS                  Actual              Plan            Var.(abs.)          Var.(%)

            841000  Sales Costs                            18,947.26                             18,947.26
*           Other General Expenses                         18,947.26                             18,947.26
**          Other Operating Charges                        18,947.26                             18,947.26
***         Total Other Operating Charges                  18,947.26                             18,947.26
****        Total Operating Costs                          18,947.26                             18,947.26
*****       Operating Profit/(Loss)                     9,260,718.91-                         9,260,718.91-
******      Profit/(Loss) Before Interest               9,260,718.91-                         9,260,718.91-
*******     Profit/(Loss) Before Tax                    9,260,718.91-                         9,260,718.91-
********    Profit/(Loss) After Tax-Cont Operation      9,260,718.91-                         9,260,718.91-
*********   Group Profit/(Loss) for Financial Year      9,260,718.91-                         9,260,718.91-
**********  Profit/(Loss) for Financial Year            9,260,718.91-                         9,260,718.91-
*********** Account


Report: Act/Plan/Var - FI10                                                       Page:   3 /  4

Profit Centre/Group: 1602            Description: Speciality Legacy AR.
Reporting Period:   1 to 16          Report Executed On:   28.09.2011
Fiscal Year: 2011                    Time Report Executed: 07:55:35

Cost/Revenue Element & Description-FI10                  Actual              Plan            Var.(abs.)          Var.(%)

  841000  Sales Costs                                      18,947.26                             18,947.26
* Variance Total                                           18,947.26                             18,947.26

I hope I am clear in making you all understand the issue, please let me know how i can rectify this issue and provide proper data for fiscal year 2010 and 2012.

topic Re: Issue with Report Painter in Application Development and Automation Discussions

Issue with Report Painter

Re: Issue with Report Painter