01
Aug
10

EDI X12 Byte Space limitation

For one month, we have contents in EDI files sent to us with ‘broken lines’.  This results in some purchase order details in the file unable to process further or missing information being sent back as in 861 EDI.

We have to investigate the problem, starting from the actual inbound file or also known as the ‘raw file’ from Customer.  From our implementation, we have to process this file in 2 stages:

  • Stage one: The system performs conversion of hex char (CR/LF) from raw 856 to the correct hex char (LF), re-generated 856.  This is the initial issue from Customer’s system which unable to resolve the extra ‘CR’ character from the file and this has to be manipulated at our side to allow the files to get through our system successfully before performing data mapping to respective outputs for our back-end systems.
  • Stage two: The processed 856 is used for actual data translations into the respective output files to back-end systems

We faced the issue that at certain row(s) of the record, it got broken and there is a CR that caused it.  It seems like 2 files (of different ISA control numbers) have the same proble identified at the same record/row.  We also realized a pattern in which for every 4 kbytes of records in that file, CR is being included.  To investigate this to ensure if this is a system problem at our end, we requested the customer to send more similar file type that have more or less 4 kbytes of records to see if our analysis is correct.

We will find out more in the next few days.   Watch out this space for findings.

Advertisements

0 Responses to “EDI X12 Byte Space limitation”



  1. Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


August 2010
M T W T F S S
« Jun   Feb »
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

Categories

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 443 other followers


%d bloggers like this: