Split Distributions with Tax Inclusive gives Error : Percentage is not 100%

(Doc ID 1077235.1)

Last updated on JUNE 20, 2016

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms