Customising GL Detail Report to add a field to identify original transaction - INVNO for Jobs not helpful and GLTrans Transtype field is blank

A client of mine is struggling to reconcile data on the GL Detail Report and requested if we could add a common field to make it easier to find transactions originating from the same source transaction. For instance Inwards Goods Receipts or Purchase Invoices that are from the same Purchase Order.

If goods are received in, used in a job, purchased via creditors, there can be several transactions in the GL Detail report that all relate to the same original purchase.

The fields on the report (and in GLTrans) when creditor transactions originate from the jobs ledger are quite unhelpful:

The InvNo can be a PO number or simply say "JOB: 1933"

The ChqNo has fields such as "WIP: ", "CR INVOICE", "RECEIPT", or a seqno I haven't identified the original of yet (it's not IWG, PO or PI)

The Transtype field in GLTrans is blank, so there is no way to identify the transaction type and base an sql query on that

Is there anyway to link creditor transactions in the GL Detail report or from the GLTrans table by identifying a common field, such as a source seq no?