FrontAccounting forum — show total excluding tax even when pricebook is including tax

Re: show total excluding tax even when pricebook is including tax

null@example.com (joe) — Fri, 07 May 2010 07:50:47 +0000

The method described by rodw, will be an option (config.php) in release 2.3 that are about to ship primo June.

/Joe

Re: show total excluding tax even when pricebook is including tax

null@example.com (brynn_thomas) — Fri, 07 May 2010 07:20:37 +0000

I've just installed FA and was wondering if this issue is being taken seriously. My customers are more interested in the excluding VAT amount as this is what they actually pay, the VAT amount is offset against their own purchases.
If it isn't going to be changed on the software, (I really think having both options is the best way forward), is there somewhere I can change it on my installation?

Any help would be greatly appreciated.

Thanks,
Brynn

Re: show total excluding tax even when pricebook is including tax

null@example.com (alvin) — Mon, 08 Mar 2010 21:28:24 +0000

You have my vote for this change...

Re: show total excluding tax even when pricebook is including tax

null@example.com (rodw) — Mon, 08 Mar 2010 10:56:16 +0000

joe wrote:

Before the tax displaying, the function get_trans_tax_details($type, $trans_no) is called in all the views and reports, so it should be fairly ok to fix this, but the line totals are displayed tax included. Wouldn't it require one more total line, f.i. Subtotal (tax included) Subtoal (tax excluded) and then the normal tax display and invoice total?
/Joe

Joe I think we are thinking of (well I was anyway) of something like

IF (Global_ShowReportsTaxInclusive == TRUE){
// Show Current default report format
Display{
sub-total : 16.00
VAT 19% included 2.55 : (and then nothing in the cell with amounts)
total : 16.00
}
}
ELSE{
// Show revised Tax Exclusive report format
Display{
sub-total excluding VAT: 13.45
VAT 19%: 2.55
total including VAT: 16.00
}
}

Anyway, you'll get the drift of my peudo-code...

Re: show total excluding tax even when pricebook is including tax

null@example.com (shopimport) — Sun, 07 Mar 2010 14:47:01 +0000

I do appreciate the input of rodw and at first it seems like a good solution, however probably maintenance wise it's not prefered to have extra company options for this. I think if the subtotal tax excluded is added to the screen and invoice report then this will fullfill my needs.

Whether or not to also show Subtotal tax included I think this depends whether it can differ from the invoice total. If the Subtotal tax included will never be different from the invoice total then there seems no need to add it. But probably it might differ in case of shipment? I just checked the demo and indeed the total invoice will have shipment included while the subtotal will only sum the item lines.

This means that also Subtotal tax excluded is not good enough for me. I'm looking for the Total invoice tax excluded.

If I send an invoice to a client and I'm not sure whether it's a company or private person then at least total excluding, the VAT and the total including are relevant.

Re: show total excluding tax even when pricebook is including tax

null@example.com (joe) — Sun, 07 Mar 2010 11:18:32 +0000

Before the tax displaying, the function get_trans_tax_details($type, $trans_no) is called in all the views and reports, so it should be fairly ok to fix this, but the line totals are displayed tax included. Wouldn't it require one more total line, f.i. Subtotal (tax included) Subtoal (tax excluded) and then the normal tax display and invoice total?

/Joe

Re: show total excluding tax even when pricebook is including tax

null@example.com (rodw) — Sun, 07 Mar 2010 11:08:27 +0000

I can see that people would like to have a choice here. From my brief experience with FA, this does not sound too hard to achieve as it is only a change to report format and the reports are mainly contained in the one file aren't they?

Perhaps there was a global flag that allowed user to toggle between the current report and the format proposed by shopimport? There may also need to be a couple of screen updates that would also respect the state of this flag..

Re: show total excluding tax even when pricebook is including tax

null@example.com (joe) — Sat, 06 Mar 2010 22:36:23 +0000

This was discussed a long time ago, before the establishment of the Forum.
It was at that time proposed to present it as is now. But we can let this be an object for discussion.

/Joe

show total excluding tax even when pricebook is including tax

null@example.com (shopimport) — Sat, 06 Mar 2010 20:18:12 +0000

I'm using the sales type "retail" with the tax included set. So when creating an invoice then the prices of the items are including tax. An item of 16 euro will be 16 euro including tax.

The total will also show 16 euro which is great. However the sub-total I would prefer to see the sub-total excluding tax while currently (FA 2.2.6) it shows again the total including tax.

sub-total : 16.00
VAT 19% included 2.55 : (and then nothing in the cell with amounts)
total : 16.00

And I'm really missing the amount excluding tax. I would prefer to see:

sub-total excluding VAT: 13.45
VAT 19%: 2.55
total including VAT: 16.00

In this case it will keep a consistent sub-total calculation whether the sales type is including or excluding tax.