Close Fiscal Year with Job Cost Active - anyone had problems with

[John_Dickey]

Hello. We are a manufacturing company, but we do use the Job Cost
Application in JD Edwards as part of our fixed assets processing. Because
of this, on the Close Year program we have set the first processing option
on (roll P&L even though no activity). Now 5 years later accounting is
complaining about the slowness of running FASTR reports, and even other
reports. Investigation shows that we have 12 million records in the F0902
file, with over 3,000,000 in the current fiscal year. The bulk of those
records are work order records. We populate the subledger with the work
order number and the subledger type with a "W". Our work orders hit the P&L
section of the financial statements. At almost 600,000 new work orders a
year, after 5 years that is almost 3,000,000 records - amazing eh? Even
though the work orders are long closed, they all keep rolling over to the
next fiscal year because of having to set that first option on. JDE will
not let you purge current fiscal year F0902 records, so in a Catch 22. Has
anyone else run into this situation? If so, how did you handle it? I have
gotten JDE to at least consider an enhancement request to change the Close
Fiscal Year program to address this situation, as their testing verified my
situation. Of course no guarantee the enhancement request will be accepted.

John Dickey
JDE Financial Systems
Administrator/Programmer/Analyst
White-Rodgers, Division of Emerson
St. Louis, MO
314-577-1466

 

[Colin_Hugill]

Hi,

A quick thought, I wrote a paper for Klee and Associates on FASTR
performance suggestions, I think there are several suggestions in this paper
that may help you overcome the complaints from 'accounting'. Contact Andy
Klee - [email protected] or www.JDETips.com

You should also conduct some serious analysis and review of the existing JDE
purge capabilities, but then are workorders being "closed" when they are
complete (ie are you advancing the work order status to indicate it is
closed)?. I would also give some serious in depth thought to what you do
when rolling P&L at year end - sounds like it is a bit on the grossly
inefficient side. If an F0902 record doesn't exist for current year then
the post program will create it - an AS/400 processing efficiency concept.
What is most likely - create a few (hundred) thousand records over the
course of the year for existing work orders or have them all present at the
start of the year but only use a small proportion of them.

Regards

Colin HUGILL

----- Original Message -----
From: "John_Dickey" <[email protected]>
To: <[email protected]>
Sent: Friday, March 28, 2003 9:27 AM
Subject: Close Fiscal Year with Job Cost Active - anyone had problems with


P&L
Has
have
my
accepted.



Colin Hugill
Consultant
(World A7.3 cum12)

 

[PDavis]

John:

I know this is an old post, but did you ever resolve this issue? Our F0902 is starting to grow with closed work orders, so this is becoming an issue for us too.

Peter Davis
Business Analyst
Newfoundland & Labrador Hydro

 

[JoAnnL]

There are options on g5131 that might help. You must be careful to have the yr 2000 PTF, or the results could be bad. I have used this process and it works after a fashion. There is a white paper that explains the process.