FrontAccounting forum — Tax Inquiry Problem

Re: Tax Inquiry Problem

null@example.com (gobrien) — Tue, 16 Nov 2010 14:12:34 +0000

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;

Re: Tax Inquiry Problem

null@example.com (joe) — Tue, 16 Nov 2010 10:54:05 +0000

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

/Joe

Re: Tax Inquiry Problem

null@example.com (gobrien) — Tue, 16 Nov 2010 10:16:29 +0000

Thanks Joe.

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

Gareth.

Re: Tax Inquiry Problem

null@example.com (joe) — Mon, 15 Nov 2010 23:59:11 +0000

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

/Joe

Re: Tax Inquiry Problem

null@example.com (gobrien) — Mon, 15 Nov 2010 19:30:46 +0000

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].

Tax Inquiry Problem

null@example.com (gobrien) — Mon, 15 Nov 2010 18:19:46 +0000

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.