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

Last updated on JUNE 12, 2023

Applies to:

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

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