My Oracle Support Banner

Split Distributions with Tax Inclusive gives Error : Percentage is not 100% (Doc ID 1077235.1)

Last updated on MAY 07, 2019

Applies to:

Oracle Receivables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
ARXTWMAI, Distributions


Symptoms


The entry of multiple distribution line is not consistent when line amount is tax inclusive.

This problem occurs whether you distribute by entering the distribution amounts, or by entering a distribution percentage split. The system treats the first distribution line (correctly) as being inclusive of VAT, but
treats the subsequent distribution lines (incorrectly) as being exclusive of VAT.

For example, Enter a single invoice line for 100.00 (inclusive of 25% VAT) total line 100.00 line amount 80.00 tax amount 20.00

1. When Using Amount Split to Distribute Invoice Lines

Now enter 5 distributions filling up the amount field, each for 16.00 (1/5 of the net invoice line value).
When entering the first distribution, the system correctly calculates the distribution percentage as 20% (16.00 / 80.00). i.e. 20% of the net line amount excluding the VAT.

When entering the remaining distributions, the system incorrectly calculates the distribution percentage as 16% (16.00 / 100.00). i.e. 16% of the gross line amount including the VAT.

you get :

line class % Distribution Amount
1 Revenue 20.0000 16.00
1 Revenue 16.0000 16.00
1 Revenue 16.0000 16.00
1 Revenue 16.0000 16.00
1 Revenue 16.0000 16.00

total % is 84.00 Total Amount 80.00
Transaction Line Amount 100.00

When you try to save, you get an error message that the distributions do not add up to 100%

2. When Using Percentage Split to Distribute Invoice Lines

Now enter 5 distributions filling up the % field, each for 20% of the invoice line value.
When entering the first distribution, the system correctly calculates the distribution amount as 20% of 80.00 = 16.00. i.e. 20% of the net line amount excluding the VAT

When entering the remaining distributions, the system incorrectly calculates the distribution amount as 20% of 100.00 = 20.00. i.e. 20% of the gross line amount including the VAT.

you get :

line class % Distribution Amount
1 Revenue 20.0000 16.00
1 Revenue 20.0000 20.00
1 Revenue 20.0000 20.00
1 Revenue 20.0000 20.00
1 Revenue 20.0000 20.00

total % is 100.00 Total Amount 96.00
Transaction Line Amount 100.00

Only when you complete the transaction, and then go back and view the distributions do they look correct. Although this method (using percentage splits) ultimately works, it is very confusing.

The distribution amounts should be calculated correctly at the time of initial data entry.

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.