IC11.1 Add-In

Author
Messages


ardrao











Advanced Member



Posts: 32




Advanced Member



    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: 1162




    Veteran Member



      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



        Thank you Jon. Much appreciated.


        Kat V











        Veteran Member



        Posts: 1020




        Veteran Member



          What Jon said!  We do an UNSPSC update monthly, I can share the spreadsheet example and map if need be.kvila@mhs.net
          ---