My Oracle Support Banner

E1: 52: How to Prevent Retainage Being Calculated for All Lines on Subsequent When Adding a New Retainage Rule (P5204) After a Contract (P5201/(P5202) Has Been Previously Generated (Doc ID 2773579.1)

Last updated on OCTOBER 05, 2022

Applies to:

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


 This  document is to explain how to setup retainage when adding additional lines or retainage rule after a contract(P5201/P5202) has been generated.

Example of setup and processing:

  1. Create Contract with multiple billing lines with no retainage or tax. (P5201/P5202) In my test, I had 1 lump sum and 2 T&M billing line types.
  2. Enter JE (P0911) and post or adhoc entries (P4812) for T&M records.
  3. Run Workfile Generation (R48120) if JE were entered
  4. Run Invoice Generation (R52121).
  5. Run Create AR (R48199) and post batch.
  6. Create a new retainage rule.   Be sure not to check the Cumulative.  This allows the retainage to only be calculated on invoices going forward.
  7. Add retainage rule of 10% to contract master (P5201).
  8. Enter another record for T&M.
  9. Run Invoice Generation (R52121).
  10. Go to Batch Review and drill into batch - Retainage is only calculated on new lines created.


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

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