My Oracle Support Banner

E1: 52: To Date Retainage Displays Incorrect Value in Time and Material Billing Line Revisions (P52221) After Partial Retainage Release on T&M Billing Line (Doc ID 2801826.1)

Last updated on AUGUST 25, 2021

Applies to:

JD Edwards EnterpriseOne Contract and Service Billing - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

After creating A/R for a partial retainage release on a T&M Billing Line, once a subsequent invoice is created, the Time and Material Billing Line Revisions (P52221) will not display the correct Retainage To Date. The value will not match the Retainage To Date in Contract Billing Line Inquiry (P5222).

Steps:
1. Create Contract (P5201) with Retainage Rule assigned to contract Master.
2. Create a Type ‘T’ billing line (P5202).
3. Cross Reference the T line to a billable account on the job.
4. Process transactions against the billable account (P0901) and post.
5. Run Workfile Generation (R48120) to pull transactions into billing workfile.
6. Run Invoice generation (R52121).
7. Inquire on the batch in Batch Review (P48221). Select the record and drill into the batch to access Billing Line Inquiry (P5222). Review Retainage Current, Prior and To Date
8. Select the billing line again to access Time and Material Billing Line Revisions (P52221). Click on the Retainage tab and review Retainage Current, Prior and To Date.
9. Return to Batch Review (P48221) and take the row exit to Create A/R.
10. In Batch Review (P48221), Create new batch and manual invoice (P52121).
11. Drill into the invoice batch to review retainage in P5222. Confirm Current, Prior and To Date retainage are correct.
12. Select the line to access Billing Line Revisions (P52221); enter a partial release amount, then confirm Current, Prior and To Date are correct.
13. Exit back to P5222; confirm Current, Prior and To Date retainage are correct.
14. Return to Work with Batches and take the row exit to Create A/R
15. Process another journal entry (P0911) against the billable account and post the batch (R09801)
16. Run Workfile Generation (R48120) over the batch to pull the transaction into the workfile.
17. Run Invoice Generation (R52121) over the contract.
18. Find the new batch in Batch Review (P48221). Select the line and drill Contract Billing Line Inquiry (P5222); notice that Current, Prior and To Date retainage amounts are correct.
19. Select the line to access Time and Material Billing Line Revisions (P52221); click on the Retainage Tab and notice that Current and Prior retainage are correct, however To Date Retainage is incorrect. To date should display as the sum of prior and current retainage and should match the prior retainage shown in the P5222.


 

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.