"Products and Services Purchased"-Subpanel for Invoice-LineItems, too

💬 General Discussion
1

Hi,

We use the new SuiteCRM 7.4 Release and the new “Products and Services Purchased”-Subpanel is a very nice and helpful feature for us.

  1. Is it possible to show the lineItems of the invoice-module in this subpanel? Which files i had to customize to change the SQL-Query for realizing this?

  2. In my installation an error will be occured, if I change the order of the subpanel by clicking at the header-line. By clicking at “Product/Service” it works.
    For examble if I click at “Quote” it doesn’t work.

    This are the lines from the suitecrm.log-file:

11/05/15 18:58:11 [12540][1][FATAL] Error retrieving Account list: Query Failed: (
SELECT
aos_products_quotes.*
FROM
aos_products_quotes
JOIN aos_quotes ON aos_quotes.id = aos_products_quotes.parent_id AND aos_quotes.stage LIKE ‘Closed Accepted’ AND aos_quotes.deleted = 0 AND aos_products_quotes.deleted = 0
JOIN accounts ON accounts.id = aos_quotes.billing_account_id AND accounts.id = ‘64d00332-17c9-470e-6637-55799b75b46f’

		) ORDER BY parent_name desc LIMIT 0,10: MySQL error 1054: Unknown column 'parent_name' in 'order clause'