Skip to content
Gallery
Doc 02 | How to Coda with VAT?
How to Coda with VAT?
Databases
More
Share
Explore
How to Coda with VAT?

icon picker
Part III

How to Coda with VAT - Part III
Below the tables and functions as described in my blog.
⁠

Reduction on Products, VAT incl or excl, fixed amount or Percentage



VAT Excl
⁠
⁠

Fixed Amount
⁠
⁠
⁠

⁠
100
⁠
​
⁠
10
⁠
EXAMPLE-3
Name
Amount
db vat
PriceVATIncl
Reduction
New Price
New Base Price
VAT
Fix_Perc
1
€1,000.00 - 21%
€1,000.00
1.2 - Belgium Standard VAT
€1,210.00
-€100.00
€900.00
€900.00
2
€800.00 - 12%
€800.00
1.3 - Belgium Lower VAT
€896.00
-€80.00
€720.00
€720.00
3
€500.00 - 6%
€500.00
1.4 - Belgium Reduced VAT
€530.00
-€50.00
€450.00
€450.00
4
€100.00 - 0%
€100.00
1.5 - Belgium Zero VAT
€100.00
-€10.00
€90.00
€90.00
5
€60.00 - 6%
€60.00
1.4 - Belgium Reduced VAT
€63.60
-€6.00
€54.00
€54.00
There are no rows in this table
⁠

New Price
If(thisRow.VAT,
Sum(thisRow.Amount,thisRow.Reduction),
Sum(thisRow.PriceVATIncl,thisRow.Reduction)
)
New Base Price:
If(thisRow.VAT,
Sum(thisRow.Amount,thisRow.Reduction),
Sum(thisRow.Amount,
Quotient(thisRow.Reduction, Sum(1,thisRow.[db vat].[VAT percentage]))
)
)
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.