1 Topic by gobrien (edited by gobrien 11/15/2010 06:27:30 pm)

  • Registered: 10/01/2010
  • Posts: 11

Topic: Tax Inquiry Problem

Both the Tax Inquiry and the Tax Report are behaving oddly. I'm expecting I've done something wrong so I'm putting it here rather than in Mantis. I'm expecting that the following inquiry for January 2010 should show a Net Payable amount of 903.64 - 488.99 = 414.65, i.e the difference. For some reason it is showing both values as positive and thus it's telling me to pay too much tax.

Has anyone seen this before?

from:          to:          Show
Type    Description    Amount    Outputs/Inputs
VAT IE 21%    Charged on sales (Output Tax):    903.64    4,303.05
VAT IE 21%    Paid on purchases (Input Tax):    488.99    2,328.52
VAT IE 21%    Net payable or collectible:    1,392.63   
Total payable or refund:    1,392.63   

Thanks,

Gareth.

By the way it is correct in the GL. Only the report and inquiry are wrong.

  • Registered: 10/01/2010
  • Posts: 11

Re: Tax Inquiry Problem

It seems that when the purchase is for actual stock items that have a PO and then are invoiced everything works fine.
However when I do the following it seems the value is entered in the trans_tax_details as a negative which doesn't seem to be correct:

Open Purchases>Enter Supplier Invoice
Use a Quick Entry to put two lines into the invoice the first of which is tax and the second the service, etc.
Post the invoice.

The AP and GL entries are correct including the tax entries so no problem there. However the trans_tax_details entry will be -[tax amount] whereas for an item-based (rather than GL Item) invoice the trans_tax_details entry will be +[tax amount].

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Tax Inquiry Problem

This was a bug a while ago. It is fixed in 2.3 RC3.

/Joe

  • Registered: 10/01/2010
  • Posts: 11

Re: Tax Inquiry Problem

Thanks Joe.

Please confirm that they should be +ve values in the database so I can write some bad SQL to change them!

Gareth.

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Tax Inquiry Problem

The values will be on the right side on the tax reports.

/Joe

  • Registered: 10/01/2010
  • Posts: 11

Re: Tax Inquiry Problem

In case someone else runs into this. I ended up using this to correct the values in the database:

UPDATE `frontaccount`.`1_trans_tax_details` ttd
SET net_amount = -net_amount, amount = -amount
WHERE trans_type=20 AND amount < 0;