Identifying transactions

SUGGESTED

In the audit reports (e.g. AUDITDL) when downloaded as an Excel/csv file, how do you identify the deleted or cancelled transactions (which are shown in red when you look at it in Sage). They all appear to start with "Cancel - see tran" oe "Deleted" in the TransactionItemised.Details field, but surely somebody could enter text like that in a normal entry in the Details column, so that isn't absolutely guaranteed to be a system deleted or cancelled transaction.  Sage must have some way of identifying the transactions to be ignored, but how do we do it?

Alternatively is there a version of the AUDITDL report which excludes deleted/cancelled transactions?

Parents
  • 0
    SUGGESTED

    Hi Malcolm,

    Thanks for using Sage City. Apologies for the late reply to this. We changed over Sage City and some queries were missed by mistake.

    You may have already found an answer to your query but if not, you can run the Audit Trail report you mentioned but tick 'Exclude Deleted Trans' in the criteria screen and that'll remove them for you.

    If this has answered your question please click More > Verify Answer.

    Kind regards,

    Sean,
    Sage UKI

Reply
  • 0
    SUGGESTED

    Hi Malcolm,

    Thanks for using Sage City. Apologies for the late reply to this. We changed over Sage City and some queries were missed by mistake.

    You may have already found an answer to your query but if not, you can run the Audit Trail report you mentioned but tick 'Exclude Deleted Trans' in the criteria screen and that'll remove them for you.

    If this has answered your question please click More > Verify Answer.

    Kind regards,

    Sean,
    Sage UKI

Children
No Data