My Oracle Support Banner

E1: 43: P4316 Multiple Account Distribution Adding a Penny to Last Line During Voucher Match (P4314) (Doc ID 2617815.1)

Last updated on DECEMBER 05, 2019

Applies to:

JD Edwards EnterpriseOne Procurement and Subcontract Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When performing a voucher match with multiple account distribution, a penny variance is being calculated on the last entry in the multiple account distribution form.  This causes the F0911 to have an additional .01 added to the last line in this table.  This occurs if the amount being vouchered is reduced by the same negative amount and the rest of the multiple account lines are entered to different accounts with amounts that total the amount being vouchered.

As this issue is very specific to the amounts being added in the P4316, the steps to duplicate are provided below:


STEPS
-----------------------
1. Enter a J line type purchase order in the amount of 3,102,486.85.  Go into the multiple account distribution form and select distribute by fixed amount and enter the amount on the order.  Do not distribute the amount to any other accounts.  
2. Go into voucher match (P4314).  Add a new voucher, select the order to match.  After selecting the order to match, change the amount to voucher to
1,362, 000.
3. Take the row exit to go into the multiple account distribution form.
4. On the first available line in the multiple account distribution form, input the same account entered on the order, but input a value of -1,362,000.00.
5. Fill in the rest of the lines in the multiple account distribution form with the following amounts (they can go to different accounts or the same account):

559,367.28
12,457.22
16,253.97
2,180.92
60,866.65
44,044.70
374,966.65
11,012.85
31,053.98
22,258.45
177,867.43
33,881.43
11,136.41
4,652.06.

6.  Complete the voucher process.  No error is received.
7.  Review the journal entries created.  Note the last amount in the F0911 is 4,652.07.
8.  Attempt to post the voucher.  The error Batch out of Balance is received due to the F0911 amount being .01 greater than the F0411 amount. 


BUSINESS IMPACT
-----------------------
Unable to post the voucher batch due to the batch being out of balance. The amount in the F0911 must be manually adjusted in order to post the batch.

Changes

 

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
Changes
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.