Need to create an 835 edi file from a flat file.

[Lisa Heaton]

Need to create an 835 edi file from a flat file.  I’ve gone from edi to flat, this is my first flat to edi.

I’ve got things working to a certain degree.  My question concerns going to the next record (CLP and SVC)  Going to a flat file, we have iterations we can do but what do you do going the other direction.

Had the basic all fields, one record working yesterday but today I’m not getting all the fields. Grrr.  I’ll get that working again.

I can’t seem to find clear documentation.  

How do you:

Get it to repeat?

Create the Envelope as well as the STSE segment?

Do you have to use a counter to get the record count?

Any help would be appreciated.

Thank you,

Llisa

Topic

[Brenda Carpenter]

Hi Lisa,

I have built a FF to 834 x12 file in cloverleaf and needed to use multiple HRLs.

Each input record was defined as FRL, then built HRLs to do the repeating, this HRL within the HRL repeats for x amount of times.  Then within that LOOP, I have other HRL loops  to repeat data as necessary.  I think the 834 is much easier than the 835 will be tho.

ie: FF HRL:

STHDRSEG

BGNSEG

DTPFSEG

N1SSEG

N1PSEG

INSLOOPHRL  –  REPEATS X AMT OF TIMES

SETRLRSEG

EXAMPLE OF INSLOOP:

INSSEG

REFLOOP    – REPEATS X AMT OF TIMES

DTPLOOP   – REPEATS WHILE… LOGIC

NM1SEG

PERSEG

ETC….

Hope that helps.. it took quite a while to get this just right, so keep tweaking!

Brenda

[Brenda Carpenter]

Forgot to answer the other two questions,

I modified the X12 variant to include the ISA/IEA and formatted them to receivers spec in the xlate

and yes, I used a counter for the total record count on the trailers.

PM me if you need more detailed info!

-Brenda

[Lisa Heaton]

Thank you Brenda, I’ll give it a shot.

[Author]

Replies