Component Item with Zero Percent Vat_rate Gets Prorated Vat Out Retail (TRAN_CODE 88)

(Doc ID 2252134.1)

Last updated on APRIL 05, 2017

Applies to:

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

Goal


When a Pack with vat_rate greater than zero with one component item having vat_rate greater than zero and another component item with zero vat_rate is used on a sale transaction, the TRAN_DATA posting for tran_code 88 (Vat Out Retail) prorates the total_vat to both the component items even though one of the items has zero percent vat_rate.

Expecting that the total_retail should not be prorated to the item that has zero percent vat_rate, but the Vat Out Retail should be computed for the component item that has positive vat_rate.

Working: When you do a purchase via Purchase Order (PO), the tran_code 87 (Vat In Cost) is being computed correctly by using the vat_rate from VAT_ITEM table for the component tables.

Steps to Reproduce
-----------------------
1. Create a sales transaction with tax details on SVAT environment.

2. Run the following batches
- Export of POS transactions from ReSA to RMS (SAEXPRMS.PC $UP Y)
- Pre/Post Helper Processes for ReSA Batch Programs (SAPREPOST.PC $UP saexprms post)
- Upload POSU File for Processing (UPLOADSALES.KSH $UP)
- Main Processing of Staged Sale/Return Transactions (SALESPROCESS.KSH $UP)

3. Notice that on TRAN_DATA the total_retail for the component item that has 0% vat_rate gets prorated for tran_code 88.
 

Solution

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