Any takers on this one? 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 -------------------------------------------------------
