Help with Processing Option... Financial Report

Eric · Feb 21, 2001

Hi Guys,

Ok Sorry the system that I am running on is on an AS400
B7332 SP11.3 wirh
ESU 4116422

The processing option template tyhat it keeps coming up
with is T83PO

You could recreate the same report by going into ERW,
and selecting
Financial report writer, and selecting the account
balance column twicce,
once for ledger type BA, and oncew for ledger type AA
for the same period
and range of account codes...

A third column is also utilsed which is column two - one
whic give the
variance...

The rest of the report is straightforward with the
exception of a number of
row specs which menas that it is picking up a number of
accounts...

The client wants to create differnet versions of this
report with 3
processing option

Processing option 1 and 2 are the same as the template
processing option
mentioned above i.e. Fical period and date, and
processing option 3 is 30
character field which will appear in the report
header...

I have copied the T83PO template renamed it T5583PO and
coded so that all
the information appears correctly in the header, howver
in the detail
section it is ignoring my processing options for period
number and fiscal
year...

I cant see any event rules anywhere to change, and also
the system
automatically attaches T83PO from the wizard as soon as
you specify
Financial reports

I could modify T83PO but do not want to go down this
path

Any help will be appreciated

Thanks

Marco

carlo_tan · Feb 21, 2001

RE: FW: Help with Processing Option... Financial Report

<html><DIV>

Hi Marco,</P>

</P>

This problem should not be too hard provided that you have a sufficient knowledge/experience on event rules. Whenever you use the default templates (e.g. financial reports) RDA automatically assigns the default processing option to your report. This should be obvious to you since you have noticed it happening. Thus, it also includes the processing option variables used for each of your column event rules. You can change the processing option however this does not automatically roll down to the report's event rules code. So you will have to manually look at each event rule and make sure they're using the new variables of your new processing option. Hope I got my thought through. </P>

</P>

</P></DIV>----Original Message Follows----
From: [email protected]
Reply-To: [email protected]
To: [email protected]
Subject: RE: FW: Help with Processing Option... Financial Report
Date: Wed, 21 Feb 2001 19:04:49 -0800 (PST)
MIME-Version: 1.0
X-Originating-IP: 198.144.206.172
Received: from [216.122.12.105] by hotmail.com (3.2) with ESMTP id MHotMailBC5DD534003340043215D87A0C69E9380; Wed Feb 21 19:40:44 2001
Received: by jdelist.com (8.9.3/8.9.3) id TAA10434for jdeowdevml-30618286; Wed, 21 Feb 2001 19:04:52 -0800 (PST)
Received: by jdelist.com (8.9.3/8.9.3) id TAA10415;Wed, 21 Feb 2001 19:04:49 -0800 (PST)
From [email protected] Wed Feb 21 19:41:20 2001
Message-Id: <[email protected]>
User-Agent: IMP/PHP3 Imap webMail Program 2.0.11
Sender: [email protected]
Precedence: bulk

Hi Guys,

Ok Sorry the system that I am running on!
is on an AS400
B7332 SP11.3 wirh
ESU 4116422

The processing option template tyhat it keeps coming up
with is T83PO

You could recreate the same report by going into ERW,
and selecting
Financial report writer, and selecting the account
balance column twicce,
once for ledger type BA, and oncew for ledger type AA
for the same period
and range of account codes...

A third column is also utilsed which is column two - one
whic give the
variance...

The rest of the report is straightforward with the
exception of a number of
row specs which menas that it is picking up a number of
accounts...

The client wants to create differnet versions of this
report with 3
processing option

Processing option 1 and 2 are the same as the template
processing option
mentioned above i.e. Fical period and date, and
processing option 3 is 30
character field which will appear in the !
report
header...

I have copied the T83PO template renamed it T5583PO and
coded so that all
the information appears correctly in the header, howver
in the detail
section it is ignoring my processing options for period
number and fiscal
year...

I cant see any event rules anywhere to change, and also
the system
automatically attaches T83PO from the wizard as soon as
you specify
Financial reports

I could modify T83PO but do not want to go down this
path

Any help will be appreciated

Thanks

Marco

--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Ca
t=0&Board=OWDEV&Number=6049

----- End forwarded message -----
*************************************************************
This is the JDEList One World / XE Developers Mailing List.
Archives a!
nd information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************

<br clear=all><hr>Get your FREE download of MSN Explorer at http://explorer.msn.com
</p></html>

carlo_tan · Feb 21, 2001

RE: FW: Help with Processing Option... Financial Report

<html><DIV>

</P>
<DIV></DIV>

Hi Marco,</P></DIV>

</P>
<DIV></DIV>

This problem should not be too hard provided that you have a sufficient knowledge/experience on event rules. Whenever you use the default templates (e.g. financial reports) RDA automatically assigns the default processing option to your report. This should be obvious to you since you have noticed it happening. Thus, it also includes the processing option variables used for each of your column event rules. You can change the processing option however this does not automatically roll down to the report's event rules code. So you will have to manually look at each event rule and make sure they're using the new variables of your new processing option. Let me know if you understand what I'm trying to convey. </P>
<DIV></DIV>

</P>
<DIV></DIV>

</P>
<DIV></DIV>----Original Message Follows----
From: [email protected]
Reply-To: [email protected]
To: [email protected]
Subject: RE: FW: Help with Processing Option... Financial Report
Date: Wed, 21 Feb 2001 19:04:49 -0800 (PST)
MIME-Version: 1.0
X-Originating-IP: 198.144.206.172
Received: from [216.122.12.105] by hotmail.com (3.2) with ESMTP id MHotMailBC5DD534003340043215D87A0C69E9380; Wed Feb 21 19:40:44 2001
Received: by jdelist.com (8.9.3/8.9.3) id TAA10434for jdeowdevml-30618286; Wed, 21 Feb 2001 19:04:52 -0800 (PST)
Received: by jdelist.com (8.9.3/8.9.3) id TAA10415;Wed, 21 Feb 2001 19:04:49 -0800 (PST)
From [email protected] Wed Feb 21 19:41:20 2001
Message-Id: <[email protected]>
User-Agent: IMP/PHP3 Imap webMail Program 2.0.11
Sender: [email protected]
Precedence: bulk

Hi Guys,

Ok Sorry the system that I am running on is on an AS400 !

B7332 SP11.3 wirh
ESU 4116422

The processing option template tyhat it keeps coming up
with is T83PO

You could recreate the same report by going into ERW,
and selecting
Financial report writer, and selecting the account
balance column twicce,
once for ledger type BA, and oncew for ledger type AA
for the same period
and range of account codes...

A third column is also utilsed which is column two - one
whic give the
variance...

The rest of the report is straightforward with the
exception of a number of
row specs which menas that it is picking up a number of
accounts...

The client wants to create differnet versions of this
report with 3
processing option

Processing option 1 and 2 are the same as the template
processing option
mentioned above i.e. Fical period and date, and
processing option 3 is 30
character field which will appear in the report
heade!
r...

I have copied the T83PO template renamed it T5583PO and
coded so that all
the information appears correctly in the header, howver
in the detail
section it is ignoring my processing options for period
number and fiscal
year...

I cant see any event rules anywhere to change, and also
the system
automatically attaches T83PO from the wizard as soon as
you specify
Financial reports

I could modify T83PO but do not want to go down this
path

Any help will be appreciated

Thanks

Marco

--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Ca
t=0&Board=OWDEV&Number=6049

----- End forwarded message -----
*************************************************************
This is the JDEList One World / XE Developers Mailing List.
Archives and information o!
n how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************

<br clear=all><hr>Get your FREE download of MSN Explorer at http://explorer.msn.com
</p></html>

Adrian_Chimirel · Feb 22, 2001

Marco,

This thread got all messed up (and I know why!), therefore its replies are spread all over the Forum and THAT IS WHY I was replying just 6 minutes AFTER our good friend Zoltan

Sorry for that.

Did you use the Find capability in RDA? You should be able to find the ER pertaining to the OLD processing options.
If you do not have that capability in your RDA version, then there is another (not mine, but another JDELister's) trick that could solve your problem:
When in ER, click on Print, select the "Generic / Text Only" printer and print ALL your ER into one file (say c:\myER.txt).
Finally, open your text file with notepad and use ITS Find capability to search for the ER that deals with the OLD processing options. Once you identified ALL needed ER, go there, open them up, change OLD with new proc opt, click OK and, as French people say, Voila! You're done. Good luck colega!
PS If you don't have a "Generic / Text Only" printer and you you don't know how to add it, we should be able to help with that, too.

Adrian Chimirel
Programmer Analyst
LIVE: B732.1 SP12.2, Oracle 806
SANDBOX: XE SP13, 8i
RS/6000, Citrix, 200+ clients<P ID="edit"><FONT SIZE=-1>Edited by Adrian_Chimirel on 2/22/01 06:19 AM.</FONT></P>

Zoltan_Gyimesi · Feb 22, 2001

Marco, Adrian & List,
It is just an addition to Adrian's suggestion.
If I am right then Marco's platform is B7332.
Starting from B733, you have the ability to print ER into a file on the ER Print window instead of installing "Generic / Text Only" printer and use it.
Choosing the first and native method has some major advantage:

1.) Long ER lines will be wrapped instead of truncated as it can occur using Generic printer method.
(If you still use Generic printer method then set the largest paper size for it to fit longer lines onto the "page"!)

2.) The output won't contain several printer control characters which will make harder to read the output file.

Regards,
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)

sean_gilbert · Feb 22, 2001

You should be able to get it going...

For financial reports after you get through the Wizard you will have a your
report layout with the financial columns(smart fields) you selected (ie.
AB-Account Balance) and the default Processing Option Template of T83PO.

Now change your Template to your new T5883PO and save. The you need to go
into the 'Column Inclusion' event for each column there you will find a
business function for your column (ie AB-Account Balance) in the variable
mapping of this function you will need to remap the variable for your
processing options.

Alternatively during the wizard don't select any columns for the report,
just push through it and then Change your processing option template and
SAVE.
Now you add your Smart Field Columns (AB-Account Balance, PA-Period
Activity etc..) from the Column > Create >Smart Field menus. This way the
business function mapping should follow automatically from your custom
template.

Sean Gilbert
JDEdwards Applications Consultant
PricewaterhouseCoopers

Tel: 514.201.5001 x3619
Fax: 450.655.0163

Eric
<MRiccomini@jde-one To: [email protected]
world.com> cc:
Sent by: Subject: Help with Processing Option... Financial Report
owner-jdeowdevml@jd
elist.com

02/21/2001 10:01 PM
Please respond to
jdeowdev

Hi Guys,

Ok Sorry the system that I am running on is on an AS400
B7332 SP11.3 wirh
ESU 4116422

The processing option template tyhat it keeps coming up
with is T83PO

You could recreate the same report by going into ERW,
and selecting
Financial report writer, and selecting the account
balance column twicce,
once for ledger type BA, and oncew for ledger type AA
for the same period
and range of account codes...

A third column is also utilsed which is column two - one
whic give the
variance...

The rest of the report is straightforward with the
exception of a number of
row specs which menas that it is picking up a number of
accounts...

The client wants to create differnet versions of this
report with 3
processing option

Processing option 1 and 2 are the same as the template
processing option
mentioned above i.e. Fical period and date, and
processing option 3 is 30
character field which will appear in the report
header...

I have copied the T83PO template renamed it T5583PO and
coded so that all
the information appears correctly in the header, howver
in the detail
section it is ignoring my processing options for period
number and fiscal
year...

I cant see any event rules anywhere to change, and also
the system
automatically attaches T83PO from the wizard as soon as
you specify
Financial reports

I could modify T83PO but do not want to go down this
path

Any help will be appreciated

Thanks

Marco

--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OWDEV&Number=6068

*************************************************************
This is the JDEList One World / XE Developers Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************

----------------------------------------------------------------
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from any
computer.

MRiccomini · Feb 25, 2001

Hi Guys,

Thanks for your help on this.. My Report Now works

Marco

Adrian_Chimirel · Feb 26, 2001

Re: RE: Help with Processing Option... Financial Report

It would be nice to share How/What made it work now

Adrian Chimirel
Programmer Analyst
LIVE: B732.1 SP12.2, Oracle 806
SANDBOX: XE SP13, 8i
RS/6000, Citrix, 200+ clients

Help with Processing Option... Financial Report

Eric

Active Member

carlo_tan

Member

carlo_tan

Member

Adrian_Chimirel

Legendary Poster

Zoltan_Gyimesi

Legendary Poster

sean_gilbert

Well Known Member

MRiccomini

Member

Adrian_Chimirel

Legendary Poster

Similar threads

We value your privacy