Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

EDI Remit To Substitutions

 4 Replies
 1 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
Matt_B
Advanced Member
Posts: 22
Advanced Member
3/11/2019 3:08 PM

    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
    Veteran Member
    Posts: 510
    Veteran Member
    3/11/2019 4: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
      Tags: EDI; Remit; Substitution Table
      Erik G.
      Basic Member
      Posts: 14
      Basic Member
      3/11/2019 4: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).
        Tags: EDI; Remit; Substitution Table
        Matt_B
        Advanced Member
        Posts: 22
        Advanced Member
        3/11/2019 6: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.
          Tags: EDI; Remit; Substitution Table
          Kat V
          Veteran Member
          Posts: 1020
          Veteran Member
          3/11/2019 8:28 PM
            oooo... I didn't either! Please share if it works!
            Tags: EDI; Remit; Substitution Table