ISTech Support Forum - Viewing EDI Line Items and converting to SO

kevind

Active Member

I was more than
willing to
"pony up",
how b'out U?

Posts: 639
Gender: male

Viewing EDI Line Items and converting to SO
10/05/06 at 12:13:47

Since updating, when we view an EDI Order, the First Line
of the description does not display in Display Lines. It is there
because if you just convert to a SO (using DE-P-D), they show up
in the Sales order.

If you convert a Sales order from DE-P-C, it still chaines to the old
Convert program (bkedd) which errors out.

The new ISEDID program works great!

Back to top

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10

IP Logged

kevind Active Member I was more than willing to "pony up", how b'out U? Posts: 639 Gender:	Re: Viewing EDI Line Items and converting to SO Reply #1 - 10/11/06 at 10:55:03 Just discovered that the lines that show up blank on the 'Display Lines' screen have line numbers on them. If you delete the line number and press enter through the rest of the record, then they show up on the 'Display Lines' screen.
Back to top	Kevin Damke Spectronics Corporation ISTECH 2004.1 7/26/13 SP1 - 20 user Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user (Prev version was 2004.1 10/24/12) (All Patches Installed as of 7/26/13) Pervasive 2000i SP4 - Crystal Reports V10 IP Logged

kevind

Active Member

I was more than
willing to
"pony up",
how b'out U?

Posts: 639
Gender: male

Re: Viewing EDI Line Items and converting to SO
Reply #2 - 10/12/06 at 13:43:19

Thank for the additional info kevin Grin

I have discovered what is causing the lines to show up
blank in EDIT EDI Orders.

Line numbers are automatically assigned when orders imported.

The Line Number field in BKEDIL is a 3 character field.

A line number of '1' is encoded in hex as 31 00 20.
(Notice the NULL 00 in the middle of the field)
When you change the line number, or enter through a
line in the EDIT EDI order program, it changes the 3
byte line number encoding to 31 20 20.

If you directly edit the BKEDIL file with a file editor, and
change the 00 to a 20, then it also fixes it.

A null in the middle of the field is causing the EDIT EDI Orders and SO-A to not show the line when the
'Display Lines' button is clicked.

Back to top

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10

IP Logged

kevind Active Member I was more than willing to "pony up", how b'out U? Posts: 639 Gender:	Re: Viewing EDI Line Items and converting to SO Reply #3 - 11/13/06 at 08:16:25 Kevin, Have you heard from anyone else that can confirm your observations? Just wondering.
Back to top	« Last Edit: 11/13/06 at 12:00:30 by kevind » Kevin Damke Spectronics Corporation ISTECH 2004.1 7/26/13 SP1 - 20 user Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user (Prev version was 2004.1 10/24/12) (All Patches Installed as of 7/26/13) Pervasive 2000i SP4 - Crystal Reports V10 IP Logged

kevind Active Member I was more than willing to "pony up", how b'out U? Posts: 639 Gender:	Re: Viewing EDI Line Items and converting to SO Reply #4 - 01/12/07 at 13:20:17 Kevin, It looks like you are the only person that is using the EDI import. Good luck to ya!
Back to top	Kevin Damke Spectronics Corporation ISTECH 2004.1 7/26/13 SP1 - 20 user Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user (Prev version was 2004.1 10/24/12) (All Patches Installed as of 7/26/13) Pervasive 2000i SP4 - Crystal Reports V10 IP Logged

NovaZyg Administrator When all else fails.. Read the instructions. Posts: 789 Gender:	Re: Viewing EDI Line Items and converting to SO Reply #5 - 01/12/07 at 17:25:38 LOL Kevin, Let me take a look, sounds like a binary Zero in the import. If that is the case then I can fix it. And no you are not alone in using EDI import, but you are, as it seems, the first to be using it with auto line numbers turned on.
Back to top	Allen Landry Evo~ERP EvoERP and DBA Classic always Beta's of the Latest versions. IP Logged

kevind Active Member I was more than willing to "pony up", how b'out U? Posts: 639 Gender:	Re: Viewing EDI Line Items and converting to SO Reply #6 - 01/15/07 at 09:58:04 Where is that option? ... I don't knowingly have it turned on. We do not want lines numbered.
Back to top	Kevin Damke Spectronics Corporation ISTECH 2004.1 7/26/13 SP1 - 20 user Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user (Prev version was 2004.1 10/24/12) (All Patches Installed as of 7/26/13) Pervasive 2000i SP4 - Crystal Reports V10 IP Logged

gtladmin Active Member Diving is fun, diving is fun! Posts: 1306 Gender:	Re: Viewing EDI Line Items and converting to SO Reply #7 - 01/15/07 at 15:22:27 Kevin, Nice conversation you've been having. We use the add-on product and have not been having a problem (to my knowledge) with the line numbers issue. Sorry! Val
Back to top	Val Feehan IP Logged

NovaZyg

Administrator

When all else
fails.. Read the
instructions.

Posts: 789
Gender: male

Re: Viewing EDI Line Items and converting to SO
Reply #8 - 01/16/07 at 11:47:33

Kevin,

It seems that the EDI import, ISEDIB (make sure your menu is calling this program) had an issue with the numbering of lines, and it is not an option, it just does it due to CANDOEDI that this supports. I have found the code that was putting it in and it looks like that was the problem, it was only populating the first position of an alpha 3 space that left room for Bin Zeros to get in.. And the program has a very bad reaction to Bin Zeros..

This is now fixed and will be in our next post.

Back to top

Allen Landry
Evo~ERP

EvoERP and DBA Classic always Beta's of the Latest versions.

IP Logged

kevind

Active Member

I was more than
willing to
"pony up",
how b'out U?

Posts: 639
Gender: male

Re: Viewing EDI Line Items and converting to SO
Reply #9 - 01/16/07 at 13:27:11

Allen,
It is calling ISEDIB.

I just found out that to work around this, we have to go into every order
that we import, and press return through every line item!!!!

Could you please email me the new ISEDIB so that I could check it,
and verify that this is the only problem??

Thank You

P.S.
Did you also fix DE-P-C (BKEDC) so that it chains to the correct convert program? (See first message of this thread)

Back to top

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10

IP Logged