Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

Substitution Table Question

 6 Replies
 1 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
h0llywood
Basic Member
Posts: 7
Basic Member
1/13/2017 12:43 PM

    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
    Veteran Member
    Posts: 1163
    Veteran Member
    1/13/2017 1:54 PM
      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 - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
      h0llywood
      Basic Member
      Posts: 7
      Basic Member
      1/13/2017 2:00 PM

        Thanks John!

        Jimmie
        Basic Member
        Posts: 22
        Basic Member
        12/5/2019 10: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
          Veteran Member
          Posts: 510
          Veteran Member
          12/6/2019 6: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
            Veteran Member
            Posts: 1020
            Veteran Member
            12/6/2019 8: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
              Basic Member
              Posts: 22
              Basic Member
              12/6/2019 8: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.