EDI purchase from vendors vs pay to vendors

 2 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
Kodi L
Basic Member
Posts: 12
Basic Member
    We have an issue where we have to issue purchase orders to a certain company (we have seperate EDI #'s) but when the invoices come through MA540 the remit to is a different company with several divisions. For example, we buy from Codman, Depuy, Ethicon, etc but when the invoices come through MA540 the remit to is Johnson and Johnson so the match errors our and the purchasing agents have to go change the PO vendor to Johnson and Johnson so the invoice from EDI can match.

    What would Lawson best practice suggest in this scenario? 

    We have heard to use the Pay to from the data management team and the Purch From from the accounts payable team. Any thoughts would be helpful.

    Thanks in advance.
    JonA
    Veteran Member
    Posts: 1163
    Veteran Member
      Best practice is to use the Purchase From (AP10.2/PO10.2) to identify divisions within a vendor. Using your example, J&J, our EDI setup is slightly different though. We have a single vendor number for all J&J and then purchase from codes for J&J Healthcare, Ortho Clinical Diagnostics, etc., but we only use the J&J Healthcare purchase from code for EDI.  We identify the many divisions by setting up a substitution in ED40... TPID_O_JJDIV. This grabs the Mfg/Div on the PO line and translates it to a 2 character J&J division code that goes in PO107. J&J uses this to determine to which division the order should go. (We also use GHX as the VAN for J&J orders)
           
       Lawson Value  External Value
       JJASP AS (Advanced Sterilization Products)
       JJBIOS BW (Biosense Webster)
       JJCODM CO (Codman)
       JJCORD CC (Cordis)
       JJENDO ES (Ethicon Endo)
       JJETHI ET (Ethicon)
       JJMEDI MI (Medical)
       JJMITE DM (Depuy Mitek)
       JJORTH OC (Ortho Clinical)

      Examples
      PO1>1>1>PK>100>>MF>DM>VC>214120>IN>58063
      PO1>1>1>CA>2712.03>>MF>ES>VC>4350>IN>12134

      Likewise, you can set up a substitution for the Remit-to to be used to process the EDI invoice.
      Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
      Kodi L
      Basic Member
      Posts: 12
      Basic Member
        Thanks Jon!  This is really helpful.