Incorrect VAT_CODE, VAT_RATE Posting to INVC_DETAIL Table (Doc ID 1985075.1)

Last updated on AUGUST 25, 2015

Applies to:

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

Symptoms

In Oracle Retail Merchandising System (RMS) 13.2.x, an incorrect VAT_CODE and VAT_RATE are being posted to the INVC_DETAIL table.


Steps to Recreate:

Case 1:   (Item, Supplier, Region all in the same VAT_REGION)

  1. Create a direct to store purchase order (PO) in RMS.
  2. Receive the PO in RMS.
  3. Note the VAT code on the INVC_DETAIL table is E.  It is expected that the VAT code would be S.


Case 2: 

  1. Make sure there is no data in the OUTLOC table with the outloc_type = 'BT'.
  2. Create a direct to store Purchase Order (PO) in RMS.
  3. Ship the PO in RMS.
  4. Receive the PO in RMS.
  5. Note the VAT code on the INVC_DETAIL table is Z and the VAT Rate is zero.



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