• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
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 Send Private Message
Posts: 32
Advanced Member
2/20/2015 11:57 PM
Thank you Jon. Much appreciated.
Kat V
Veteran Member Send Private Message
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