Non-Inventory item import cannot update Cost field?
I am helping a friend update his item list. One of the things he's most interested in doing is getting the cost of each item (from the vendor) imported into QB. Almost all of the items are currently non-inventory items. He is an electrician and these are items he buys from a vendor and then uses to do work for his clients.
We have exported his item list to Excel, made some items Not-Active, added several items, and changed some items. I thought this import was going to work great, and then I just read somewhere that the Cost field is not imported for non-inventory items. I also read that you CAN set it to insert cost if you set the fields a certain way and add a column for "is reimburseable charge" on the import.
The article I read states that this works for NEW items, but you cannot update cost for existing non-inventory items. Is there no way around this? One of the things we were hoping to do is get updated cost numbers from the vendor periodically and re-import them to QB so his list always has current prices.
What is the best solution here?
Thanks for any help!