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

This topic has 3 replies, 2 voices, and was last updated 7 years, 7 months ago by Lisa Heaton.

Creator

Topic
February 9, 2017 at 4:06 pm #55304

Lisa Heaton
Participant

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
Creator

Topic

Viewing 2 reply threads

Author

Replies
- February 9, 2017 at 6:44 pm #84898
  
  Brenda Carpenter
  Participant
  
  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
- February 9, 2017 at 6:57 pm #84899
  
  Brenda Carpenter
  Participant
  
  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
- February 9, 2017 at 7:02 pm #84900
  
  Lisa Heaton
  Participant
  
  Thank you Brenda, I’ll give it a shot.
Author

Replies

Viewing 2 reply threads

The forum ‘Cloverleaf’ is closed to new topics and replies.