Wrong VCT Amount in IM_AP_STAGE_DETAIL Table for the Acquisition Tax (Doc ID 3039489.1)

Last updated on AUGUST 07, 2024

Applies to:

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

Wrong VCT amount in IM_AP_STAGE_DETAIL table for the Acquisition Tax.

Steps to Recreate:

MFCS data setup:

==================

1. Ensure Supplier "2400"(Vat_Region "1000") and Location (20001/Vat Region 2000) VAT Regions are different.

2. VAT_REGION.vat_region_type = 'M' for Supplier VAT region.

3. VAT_REGION.Acq_vat_ind = 'Y' for Location VAT Region.

Make sure Vat_rate is NON-ZERO value for the item in VAT_ITEM table.

4. Create new items "102020050" for this Supplier and range the location.

5. Create a PO"2030069" for these item/Supp/Location combination.

6. Create a Shipment and Receipt for the same.

IMCS data setup:

=================

IM_SYSTEM_OPTIONS.CALC_TOLERANCE = 5, POST_ON_DOC_HEADER' Y'

1. Ensure GL Cross Reference setup is completed for TAXACQ and TAXACQ tran codes

2. Create a new Merchandise Invoice "2030069" for this PO/Location.

3. Using Default from Receipt / PO , add all the Items. Update header total cost such that header and detail total is below 5 Calc Tolerance.

4. Match the Invoice, run REIM_ROLLUP batch job

5. Run REIM_POSTING_JOB, Verify Invoice Postings to IM_AP_STAGE_HEAD & IM_AP_STAGE_DETAIL

VCT- 11.95 was added for small variance1 -1.95

VCT recorded as Actual Variance + TAXACO value ( -1.95 + -10) = -11.95

	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

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