Results 1 to 4 of 4

Thread: Invoice a customer electronically with EDI via Inovis TrustedLink (want Shipper Address from F4006 table)

  1. #1
    Senior Member
    Join Date
    Sep 2005
    Posts
    576

    Invoice a customer electronically with EDI via Inovis TrustedLink (want Shipper Address from F4006 table)

    EDI users, I will post this question on Inovis' tech support forum cuz we paid for Inovis tech support but I am wondering if you Inovis TrustedLink users know how to map F4006 order address info into 810 documents.

    Now I gotta learn EDI. Already hit a snag in our attempt to invoice our customer electronically with EDI via Inovis TrustedLink and include the drop-ship physical address: street, city, state and ZIP, which is stored in F4006 table.

    We expected that the only data our customer would want would be what JDE puts in tables:
    F47046 -EDI Invoice from Sales Header-Outbound
    F470461 -EDI Invoice Additional Header - Outbound
    F47047 -EDI Invoice from Sales Detail - Outbound
    F470471 -EDI Invoice Additional Detail - Outbound
    Our Inovis technical consultant mapped data from the four tables above to create the 810 document.
    Now our customer has changed the scope of the original project and wants us to also transmit the shipper street address also. Address data is not found in any of the 4 tables shown above.
    Customer is saying, "your P42565 Invoice program prints the Shipping Address. It should be real easy for you to transmit the shipping address to us via EDI".
    groan.
    EricL 918-879-6036 email elehti(at)ameristarfence.com

  2. #2
    Senior Member
    Join Date
    Sep 2004
    Posts
    167

    Re: Invoice a customer electronically with EDI via Inovis TrustedLink (want Shipper Address from F4006 table)

    for One World, i wrote a batch program to compile/populate these EDI files with the info. how the data gets populated was controlled by the custom batch i developed. not sure how you are getting the data into these EDI files for Inovis to pick up.

    done some time ago, but i remember it was working fine for One World. there are instances where the std JDE EDI files were insufficient to host the info, so we had to create custom tables to tag on with the missing info.
    ERP8 AS400
    PTF Level : Update 1 SP21
    O/S Release : V5R2M0

  3. #3

    Re: Invoice a customer electronically with EDI via Inovis TrustedLink (want Shipper Address from F4006 table)

    We have some external tables mapped to f0101 and f0116 in the inovis software. You can then map the field in edi to the address book number and reference the external table for translation.

    The external tables we have for addresses are as below.

    Set all this up a long time ago but happy to provide more details if required.

    F0101EDI jde address description F0101 *LIBL
    F0116EDI1 jde address 1 F0116 *LIBL
    F0116EDI2 jde address 2 F0116 *LIBL
    F0116EDI3 jde address city F0116 *LIBL
    F0116EDI4 jde address county F0116 *LIBL
    F0116EDI5 jde address post code F0116 *LIBL

    In map following details specified.

    Source – SYSHAN.
    Target - Address field in CLO segment.
    Conversion - User external table F0116EDI1.

    Regards,

    Paul Thompson
    World 7.3 C7

  4. #4
    Senior Member
    Join Date
    Sep 2005
    Posts
    576

    RE: Invoice a customer electronically with EDI via Inovis TrustedLink (want Shipper Address from F4006 table)

    Thank you all for the postings about addresses.

    I discovered last night that P42565 program writes the F4006 address
    data to 3 address records in table F4706. Yippee!



    And the shipper's physical address is put in F4706 record type 2, so I
    created LF F4706LY to test for shipper addresses. Works!

    This morning I will get help from Inovis tech support about how to
    map/join the shipper address (F4706) over to F47046.

    Eric Lehti, Sr. programmer analyst
    (918) 879-6036 direct; (918) 292-9142 mobile
    Ameristar Fence Products, Tulsa Oklahoma





Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Inovis TrustedLink EDI license fees for transfer to Power6 server
    By Eric Lehti in forum JD Edwards® World™ Applications
    Replies: 1
    Last Post: 11-23-2009, 01:12 PM
  2. EDI; Inovis TrustedLink System i; not committed to A91 release?
    By Eric Lehti in forum JD Edwards® World™ Applications
    Replies: 2
    Last Post: 11-30-2007, 12:39 PM
  3. Replies: 0
    Last Post: 11-30-2007, 10:13 AM
  4. f4006 order address
    By ekben in forum JD Edwards® EnterpriseOne
    Replies: 2
    Last Post: 07-31-2006, 04:30 PM
  5. Order Address F4006
    By mjb in forum JD Edwards® EnterpriseOne Applications
    Replies: 2
    Last Post: 04-08-2003, 07:02 AM

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, Oracle or Peoplesoft.