PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 03/11/2019 4:28 PM by  Kat V
EDI Remit To Substitutions
 4 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Matt_B
Applications Analyst
Private
Advanced Member
(52 points)
Advanced Member
Posts:20


Send Message:

--
03/11/2019 11:08 AM

    Hey All, 

     

    I was wondering if any of you are using the Remit to substitution function and hopefully someone could explain to me exactly where it's grabbing the Lawson Value. 

     

    Trading Partner specific remit to code

     

    Field Value Comments/Examples
    List name _I_REMITTO
    Your value
    External value Value in N1RE04

    Scanario: We have Abbott all under a single vendor number with multiple purchase from locations. For example Abbott Vascular is P005 and Abbott Nutrition is P005. The invoices for these come in with a Remit to of Abbott Labs and apparently this causes our AP processor in charge of EDI vendors to have to manually change the Remit To for invoices from these trading partners prior to payment. I'm wondering if this is the correct application for the substitution table entry and if so, where are we setting up the Remit to code? 

     

    I know that the external value is in Segment 04 but just need to figure out where and what to setup to get it to work correctly. 

     

    REF^OQ^500181533563~ 

    N1^RE^ABBOTT NUTRITION^91^0042831150114

    N3^P.O Box 92679~

     

    Any ideas or information would be greatly appreciated. 

    Tags: EDI; Remit; Substitution Table
    JimY
    Private
    Private
    Veteran Member
    (1246 points)
    Veteran Member
    Posts:446


    Send Message:

    --
    03/11/2019 12:09 PM
    We use the _I_SHIPTO Substitution.
    For Example -
    Internal Value: ST1 21773PUR11000
    External Value: 78917

    ST1 - Our Ship To Location length 5
    21773 - Vendor Number length 9
    PUR1 - Purchase From Location Length 4
    1000 - Company Number Length 4
    Erik G.
    System Analyst I
    Private
    Basic Member
    (17 points)
    Basic Member
    Posts:7


    Send Message:

    --
    03/11/2019 12:56 PM
    We do the same thing that JimY's organization does except that our internal value is * (Not sure why as this was set up long ago).
    Matt_B
    Applications Analyst
    Private
    Advanced Member
    (52 points)
    Advanced Member
    Posts:20


    Send Message:

    --
    03/11/2019 2:23 PM
    Interesting, I was not aware that a ShipTo substitution entry could be used in an incoming transaction. I'll do some testing and come back with results for posterity if it works out.
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2336 points)
    Veteran Member
    Posts:796


    Send Message:

    --
    03/11/2019 4:28 PM
    oooo... I didn't either! Please share if it works!
    You are not authorized to post a reply.