Ditto to what Stephen said. You are well advised to leave the original sales tax report as is. If you set this up, you might be held liable as well. The States want their revenue regardless of what has been collected. Now, if your customer is willing to acknowledge the requirements IN WRITING, and you provide an additional report, you are probably OK. I would also include a DISCLAIMER line at the beginning of such a report.

>Hello SBT hackers-
>
>I need to write a report that gives the user information on sales tax for payments only. Standard SBT calculates sales tax off of the invoice date. Customers sometimes partially pay their invoices from one month to the next and we would like to calculate the sales tax off of their payments.
>
>I have the following select so far but was wondering if anyone had something already written for this purpose.
>
>SELECT a.invno, a.invdte, a.custno, a.terr, a.tax, a.taxrate, a.taxsamt, ;
> b.paidamt, b.dtepaid, b.refno, b.artype ;
> FROM armast01 a, arcash01 b ;
> WHERE a.invno = b.invno ;
> AND a.tax > 0 ;
> AND a.taxsamt > 0 ;
> AND b.artype = " " ;
> AND BETWEEN(b.dtepaid, dbeg_date, dend_date) ;
> ORDER BY a.terr, a.custno, b.dtepaid ;
> INTO CURSOR sbttax_cur
>
>I will do basically the same select on the arycsh file. Let me know if you have something like this already written.
>
>Thanks-
>
>Geoff