09-28-2011 8:00 AM
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
09-28-2011 8:04 AM
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.