Mismatch Between Header Amount and Detail Amount in EBS Accounts Payable for Consignment Invoices (Doc ID 1612752.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Invoice Matching - Version 13.1.4.4 to 13.1.9 [Release 13.1]
Information in this document applies to any platform.

Symptoms

In Oracle Retail Invoice Matching (ReIM) 13.1, consignment items posting is failing in E-Business Suite (EBS) due to an additional VCT line, different from zero, that is added to the invoice amount and not subtracted.


Steps to Reproduce:

  1. Log in to Retail Merchandising System (RMS) application.
  2. Create a consignment item.  Perform a sales transaction for the consignment item in RMS.
  3. Run saexprms (Sales Audit Export to RMS) batch to get POSU file.
  4. Upload POSU file (with included consignment item).   Check for TRAN_DATA posting.
  5. Generate a purchase order (PO) and verify entries in INVC_HEAD and INVC_DETAIL tables.
  6. Run EDIDLINV (EDI Invoice Download) batch to download the invoice.
  7. Run EDIUpload Batch to upload the invoice in ReIM.
  8. Verify that the invoice is created successfully in 'Matched' status.
  9. Run Financial Posting batch to post the invoice.
  10. Notice that consignment items posting is failing in EBS because an additional VCT line that is different from zero is added to the invoice amount.

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