Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 14 Next »

Inbound EDI X12 860 (Purchase Order Change Request - Buyer Initiated

🤔 Problem Statement:

XYZ Manufacturing company, currently utilizes a manual process for managing purchase order changes from their trading partners. This process is labor-intensive, prone to errors, and often results in delays that affect our supply chain efficiency and customer satisfaction. To streamline operations, they aim to implement an automated system for handling inbound EDI X12 860 (Purchase Order Change Request - Buyer Initiated) transactions.

Objective

The goal is to develop and implement a robust solution that facilitates the automated processing of inbound EDI X12 860 transactions. This solution should seamlessly integrate with their existing ERP system, ensure data accuracy, and enhance operational efficiency.

📄 Solution Architecture:

  1. Design a Transaction using an EDI Inbound Pre-built template.

  2. Create Source Schema- EDI860

  3. Create Target Schema - Advance positional

  4. Create a File Event activity

  5. Create Target folder Location (LAN)

  6. Create Mapping activity

  7. EDI Configuration

 

📑 Pre-requisites:

  1. a. Create a Network for which you are creating a transaction.

  2. b. Create a Partner for the data exchange.

🔍 Solution:

Design : Create transaction in Adeptia Connect to convert data

1. Configure : Define Transition

  1. To Create a Inbound Transition Click Transactions Templates.

  2. On the Templates screen, navigate to the EDI Inbound Template

image-20240619-070208.png
  1. To Define Transaction Provide the name and description of the Transaction.

image-20240613-101238.png
  1. Select Network and Partner

8c932f3c-e3cc-4188-8324-076d66677f47-20240619-112051.png

Setting up the partner EDI Configurations

image-20240628-081024.pngimage-20240628-080502.png

 Sample

Field

Description

Example Value

EDI Standard

Type of EDI standard used

X12

EDI Standard Version

Version of the EDI standard

004010

Association Assigned Code

Code assigned by the association

(Empty)

Transaction Set Code

Specific type of EDI transaction/document

845

Common X12 Transaction Set Codes

Transaction Set Code

Description

Transaction Set Code

Description

Transaction Set Code

Description

810

Invoice

850

Purchase Order

856

Ship Notice/Manifest

846

Inventory Inquiry/Advice

845

Price Authorization Acknowledgment/Status

Example Structure of an 850 Purchase Order

Segment

Description

Example

ST

Transaction Set Header

ST*850*0001

BEG

Beginning Segment for Purchase Order

BEG*00*NE*123456789**20230701

N1

Name (Buyer and Seller information)

N1*BY*Buyer Company*9*1234567890

PO1

Purchase Order Line Item

PO1*1*10*EA*15.00*PE*XYZ123

CTT

Transaction Totals

CTT*1

SE

Transaction Set Trailer

SE*6*0001

  1. Select and configure the EDI Standard X12, EDI Standard Version 004010, transition Set Code to 860 

image-20240614-095545.pngimage-20240614-095722.pngimage-20240614-095835.pngimage-20240614-095942.pngimage-20240614-100424.png

 2, Define Source:

  1. Select the Source type as FTP and click next to configure File Event

image-20240614-100728.pngImage-20240619-130721.png

Define the File Event > Name >Trigger Type (On file Created)

Image-20240619-131443.png

File Event Recommended setting: Need to maintain the polling frequency at 1 minute and ensure that the stable time is not less than 10 seconds.

Specify the file base location path, user ID, and password. Then choose the event start date as well as the expiry date and time.

image-20240614-101350.pngimage-20240614-101456.png

Select Trigger Simple and polling frequency as per the requirement.

Image-20240619-131654.png

3. Set Destination

Define the Destination application account.

image-20240614-101928.png

Click on Next to create a FTP Account Information

image-20240614-102234.pngimage-20240614-102322.pngimage-20240614-102357.pngimage-20240614-102800.png

4. Create Mapping

image-20240614-102927.png

Create Data Mapping >>Load Source and Target Schema

image-20240618-071737.png

Create/Add Variables

1. Let's create a variable using the following name: varPricingqty

Condition Applied

WHEN CONDITION{$Input_X12_004010_860/EDIRoot/TS_860/BCH/BCH01='01' } VALUE=['Y' ] OTHERWISE VALUE=['' ]

The conditional mapping expression WHEN CONDITION{$Input_X12_004010_860/EDIRoot/TS_860/BCH/BCH01='01' } VALUE=['Y' ] OTHERWISE VALUE=['' ] is used to check the value of the BCH01 element within the BCH segment of an EDI 860 document. If the value is '01' (indicating a new order), the output is set to 'Y'. Otherwise, the output is set to an empty string. This helps automate decision-making in the EDI processing workflow based on specific transaction criteria.

image-20240617-043700.png

Implement a For Each loop at the root level on the destination side.

$Input_X12_004010_860/EDIRoot/TS_860

image-20240618-065315.png
  1. Let's establish a name for the variable. :varST_LOC

./Loop5_N1/N1[N101='ST']/N104

The expression ./Loop5_N1/N1[N101='ST']/N104 is used to navigate an EDI document's structure to find and extract the identification code (N104) for the Ship To location. This is useful in EDI processing for pinpointing specific data elements based on conditional criteria, allowing for precise data extraction and transformation.

image-20240618-063900.png
  1. Let's proceed by creating a variable named 'name'.: varS_ST_EDI_LOC_CODE

WHEN CONDITION{$varST_LOC='H050' or $varST_LOC='1300'} VALUE=['EAVN1824' ]
WHEN CONDITION{$varST_LOC='H464' or $varST_LOC ='H204' } VALUE=['EAVN1823' ]
WHEN CONDITION{$varST_LOC='1303'} VALUE=['EAVN43685']
WHEN CONDITION{$varST_LOC='1373'} VALUE=['EAVN52820']
OTHERWISE VALUE=[$varST_LOC ]

The conditional mapping expression provided is used to map different values of the variable $varST_LOC to specific output values based on predefined conditions. If none of the specified conditions are met, the default action is to retain the original value of $varST_LOC. This type of conditional mapping is useful in scenarios where specific values need to be translated to other values for processing or integration purposes.

image-20240618-064046.png
  1. Let's proceed by creating a variable name.: varX

IF CONDITION{ $Input_X12_004010_860/EDIRoot/TS_860/BCH/BCH01='01'} VALUE=[ 'Y']

The conditional mapping expression IF CONDITION{ $Input_X12_004010_860/EDIRoot/TS_860/BCH/BCH01='01'} VALUE=[ 'Y'] is used to check the value of the BCH01 element within the BCH segment of an EDI 860 document. If the value is '01' (indicating a new order), the output is set to 'Y'. This helps automate decision-making in the EDI processing workflow based on specific transaction criteria, allowing for the flagging or marking of new orders appropriately.

image-20240618-064223.png
  1. Let's proceed by defining a variable name.: varTP_CODE

'AVNET'

image-20240618-064401.png
  1. Let's proceed by creating a variable name.: varCONTROL_NUM

normalize-space( $Input_X12_004010_860/EDIRoot/TS_860/ST/ST02)

The XPath expression normalize-space( $Input_X12_004010_860/EDIRoot/TS_860/ST/ST02) is used to retrieve and clean up the content of the ST02 element within the ST segment of an EDI 860 document. It ensures that the extracted text is formatted correctly by removing unnecessary whitespace characters, thereby providing a clean and standardized representation of the data for further processing or display.

image-20240618-064522.png

Next step is to Check for the data input and output.

image-20240617-044444.png

Steps to Turn on the Transaction

After you have Saved and Exit the Transaction page. You will be asked to Turn on the transaction

 Viewing execution details

Go to the Dashboard to view execution details. The Status column shows execution status of the transaction.

Click the execution icon under Action to view the detailed information about transaction.

Click the information icon under the respective Icons to know details of execution at a that step.

Click More arrow under Action menu to know further details of the transaction.

 

EDI Dashboard and EDI X12 Interchange logs

Logs provide runtime details about the inbound and outbound transactions.

Users can search logs with Partner ID, Sender/Receiver ID, Transaction Control Number and with any other data field.

  • No labels