Extracting Invoice Data

You use the Invoice Data Extract program (R74H504) to extract the invoice data of the domestic and non-void transactions and submit to the Hungarian Tax Authorities. The R74H504 report extracts the invoice data from the Customer Ledger table (F03B11) and the Legal Document Header table (F7430010).

If there is an error in the selection of a transaction due to validation failure, the Invoice Extraction Error report (R74H503) displays the details of the transactions with error. The system validates the transaction based on the minimum invoice VAT amount value specified in the processing option.

Note: (Release 9.2 Update) When you run the R74H504 program, the system processes an invoice only if the Company and the Customer on the invoice are associated with the same country code even if the invoices were entered in a foreign currency. To understand the fields printed in the report generated by the R74H504 program, see Hungary B2B E-Invoicing XML Mapping (Doc ID 2450411.1) on the My Oracle Support site:https://support.oracle.com/epmos/faces/DocumentDisplay?id=2450411.1

After you extract the invoice data, the system runs the Sales and AR Invoices Real Time Extractor program (R74H501) to extract the sales and accounts receivable invoice data for each processed invoice and export it to XML files. The exported transactions are stored in the Extracted Transactions Detail table (F74H502) with Submitted (S) status.

Before you begin, set the processing options for the R74H504 program.

Default

1. Company

   Specify a country code that identifies a specific organization, fund, or other reporting entity.

2. Date From

   Specify the beginning date for the transaction code.

3. Date Thru

   Specify the ending date for the transaction code.

4. Select Date

   Specify the date type that the system uses to select records to process.

5. Threshold VAT Amount

   Specify the minimum invoice VAT amount that the system uses to select records to process. The value for this processing option must be greater than zero.

6. Fiscal Representative

   Specify the address book number of the Company's fiscal representative. If you leave this processing option blank, the system uses the Company's address number as a fiscal representative.

7. Invoice Appearance

   Specify the predefined lookup codes that identifies the physical appearance of the invoice document. Use this field to print the value of InvoiceAppearance tag in the Hungary E-Invoice Data Extract XML. If you leave this processing option blank, the system uses the default value as PAPER.