Because some of the tax paid was entered by way of GL transactions (because 
they were not paid by the company), the tax paid report in AP will obviously 
not reflect those entries.

Could someone tell me what the syntax for a query would be to 

1. List and subtotal the transactions between 2 dates, for the tax debits and 
the corresponding net amounts where the reference (source) is the same.

2.  Do the same for tax credits and then a grand total.

Sorry I am a SQL newbie

Regards

Scott
 

Reply via email to