EDI Setup
Before processing EDI transactions, you must complete the following setup tasks:
- Configuring your EDI system.
-
Defining the actions the system will execute during the import and export of EDI transactions.
To set up the M2M EDI, use the EDI Setup (XEDI) window. The setup process involves the following steps:
-
General Setup: On the General tab, execute the general setup. For more information, refer to the General Setup section.
-
Inbound Transactions Setup: On the Inbound tab, configure the settings for inbound transactions. For more information, refer to the Setup EDI Inbound Transactions section.
-
Outbound Transactions Setup: On the Outbound tab, configure the settings for outbound transactions. For more information, refer to the Setup EDI Outbound Transactions section.
-
Sales Order EDI Labels Setup: On the Sales Order tab, set up the Sales Order EDI labels Setup. For more information, refer to the Set Up the SO EDI Labels section.
-
Purge Temporary EDI Records: On the Purge Temporary EDI Records tab, specify the EDI document types for which you want to delete temporary records created during import but not used in the final EDI document. For more information, refer to the Specify the EDI Record Types to Purge section.
-
In addition to the above setup process, there are a few more additional steps:
- M2M Format Mapping: Use the EDI M2M Format Groupings (XGROUP) window to set up lists of data elements for import/export. For more information, refer to the M2M Format Mapping section.
- Customer-Specific Setup: Perform specific setup steps for each customer with whom you plan to conduct EDI transactions in the Accounts (CUST) window. For more information, refer to the Customer-Specific Setup section.
General Setup
To perform the general setup of the M2M EDI, follow these steps:
- Open the EDI Setup (XEDI) Window using one of the following methods:
- On the Utilities tab, in the Company Setup group, and click Module Setup > EDI Setup.
- Type XEDI in the Navigation search bar and click Enter.
- Click the General tab. General setup includes:
- General Information Setup
- Aptean EDI One Credentials Setup
- In the General Information section, specify the following fields and options:
- EDI Qualifier: Type the EDI Qualifier provided by EDI One.
- ID: Enter the identifier provided by EDI One.
- GS1 Company Prefix: Configure the GS1 identifier, used with the RPUCC128 report.
- Allow SO EDI Only For EDI: Select this checkbox to ensure that the fields on the EDI Header and EDI Items tabs of the Sales Order (SO) window are populated solely by EDI document automation. Manual changes will not be allowed.
- Check Null Ship To: Select this checkbox to verify that the imported data includes the ship-to address key.
- Ignore Inbound SAC: Select this checkbox to bypass Special Allowance or Charge (SAC) code data input lines.
- Split EDI Outbound Files: Select this option to enable the splitting of EDI outbound files.
- Decimal Implication: Choose one of the following options:
- Use M2M FFF Implied Decimals: Use M2M implied Fixed File Format (FFF) decimal positions.
- Use Fixed Length Decimals: Use specified fixed length decimal positions.
- Use Actual Length Decimals: Use decimal positions as defined in the actual imported/exported file.
- Depends on Customer: Use decimal positions defined in the Customer window.
- Memo Population: Select one of the following options:
- Overwrite: To overwrite existing data.
- Append: To add to the existing data.
- Click Save to save the settings.
- In the Aptean EDI One Credentials section, specify the following fields and options:
- Tenant Id: Enter the unique identifier assigned to your tenant.
- Secret Key: Enter the secret key provided by EDI One.
- API Key: Enter the API key assigned to your account.
- Click Test Authentication to verify the credentials.
- Click Save to apply the settings.
Inbound Transactions Setup
The Inbound tab of the EDI Setup (XEDI) window contains sections for configuring different types of inbound transactions. Currently, only 830 (Planning Schedules with Release Capability) and 850 (Purchase Order) are certified for use.
The sections available in the Inbound tab are:
- 820 - Payment Order/Remittance Advice
- 830 - Planning Schedules with Release Capability
- 840 - Request For Quotation
- 850 - Purchase Order
- 860 - Purchase Order Change
- 862 - Shipping Authorization
To set up EDI inbound transactions, follow these steps:
- Open the EDI Setup (XEDI) window using one of the following methods:
- On the Utilities tab, in the Company Setup group, click Module Setup > EDI Setup.
- Type XEDI in Navigation search bar, and click Enter.
- Click the Inbound tab. Configure the settings for each transaction type in the appropriate section:
820 - Payment Order/Remittance Advice
- After Adding: Select the required option:
- Leave In ‘Started’ Status: Select this option to leave the document status as Started.
- Change Status To Paid: Select this option to change the document status to Open.
830 - Planning Schedules with Release Capability
- Cross Reference Check: Select this checkbox to perform a cross-reference check.
- Modify Line Item: Select this checkbox to modify the line items.
840 - Request For Quotation
- On Create: Select the required option:
- Create New Documents: Select to create new documents.
- Append To ‘Started’ Documents: Select to append to documents with a status of Started.
- Depends on Customer: Set according to customer settings.
- After Adding: Select the required option: - Leave In ‘Started’ Status: Select this option to leave the document status as Started. - Change Status To Paid: Select this option to change the document status to Open. - Depends On Customer: Select the option to configure settings according to customer preferences.
850 - Purchase Order
- On Create: Select the required option:
- Create New Documents: Select to create new documents.
- Append To ‘Started’ Documents: Select to append to documents with a status of Started.
- Depends on Customer: Set according to customer settings.
- Append To ‘Started’ Documents: Select to append to documents with a status of Started.
- After Adding: Select the required option:
- Leave In ‘Started’ Status: Select this option to leave the document status as Started.
- Change Status To Paid: Select this option to change the document status to Open.
- Depends On Customer: Select the option to configure settings according to customer preferences.
- Cross Reference Check: Select this checkbox to perform a cross-reference check.
- Create New Documents: Select to create new documents.
860 - Purchase Order Change
- Cross Reference Check: Select this checkbox to perform a cross-reference check.
862 - Shipping Authorization
- On Create: Select the required option:
- Create New Documents: Select to create new documents.
- Append To ‘Started’ Documents: Select to append to documents with a status of Started.
- Create New Documents: Select to create new documents.
- After Adding the required option:
- Leave In ‘Started’ Status: Select this option to leave the document status as Started.
- Change Status To Paid: Select this option to change the document status to Open.
- Cross Reference Check: Select this checkbox to perform a cross-reference check.
- Leave In ‘Started’ Status: Select this option to leave the document status as Started.
- Click Save to apply and save the setup settings for the inbound transactions.
Outbound Transactions Setup
The Inbound tab of the EDI Setup (XEDI) window contains sections for configuring different types of inbound transactions.
To configure EDI outbound transactions, follow these steps:
Open the EDI Setup (XEDI) Window using one of the following methods:
- On the Utilities tab, in the Company Setup group, click Module Setup > EDI Setup.
- Type XEDI in the Navigation search bar and click Enter.
- Click the Outbound tab. Configure the settings for each transaction type in the appropriate section:
810 - Invoice
- On Create: Select the required option:
- Overwrite: Select this option to overwrite the existing document.
- Append: Select this option to append to the existing document.
- When Status Is: Select the required option:
- New, Not Confirmed: Select this option to begin the document export when the status is New and Not Confirmed.
- Unpaid: Select this option to begin the document export when the status is unpaid.
- Partially Paid: Select this option to begin the document export when the status is partially paid.
- Paid In Full: Select this option to begin the document export when the status is paid in full.
- Invoice Type: Select any of the invoice types from the list below for export:
- All
- Credit Memo
- Miscellaneous
- Normal
- Overwrite: Select this option to overwrite the existing document.
Prepayment Credit Memo
- Time & Materials
Export All Memo Lines: Select this checkbox to export all memo lines.
846 - Inventory Advice
- On Create: Select the required option:
- Overwrite: Select this option to overwrite the existing document.
- Append: Select this option to append to the existing document.
- Overwrite: Select this option to overwrite the existing document.
855 - Purchase Order Acknowledgment
- On Create: Select the required option:
- Overwrite: Select this option to overwrite the existing document.
- Append: Select this option to append to the existing document.
- When Status Is: Select the required option:
- Started: Select this option to begin the document export when the status is started.
- Awaiting Approval: Select this option to begin the document export when the status is awaiting approval.
- Open: Select this option to begin the document export when the status is open.
- When to Export: Select any of the methods below to determine when to export:
-
Auto
-
Depends on Customer
-
Manual
o Export All Memo Lines: Select this checkbox to export all memo lines.
-
- Overwrite: Select this option to overwrite the existing document.
856 - Ship Notice/Manifest
- On Create: Select the required option:
- Overwrite: Select this option to overwrite the existing document.
-
Append: Select this option to append to the existing document.
-
When Status Is: Select the required option:
-
Shipped: Select this option to begin the document export when the status is shipped.
-
Not Shipped: Select this option to begin the document export when the status is not shipped.
o Export All Memo Lines: Select this check box to export all memo lines.
-
-
Skip Calculated Totals On DET Segment: Select this check box to exclude calculated totals in the DET segment.
-
- Overwrite: Select this option to overwrite the existing document.
861 - Receiving Advice/Acceptance Certificate
- On Create: Select the required option:
- Overwrite: Select this option to overwrite the existing document.
- Append: Select this option to append to the existing document.
- Overwrite: Select this option to overwrite the existing document.
862 - Shipping Schedule
- On Create: Select the required option:
- Overwrite: Select this option to overwrite the existing document.
- Append: Select this option to append to the existing document.
- When Status Is: Select the required option:
- Started: Select this option to begin the document export when the status is started.
- Awaiting Approval: Select this option to begin the document export when the status is awaiting approval.
- Overwrite: Select this option to overwrite the existing document.
- Open: Select this option to begin the document export when the status is open.
865 - Purchase Order Change Acknowledgment
- On Create: Select the required option:
- Overwrite: Select this option to overwrite the existing document.
- Append: Select this option to append to the existing document.
- When Status Is: Select the required option:
- Started: Select this option to begin the document export when the status is started.
- Awaiting Approval: Select this option to begin the document export when the status is awaiting approval.
- Open: Select this option to begin the document export when the status is open.
- Overwrite: Select this option to overwrite the existing document.
Note: Only 80 characters in a memo line are exported.
- Click Save to apply and save the setup settings for outbound transactions.
Sales Order EDI Labels Setup
Use the EDI Setup (XEDI) window to set up and customize the Sales Order (SO) EDI labels. This setup allows you to define and modify the field labels that appear in the Sales Order EDI tabs.
Follow these steps to configure the labels:
Configuring EDI Labels in XEDI
To configure EDI labels in XEDI:
- Open the EDI Setup (XEDI) window using one of the following methods:
- On the Utilities tab, in the Company Setup group, click Module Setup > EDI Setup.
- Type XEDI in the Navigation search bar and click Enter.
- Navigate to the Sales Order tab within the EDI Setup window.
- In the Header and Detail tabs, customize the labels for the sales order.
- Click Save to save the changes.
Note: This label customization will appear in the Sales Order EDI Header screen of the respective Sales Order.
Viewing Customized Labels in Sales Orders
Once you have customized the EDI labels in the EDI Setup window, you can view these changes and edit further in the Sales Orders window:
- Navigate to Sales Orders.
- Go to More Actions and select Sales Order EDI Header.
- The customized labels will be reflected in the Sales Order EDI Header screen. You can customize further if needed.
Purge Temporary EDI Records
Temporary records are generated when exceptions occur during the import of EDI documents. Over time, the number of these records may increase. It is recommended to periodically purge these records.
Use the Purge Temporary EDI Records tab, in the EDI Setup (XEDI) window to specify the type of temporary EDI records that you want to purge.
To specify the EDI record types to purge:
- Open the EDI Setup (XEDI) window using one of the following methods:
- On the Utilities tab, in the Company Setup group, click Module Setup >EDI Setup.
- Type XEDI in Navigation bar, and click Enter.
- Click the Purge Temporary EDI Records tab.
- Select the appropriate checkboxes for the document types for which you want to purge the temporary records:
- 820 - Payment Order / Remittance Advice
- 830 - Planning Schedule with Release Capability
- 840 - Request For Quotation
- 850 - Purchase Order
- 860 - Purchase Order Change
- 862 - Shipping Authorization
- Click Purge All to purge the selected records.
Note: The Purge All button will be enabled only when at least one checkbox is selected.
A confirmation popup will appear with the message: Do you want to delete the temporary EDI records for the selected EDI type?
- Click Yes to confirm purging the records. Click No to cancel the operation.
Tip: If you click Yes, the records will be purged, and information about the purged data will be displayed.
M2M Format Mapping
Using M2M format mapping, you must create at least one grouping for the intermediate file generated for each transaction type you plan to process. Groupings determine the data elements on a customer-by-customer basis or for many customers having the same element requirements during the import/export process.
Before you attempt to create a grouping, it’s important that you understand the following terms:
Element: A specific location in M2M is referred by table and field.
Grouping: A subset of elements for transaction import or export.
Intermediate file: A collection of transactions that EDI imports from or exports to.
Groupings describe to the parser the data elements that are to be imported in the inbound intermediate file. Therefore, by simply changing the grouping, you can change the data elements that M2M’s EDI processes.
Standard Groupings
The standard XGROUPs for the five documents available in version 8.0 can either be used as is or copied to create customized groupings:
Inbound
- 850
- 830
Outbound
- 810 (Invoice)
- 855 (PO Acknowledgment for inbounds)
- 856 (Ship Notice)
The standard groupings include the minimum required fields for the document set.
Customized Grouping
You can create a customized grouping from the EDI M2M Format Groupings (XGROUP) window. To do this, copy the standard grouping, customize it, and save it as a new customized grouping.
To create a customized grouping:
-
Open the EDI M2M Format Groupings (XGROUP) window using one of the following methods:
- On the Electronic Data Interchange tab. In the General Information group, click Master Data > EDI M2M Format Groupings.
- Type EDI M2M Format Groupings (XGROUP) in the navigation bar and click Enter.
-
In the header tool bar, click Copy.
-
In the Group ID field, type a unique transaction ID for the grouping. To ensure uniqueness and easy identification, consider assigning a group ID that combines the document number and the EDI trading partner number. If the trading partner has multiple facilities, include the facility number in the EDI group ID as well.
-
In the EDI Type field, select INBOUND or OUTBOUND.
-
In the Transaction Type field select a tansaction number.
Based on the transaction numbers selected from the transaction type field, the appropriate fields will be displayed in a grid in alphabetical order.
-
In the Select column, select or clear the check boxes to include or remove elements from the grouping.
-
Click Save.
Tip: You can create multiple groupings for each transaction set.
New Grouping
You can create a new grouping from a customized grouping. To create a new grouping:
-
Open the EDI M2M Format Groupings (XGROUP) window using one of the following methods:
- On the Electronic Data Interchange tab. In the General Information group, click Master Data > EDI M2M Format Groupings.
- Type EDI M2M Format Groupings (XGROUP) in the navigation bar and click Enter.
-
Navigate to the customized grouping and click New.
Note: The New button will only be visible when you are on a customized grouping page. It will not be available on a standard grouping screen.
-
In the Group ID field, type a unique transaction ID for the grouping. To ensure uniqueness and easy identification, consider assigning a group ID that combines the document number and the EDI trading partner number. If the trading partner has multiple facilities, include the facility number in the EDI group ID as well.
-
In the EDI Type field, select INBOUND or OUTBOUND.
-
In the Transaction Type field select a tansaction number.
Based on the transaction numbers selected from the transaction type field, the appropriate fields will be displayed in a grid in alphabetical order.
-
In the Select column, select or clear the check boxes to include or remove elements from the grouping.
-
Click Save.
Tip: You can create multiple groupings for each transaction set.