PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 12/06/2019 3:41 PM by  Jimmie
Substitution Table Question
 6 Replies
Sort:
You are not authorized to post a reply.
Author Messages
h0llywood
Junior Software Analyst
Private
Basic Member
(19 points)
Basic Member
Posts:7


Send Message:

--
01/13/2017 7:43 AM

    Hi all,

    I have a quick question concerning the substitution tables (ED40). Yesterday one of our sites had a transmission failure that lead me to realize their purchase from value was different than what we had setup in the substitution table. 

    The problem is, I know that this vendor (Baxter) has different divisions and locations we order from, which we have set up as 2 & 5 subsequently. Now we have the Purchase from 2 on our substitution table, but not the 5. I was wondering if I did setup the 5, would that cause issues with the other Purchase from location because they share the same account. 

    I'd also like to add that we have both locations setup properly in PO10.2. 

    Any input or insight would be great. Thanks!

    JonA
    Private
    Private
    Veteran Member
    (3431 points)
    Veteran Member
    Posts:1141


    Send Message:

    --
    01/13/2017 8:54 AM
    Baxter assigns account numbers based on the customer's shipping address so one account is standard across all divisions. We EDI to Baxter and have 5 divisions set up in ED40 for our main medical center all using the same account number. Where you run into trouble with this is with the inbound transmissions. For setting up Baxter the Lawson trading partner setup guide shows a Purchase From substitution table entry for the 855s and 810s. Since Baxter is sending the same account number in N1ST04 for any division, how does Lawson know which to substitute? So we just don't enter anything in ED40 for inbound Purchase Froms for Baxter. Generally speaking, all you really need in ED40 for inbound transmissions are entries for company and vendor.
    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health
    h0llywood
    Junior Software Analyst
    Private
    Basic Member
    (19 points)
    Basic Member
    Posts:7


    Send Message:

    --
    01/13/2017 9:00 AM

    Thanks John!

    Jimmie
    application engineer
    Private
    Basic Member
    (40 points)
    Basic Member
    Posts:20


    Send Message:

    --
    12/05/2019 5:47 PM

    I have an additional substitution table question. I have a vendor who would like to use the N2 line instead of an SDQ line to gather "Deliver to" information which they need for desktop delivery. Is there a way to map the "deliver to" field from the RQ to the 850 EDI outbound file? We currently have a requesting location that shows up in the N2 line in segment 1.  I cannot see a substitution value in ED40 for this but we would like to try and map the deliver to field that shows in segment 23 son the SDQ line to show in the N2 section in segment 2.

    JimY
    Private
    Private
    Veteran Member
    (1438 points)
    Veteran Member
    Posts:510


    Send Message:

    --
    12/06/2019 1:17 PM
    Not sure if you can do that through the Substitution Table (ED40). We had a vendor that we had to make changes to the Perl script so that the values were in the right segments. Not the best way to handle it, but it worked. Of course the next time you update EDI you will have to reapply the changes.
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2824 points)
    Veteran Member
    Posts:966


    Send Message:

    --
    12/06/2019 3:35 PM

    We had to move it for Cardinal - we are using GHX's map and to make the reqloc appear where the ship to normally does is two part.

    1. Turn on the substitution:
    List Name: TPID_O_DEPT_SHIPTO
    Lawson Value: COMPANY (We use Company 1 - value is 0001)
    External Value: ON

    2. Put in all the req locs with the regular tpid-o-dept

     

    3. if you are using an exchange line GHX, you'll need to board all the req locs as accounts with them.

    Jimmie
    application engineer
    Private
    Basic Member
    (40 points)
    Basic Member
    Posts:20


    Send Message:

    --
    12/06/2019 3:41 PM

    I have the reqloc on the N2 line but I need the actual text value from the "deliver to" that normally shows on SDQ segment 23.  I think the challenge may be it's not in the POEDI header so I can't map it to the N2 segment based on what infor support said.  I don't really understand the substitution tables that well so I could have misunderstood what he was trying to tell me.  

     

    Is there a way to get that value to show up on the header line of the POEDI file?  I thought about the perl script change, and I don't really want to have to make a custom script for one vendor.

    You are not authorized to post a reply.