Query - Time card Entries and the related Service Incidents

#1 · June 4, 2020, 2:09 pm

Here is a nifty SAP Business One report that lists time card entries and the related service calls they were entered for. I have this as a formatted search from a UDF on the AR Invoice form. This allows me to easily create my billings for service related activities.

Note: If you set this query up as a Boyum Usability Package SQL Universal Function, then you can get expanding and collapsing entries for each service ticket.

SELECT T2."DocNum" "Service ID",
T0."AbsEntry" "Timecard",
T0."ProjectID",
T0."FirstName",
T0."LastName",
T0."CreateDate",
T2."subject",
T1."BillableTm",
T1."NonBillTm"
FROM OTSH T0 INNER JOIN TSH1 T1 ON T0."AbsEntry" = T1."AbsEntry"
INNER JOIN OSCL T2 ON T1."ServCall" = T2."callID"