[GNC] Tax tables changing
Adrien Monteleone
adrien.monteleone at lusfiber.net
Sun Jun 21 13:10:32 EDT 2020
The current terminology is:
“Reset Tax Tables to current values?”
“Yes, reset the Tax Tables”
“No, keep them as they are”
Regards,
Adrien
> On Jun 20, 2020 w25d172, at 7:59 AM, Derek Atkins <derek at ihtfp.com> wrote:
>
> Hi,
>
> On Sat, June 20, 2020 6:55 am, finfort at gmail.com wrote:
>> I have renamed some of taxtables and see the same old names in my bills
>> and invoices.
>>
>> I also see a lot of records with the same taxtable names in Postgresql
>> table "taxtables".
>>
>> Could some body explain the logics of this table? What is "parent" in it?
>
> If you search the archives I'm sure you'll find I've gone through this in
> excruciating detail in the past.
>
> In short, Tax Tables get frozen when an invoice is posted. And future
> changes to the Tax Tables introduce a Copy-on-Write semantic.
>
> The reasoning is that if you post an invoice in 2018 with a 2% tax and
> then in 2019 that tax changes to 3%, if in 2020 you need to revisit that
> 2018 invoice you want it to display with 2% tax, not 3% tax. So to solve
> this problem the tax tables are frozen on posting. When you unpost an
> invoice with tax-table associations it asks you whether you want to keep
> the taxes or "unfreeze" them (I forget the terminology). I.e., if you
> unposted that 2018 invoice and told it to unfreeze, then it would change
> those taxes from 2% to 3% and the values would change when you re-posted
> the invoice. Sometimes this may be what you want (e.g. to correct an
> error in the tax table), but sometimes it may NOT be what you want (e.g.
> to correct a typing error).
>
> The "parent" is a pointer from the frozen tax table to the non-frozen one.
> So when the 2018 invoice is posted, it freezes and when you change it in
> 2019 you get a parent/child relationship between them.
>
> Hope this helps!
More information about the gnucash-user
mailing list