Prev
Next
Forums User Experience Lawson Add-Ins for Microsoft Office

IC11.1 Add-In

 3 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages


ardrao











Advanced Member



Posts: 32




Advanced Member



2/18/2015 12:16 AM

    Would anyone be willing to share their IC11.1 upload?  I am fairly new to Lawson and am having an issue uploading the UNSPC codes.  The problem is I am unable to find the FC in the IC11.1 table.  Any help would be greatly appreciated.

     

    Thank you,

    Ardra



    JonA











    Veteran Member



    Posts: 1163




    Veteran Member



    2/19/2015 7:18 PM
      There is no FC field for IC11. To load UNSPSC codes the code has to exist in IC16.1 first. Then map your fields as follows (for v. 9.0.1)

      Item Group = _f3,ITE-ITEM-GROUP
      Item = _f7,ITE-ITEM
      Segment = _f74,ITE-ICSEGMENT
      Family = _f75,ITE-ICFAMILY
      Class = _f76,ITE-ICCLASS
      Commodity = _f77,ITE-ICCOMMODITY
      Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health


      ardrao











      Advanced Member



      Posts: 32




      Advanced Member



      2/20/2015 11:57 PM
        Thank you Jon. Much appreciated.


        Kat V











        Veteran Member



        Posts: 1020




        Veteran Member



        2/24/2015 5:46 PM
          What Jon said!  We do an UNSPSC update monthly, I can share the spreadsheet example and map if need be.kvila@mhs.net