Autoinvoice: Grouping Rule - Transaction Grouping Based on Tax Rate Code Not Working (Doc ID 1531036.1)

Last updated on MARCH 27, 2017

Applies to:

Oracle Receivables - Version 12.0.0 and later
Information in this document applies to any platform.
Checked for relevance on 07-SEP-2014

Symptoms

The Additional Grouping Attribute of the Tax Rate is not working.
The Autoinvoice program is grouping SO lines with different tax rates to one Invoice.

For Example:
1. Created a grouping rule which the following Additional Attributes:
    Sales Order
    Attribute 1
    Tax Rate

2.  Then, created a Sales Order with following 4 lines:
     Sales Order line Attribute 11 Tax Rate SO Number
     Product VAT-25% 123
     Product VAT-0% 123
     Product VAT-25% 123
     Product VAT-0% 123

Expected Invoice behavior:
Invoice 1:
Sales Order line Attribute 11 Tax Rate SO Number
1 Product VAT-25% 123
3 Product VAT-25% 123

Invoice 2:
Sales Order line Attribute 11 Tax Rate SO Number
2 Product VAT-0% 123
4 Product VAT-0 123

Actual Invoice:
Invoice 1
Sales Order line Attribute 11 Tax Rate SO Number
1 Product VAT-25% 123
2 Product VAT-0% 123
3 Product VAT-25% 123
4 Product VAT-0% 123

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