My Oracle Support Banner

Why RMS is not Calculating VAT on its own when Posting Tran Code 1 and 2? (Doc ID 2228140.1)

Last updated on APRIL 16, 2020

Applies to:

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


When Retail Sales Audit (ReSA)exports POSU file for Retail Merchandising System (RMS) without TAX records and RMS consumes that by sales upload process, it writes Tran Code 1 (Net Sale) and 2 (excluding VAT) and it calculates the net retail excluding VAT.

If an item was marked as 90$ (US Dollars) with a VAT of 10% = 9$ in this case. Retail Point Of Service (RPOS) did take TENDER as 99$ but does not send the break up to ReSA.
Now when ReSA exports to RMS without TAX records, RMS writes:

Tran code 1 with a value of 90
Tran Code 2 with a value of 90

Why RMS is not calculating VAT on its own when posting tran code 1 and 2?
And what is the purpose of STKLEDGR_PRICING_SQL? When will this package be used in writing Tran Codes 1 and 2 ?


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.