My Oracle Support Banner

E1: 51: R51800/R51444 Does Not Create the Correct Journal Entries when Run Twice in the Same Period Under Different Scenarios (Doc ID 2708896.1)

Last updated on SEPTEMBER 03, 2021

Applies to:

JD Edwards EnterpriseOne Project Costing - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When running the R51800 Multiple Times (R51800, R51444, Post JE, No Changes to the AA ledger, R51800, R51444, Post JE, No Changes to the AA ledger.......) for the SAME period the R51800 creates incorrect journal entries.

Steps:
1.   Create a Job (P51006)
2.   Add accounts to the job (P510121)
3.   Create a JE (P0911)
4.   Post to GA (R09801)
5.   JSI (P512000)
6.   Run the R51800
7.   Review F5144
8.   Review F5145
9.   Review R51444
10. Review the Journal Entry the 1st time
11. Post the Journal Entries to General Accounting (R09801)
12. Run the R51800 using the same processing options.  No Changes to the Actuals.  SAME period.
13. Run the R51444 using the same processing options. No Changes to the Actuals.

The system is not correct if it moves the cost/revenue to the Income Statement multiple times when there are no additional amounts added to the actuals.

Build Profit Recognition Records - N5100009 

Before the Fix, the system would update the F5144 file each time the R51800 was run when no additional amounts are added.

After the Fix, the system will only update the F5144 file when changes are made to the actual amounts.

Another issue with this correction: Bug 31893321 - BUG 31693558 DIDN'T CORRECT THE ISSUE WHEN THE MONTH IS MOVED TO THE NEXT MONTH

When the R51800 and R51444 are run for a period and posted to GA, and then the date pattern is changed to the NEXT period without ANY additions, and the R51800 and R51444 are run again the system created the correct journal entries and doesn't move the amounts from the Balance Sheet down to the Income Statement again. HOWEVER, if it is run AGAIN for the same period (R51800/R51444) without any additions the system will create the original JE from the first time it was run.

Steps:
1.   Create a Job.
2.   Add accounts to the job:
3.   Create a JE.
4.   Post to GA.
5.   Review JSI.
6.   Run the R51800 for July
7.   Review F5144.
8.   Review F5145.
9.   Run the R51444 for July.
10.  July JE 1st Time.
11.  Post the Journal Entries to General Accounting for July
12.  Change the Date Pattern to August of 2020: Clear Cache if Necessary
13.  Run the R51800 for August-No Changes to the AA ledger or any other Changes. -1st time ok
14.  Try and Create JE for August
15.  Post the JE to GA for August.
16.  Run the R51800 for August- No Changes to the AA ledger or any other changes-2nd Time- Not OK.
17.  Run the R51444 using the same processing options. No Changes to the Actuals.
18.  JE are created again even though there haven't been additions.

The system should never create new JEs if new additions haven't been added no matter how many times the R51800 and R51444 are run and no matter what periods it is run in.

Possible Work around: Only run the R51800 on Jobs that have changes made to them. This is hard to determine when running lots of jobs.

The above issue has been corrected.  Please apply the Bug 31893321 - BUG 31693558 DIDN'T CORRECT THE ISSUE WHEN THE MONTH IS MOVED TO THE NEXT MONTH

Check Bug 32484862 - R51444 CREATES INCORRECT JES WHEN R51800 RUNS 2ND TIME IN THE SAME PERIOD and test by downloading ESU JN18969.

It has been determined that Bug 32765900 - RUN R51800 TWICE IN THE SAME PERIOD AT THE PROJECT LEVEL W/ ONLY ONE JOB ASSIGNED TO PROJECT AND NO OTHER CHILD JOBS ASSIGNED TO THE PROJECT and IS AAIs are pointing the a single account number has been corrected by applying all the other bugs that have been entered to address this issue.  Once code current thru Bug 32567692 the following issues should be corrected:

1. Voiding an entry in the same month and getting the system to update the R51800 and R51444 correctly.
2. Being able to run the R51800/R51444 more than once in a month.
3. Running the R51800 and R51444 where a job rolls up to the project and is the only job in the project where the R51800 and R51444 is run more than once in a month.

This issue of running the R51800 more than once has been an issue for awhile.  We are having a hard time testing ALL the setup scenarios as customers are running the R51800 with the following ways:

1. Jobs kept on the Balance Sheet/Income Statement/Combinations.
2. The IS and BS AAIs are setup very differently between companies. Some simple, some Very Complex.
3. The R51800 run by the Job/Projects/ run by jobs that are really projects with NO child jobs underneath them.

Please make sure and TEST this correction in the test environment before running it in production.  If there is a slightly different scenario that can be duplicated please open up a new Service Request to Address this issue and include the code for the N5100009 and detailed steps on how to duplicate your issue.

 

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.