ReIM Allowing Posting of Invoices with Tax Discrepancy

(Doc ID 2170886.1)

Last updated on AUGUST 15, 2016

Applies to:

Oracle Retail Invoice Matching - Version 15.0 and later
Information in this document applies to any platform.

Symptoms

The issue described in this document is known to Oracle, and a fix already scheduled for future release.
This article will be updated as official patch information becomes available.


When an invoice is created at the header level with the wrong tax code, the system allows the user to manually match the invoice against its receipt. The match process is successfully executed for both cost and quantity match and the invoice changes its status to "Matched". When the posting batch process is executed, the invoice change its status to "Posted", which is incorrect since a tax discrepancy exists.


Steps to Reproduce:

  1. Create a new item with VAT set to 12%, cost set to .7309. Create a new order with quantity 30.
  2. Ship and receive the order in full.
  3. Update the following system options:
      UPDATE IM_SYSTEM_OPTIONS
      SET MAX_TOLERANCE_PCT = '0', CALC_TOLERANCE = '.0001', TAX_VALIDATION_TYPE = 'RECON', NUM_TAX_ALLOW = 'S';
  4. Create a new merchandise invoice for the quantity of 30 for the item with tax rate set to 0%.
  5. Manually match the invoice with its receipt using summary match.
  6. See that invoice and receipt are shown as being within tolerance and an exact match.
  7. Invoice is successfully matched against receipt.
  8. Tax discrepancy is not identified and invoice is shown as matched.
  9. Furthermore, the invoice is posted without issues.

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