Login
Enter your username and password to login. If you do not have a username you can register one.

Username: 
Password: 
Remember Me



Forgotten Password?

Online
34 guests have been online with in the last 10 minutes.

Hot Topic
No posts have caught fire as of yet.

JD Edwards® World™ Discussions >> JD Edwards® World™ Applications

Pages: 1
Eric Lehti
member


Reged: 09/28/05
Last on: 12/11/13
Posts: 583
Invoice a customer electronically with EDI via Inovis TrustedLink (want Shipper Address from F4006 table)
      #137726 - 09/12/08 03:37 PM

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
JdeBlues
member


Reged: 09/11/04
Last on: 06/30/11
Posts: 170
Re: Invoice a customer electronically with EDI via Inovis TrustedLink (want Shipper Address from F4006 table)
new [Re: Eric Lehti]       #137743 - 09/14/08 07:21 AM

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
PaulThompson
member


Reged: 04/12/01
Last on: 09/25/12
Posts: 38
Re: Invoice a customer electronically with EDI via Inovis TrustedLink (want Shipper Address from F4006 table)
new [Re: Eric Lehti]       #137753 - 09/15/08 03:25 AM

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
Eric Lehti
member


Reged: 09/28/05
Last on: 12/11/13
Posts: 583
RE: Invoice a customer electronically with EDI via Inovis TrustedLink (want Shipper Address from F4006 table)
new [Re: Eric Lehti]       #137811 - 09/16/08 09:43 AM

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






Post Extras: Print Post   Remind Me!   Notify Moderator  
Pages: 1


Extra information
0 registered and 0 anonymous users are browsing this forum.

Moderator:  ekempter, Christian Audet, jdecnc, Sef 

Print Thread

Forum Permissions
      You cannot start new topics
      You cannot reply to topics
      HTML is disabled
      UBBCode is enabled

Rating:
Thread views: 4670

Rate this thread

Jump to

JDELIST Support | Privacy statement JDELIST.com

*
UBB.threads™ 6.4.1

 .: IIP 5.4.5 by David Lozier ©2003 :. 
Distributed by ThreadsDev.com

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.

This page best viewed with Netscape 4 or Microsoft Explorer 4 or above in 800 x 600 resolution.