Total Sales Tax in Store Summary Report Is Incorrect for Transactions With Negative Exchange (Doc ID 2093021.1)

Last updated on MARCH 24, 2017

Applies to:

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

Symptoms

In Oracle Retail Point of Service (ORPOS), Total Sales Tax in Store Summary report is incorrect in case of a negative exchange.


Steps to Reproduce:

Use an item that is taxable but whose tax is 0.00 (example from sample data is item 20)

1. Select F2 POS
2. Select F2 return
3. Select F3 No receipt
4. Enter item 20
5. Fill out the Return Item info screen
6. On the Sell Item screen, enter item 919 and override price to 0.25
7. Issue change of 0.01 and complete the exchange transaction

__________________________________________

6/4/15 6:15 PM
Trans.: 0036 Store: 01111
Reg.: 128 Till: 11
Cashier: Applicatio Sales: Applicatio
Customer: asd asd

Exchange

Barcode:[{C01111128003620150527]
__________________________________________

House plant, violet (1.99) N
20 1 @ 1.99
Orig. Receipt: None

CK knee socks 0.12 T
919 1 @ 0.25
Deal Discount 50.00% (0.13)
Buy 1 Item, get any 1 of 2 items 50%
Advan=0.12 @ 8.2500% 0.01

Subtotal (1.74)

Total Discount (0.13)
Advan Taxable Amount 0.12
Advan Tax 0.01
Total Sales Tax 0.01

Total (1.86)

Cash (1.86)

Total Tender (1.86)

Change Due 0.00

Number of Items Sold: 1

Return Ticket I
D: 01111-128-0527-2015-000000693

Customer Copy
__________________________________________

8. Select F9 More
9. Select F5 Manager
10. Print Till Summary Report

Summary Report

6/4/15 6:15 PM
Store: 01111 Register: 128
Cashier ID: 0

__________________________________________
Starting Date: 5/27/15

Till Summary for #: 11

__________________________________________
Open Float 100.00
Closing Float 0.00 OPEN
Over/Short (100.00)OPEN

Tender Summary Count Amount

Cash
In 0 0.00
Out 1 1.86
Net (1.86)
Counted 0.00

Over/Short (98.14)

Totals (USD)
In 0.00
Out 1.86
Net (1.86)
Counted 0.00 OPEN

Over/Short 1.86 OPEN

__________________________________________
__________________________________________

Transaction Summary Amount

Net Trans. Taxable (1.87)
Net Trans. Non-Taxable 0.00
Sales Tax (0.01) < -------- This is incorrect

__________________________________________

Tax Summary Amount

Sales Taxable 0.12
Sales Nontaxable (1.99)
My Tax Authority
Advanced Pricing TaxB 0.01
Total Sales Tax (0.01) < -------- This is incorrect


-------------- END OF REPORT -------------

Changes

 

Cause

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