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.
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
edi file has total VAT amount as 0, where it should be the value calculated by CUSTOM_VAT_SQL.
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