PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 01/13/2017 9:00 AM by  h0llywood
Substitution Table Question
 2 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
    (2766 points)
    Veteran Member
    Posts:972


    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!

    You are not authorized to post a reply.