Invoices: Update as a "Purchase"?

pgr · 16 March 2020 16:18

Ah ok, I know what you mean now, thanks.

The data for that subpanel comes from this SQL query:

salesagility/SuiteCRM/blob/master/modules/AOS_Products/AOS_Products.php#L95


           move_uploaded_file($_FILES['uploadimage']['tmp_name'], $sugar_config['upload_dir'] . $prefix_image . $_FILES['uploadimage']['name']);
       }


       require_once('modules/AOS_Products_Quotes/AOS_Utils.php');


       perform_aos_save($this);


       return parent::save($check_notify);
   }


   public function getCustomersPurchasedProductsQuery()
   {
       $query = "
			SELECT * FROM (
				SELECT
					aos_quotes.*,
					accounts.id AS account_id,
					accounts.name AS billing_account,


					opportunity_id AS opportunity,
					billing_contact_id AS billing_contact,

I think the part most relevant to you is this: aos_quotes.stage = 'Closed Accepted'

This is related to the values coming from this dropdown (see Admin / Dropdown Editor):

Note that if you don’t like the string Closed Accepted you can change its display label, but you should leave the Item name as it was, so that the value is stored in the database in the way that the above query expects it to.

Once you fix that, you will need to re-save records to make sure they have “close accepted” in the database.

It would be nice if that “close accepted” wasn’t hard-coded into the query, but hey maybe somebody will fix that one day…