My Oracle Support Banner

Apply VAT_CODE To An Importation Order (Doc ID 3050189.1)

Last updated on SEPTEMBER 30, 2024

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.

Symptoms

On : NA version, Merch - Procurement

ACTUAL BEHAVIOR
---------------
Apply VAT_CODE to an importation Order


Is it possible to use the GTS functionality to attach a VAT CODE (IMPTAX) to items when they are on an importation order?

Example:
Supplier: S1 from China with VAT_REGION = 2000 (CHINA)
WH: W1 on Germany with VAT_REGION = 1001 (GERMANY)

Have a Tax Rule setup as:
* Origin region: 2000
* Destination region: 1001
* Include for all departments
* VAT_CODE = IMPTAX with PERCENTAGE_RATE = 0%


On testing, using the setup explained, the system does not log the tran_data records as required.

EXPECTED BEHAVIOR
-----------------------
When receiving the merchandise from S1, the system should log on the TRAN_DATA table the 87 trancode.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Have a supplier with VAT_REGION from China
2. Have a warehouse location with VAT_REGION from Germany
3. Have a tax rule with:
+ Origin: China VAT REGION
+ Destination: Germany VAT REGION
+ All departments
+ TAX_CODE = IMPTAX(example) with Percentage = 0%
4. Have an import order for the supplier to the warehouse.
5. Receive the order and check that the IMPTAX taxcode was not included on the transaction (tran_code 87 on the tran_data).

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