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

Last updated on JULY 06, 2017

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

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