Integrating Zoho CRM Price Book with Zoho Creator
Hello Experts,
I'm trying get an idea about feasibility of integrating ZOHO CRM's PRICE BOOK / QUOTE INVOICING features with Zoho Creator (or an external database like Access or MSQL)
Is it possible to generate dyanamic Unit Prices based on user defined parameters (eg Model, Plating Type1, Plating Type2), which are passed to a database (eg MSQL or similar), and which returns a Unit Price for including in a Quotation?
In my company:
Each Model has 4 Parts
Each Part has a Raw Price and Plating Weight.
Each Plating Type has a Plating Cost( $/KG) or Plating Cost ($/Unit)
Each Part can have 0, 1 or 2 Plating Types ($/KG).
Price = Sum(Raw Price) + Sum(Plating Weight*Plating Cost#1) +
Sum(Plating Weight*Plating Cost#2) +
Sum (Plating Cost $/Unit)
Any comments much appreciated.