E1: 52: Invoice Generation (R52121) Does Not Include the Credit Amount From a Negative Billing Line in Billing Line Detail (P5202) (Doc ID 2735231.1)

Last updated on OCTOBER 27, 2023

Applies to:

Symptoms

Invoice Generation (R52121) creates a batch that is out of balance when the contract (P5201/P5202) is set up with a negative billing line. Issues occurs when using retainage flag of 3 with vertex tax calculated with an S. The Edit Register (R48300) does not take the credit amount into account when calculating the batch.

The issue can be reproduced with the following steps:

1. Create a contract (P5201/P5202) for a Company with CAD
2. Set up contract with retainage flag set to 3.
3. Set up tax with S tax explanation code.
4. Create Unit price type billing lines.
5. Add a change order and add a negative Lump sum billing line (P5202).
6. Run Invoice Generation (R52121) with a 1 to allow a zero dollar invoice.
7. Drill into the batch and populate amount fields for each line.
8. Run Journal Generation (R48131) from Row Exit.
9. Check reports - R48131, R48132, R48300
 

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.