
Currently standard cost and list prices on the inventory cards are being updated manually whenever needed. I'd like to be able upload price lists from our vendors to make the changes. Does anyone know what options might be available? I've run into an error we cannot bypass with SmartConnect.
*This post is locked for comments
I have the same question (0)We use integration manager to update inventory cost and adjust inventory from a mainframe feed.
With IM you can source from text files, database views or spread sheets which most businesses use already. When you set up the mapping, you will need the item number and site as the main key, The only other fields you need to set are Cost and Price in the mapper. The rest of the fields can be set to default. Please test this on a test company until you know the price and costing system is stable after the integration. Do run reconcile on the inventory so that it can adjust sales prices with vendor records and the item master.