EDI Interface File

couberpu · 2006-11-01

Hi All,

I need help on where to place 850, I_SLSORD, interface file and what the interface file should look like.

I setup the common receive path to c:\Temp\850 and have temp and archive subdirectory under c:\Temp\850. I placed the 850 file from my trading partner to c:\Temp\850. The program is reading the file from trading partner ok but has trouble finding the interface file. I have the interface file field set to "Housex12850" but I did not place any file for I have no idea where and how the interface file to place.

Thanks a lot for any help.

CouberPu

ara3n · 2006-11-01

Are you using Lanhan EDI? or is this customization?

Savatage · 2006-11-01

It looks like Lanham

I put some docs up for you

http://savatage99.googlepages.com/edistuff

for example I have .........
Navision Document : I_SLSORD
EDI Document Number : 850
Version : 004010
EDi Standard : V
Type : Import
Status: Production
EDI Template Name : GENTRAN (We use Sterling Commerce -Gentran Director)
INterface File: C:\temp\BBB850.txt

**Gentran - Retrieves & Sends the Docs. The Doc location is set up as C:\Temp

Click ON the Line Then You can go to Segments and set those up.
Then you can add the elements to each segment.

Enjoy! :whistle:

Savatage · 2006-11-01

couberpu wrote:

Hi All,

I need help on where to place 850, I_SLSORD

Oh.
When you create your trading partner - go to Trading Ptnr button & goto Documents

couberpu · 2006-11-02

Good Morning,

Thank you ara3n & Savatage.

I am using Lanhan EDI came with 3.60 and I did have two 810 partner running fine. I am working on receiving PO, 850, from one of them and hit a wall.

Thank you again for the information and I will post the result once I punched through "the wall".

Best Regards,
CouberPu

Savatage · 2006-11-02

No prob! lets us know if you get stuck somewhere.

I added a sample 850 Doc map if you need some guidance
http://savatage99.googlepages.com/edistuff

couberpu · 2006-11-02

Thank you again Savatage,

The problem I had before was caused by missing interface file path under E.D.I. Template. I fixed the correct path and report 14002354, Receive Purchase Order, did not give me error anymore. But I still can not see the imported PO in File Cabinet. Following is how ???.edi file looks like in the Inbox:

DELIMITERS(010,042,042)
ISA*00* *00* *12*61552504XX *12*63175855ZZ *061101*1610*U*00400*000000214*0*P*>

GS*PO*61552504XX*63175855ZZ*20061101*1610*214*X*004010

ST*850*2140001

BEG*00*SA*S0197792**20061101

PER*BD*15

ITD*ZZ***********2% 60 DAYS 20

DTM*038*20061101

N9*AB*9999

N1*ST*ZZZZZ-XXXXXX HARDWARE*92*001

N3*0000 WATER PLANT RD

N4*KNOZZZZZZ*TN*00000

PO1*1*5*EA*0.0000*CP*IN*10220168*UP*751338174108*ZZ*706 2X2-1/2"ENT HEAD*LS*2

...

CTT*41

SE*52*2140001

GE
IEA

And I use :

Interface File Type: Harbinger
File Format: Delimited
Component Delimiter:>
Element Delimiter: *
Segment Terminator:
Segment Line Terminator: CR LF
Interchange Terminator:
Segment ID Beg Pos: 1
Segment ID Length: 3
Trade Partner Beg Pos.:18
Trade Partner Length:10

This is the 1st time I am doing 850 receiving and I have no idea if there was an error in the edi output file.

Please help me!

Thanks,
CouberPu

Savatage · 2006-11-02

Did you read all the docs I put up yet?

So you are using a program called Harbinger to do the communications between you and your partner??

did you create the segments and the elements?
did you set up any partner items?

Usually a vendor can provide you with an edi mapping guide for you to work with.

for example
http://www.vendor.bedbath.com/ediMappin ... ediMapping

Usually the first one is the hardest - once you get the hang of it, it won't seem so difficult. What really helped me was to pay an NSC to teach me for a few hours. It was well worth it.

I dod learn using Sterling's Gentran but I will assume they are all very similar.

PS I'm using the Lanham EDI Generation 1.

couberpu · 2006-11-02

Sorry I was confused.
I am trying to implement 850 under generation 2.
Harbinger is the File Type in E.D.I. Template, as one of the interface file type options, just as Sterling, X12 Delimited or EDIFACT Delimited. It defines how the imported file was formatted. What I am not sure is that I might screwed up the Dec code on delimiters or terminators.
For whatever the reason, My EDI screen layout did not match the PDF file you send me and some of the information either was not on PDF or on screen. I am sure that it is EDI from Lanham and I used "Harbinger" file type on 810 to send EDI invoices without problem.
I only have very limited experience on Navision EDI but I wrote several C programs to convert APPGEN database data to 810 and 850 into APPGEN database. What confused me is if there was no error message and no record in File Cabinet yet edi file was created in Inbox, what I missed!?

Thanks,
Couber :? :?

Savatage · 2006-11-02

What I have noticed (I'm trying to remember back to 2003)
as an Add-on (Especially Gen1) was if it didn't work or something wasn't set up correctly it did not give any error message. in fact F1 didn't give any help either. that's why I had to find those docs. But the docs do SKIP steps as if "your supposed to know" in some parts.

If you're waiting for an error message to help guide you I think you'll be waiting a long time.

Try and read the docs - even though it might not be exactly what you're seeing on your screen - understanding what's it's doing will help you.

Importing is very different from exporting data. You have to match up fields, validate, etc etc.

Just setting up the Edi Setup Template is not enuf - you need to create the docs to read the file and map it to the proper nav fields.

Have you loaded the EDI Nav Fields under SETUP? I think we needed a dev license to do it.

I'm trying to visualize what you are looking at but It's not very easy.

and again, taking a few lessons at your local NSC on the EDI addon will pay dividends. I think originally I scheduled 10 hrs but after 3 or 4 I basically had the idea so I was only billed for that amount.

Did you look at the 850 sample map I also posted? Do you have anything like that setup?

You also turn on the Tools->Debugger->"Code Coverage" to see what is happening.

NOTE:
In EDI Template Setup
when I select Harbinger I auto get...
http://savatage99.googlepages.com/harbi ... faults.jpg

PS The web link has both - Gen1 & Gen 2 info.

couberpu · 2006-11-02

Thanks!
I guess I have a lot of home work to do then.

Best Regards,
CouberPu

Savatage · 2006-11-02

I don't believe gen 2 is that much different - maybe more streamlined. **Perhaps a Gen2 expert can just in here**

But I know I HAD TO:
Create Trading Partner Item #'s
-so their # has to point to one of our item #'s
Create Partner Store Setup:
-so the import doc knew which cust it belonged to
Create Edi Partner Docs
-to map the incoming data to the proper Nav fields.

I don't think these basics have been bypassed.

couberpu · 2006-11-02

Savatage wrote:

I don't believe gen 2 is that much different - maybe more streamlined. **Perhaps a Gen2 expert can just in here**

But I know I HAD TO:
Create Trading Partner Item #'s
-so their # has to point to one of our item #'s
Create Partner Store Setup:
-so the import doc knew which cust it belonged to
Create Edi Partner Docs
-to map the incoming data to the proper Nav fields.

I don't think these basics have been bypassed.

I did setp 1, 2, and 3 last month and spent few weeks using debug trying to learn the coding steps. The thing is I got about 60 people at work and most of them want to make sure I earnned my pay so I finally gave up trying and looking for a short cut at www.mibuso.com.

I will read the document again and check my 1, 2, 3 to make sure nothing funny that I missed.

Thank you so very much for helping me. =D> =D>

Best Regards,
CouberPu

Savatage · 2006-11-02

I don't thinkI was tring to provide a shortcut - Obviously it's always harder trying to figure out someones total problem with a few lines of text in a post.

What wasn't clear was how much has already been done and at what step in the process you were up to. That text edi file was that provided for you? How was it created?

My bigegest problem always fell into the Segments and Elements being setup correctly in the Partners Docs.

So if you feel the Store Setup and Item setup is fine, then the Doc Maps is where I would focus my attention. Since those two are pretty straight forward.

couberpu · 2006-11-03

Dear Savatage,

Please do not get me wrong.
I really appreciate your help and I promise that I will post the result on my findings.

Best Regards,
CouberPu

couberpu · 2006-11-06

Hi All,

This is what I found out so far:

1. After created a new I_SLSORD template, I need to recreate EDIMAP.txt, import and compile so Now I have my file cabinet -- This answered my question on why there was an edi output file yet no file cabinet.
2. I changed the file type to X12 Delimited and ran into an error on "Segment ID GE is not setup...". I edited the edi file to bypass this error and I got my sales order. -- Now I can handle the error by trace the code unit and make proper code change, adding a new file type or something.

So my problem, at least for now, was not knowing that I need to recreate EDIMAP.txt and recompile the code unit.

Will keep posting my finding until I can create the sales order without any problem.

Thanks,
CouberPu :roll:

Savatage · 2006-11-06

Yes the EDIMAP.txt - creates a list of Navision Fields so you can map your edi fields to the proper fields.

Usually upon installation, this map has already been run & compiled.
Since nothing can really be done without it.

Once done you don't have to redo unless you need to match some new custom fields.

You will find info on EDIMAP on the Doc about GEN2 I put up.
You can search the PDF for EDIMAP.

Savatage · 2006-11-06

Segment ID GE is not setup...".

Have you found where this is?

We have many segments not mapped to anything but just there to make the file run.

Such as a Terms section - the edi file might contain it but the terms for the customer are set so we don't map "What they Want it To Be" to any Nav fields.

If you know what I mean.

Glad you're making progress - See the next one will be easier

couberpu · 2006-11-07

Savatage wrote:

Segment ID GE is not setup...".

Have you found where this is?

Yes. It is at the end of edi file and usually part of the trailer. I guess that X12 Delimited must have different way of handling the data and I am working on it as I am typing this message.

I will get to the bottom of this!

Thanks,
Couber

couberpu · 2006-11-08

couberpu wrote:

I will get to the bottom of this!

Hi All,

I was wrong about need to recreate the EDIMAP.txt file. I do not need to recreate it. What I did wrong was I messed up the File Type and once I changed the format to X12 Delimited and made few small changes to code unit "E.D.I. File Split". I am good now.

Thank you for all the helps.

Best Regards,
CouberPu \:D/

Howdy, Stranger!

Quick Links

Categories

EDI Interface File

Answers