My Oracle Support Banner

E1: 47: Sales Invoice Transactions (810/INVOIC) (R42565/R47042/P47046/R47042C/R47047/P4210) (Doc ID 1338898.1)

Last updated on MARCH 25, 2024

Applies to:

JD Edwards EnterpriseOne EDI - Version XE and later
Information in this document applies to any platform.



An EDI Sales Invoice transactions (810/INVOIC) produces an electronic version of a paper Invoice or bill. A supplier will use the 810 Invoice to communicate to a buyer the specific items, price, and quantities they have delivered and now must be paid for by the buyer.


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
 Checklist for New Implementations and Troubleshooting
 Frequently Asked Questions
 Question 1: When generating EDI-information from the Invoice Print (R42565) program issues were found generating information into F470461 file. The issue lies in the field F42565.SHPN, where the program attempts to put the F4211/F42119.CDCD. Whenever there is a Commodity Code in this field the program will fail, why?
 Question 2: What tables get populated with the tax information for Invoice /EDI?
 Question 3: What are the ANTY (Type Address Number) values within F4706 EDI Order Address Information table, when processing R42565 EDI Invoice?
 Question 4: Does Global Localization, specifically Argentina, work with the standard  EDI 810 processes?
 Question 5: Client is upgrading from XE to 9.1 and noticed that the Invoice Print (R42565) EDI processing options have increased from 7 in XE to 13 in 9.1.  Also there are three new tables in 9.1 that did not exist in XE. What is the purpose of the new processing options and tables?
 Question 6: Customer requirement is to send 810 Invoices to EDI customers, how can this be achieved without manually adding the address books in the data selection for each run to equal EDI customers or not equal EDI customers. Customer doesn't want to have several different versions of the R42565. Two would be ideal one for EDI and one for non EDI. Is this possible?
 Question 7: Customer requires the trading partner id to be in the F47046 and F47047 tables. The customer can have from 1 to 100 EDI customers and would not like to manually enter the Trading partner ID into the PO for each customer when the invoice has been run. Is there any other way to handle the Trading Partner ID Requirement.
 Question 8: Is there a way to flag some EDI customers to receive both a EDI invoice and a PDF and others to receive EDI only?
 Question 9: If the client has deleted the Record Type 7 from the Flat File Cross Reference (P47002), why does the Record Type 7 still appear in the flat file created by EDI Invoice Extraction Conversion (R47042C)?
 Question 10: When a Print on Invoice - Detached (Control Code 6) Adjustment has been applied to a Sales Order, which EDI table and field contains the adjustment amount that is sent for the EDI Outbound Invoice?
 Question 11: The Customer Number (AN8) populated in the flat file created by EDI Invoice Extraction Conversion (R47042C) has a decimal with 15 following zeros. Is there a way to create the customer number with no decimals in the text file?
 Question 12: After running the EDI Invoice Extraction Conversion (R47042C) and creating the flat file, the EDI Invoice Header (Sales) - Outbound (F47046) table is not getting updated as successfully processed. How does the EDI - Successfully Processed (EDSP) field get updated to Y, so that the files do not get picked up again with next run of R47042C?

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