Void Ticket showing in ServQuest but not in Dispatch or AR-Invoice

Troubleshooting tickets only showing in ServQuest but not in Dispatch

The ticket is likely voided by the client, this can be confirmed by running the query:

select csono,ccustno,cstatcode,dorder,dcreate,damendtime,lvoid,* from scsord where cstatcode = 'OPEN      '
and lvoid = 1

This query will return all voided tickets, a voided ticket will have a lvoid column values of '1'.

The table above shows all voided tickets for a specific client.

lvoid = 0: The ticket is not voided

lvoid = 1: The ticket is voided

2. The above Script Will help you to identify the Void tickets that are not showing on the AR- Invoice Menu grid.