HowTo: Populate F0902?

DBohner-(db)

Legendary Poster
Howdy,

I'm currently working on some financial reports - and many of the
Business Unit/Account codes do not have F0902 records populated...
actually, very few of them do (in the test environment).

What's the process(es) to get the F0902 populated? Is it some sort of
month end or ... what?

Any knowledge provided, will be greatly appreciated!

(db)

--
 
DBohner,

You will need to post some journal entries. F0902 records are generated as a
result of posting F0911 (General Ledger) entries.

Either enter some manual journal entries through the General Ledger (GL)
module, or generate some general ledger entries by completing some
transactions within other modules such as Accounts Payable or Accounts
Receivable. You will need to have some AAI (Automatic Accounting
Instructions) set up if you wish to generate GL entries through these other
modules.

If entering manual journal entries be sure to check the GL accounts you use
in your journal are set to allow manual entries (check the chart of
accounts).

Regards,

Adrian
 
Adrian,

You could also copy the production F0902 to the DV (test) F0902. If you do this you may
want to also copy the F0901 and F0911 also as all 3 of these files are meant to be in sync.

The F0901, F0902, and F0911 are the main 3 G/L files but you may need others if you report uses them (like AAIs).

For example, I have worked on some financial reports that only use the F0902 and I am currently the only person using DV. So I removed all the F0902 records from DV and copied PD into DV. It did not matter that the F0901 and F0911 were out of sync with the F0902 as I really only cared about the F0902 during development of my report. I just copied all 3 files from PD to DV when they need to be in sync.

Please keep in mind that these files can become quite large. Not so much the F0901 or F0902. But it is not uncommon for companies to have millions of records in the F0911. So it takes a while to copy this file to DV. It can be done. The copy just takes a while.

I am not sure that you have to do this but it has corrected some problems for me. After you do the copy you may need to go into OMW and rebuilt the indexes for the copied table(s).

Good Luck,
Danny.

askuodas <[email protected]> wrote:
DBohner,

You will need to post some journal entries. F0902 records are generated as a
result of posting F0911 (General Ledger) entries.

Either enter some manual journal entries through the General Ledger (GL)
module, or generate some general ledger entries by completing some
transactions within other modules such as Accounts Payable or Accounts
Receivable. You will need to have some AAI (Automatic Accounting
Instructions) set up if you wish to generate GL entries through these other
modules.

If entering manual journal entries be sure to check the GL accounts you use
in your journal are set to allow manual entries (check the chart of
accounts).

Regards,

Adrian
 
From what I can see, Financial reports can use the default BSVW of
V830001, which is over F0006, F0901 and F0902. If these three files
are copied to DV - then all should be good, and F0911 would not be a
necessary step of database resouces.

Mainly, I wanted to know if there was a simple report that could be
run to populate the F0902 - since there are no Year '3' or '4' records
within.

Stale development data - can really kill a report on its way to production.

(db)
--
 
Daniel,

If you have brought over your F0911 table, you can run the close year process. This will create F0902 with appripriate balances. Alternatively, you could copy F0902 from production to your test environment.

DBohner <[email protected]> wrote:
Howdy,

I'm currently working on some financial reports - and many of the
Business Unit/Account codes do not have F0902 records populated...
actually, very few of them do (in the test environment).

What's the process(es) to get the F0902 populated? Is it some sort of
month end or ... what?

Any knowledge provided, will be greatly appreciated!

(db)

--

Member - iConsortium Always looking for new gigs! Daniel Bohner | JDE Developer Independant-JDE/Web/Photo www.ExistingLight.Net | [email protected] JDE XE - 8.10 | AS/400
 
Hi Daniel

Whilst all previous posters made sense with their advise, there is a batch job that creates F0902 records directly from F0911. R099102 is specifically there to re-recreate F0902 records.
(My advice is to run the process for a single account first to test and also be aware that re-posting the entire F0911 may take a while)
Rgds,
 
Sef,

Thanks for your most-excellent reply - that's exactly what I was hoping for!

The server I play with, will be going down for nightly maintenance,
soon. I'll work on it some more in the morning... and provide
feedback to this post.

YOU R GREAT!

(db)

--
 
Back
Top