My Oracle Support Banner

ReSA Does Not Determine UNIT_RETAIL_VAT_INCL Field Correctly (Doc ID 2130157.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Retail Sales Audit - Version 14.1.1 and later
Information in this document applies to any platform.


ReSA does not include tax amount in balancing correctly.

Steps to Reproduce

1. Make sure that the CLASS_LEVEL_VAT_IND is set to 'N' and the store in testing has VAT_INCLUDE_IND = 'N'.
1a. By default all CLASS.CLASS_VAT_IND is 'Y' when the CLASS_LEVEL_VAT_IND is 'N'
2. Create an RTLOG, make sure that the store is setup with IGTAX, and the Transaction has IGTAX line.
2a. Also make sure that the Retail price is VAT exclusive and the Transaction is out of balance.
3. Once uploaded successfully, go to the transaction to fix error.
3a. Notice that on Item detail line or SA_TRAN_ITEM, the Unit retail vat incl flag is set to 'Y'.
4. The IGTAX amount can be updated on the Item Tax line, but the adjusted value will not effect the Sales total, as ReSA assumes that the Retail price is VAT inclusive when it is not.
4a. The UNIT_RETAIL_VAT_INCL indicator should be set to 'N'


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.