Dissecting an EDI FA 997


ST01 Transaction Set Identifier Code i.e. 997 for a Functional Acknowledgment

ST02 Transaction Set Control Number


AK101 Functional Identifier Code i.e. if you are acknowledging a SI, send SI

AK102 Group Control Number i.e. the assigned number originated and maintained by the sender


AK201 Transaction set identifier code i.e. if you are FA an 858 send 858

AK202 Transaction set control number

And AK5 was most interesting to me

AK501 Transaction Set Acknowledgment Code

A Accepted

E Accepted But Errors Were Noted

R Rejected

AK501 Transaction Set Syntax Error Code

Code indicating error found based on the syntax editing of a transaction set

1 Transaction Set Not Supported
2 Transaction Set Trailer Missing
3 Transaction Set Control Number in Header and Trailer Do Not Match
4 Number of Included Segments Does Not Match Actual Count
5 One or More Segments in Error
6 Missing or Invalid Transaction Set Identifier
7 Missing or Invalid Transaction Set Control Number

And for the more in depth PDF download here


Defeat the “Multiple connections to a server or shared resource …”

If you are running your computer as a joe schmoe user, and you have a mapped drive to a server, when you go to connect to an administrative share it will give you:

Multiple connections to a server or shared resource by the same user, using more than one user name, are not allowed.

In order to get around this try the below

From here

There’s a little workaround that allows you as many as two parallel connections with different credentials to the same machine:
For one connection, use the host name to connect to the share, for the other connection, use the IP address.

EqualLogic Maintenance Record

This might be interesting for some

We bought two PS6000’s 10/09

One came with a bum controller card which was replaced Quickly. Then 12/09 we lost a drive on the same PS6000. Then the PS6000’s have note had issues (as of Jan 27 2010)

We also bought a PS4000 at the same time

It lost its first drive on 12/12/09

then its second drive on 12/15/09

then its third drive on 1/26/10

This has been a little too frequent for my tastes….

No data has been lost and the failovers have worked flawlessly. It makes me wonder about that whole SATA versus SAS reliability thing though.

Getting UUID for the Iphone the lazy and fast way

There are posts all over the place showing you how to get your iphone UUID. But I’m lazy and I can’t be bothered to connect my iphone to my computer and open up Itunes (what an abomination of a program anyways)

Anyways there is an app for that… its called hm UUID which gives your UUID and then lets you email it to someone.

Note to self, transformtool.jar is case sensitive on the file extension…. must use .eif NOT .EIF lame….


PowerTrack EDI and Adage ERP

So started the process of setting PowerTrack for our Freight Invoice Consolidation. Since I am always annoyed when I can’t find any data on subject on the Internet here is a quick overview of how PowerTrack works as well as their 858 doc specifications.

Well not sure if you can read that or not but basically you send an 858 to powertrack, and your shipper sends an invoice to powertrack. PowerTrack then matches your expected freight to what they invoiced and if they match then the pay on your behalf. Every month they then bill you a consolidated invoice. The shipper pays for this service with a 1% off of their bill.

Ahh, and here is the infamous 858 EDI doc specifications.

So here is my desired workflow

Automate Order creation, I do this with an inbound 850 through TEE

Auto Ship the order, I do this through an Expect TCL script. (Setup the Customer to create an outbound advanced shipping order, through external interface)

Parse the outbound .EIF files and look for a match of the freight types that we are desiring, otherwise delete the .EIF.

— Check that the .EIF contains all of the needed lines (in case it is shipped by different plants) If not, put it on hold until the other line comes along and then combine them.

Convert the .EIF to XML using transform.jar

Convert the XML to x12 EDI either using bots transform engine or mapforce

Use mendelson AS2 to send the file.

Receive 997 through AS2 into BOTS. Match the Adage database (select on all sales orders that match the freight types) to the BOTS database and confirmed status.

Note to self, Adage ERP Text Message

Remember to setup the external partner or else no worky….