Fixed query error impacting performances in inventory

This merge request is fixing and error in several queries impacting significantly performances if there are a big number of orders in the database. Replaced: vtiger_invoice_recurring_info.start_period = vtiger_salesorder.salesorderid With: vtiger_invoice_recurring_info.salesorderid = vtiger_salesorder.salesorderid

modules/Accounts/Accounts.php

@@ -756,7 +756,7 @@ class Accounts extends CRMEntity {
LEFT OUTER JOIN vtiger_quotes ON vtiger_quotes.quoteid = vtiger_salesorder.quoteid
LEFT OUTER JOIN vtiger_account ON vtiger_account.accountid = vtiger_salesorder.accountid
LEFT JOIN vtiger_groups ON vtiger_groups.groupid = vtiger_crmentity.smownerid
-                LEFT JOIN vtiger_invoice_recurring_info ON vtiger_invoice_recurring_info.start_period = vtiger_salesorder.salesorderid
+                LEFT JOIN vtiger_invoice_recurring_info ON vtiger_invoice_recurring_info.salesorderid = vtiger_salesorder.salesorderid
LEFT JOIN vtiger_salesordercf ON vtiger_salesordercf.salesorderid = vtiger_salesorder.salesorderid
LEFT JOIN vtiger_sobillads ON vtiger_sobillads.sobilladdressid = vtiger_salesorder.salesorderid
LEFT JOIN vtiger_soshipads ON vtiger_soshipads.soshipaddressid = vtiger_salesorder.salesorderid
@@ -1753,4 +1753,4 @@ class Accounts extends CRMEntity {
}
}
-?>
\ No newline at end of file
+?>