Can Excel pull data from Sage 100 Item inquiry under the Bill of Material menu

Question

Hi Everyone, 
 I am wondering if there is a way that I can have excel look up a part number when entered in sage and pull the standard price from the Item Inquiry under the Bill of Materials menu automatically. So my excel sheet is for scrapped items. I would like it to pull the most up-to-date cost for the items when I type them in the excel form so that way I do not have to look them up each time. Let me know if I need to give more information.

Sage100Reports · Answer

I would create a sheet in your excel spreadsheet that links to the ci_item table. Then, on your other sheets, you can do a VLOOKUP against that table within Excel. The only catch is that you will need to use the Refresh feature to update the data but this should provide you the functionality you are looking for. The refresh should only take a minute. Hope this helps!

Sage 100

Can Excel pull data from Sage 100 Item inquiry under the Bill of Material menu

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING