Couple of questions on this one: If the company did not pay the tax, is it entitled to deduct iut as prepaid tax? Did an employee or director pay it and was he/she reimbursed? If so, was that excluding or including tax?
(Depending on the answers on above questions) IF the company is entitled to deduct the tax in those items, the G/L entries may be wrong. >From your initial question I take it they were NOT split in gross, tax and net cost. Hth, Paul -----Original Message----- From: [EMAIL PROTECTED] [mailto:sql-ledger-users-bounce@;freelists.org] On Behalf Of Scott Taylor Sent: Friday, October 25, 2002 8:17 PM To: [EMAIL PROTECTED] Subject: [SL] PostgreSQL Tax Query 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 -------------------------------------------------------
