Results 1 to 3 of 3

Thread: EDI , Tradacoms , - Please help me !!!

  1. #1
    Member p_watton's Avatar
    Join Date
    Mar 2001
    Location
    UK
    Posts
    35

    EDI , Tradacoms , - Please help me !!!

    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--




  2. #2
    Senior Member
    Join Date
    Oct 2000
    Location
    PA
    Posts
    171

    RE: EDI , Tradacoms , - Please help me !!!

    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



    OneWorld Xe SP22 AS/400 V5R2

  3. #3

    Re: EDI , Tradacoms , - Please help me !!!

    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)
    B733 (Base), HP9000, NT, Oracle, WTS, Citrix
    (Upgrading to Xe)

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.