My Oracle Support Banner

Italy Localization : AP invoice GL_date is out of sync if raised using IPV protocol functionality (Doc ID 2546565.1)

Last updated on DECEMBER 04, 2019

Applies to:

EMEA Add-on Localizations - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

 Reported Issue 
 -----------------
 Issue with the generated GL_DATE for the AP invoices on validation using IPV protocol functionality .
 As mentioned , it is observed specifically with permanent sequences that have this temporary sequence link - using the IPV protocol described below:
 Italy Add-on Localization How to resolve Permanent document sequence issues in IPV Protocol Feature (Doc ID 2306097.1) . 

 Steps for replication 
 ----------------------
 Lets consider the replication with below example :-

1) Create an invoice (temporany sequence) with gl_date 28-06-2018. the Accounting date of ap_invoice_distributions_all was 28-06-2018 , gl_date in zx_rec_nrec_dist was 28-06-2018.
2) Validate the invoice.  Permanent sequence having gl_date 03-09-2018.
3) Validate the invoice in point 1, so the temoporary sequence was transformed in permanent sequence and the gl_date in AP_invoice_distributions_all changed in 03-09-2018 correctly as the last voucher number but the GL_DATE inZX_REC_NREC_DIST remained 28-06-2018.
4) Accordingly, on launching vat_register will have a gl_date in the vat register 28-06-2018 and not 03-09-2018


 Expected Behavior 
 --------------------
 THe ZX tables also should be in synchronization of the GL Date along with AP Invoice Lines and Distributions.

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.