Job Manage Utility Fix

Update quotes to exclude Reports flag on that are marked as prepriced 

 This flags the quotes with the Exclude from Reports tick box 

 In each of the first query, you need to note the quote numbers to update 

 Rules 

 Only sub quotes with . numbers are applicable 

 Any quotes that have the Charge up and prepriced ticked are excluded 

 Any quotes that have the prepriced ticked and not the charge up tick are eligible for the query update. 

 Run query for each quote that means the condition 

 Update Job lines that are CTC with sell value and set to zero 

 This sets CTC lines that have a selling value to zero for both job lines and job history lines 

 The second query checks for any job lines that are marked as CTC and have a sell price in them. 

 If any are found, then tick the box to run the queries 

 There are two queries to run for the job 

 Set Invoice lines that are marked as CTC with sell value to SC for Usage invoice only 

 This changes usage invoice lines that are CTC which have a sell value to SC line 

 It also sets the SC line to display quantity based on quantity to sell 

 This is to ensure that the invoice displays the correct lines to match to the total of the invoice 

 The third query 

 This is specific to only usage invoices on this job 

 In order to active the check button, one must select an invoice to update which searches for usage invoices only linked to this job