Wrong Markdown/Markup in RMS When Point-of-Sale (POS) has Retail Inclusive of VAT and RMS Has Retail Exclusive of VAT (Doc ID 444204.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Sales Audit - Version 11.0.9 and later
Oracle Retail Merchandising System - Version 11.0.9 and later
Information in this document applies to any platform.
Checked for relevance on 07-December-2010
Checked for relevance on 09-September-2012


Goal

How is VAT handled by posupld.pc when Point Of Sale (POS) has retail inclusive of Value Added Tax (VAT) and Oracle Retail Merchandising System (RMS) has retail exclusive of VAT?  The following SYSTEM_OPTIONS table settings are in effect:

 stkldgr_vat_incl_retl_ind = N
 class_level_vat_ind = Y
 class level vat_ind = N for all the classes and all the stores have vat_include_ind = Y

In the current design, an incorrect markup/down is getting posted in RMS while uploading sales to the TRAN_DATA table.

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