Reporting On Manually Generated Connotes

To report on manually generated connotes, run the following SQL script:

Copy

SELECT
Status,
CarrierName,
CarrierServiceName,
ConnoteDate,
ConnoteNumber,
SenderName,
DeliveryName,
DeliveryCompany,
DeliveryAddress1,
DeliveryAddress2,
DeliverySuburb,
DeliveryState,
DeliveryPostcode
 
FROM CON
 
INNER JOIN CAR1
ON CAR1.CarrierServiceID = CON.CarrierServiceID
 
INNER JOIN CAR
ON CAR.CarrierID = CAR1.CarrierID
 
INNER JOIN CON1
ON CON.ConnoteID = CON1.ConnoteID
 
WHERE CAR.TenantID = < TENANT ID >
AND CAR.InstanceID = < INSTANCE ID >
AND CON1.JobID = 0
AND CON.Status IN('Completed', 'Manifested')