My Oracle Support Banner

VAT Value Shown For A Discounted Price Item Is Incorrect On The EJournal (Doc ID 2775145.1)

Last updated on MAY 28, 2021

Applies to:

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

Symptoms

When a discount rule (example:  Buy N of X, Get Y at Z % Off) is active, notice that the VAT value shown on the Target Item is incorrect.

Steps to reproduce:
1. Create a discount rule Buy N of X, Get Y at Z % Off  (Where X= Item 80020002: $ 729.99 , Qty of N=1,   Y = Item 80040004: $10.00, Qty of Y = 2 ).
2. When the rule is active, perform a sale transaction as below
Item: 80020002 ($ 729.99)
Item: 80020002 ($ 729.99)
Item: 80040004 ($  10.00)
Item: 80040004 ($  10.00)
Item: 80040004 ($  10.00)
Item: 80040004 ($  10.00)

3. Complete the transaction with any tender type.
4. Open Admin F4 >> E.Journal F2 >> Search for the Transaction.
5. Notice the inconsistency in VAT values shown for Item: Y (i.e.

Item: 80020002 729.99 T
Desk clock
Quantity: 1 @ 729.99
8.25% VAT T: 55.63
Price excluding VAT: 674.36
Price including VAT: 729.99

Item: 80020002 729.99 T
Desk clock
Quantity: 1 @ 729.99
8.25% VAT T: 55.64
Price excluding VAT: 674.35
Price including VAT: 729.99

Item: 80040004 10.00 T
Card file
Quantity: 1 @ 10.00
8.25% VAT T: 0.76      ======> 0.76 shown
Price excluding VAT: 9.24
Price including VAT: 10.00

Item: 80040004 10.00 T
Card file
Quantity: 1 @ 10.00
8.25% VAT T: 0.38      ======> 0.38 shown for the same Item.
Price excluding VAT: 4.62
Price including VAT: 5.00

Item: 80040004 10.00 T
Card file
Quantity: 1 @ 10.00
8.25% VAT T: 0.76
Price excluding VAT: 9.24
Price including VAT: 10.00

Item: 80040004 10.00 T
Card file
Quantity: 1 @ 10.00
8.25% VAT T: 0.38
Price excluding VAT: 4.62
Price including VAT: 5.00

Total Discount: (20.00)

VAT T Taxable Amount: 1,367.19
VAT T Tax: 112.79
Total VAT Tax: 112.79


Total: 1,479.98

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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