I meet two problems that need some suggestions:
1. What is the Account and Contact columns for in the Product input page?
Those two columns are necessary. I don't understand their meaning.
2. I can't find any product that I input already when I try to open a new quote.
I try to input some product name but it alerts me that finds no product, then I try to select product from pop window but it shows no product.
I don't know what's the problem here. Maybe some relations that I don't know are conflited prevents me to get the product.
3. Is there any function or any easy way to record all the sql statements into a file or directly show all statements on screen?
With best regards,
Dragoon
It seems that I misunderstand the functions.
I should input products into ProductTemplates (/Administration/ProductTemplates/edit.aspx), not Products (/Products/edit.aspx).
I am trying it now.
I don't think that the PRODUCTS table is used in SplendidCRM. It is a carry-over table from SugarCRM. Instead, we use ORDERS_LINE_ITEMS, QUOTES_LINE_ITEMS and INVOICE_LINE_ITEMS.
The PRODUCTS_TEMPLATES table is used to store the products that are available. This information is called a template because all data is copied to the LINE_ITEMS table when an order, quote or invoices is created.
