We are in the produce business where market prices varie weekly.  I need to have a FOB price and a delivered price for each of over 150 different products.

I want to make a 'price book',  either in Excel or Access,  where the salesperson can review the product list pricing,  changing the FOB and DEL prices as needed,  and then have these values written back to quickbooks.

I noticed when in Quickbooks it wouldn't let me change the custom pricing unless I go to single user mode.  Is this also going to be the case with QODBC?

I would like to do it in Excel (simply because I can program it more easily) but I can program Access if neccessary.  I am confused about how I can do a write back from Excel.  Could you direct me to some examples that would get me started?

Thankyou

Tom

You will need to read your Excel spreadsheet in MS Access and then program a loop to read each line and perform an update operation.

To update a PriceLevelPerItem row, the statement format looks like this:

Update PriceLevelPeritem SET PriceLevelPerItemCustomPrice = 43.21, PriceLevelPerItemItemRefListID = 'F0000-933272656'  WHERE ListID = '30000-1197755980' AND PriceLevelPerItemItemRefListID = 'F0000-933272656'

To insert PriceLevelPerItem rows see: PriceLevelPerItem Updates & Inserts for more information.