Removing Jobs from 50-50 reports that have been Reversed

04/29/2024 10:47 am EDT

Customers run a commission report called 50/50 from Report Manager>Job Management>Commission Due- 50/50

There will be times when they reverse a job, and the Job should not be included in this report. The following script will remove respective jobs.

The only updates to the script are the Job numbers = Job_code that need to be removed.

A screenshot of a computer code
Description automatically generated

//INSERT INTO OE_Job_Userdef 
(Job_Id,Customer_Site_Id,Customer_Id,Text1,Text2,Text3,Text4,Text5,Text6, Text7,Text8,Text9,Text10,Text11,Text12,Text13, Text14,Text15,Text16,Date1,Date2,Money1,Money2,Table1_Id, Table2_Id,Table3_Id,Table4_Id,Check1,Check2,Check3,Check4,Check5) 
SELECT 
Job_Id,Customer_Site_Id,Customer_Id,'','','','','','', '','','','','','','', '','','','1899-12-30','1899-12-30',0.00,0.00,1, 1,1,1,'Y','N','N','N','N' 
FROM OE_Job job 
WHERE Job_Code IN ('35136-1', 
'33824-1', 
'28864-1', 
'34862-1', 
'35450-1', 
'35404-1', 
'35682-1', 
'32625-1', 
'28471-1')

Was this article helpful?