EDI Remit To Substitutions

 4 Replies
 1 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
Matt_B
Advanced Member Send Private Message
Posts: 22
Advanced Member

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. 

JimY
Veteran Member Send Private Message
Posts: 510
Veteran Member
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.
Basic Member Send Private Message
Posts: 14
Basic Member
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
Advanced Member Send Private Message
Posts: 22
Advanced Member
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
Veteran Member Send Private Message
Posts: 1020
Veteran Member
oooo... I didn't either! Please share if it works!