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:

Goal

 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.

Solution

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