E1: 51: Over/Under Billing JE Incorrect When Running Profit Recognition By Subledger (Doc ID 2075869.1)

Last updated on NOVEMBER 08, 2016

Applies to:

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

Symptoms


When running the Create Journal Entries program (R51444) for a specific job and sub ledger, the system is not creating the correct over/under billing journal entry at the sub ledger level.
The projected final amount at the sub ledger level is not populated and therefore the job percent complete calculates as zero and the over/under billing calculates as just the actual revenue amount which is incorrect.

The over/under billing amount at the sub ledger level should be calculated as follows:
Job percent complete = Actual amounts / Projected Final amounts

Job Percent Complete x Projected Final Revenue = Earned Revenue

Earned Revenue - Actual Revenue = Over/Under Billing amount.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms