Sales Tax Reporting
Question asked by Richard Mast - June 8, 2015 at 2:58 PM
Our State allows us to file sales tax just on the invoices that we have actually collected the money for.  (Cash Basis)  We would like to be able to print a Sales Tax Report in Atrex using Cash Basis instead of Accrual Basis. 
Does the system store the date on which each particular invoice reaches zero balance?  I need to print a sales tax filing report at the end of the month which contains only invoices that reached a zero balance during that month.
Does this sound like something that can be done with report writer?
Thanks in advance.

1 Reply

Reply to Thread
Mark Culos Replied
June 8, 2015 at 4:12 PM
Employee Post
The date of each payment application is recorded (table ARDetail) so it is possible to report on those invoices that are zero balance and the latest payment application date is within your report date range.  If all invoices are created with an outstanding balance then the final payment date is determined in this way.  If you also have fully paid invoices as of the invoice date (i.e.,, payments on orders or invoices), you will need to take that into account.

Reply to Thread