This chapter contains the following topics:
As an alternative to manually receiving consumption information from the customer, you can set up the system to receive information electronically using EDI. When you process EDI transactions, you might use a trading partner and translator software to prepare the records for JD Edwards EnterpriseOne tables.
The JD Edwards EnterpriseOne Outbound Inventory Management system can process inbound electronic receipts for EDI Standard 852 (Product Activity Data - Inbound) transaction set.
Standard 852 is used where the receiver of the transaction (supplier) maintains inventory levels on their computer for the sender of the transaction (customer) and plans when orders should be issued to replenish the customer's stock.
You can use EDI to receive outbound inventory consumption transmissions. To receive these transmissions, you run a program that converts and transfers the EDI information from the format that was sent by the customer in the EDI tables into the format that is used by the EnterpriseOne tables.
See Processing EDI Documents, Receiving EDI Standard Business Documents.
To process transmissions that are received through EDI, you must understand the mapping requirements for each of its components when they are received.
These tables are used to receive EDI transmissions:
EDI Product Activity Data Header - Inbound (F47121)
EDI Product Activity Data Detail - Inbound(F47122)
EDI Product Activity Data (SDQ) - Inbound(F47123)
You can receive multiple transactions in a single EDI transmission. The system uses key fields in EDI tables F47121, F47122, and F47123 to differentiate transactions and their related components. You should assign the same value to the key fields in all of the EDI tables.
To successfully process EDI transactions, complete the required fields in the EDI Product Activity Data Header - Inbound (F47121) table:
Field Name | Alias | Type | Length | Definition |
---|---|---|---|---|
EDI - Document Number | EDOC | Numeric | 9 | The document number that is assigned by the transmitter in an EDI transaction. |
EDI - Document Type | EDCT | String | 2 | The document type that is assigned by the transmitter in an EDI transaction. |
Company - Key (EDI - Document Key Co) | EKCO | String | 5 | The company that is assigned by the transmitter in an EDI transaction. |
EDI - Transaction Set Number | EDST | String | 6 | A code used to identify a specific type of EDI transaction. |
EDI - Send/Receive Indicator | EDER | Character | 1 | Indicator used to identify if a specific transaction set can be sent, received or both. Valid values are:
S Send R Receive B Both |
Transaction Handling Code | THCD | Character | 1 | EDI Code designating the action to be taken by all parties. See User Defined Code Table 47/TH for valid codes. Refer to ANSI X.12 Data Item 305. |
Address Number | AN8 | Numeric | 8 | A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
For Outbound Inventory transactions, this field represents the Sold To value. |
To successfully process EDI transactions, complete the required fields in the EDI Product Activity Data Detail - Inbound (F47122) table:
Field Name | Alias | Type | Length | Definition |
---|---|---|---|---|
EDI - Document Number | EDOC | Numeric | 9 | The document number that is assigned by the transmitter in an EDI transaction. |
EDI - Document Type | EDCT | String | 2 | The document type that is assigned by the transmitter in an EDI transaction. |
Company - Key (EDI - Document Key Co) | EKCO | String | 5 | The company that is assigned by the transmitter in an EDI transaction. |
EDI - Transaction Set Number | EDST | String | 6 | A code used to identify a specific type of EDI transaction. |
EDI - Send/Receive Indicator | EDER | Character | 1 | Indicator used to identify if a specific transaction set can be sent, received or both. Valid values are:
S Send R Receive B Both |
Address Number | AN8 | Numeric | 8 | A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
For Outbound Inventory transactions, this value represents the Ship To value. |
EDI - Line Number | EDLN | Numeric | 7 | This is the line number you assign when originating an EDI transaction. This number can represent an order line number (applicable for any order type), an invoice pay item, a journal entry line number, and so on. |
Product Activity Code | PACD | String | 2 | A code identifying activity details for the product being reported on an EDI Product Activity Data transaction. See User Define Code 47/PA. Refer to ANSI X.12 Data Item 859.
For receiving Outbound Inventory consumption data, you must specify a product activity code of type C from UDC 47/PA. |
Sort Selection Sequence | KSEQ | Numeric | 3 | The sort sequence allows you to specify whether data is to be included in the sequence. For example, you could sequence a version of the report by Alpha Name, Reporting Code 1 and Address Number and a second version of the report by State, Alpha Name and Postal Code. |
Supplier Name | VR01 | String | 25 | An alphanumeric value used as a cross-reference or secondary reference number. Typically, this is the customer number, supplier number, or job number.
For Outbound Inventory transactions, this field represents the Customer Purchase Order number. |
Item Number - Short | ITM | Numeric | 8 | An eight-digit, computer-assigned item number |
2nd Item Number | LITM | String | 25 | A 25-digit, user defined, alphanumeric item number. |
3rd Item Number | AITM | String | 25 | A 25-digit, free-form, user defined alphanumeric item number. |
Item Number - Customer/Supplier | CITM | String | 25 | The cross-reference item number that the system assigns to an item number. A cross-reference number allows you to use a supplier's item number if it is different from your own item number when you are processing an order or printing. |
Transaction Quantity | TRQT | Numeric | 15 | A value that represents the available quantity, which might consist of the on-hand balance minus commitments, reservations, and backorders. You enter this value in the Branch/Plant Constants program (P41001).
For Outbound Inventory transactions, the quantity in this field represents the consumed quantity or the remaining quantity at customer's location. The value in the FT (FROTO) field identifies the value in the Transaction Quantity field. FT field can contain values:
|
Unit of Measure - Transaction | TRUM | String | 2 | The unit of measure you used when you entered this transaction into the system. |
Units - Secondary Quantity Ordered | SQOR | Numeric | 15 | If the secondary unit of measure option in Inventory Constants is selected, this field will display on data entry screens.
For dual pick items, you must update the secondary quantity. If you do not specify the secondary quantity, the system considers the secondary quantity as zero. |
Unit of Measure - Secondary | UOM2 | String | 2 | A user defined code (00/UM) that indicates an alternate unit of measure for the item. |
Agreement Number | DMCT | String | 12 | This field represents the Outbound Inventory agreement number.
You can leave this field blank. If you leave this field blank, the system automatically identifies the agreement based on Sold To, Ship To, Item Number and Location values and consumes quantity from the agreement. If the system finds more than one agreement for the entered agreement search criteria, it consumes inventory from the first agreement. |
Supplement Number | DMCS | Numeric | 3 | The supplement number records any changes or addendum to outbound inventory agreements that occur over time or by item |
EDI - Transmission Date | EDDT | Date | 6 | The specific date that an EDI transaction was either transmitted or received.
For Outbound Inventory transactions, this field represents the consumption date. |
Explanation - Transaction | TREX | String | 30 | Text that identifies the reason that a transaction occurred. |
Business Unit | MCU | String | 12 | An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant.
You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority. For Outbound Inventory transactions, this field represents the Outbound Branch/Plant. |
Location | LOCN | String | 20 | The storage location from which goods will be moved.
For Outbound Inventory transactions, this field represents Outbound Location. You can map customer's location to a location in the JD Edwards system, using the Location Cross Reference application (P4109). |
This section provides an overview of the transfer of inbound transmissions and discusses how to:
Extract EDI flat file
Transfer data from extracted flat file to JD Edwards EnterpriseOne tables
Before you save inbound EDI data in EnterpriseOne tables, you must extract the inbound EDI flat file. You can extract flat files through the following programs:
Flat File Cross-Reference (P47002)
Inbound Flat File Conversion (R47002C)
Access the Flat File Cross-Reference form.
Form Name | Form ID | Navigation |
---|---|---|
Flat File Cross-Reference | W47002B | Product Activity Data (G47241) menu, Inbound Flat File Cross-Reference. |
On the Flat File Cross-Reference form, complete the following fields:
Enter a code that specifies the type of EDI transaction. Enter 852.
Enter a code to specify whether the transaction is inbound or outbound. Enter 1 for inbound.
Enter an identifier to mark EDI transaction record as header or detail information. Enter:
1 for EDI Product Activity Data Header - Inbound (F47121) records
2 for EDI Product Activity Data Detail - Inbound (F47122) records
5 for EDI Product Activity Data (SDQ) - Inbound(F47123) records
Enter the file name of the flat file with the complete path.
Click OK to save the record.
Before you can extract EDI flat file data, you must set processing options for the Inbound Flat File Conversion Program.
This section provides an overview of reporting outbound inventory consumption through EDI and discusses how to: report consumption after receiving consumption data through EDI flat file.
Set Processing options for EDI Product Activity Data Edit/Create (R47121) program
Run the EDI Product Activity Data Edit/Create program
Once you receive and convert consumption data from the customer, and save it in EnterpriseOne tables, you must use the EDI Product Activity Data Edit/Create (R47121) program to update consumption details in the Outbound Inventory Management system tables.
Processing options enable you to define versions, document types, and default values for running the EDI Product Activity Data Edit/Create program.
Enter a value that specifies whether the program runs in proof or final mode. Values are:
0: Run in proof mode
1: Run in final mode
Enter a value that specifies if the servers flag or ignore warnings. Values are:
1: Servers flag warning
2: Servers ignore warning
Enter a code that identifies the document type for + transactions.
Enter a code that identifies the document type for - transactions.
Enter a code that identifies the document type for replacement transactions.
Enter a code that identifies the document type for transfer transactions.
Enter 1 to use the location and lot from primary location as default values for FROM transfers.
Enter 1 to use the location and lot from primary location as default values for TO transfers.
Enter a code that identifies the default customer number.
Enter the general ledger date to be used.
Enter a value to specify if the system processes SDQ records for outbound inventory consumption reporting or not. Values are:
Blank: Do not process SDQ records
1: Process SDQ records for consumption reporting overrides
Specify the version of the Report Outbound Inventory Consumption program (P42I03) to be used for EDI transactions.
Access the EDI Product Activity Data Edit/Create program.
Form Name | Form ID | Navigation |
---|---|---|
EDI Product Activity Data Edit/Create | R47121 | Batch Versions, R47121 |
After setting processing options, run the EDI Product Activity Data Edit/Create program to update consumption data to tables in the Outbound Inventory Management system.
To measure the accuracy and timeliness of shipments, you can use Advanced Ship Notices (ASN) with Outbound Inventory Management. You can list order information, product description, physical characteristics, and outbound inventory agreement information in the ASN.
See Sending Shipping Notices (856/DESADV) in the JD Edwards EnterpriseOne Data Interface for Electronic Date Interchange Implementation Guide.
To send ASN for outbound inventory management, you must send the information for field Outbound Inventory Detail for ASN (OIASN). This field is used to provide outbound inventory agreement details in EDI 856. The system updates the field with one of the following values:
OI01- Internally owned shipment lines
OI02- Customer owned VMI lines
You can use the EDI standard 810 to send EDI invoices for outbound inventory orders to customers.
To send detail information about outbound inventory orders, you must activate Extended EDI Invoice processing for Print Invoices program (R42565).
You use processing options to set default values for EDI processing for outbound inventory.
Use this processing option to specify whether the system populates the EDI Invoice Expanded Header (F470462) and EDI Invoice Expanded Detail (F470472) tables when printing invoices. Valid values are:
Blank: Do not populate the tables.
1: Populate the tables.
After setting the processing options for the Print Invoices program, you must update the following values in the Outbound EDI Flag field in the EDI Invoice Expanded Detail (Sales) table (F470472):
1: Internally owned shipment lines
2: Internally owned billing lines
3: Customer owned billing lines