My Oracle Support Banner

JEILARVR Output Not Include Transaction Number Only Export Number When For Reporting Code VAT-Y Section (Doc ID 1072770.1)

Last updated on APRIL 25, 2019

Applies to:

Oracle Financials for EMEA - Version 12.0.0 to 12.0.6 [Release 12]
Information in this document applies to any platform.
REPORT:JEILARVR:Israeli AR VAT Register Report
REPORT:JEILARDR:Israeli AR VAT Register Report
REPORT:JEILR385:Israeli VAT File Related to 835 report


Find that the Israel AR VAT Register Report (JEILARVR) output not include any specific dedicated "transaction number" column. So, when the reporting code is VAT-Y (Export Vat) , only export numbers or 999999999 are seen.

This only happens in the report output section concerning VAT-Y reporting code (means, Export VAT code).
When in the VAT-Y section, the "transaction number" column in the JEILARVR works like this:
a. it should show the export number from the DFF "Additional Information for Israel" in the invoices form;
b. and if this DFF field is empty it brings '999999999' .
This is working as expected.

The problem is that for VAT-Y section due to that, it's impossible to reconcile the report to GL and other information.
so we must have another field which brings the "Transaction Number" only and always, for example. Maybe a "Transaction Number" and a separate "Export Number" column?! If the transaction number will be presented it will help identify the invoice (and do some changes if needed, enter the export number for example.)

This behavior also happens for the VAT file JEILR385 but in there, there is no problem because both numbers are seen in the record lines.

The issue can be reproduced at will with the following steps:
1. In a Israel instance;
2. Go to AR IL;
3. Rn the JEILARVR and look into it's output into the VAT-Y section - "Transction Number" column. Some lines show the export number and others 999999999 .


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

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