These are pre-incorporation expenses that were paid by the Director, and are allowed under UK VAT laws
Does anyone know the SQL syntax for the query I need Regards Scott On Friday 25 October 2002 5:56 pm, you wrote: > 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 > > -------------------------------------------------------
