• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

EDI , Tradacoms , - Please help me !!!

p_watton

Active Member
This is a multi-part message in MIME format.

------=_NextPart_000_0005_01C0A59F.728A1910
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

i'm just starting to look at passing our JDE invoices to our EDI pc.

i have found the 'sales invoice menu (G47217) and have created the =
outbound files and even created the flat file on the EDI pc.

Questions.

1. Do i really have to run this process once for each trading partner. =
You have to enter the partner id in the processing options. If i had two =
hundred partners do i need to run this process two hundered times???

2. I need to get the flat file into a TRADACOMS format. I am currently =
amending the flat file creation program to 'database output' the data in =
the required format. Is this the best way. Or is there some clever way =
of doing it after the flat file has been created.

Any help would be appreciated.

Thanks,


Paul Watton.

------=_NextPart_000_0005_01C0A59F.728A1910
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV></DIV>
<DIV><FONT face=3DArial size=3D2>i'm just starting to look at passing =
our JDE=20
invoices to our EDI pc.</FONT></DIV>
<DIV></DIV>
<DIV><FONT face=3DArial size=3D2>i have found the 'sales invoice menu =
(G47217) and=20
have created the outbound files and even created the flat file on the =
EDI=20
pc.</FONT></DIV>
<DIV></DIV>
<DIV><FONT face=3DArial size=3D2>Questions.</FONT></DIV>
<DIV></DIV>
<DIV><FONT face=3DArial size=3D2>1. Do i really have to run this process =
once for=20
each trading partner. You have to enter the partner id in the processing =

options. If i had two hundred partners do i need to run this process two =

hundered times???</FONT></DIV>
<DIV></DIV>
<DIV><FONT face=3DArial size=3D2>2. I need to get the flat file into a =
TRADACOMS=20
format. I am currently amending the flat file creation program to =
'database=20
output' the data in the required format. Is this the best way. Or is =
there some=20
clever way of doing it after the flat file has been =
created.</FONT></DIV>
<DIV></DIV>
<DIV><FONT face=3DArial size=3D2>Any help would be =
appreciated.</FONT></DIV>
<DIV></DIV>
<DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV><FONT face=3DArial size=3D2>Paul Watton.</FONT></DIV></BODY></HTML>

------=_NextPart_000_0005_01C0A59F.728A1910--
 

amwalshjde

Well Known Member
Paul-

1.You dont need a version for each trading partner. However, if you leave
it blank then the TPID field in the F47's files will be left blank.

2.Your way sounds pretty good to me. The only ther option would be it any
else out here has mapped to the same version of tradacoms and would share
with you.

AW
 

mwilson

Member
Paul,
1. You don't have to run the UBE for each Trading Partner. You can leave the TPID blank and it will be blank in the F47* tables. The way that we got around this was to setup a cross reference in the address book supplemental data base (F00092) which linked the address book number and the trading partner id. After we ran the extract program (invoice, purchase order, etc) we run a custom UBE to plug the TPID into the F47* tables. This UBE is run after the extraction, but before the flat file conversion.
2. Converting the JDE flat file (very unfriendly) to a friendly file (we use Harbinger). One of the consultants that was in here wrote a program in VB that strips off all of the un-necessary blanks and zeros from the data, as well as the double quotes that surround all of the fields. This made the data much more "Harbinger Friendly".
Hope this helps,
Mark

B733 (Base), HP9000, NT, Oracle, WTS, Citrix
(Upgrading to Xe)
 
Top