Receiving advice (861/RECADV) is a document that represents customer confirmation to the supplier. This document indicates that the customer has received the order, or part of the order. The receiving advice document also includes the customer's acceptance or rejection of the items and describes the condition of the items upon receipt.
In a nonconsignment warehouse environment, the customer sends the receiving advice after the customer records the receipt of goods (what was accepted and rejected). The supplier then updates the customer sales order with the information that the supplier received from the customer and issues an invoice to the customer.
When a supplier receives receiving advice into sales documents from a customer, the translator software maps the data into a flat file and the Inbound Conversion program copies it to the EDI inbound interface tables. After this data appears in the EDI inbound interface tables, the supplier needs to copy the data to tables in the Sales Order Management system so that Sales Order Management can process the receiving advice documents.
To copy the data, run the Inbound Edit/Update program from the Customer Order Change menu. The Inbound Edit/Update program retrieves the data from the EDI inbound interface tables and copies it to the Sales Order Management application tables.
When the Inbound Edit/Update program copies the data into the tables in the Sales Order Management system, the Sales Order Management system does the following:
• Locates the correct sales order by using J.D. Edwards order number, order type, order key company, or order suffix that is mapped in the header record of the EDI receiving advice.
• Reads the EDI Receiving Advice Header table and matches it to a J.D. Edwards sales order.
• Reads the EDI receiving advice detail records and matches them to the J.D. Edwards sales order detail line.
• Records the receipt of goods or services at a customer site.
• Updates the corresponding J.D. Edwards sales order detail record to a damaged goods status if you have mapped damaged goods to an EDI receiving advice record.
If you do not map damaged goods to an EDI receiving advice record, the system updates the status normally.
• Prints the EDI Damaged Goods report, which lists records that have damaged goods.
• Updates the J.D. Edwards sales order with text that is associated with an EDI receiving advice.
• Marks the corresponding records in the EDI Receiving Advice tables as processed.
The system cannot process any record that has already been processed.
Depending upon the business environment, the transaction can be inbound to sales or inbound to purchasing. This transaction can also be sent out of purchasing. See Receiving Advice into Purchasing (861/RECADV) for information about receiving advice documents into the Procurement system.
The following diagram illustrates the process for using Receiving Advice.
3. Company A sends the PO to Company B.
4. Company B processes the order
5. Company B ships the good or services to Company A.
6. Company A records an online PO receipt and sends an advice to Company B acknowledging that the order has been received and the condition of the goods that were received.
7. Company B runs the Inbound Edit/Update program for receiving advice into sales to update the status of the sales order. Company B then issues an invoice to Company A for payment.
EDI Inbound Interface Tables
When you run Inbound Edit/Update for receiving advice into sales, the program uses the following EDI inbound interface tables:
• EDI Receiving Advice Header - Inbound (F47071)
• EDI Receiving Advice Detail – Inbound (F47072)
• EDI Order Text Lines - Header (F4714)
• Order Text Lines - Detail (F4715)
Mapping Guidelines
Mapping is the process of converting information from one table structure to another. In the following EDI interface tables, the fields listed must contain data before you can use the Inbound Edit/Update program for receiving advice into sales effectively:
• EDI Receiving Advice Header - Inbound (F47071):
• EDI Document Number (EDOC)
• EDI Document Type (EDCT)
• EDI Document Key Company (EKCO)
• EDI Transaction Set (EDST)
• Send/Receive Flag = R (EDER)
• JDE Order Number* (DOCO)
• JDE Order Type* (DCTO)
• JDE Order Key Company* (KCOO)
• JDE Order Suffix* (SFXO)
• Customer Order Number (VRO1)
• Sold To Address Book Number (AN8)
*Map either these fields or the Customer Order Number (VRO1) field.
• EDI Receiving Advice Detail – Inbound (F47072):
• EDI Document Number (EDOC)
• EDI Document Type (EDCT)
• EDI Document Key Company(EKCO)
• EDI Transaction Set (EDST)
• Send/Receive Flag = R (EDER)
• Total Quantity received (VREC)
• Short Item Number (ITM), Second Item Number (LITM), Third Item Number (AITM), or Customer Item Number (CITM)
• JDE Document Line Number (LNID)
• Sold To Address Book Number (AN8)
Map the J.D. Edwards sales order detail line number in the EDI receiving advice detail record.
Map the total quantity received to UREC. Other quantities that are informational only should be mapped to URET, UDMG, UREJ, UIQ1, UIQ2, and UIQ3. The informational quantities display on the Damaged/Rejected Goods Report along with their corresponding reason code, but are not used in processing.
Application Tables Updated
When you run Inbound Edit/Update for receiving advice into sales, the program copies the data from the EDI interface tables and updates the following application tables in the Sales Order Management system:
• Sales Order Detail (F4211)
• Sales Order Detail Ledger (Flexible Version) (F42199)
►
To receive advice into salesFrom the Receiving Advice - Sales menu (G47216), choose Inbound Edit/Update.
1. On Work With Batch Versions – Available Versions, choose the program version that you want to use.
2. From the Row menu, choose Processing Options.
3. In the first field, enter 1 to run this program in final mode. Leave this processing option blank to run this program in proof mode.
4. In the second field, enter the Next Status code that this order line should be updated to if no discrepancies are found.
5. In the third field, enter the Next Status code that this order line should be updated to if discrepancies are found.
6. Click OK.
7. Click Select.
8. On Version Prompting, choose any of the following options to review the report feature options:
• Data Selection
• Data Sequencing 9. Click Submit.
The Inbound Edit/Update program updates EDI documents that are successfully processed in the EDI inbound interface tables to prevent duplicates. The program updates EDI documents by placing Y in the Processed column (EDSP) in all of the EDI inbound interface tables.
Processing Options for EDI Receiving Advice - 861 UPDATE OPTIONS
Enter '1' to run this program in final mode. If left blank, the program will run in proof mode.
Enter the Next Status to update the Sales Order Line to, if no discrepencies are reported.
Enter the Next Status to update the Sales Order Line to, if discrepencies are reported.