Fwd: Re: making a functional invoice

[Geert Janssens]

Please keep your replies on the list. Others may have useful feedback as well and 
the conversation can be helpful for others.

As for your question, I'll get back to it later. I have to leave now.

Regards,

Geert

----------  Forwarded Message  ----------

Subject: Re: making a functional invoice
Date: Wednesday 11 May 2016, 13:56:18
From: Wendell <wkrause at ncodesys.com>
To: Geert Janssens <geert.gnucash at kobaltwit.be>

Thank you Geert,
Since the customer pays for the computer on his end, it is not part of 
the invoice except that tax calculations are based upon that cost.
I simply bring in the freight from the us and clear customs for it. 
These costs must be reimbursed along with the freight.
The freight is easily figured but the various duty charges make 
calculating cumbersome and easily mistakes can be made.
How can I write these things into the tax tables where I can simply put 
%, which vary, based upon commodity, into the tax tables. If I can't do 
that then I am going to have to do 2 invoices, one in Libre Office for 
the customer and then enter the total into GNU. This will then not track 
the various taxing entities.

Whew,
Wendell

On 05/11/2016 12:25 PM, Geert Janssens wrote:
>
> On Wednesday 11 May 2016 11:55:51 Wendell wrote:
>
> > Hello All,
>
> > The attached invoice is from Libre Office in Ubuntu.
>
> > I am trying to get the formulas into the GNU invoice to do the same
>
> > calculations as in the attached.
>
> >
>
> > Is there a way of amending the GNU invoice to do this? It calculates
>
> > shipping costs and the various duty costs, including sales tax on
>
> > everything.
>
> >
>
> > Does anyone think that this is possible?
>
> >
>
> > Thanks in advance,
>
> > Wendell
>
> > --
>
> Hi Wendell,
>
> I don't think you can get exactly the invoice you present here.
>
> Your single line in the invoice contains several costs (the cost of 
> the computer and the cost of freight) and calculations based on those 
> two. GnuCash only tracks one cost per line in the form (amount x unit 
> price = total amount, with tax either in- or excluded).
>
> You could split your line into two separate ones, one for the computer 
> and one for the freight. From there you can probably reconstruct most 
> tax calculation formulas via tax tables in GnuCash.
>
> However that won't replace the conditionals you have added in the 
> formula to calculate the freight cost based on the weight. The only 
> option I see there is to manually enter freight yourself. GnuCash 
> doesn't have a way to choose a freight cost based on the weight of the 
> package.
>
> Customs clearing seems to be the total tax amount on your invoice, 
> which normally appears on the invoice. You can also make the 
> individual taxes appear via the invoice report options. I don't know 
> if you can make that appear for each indiviual line though. Perhaps 
> it's only the tax summary that can display individual taxes.
>
> Lastly, it's unusual that the cost of your computer is not included in 
> the total invoice amount. If that really is the way invoices are 
> created in your country, that again is something not possible with the 
> invoice reports included in gnucash. If that's required you'll have to 
> tweak one of the existing reports. They are written in the guile 
> programming language.
>
> Regards,
>
> Geert
>

-----------------------------------------