My Oracle Support Banner

Difference in Tax Amount While Performing Exchange of Same Item (Doc ID 2035568.1)

Last updated on MARCH 07, 2017

Applies to:

Oracle Retail Point-of-Service - Version 13.4 and later
Information in this document applies to any platform.


In Oracle Retail Point of Service (ORPOS), there is a difference in tax amount when performing an exchange of the same item.  This is causing an out of balance transaction while doing an even exchange for these items.

Steps to Reproduce with an Example:

   1. Scan item (A)(Ex:4321) for 50.95.
   2. Scan item (B)(Ex:4321) for 50.95.
   3. Subtotal: 101.90, Tax: 8.41, Total: 110.31.  Complete the transaction with cash.
   4. The below receipt prints:



 Onion Jacket Red               50.95  T 
 4321              1 @      50.95        
 Advan=50.95 @ 8.2500%       4.20        

 Onion Jacket Red               50.95  T 
 4321              1 @      50.95        
 Advan=50.95 @ 8.2500%       4.21        

Subtotal                        101.90    
  Advan Taxable Amount     101.90 
  Advan Tax                  8.41 
Total Sales Tax                   8.41    

Total                           110.31    

 Cash                          110.31    

Total Tender                    110.31    

Change Due                        0.00 

Number of Items Sold:                2

              Customer Copy              

   5. Check the item tax in database table ‘TR_LTM_SLS_RTN_TX’.
       a. Item (A) amount is 50.95 with tax of 4.20.
       b. Item (B) amount is 50.95 with tax of 4.21.
   6. Now, go to Return flow and return the item (B) from the previous sale transaction.
   7. On sale screen, scan the same item in same transaction.
   8. Subtotal: 0.00, Tax: 0.01, Total: 0.01.  Complete the transaction with cash.

   Tax is different for both items in step 4, which is causing the uneven exchange transaction issue while returning the second item in step 7.




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.