Taxable/NonTaxable Totals Report by Customer Sort Code
Previous Topic  Next Topic 

Taxable/NonTaxable Totals Report by Customer Sort Code



The following are instructions to get a report of customers sort codes.


  1. 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.

  1. 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