Taxable/NonTaxable Totals Report by Customer Sort Code

Taxable/NonTaxable Totals Report by Customer Sort Code

The following are instructions to get a report of customer’s sort codes.

From the main menu type TCL and press enter.

At the : type SHL DISP.TCL.CMD and press enter.

This will put the report on the screen, so you print it or download. Then X to exit back to TCL.

Now print the list of existing codes. At the Input TCL Command: type:

SORT ORDER WITH CUST.SORT.CODE = "XXX" AND WITH INVOICE.DATE >= "DDD" AND WITH INVOICE.DATE <= "DDD" AND WITH TRANS.TYPE = "DI""CI""WI" TOTAL TOT.NON.TAXABLE TOTAL TOT.TAXABLE TOTAL TAX.AMT DET-SUPP

and press enter.

*DDD = Date

*XXX = Sort Code