Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
vat on items
Hi

How would i assign a vat code to a particular item

i.e. books would have 0%

Carriage wouldhave 20%

Thanks

Tina
ID
1261
Category
Customization
Author

Accounts
Date Created
3/2/2019 11:40:54 AM
Date Updated
3/2/2019 2:24:34 PM
Comments
cooper collier  3/2/2019 2:24:34 PM
HI.
If all you wish to do is assign or display the value, it is pretty easy.
Create a formula column, if you want % use a formula text.

You then use the Case formula. when I make a case formula I always format it so its easier to understand. Formula ignore spaces and line returns,

Case( [ITEM],
"books",0,
"Carriage",20
,9999

)

Each line is a combination of, "what you are comparing", "what to set the column"
the very last line, is optional and is for what to use if none of the above compares did not find anything.
The last line should not have a coma.
do not forget the ending parentheses.

Look in the formula manual.
https://www.teamdesk.net/help/13.3.aspx.

TIP, when I compare text values, I always surround them with Lower([Item]). Because the compare can be case sensitive, so I just make everything small.













Feedback
Back to Search Results