E1: 52: Out of Balance Contract Billing Batch Created After Lowering the Schedule of Values in Billing Line (P5202) and Creating a Batch (P48221 and P48222) (Doc ID 2898098.1)

Last updated on APRIL 24, 2023

Applies to:

Symptoms

After billing the full amount on a lump sum Billing Line (P5202) and creating AR, if the Schedule of Values is changed to a lower amount, a subsequent invoice batch created in Batch Review (P48221) will lead to an out of balance IB batch when AR is created.

Steps
1. Create a Contract Master (P5201).
2. Create a lump sum Billing Line (P5202) with 5000 in the Schedule of Values field. Note that the NTE amount defaults to 5000 as well.
3. In Batch Review (P48221), create a batch, select the record and form exit to create invoice (Zero Invoice Processing = 1).
4. After submitting the invoice, select the record and select the billing line. Enter the full billing line amount (5000) and save.
5. Create AR for the batch in P48221.
6. Return to the lump sum billing line and change the Schedule of Values to 4000. Note that the NTE amount is also updated.
7. Create a new batch and invoice (P48221 and P48222).
8. Access the Work Center and notice that the following error is displayed:

Amount to Date Limit Exceeded
CAUSE: Amount to date is greater than the schedule of values.

9. Select the invoice and drill into the Billing Line revisions. Enter -1000 in the Net Amount field and save.
10. Inquire on F4812 in databrowser and note that the system did not create a Workfile record as it did when the first invoice batch was generated.
11. In Batch Review (P48221), Create AR.
12. Inquire on the R48300 Report and notice that the system created a batch that is out of balance.

Changes

Cause

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