Job Boss Users Forum

Had a request to get the average # of days late for each customer for last year and this year so I used the code below. Not 100% if the tables are correct so I'm having to manually verify but I used Cash Receipts Detail in SQL Profiler to capture the tables required. ;With LastYearRes AS ( select IH...

I haven't used this one much and haven't seen it used in many other out of the box queries so I've been using the code below: Select Child.Job , Child.Order_Quantity , Child.Shipped_Quantity , Parent.Customer , Parent.Job [Parent Job], Parent.Part_Number AS 'Parent Part Number' , Parent.Order_Quanti...