E1: 43: Voucher Match (P4314) Tax Calculations are off by .01 on Some Canadian Purchase Order Lines (Doc ID 3079975.1)

Last updated on APRIL 03, 2025

Applies to:

Symptoms

Sometimes on Canadian Purchase Orders, Voucher Match (P0411/P4314) calculates taxes on lines with very small amounts depending upon if all or only some the lines are selected from the Receipts To Match screen. Also sometimes the tax amount on some lines in Voucher Match have a difference of 0.01 with the same line in Supplier’s Invoice that comes in from a 3rd Party software package they use.

Steps to Reproduce:

PO Entry (P4310) was used to create a six line purchase order for a Canadian Supplier by a Canadian Branch Plant.

•  The Taxable Amount on Line 4 was 0.09
• The Taxable Amount on Line 5 was 0.18

The Tax Rate Area (P4008) percentage is 0.5 (5 %)

Create a J-Line Type Purchase Order with six lines as follows.

• Line 1 – Qty = 1, Unit Cost = 9.46, Ext Amt = 9.46
• Line 2 - Qty = 1, Unit Cost = 26.94, Ext Amt = 26.94
• Line 3 – Qty = 3, Unit Cost = 11.74, Ext Amt = 35.22
• Line 4 - Qty = 3, Unit Cost = 0.03, Ext Amt = 0.09
• Line 5 – Qty = 3, Unit Cost = 0.06, Ext Amt = 0.18
• Line 6 - Qty = 1, Unit Cost = 26.31, Ext Amt = 26.31

Use PO Receipts Entry (P4312) to receive all six lines together.

Voucher Match (P0411/P4314) was tested two different ways with different tax calculations on Lines 4 and 5 depending upon how many of the Receipt Lines were selected on the Receipts to Match screen.

First test selected all six lines

• Line 4 had a Taxable Amount of 0.09. Tax was calculated as 0.01 but it should have been 0.00 because 0.09 x 0.05 = 0.0045.
• Line 5 had a Taxable Amount of 0.18. Tax was calculated as 0.00 but it should have been 0.01 because 0.18 x 0.05 = 0.009

Second test selected only Lines 4 and 5

• Line 4 had a Taxable Amount of 0.09. Tax was calculated as 0.00 as expected
• Line 5 had a Taxable Amount of 0.18 Tax was calculated as 0.01 as expected

Changes

Cause

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