My Oracle Support Banner

INVC_MERCH_VAT Table is Not Populated in Case of Zero VAT Rate For Consignment Item (Doc ID 2278862.1)

Last updated on FEBRUARY 26, 2019

Applies to:

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

Symptoms

INVC_MERCH_VAT Table is Not Populated in case of Zero VAT Rate For Consignment Item.

Steps To Recreate:

1.Create a sale transaction for consignment item.

2.Run  SAEXPRMS batch.POSU file will be generated

3.Export to RMS by running SALEUPLOAD jobs ( UPLOADSALES.KSH and SALESPROCESS.KSH )

4. INVC_HEAD tabke has entry for consignment item but not in INVC_MERCH_VAT table.   Note: Item has Exempted 'E' VAT code.

Changes

 

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