My Oracle Support Banner

EDIDLINV Batch Process Is Generating TAX Amount Of 0 When Supplier And Location Have Different VAT Regions (Doc ID 2741074.1)

Last updated on JANUARY 06, 2021

Applies to:

Oracle Retail Merchandising System - Version 16.0.2 and later
Information in this document applies to any platform.

Symptoms

When a RTV is shipped the data is record on the invc_* tables to be exported to ReIM generating a debit memo / Credit Note Request.
In the export process by the batch edidlinvc then generating the THEAD line the total vat amount is generated with the amount of $0 when the supplier and location have different Vat Region even considering that the calc_type of the VAT Region is "C" Custom and the TAX are being well record in the invc * tables.

Steps to replicate:
1. Implement CUSTOM_VAT_SQL as required.
2. Setup 2 VAT regions, one of them has calc_type as 'C' Custom.
3. Setup a supplier to VAT region and a location to another.
4. Create an RTV
5. Run edidlinv

Result:
edi file has total VAT amount as 0, where it should be the value calculated by CUSTOM_VAT_SQL.

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.