Running Inquiries and Revising EDI Documents

This chapter includes an overview of Electronic Data Interchange (EDI) documents and discusses how to:

Determine document status.
Revise EDI documents.
Review or change inbound shipping information.
Review or change outbound invoice information.

Understanding EDI Documents

You use the Status Inquiry/Revisions program to:

View transaction information for both inbound and outbound documents:
- Revise inbound documents before you run the EDI Request for Quote Edit/Create program (R47091) to copy the data to the application tables.
- Revise outbound documents before you send them to the translator software for processing.
Determine the status of a document or a set of documents.

Common Fields Used in This Chapter

Address Number	Enter a number to identify an entry in the JD Edwards EnterpriseOne Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
Transmission Date	Enter the date that an EDI transaction was either transmitted or received.
Tran Set (transaction set)	Enter a specific type of EDI standard document or transaction.
Batch Number	Enter the batch number. The transmitter assigns the batch number. During batch processing, the system assigns a new batch number to the JD Edwards EnterpriseOne transactions for each control (user) batch number it finds.
Document Number	Enter the document number that is assigned by the transmitter in an EDI transaction. In a non-EDI environment, this number is consistent with the order number assigned at order entry time (DOCO).

Determining Document Status

This section includes an overview of document status and discusses how to run inquiries on document status.

Understanding EDI Document Status

Use the Status Inquiry/Revisions program to determine the current status of inbound or outbound documents in the EDI interface tables. The Status Inquiry/Revisions program enables you to troubleshoot any errors when sending or receiving EDI documents. For example, you might receive an error message when running the Inbound Edit/Update program to receive an inbound document. You can use the Status Inquiry program to view the current status of the EDI document in the EDI interface tables and to determine how to correct any errors. Status Inquiry/Revisions is available as an option on all EDI transaction menus.

The Status Inquiry/Revisions program appears on every menu where you can exchange EDI documents.

Form Used to Determine Document Status

Form Name	FormID	Navigation	Usage
Status Inquiry/Revisions	W47126A	Product Activity Data (G47241), Status Inquiry/Revisions	Inquire on document status.

Running Inquiries on Document Status

Access the Status Inquiry/Revisions form.

Revising EDI Documents

This section includes an overview of EDI document revision and discusses how to:

Correct or delete EDI documents.
Revise EDI control information.

Understanding EDI Document Revision

Use EDI revisions programs to revise current inbound and outbound documents in the EDI interface tables before processing.

For example, suppose that a trading partner sends you a purchase order with an incorrect item number. Before you run the Inbound Edit/Update program, you can access the document in the EDI inbound interface tables and delete it. The trading partner can then send you a corrected document. You can also use the revisions program to correct the item number. The document is correct when you use the Inbound Edit/Update program to process the data into the application tables.

Important! Changing the data in the EDI interface tables does not change the original data. If you need to change an outbound document, delete the document from the EDI interface tables first. Then, change the data in the application tables, and run the Outbound Extraction program again with the correct data. This procedure ensures that the same data is in both the application tables and the EDI interface tables that are sent to the trading partner.

Do not revise the control information without first contacting Technical Support. Modifying the control file incorrectly can cause unpredictable results in the Electronic Commerce system.

Form Used to Revise EDI Documents

Form Name	FormID	Navigation	Usage
Status Inquiry/Revisions	W47126A	Product Activity Data (G47241), Status Inquiry/Revisions	View and change EDI documents.
Revisions	(Varies depending on your menu selection.)	On the Status Inquiry/Revisions form, select a record in the detail area, and then click Select.	Revise EDI documents.

Correcting or Deleting EDI Documents

Access the Revisions form.

Revising EDI Control Information

Access the Status Inquiry/Revisions form.

You cannot access the EDI Control Revisions form from a menu. You can only access the EDI Control Revisions form from a column on Revisions form for each transaction set. Use caution when you revise control fields. If you change information on a header record, you must change the same information on every detail record associated with the header.

You use the EDI Control Revisions form to review and revise EDI control fields associated with every EDI header and detail record. EDI control fields are categorized as follows:

Fields that control processing of the transaction.
User reserved fields, which you use for data that cannot be mapped.
Fields that you use for audit purposes.

Reviewing or Changing Inbound Shipping Information

This section includes an overview of inbound shipping information and discusses how to access inbound shipping notices.

Understanding Inbound Shipping Information

After you receive an advanced ship notice (ASN), you can use the Status Inquiry/Revisions program (P47030) to:

Review, add, update, and delete the records that are contained in the F47031 table and the F47032 table.
Copy records to the EDI Shipping Notice Header Inbound table and the EDI Shipping Notice Detail Inbound table.

Forms Used to Review or Change Inbound Shipping Information

Form Name	FormID	Navigation	Usage
Work With Inbound EDI Shipping Notice (Status Inquiry/Revisions)	W47030F	Ship Notice (G47224), Status Inquiry/Revisions	Review, add, update, copy, and delete EDI documents.
Inbound EDI Shipping Header Revisions	W47030E	On the Work With Inbound EDI Shipping Notice form, select a record and then select Header Revisions from the Row menu.	Review and update header information.
Inbound EDI Shipping Detail Revisions	W47030A	On the Work With Inbound EDI Shipping Notice form, select a record and then select Detail Revisions from the Row menu.	Review and update detail information.

Accessing Inbound Shipping Notices

Access either the Inbound EDI Shipping Header Revisions form or the Inbound EDI Shipping Detail Revisions form.

Reviewing or Changing Outbound Invoice Information

This section includes an overview of outbound invoice information, lists a prerequisite, and discusses how to:

Revise header information for outbound invoices.
Change detail information for outbound invoices.
Revise detail charges for outbound invoices.

Understanding Outbound Invoice Information

You can use the Outbound EDI Invoice Inquiry application (P47046) to add or revise EDI fields in EDI maintenance programs and to support the JD Edwards EnterpriseOne Demand Scheduling (40R) system. This application supports Type 6 detached adjustments. The system uses the EDI outbound interface tables for maintaining invoice information, and it sends these fields using the Invoice Print 810/INVOIC EDI version:

Shipment Number.
Demand ID.
Release Number.
Release Date.
Release Time.
Pull Signal.
Standard Carrier Alpha Code (SCAC).
Country of Origin (Item).
Authorization Code.
Excess Responsibility Code.
Excess Reason Code.
Routing Step Number.
Delivery Date.
Delivery Time.
Number of Pieces.
Reference Number.
Demand Address Values.
Party Type and Party Name.
ID Number Type and ID Number.

Note. These demand address values are contact information that is entered into the system through inbound EDI. This information is stored in the JD Edwards EnterpriseOne Demand Scheduling (40R) system database. The system populates the F470462 table and F470472 table with additional demand-related EDI Detail data only if the Demand ID (DEID) field in the F4211 table is not blank. In either case, the system populates the F470473 table with this information by populating the EDI tables with advanced pricing information.

Prerequisite

Set up Detached Adjustments (Type 6) in JD Edwards EnterpriseOne Advanced Pricing to handle miscellaneous charges.

Forms Used to Review or Change Outbound Invoice Information

Form Name	FormID	Navigation	Usage
Work With Outbound EDI Invoices (Status Inquiry/Revisions)	W47046A	Sales Invoice (G47217), Status Inquiry/Revisions	Add or revise EDI fields for outbound sales invoices.
Status Inquiry/Revisions Outbound EDI Invoice Expanded Header Revisions	W47046C	On the Work With Outbound EDI Invoices form, locate the invoice and select Header Revisions from the Row menu. On the Outbound EDI Invoice Header Revisions form, select EDI Expanded Header from the Form menu.	Review or change invoice header data for outbound EDI documents.
Status Inquiry/Revisions Outbound EDI Invoice Expanded Revisions	W47046F	On the Work With Outbound EDI Invoices form, locate the invoice and select Detail Revisions from the Row menu. On the Outbound EDI Invoice Revisions form, select EDI Expanded Detail from the Row menu.	Review or change invoice detail information for outbound EDI documents.
Status Inquiry/Revisions Outbound EDI Invoice Detail Charges	W47046H	On the Work With Outbound EDI Invoices form, locate the invoice and select Detail Revisions from the Row menu. On the Outbound EDI Invoice Revisions form, select Detail Charges from the Row menu.	Review or change invoice detail charges for outbound EDI documents.

Revising Header Information for Outbound Invoices

Access the Outbound EDI Invoice Expanded Header Revisions form.

Changing Detail Information for Outbound Invoices

Access the Outbound EDI Invoice Expanded Revisions form.

Revising Detail Charges for Outbound Invoices

Access the Outbound EDI Invoice Detail Charges form.