Hi, im implementing the crm in a business that sells motorcycles and have 14 stores. The problem that i have is that every night the IT department of the business send me the products and their prices using the API, because the prices are going to change every day (dollar fluctuation ,etc).
But are some problems that i cant belive you cant solve quickly....
1. The API doesnt support to associate products to a pricebook.
2. The API doesnt support to update the price list of a specific product in a specific pricebook
3. The quote module have the price list field as required field.
So if i have 200 products and i want to update the price list every day, i have to go to the pricebook and edit all the products associated to the pricebook one by one.....
I belive that the solution is easy.... or you create an API method for insert and update so you only send the pricebook, the product and the price list....
or you change the required field price list in the quote (or other module) so we cant set an specific price without typing it.
See what i need... i belive that many people need this and for me in this case is an emergency because the business cant go every day to check if the price change and go to search the product of the pricebook and change the price list.
im going to be the most understable possible.....
1. Using the API i create my products (image1)

you can see that the product "Avenger 200, 2009, Negro Multicolor" has the following data (image2):

note that the price is 12052.68.
If i want to quote using this product i go to the quote module and in the product detail i click the image for open the window of products (image3) and that buttom open the products you can see that there ir the "Avenger 200, 2009...." (image4)

opens this:

i click the AVENGER 200, 2009, Nego Multicolor, and automatic fills the fields product name, Qty.in Stock and unit price:

Here is the problem.... in Qty field i place 1 (i just need 1 product of this) but the list price is my problem because i cant create a pricebook with the product AVENGER 200, 2009 using the API so if i click the pricebook name lookup is in blank. (image6 and image7)


Here is the dilema.... create and api method to insert the association and update products to the pricebook. (what you see in the image8 do it with the api)

or when i select the product also charge the unit price as the list price or place a buttom to copy the unit price in the list price or disable the list price... because i cant risk to a human failure.....

calucalte the total using the unit price in case you dont want to develop a method for the api.
Thank.
Carlos Velasquez.
carlos.velasquea@fiomega.com
masesa@fiomega.net