[GAJ]

I’ve the need to capture and display the TAX RATE, which is auto applied at each line level in an invoice form, and is displayed at each line level in the invoice report from “item.taxrate1″ — I need to then display it in the report summary, concatenated against a label. Example: Total TVA 8% … $100.00.

The issue is that in the PDF/HTML template, item.taxrate1 is a class=”itemtable” while the summary section, is a class=”total”, i.e. “record.—” construct.

Do you have a suggestion on how to capture item.taxrate1 and display it as “record.taxrate1”?

Very much appreciate your look-see.
This is a cached copy. Click here to see the original post.

[carl.billings]

pcutler can you provide any insight here?

[michoel]

How do you plan to handle this if the tax rate varies on different lines?

If you just want to retrieve the tax rate of the first line item, you should be able to do something like ${record.item?first.taxrate1}.

[pcutler]

Originally posted by GAJ

View Post

I’ve the need to capture and display the TAX RATE, which is auto applied at each line level in an invoice form, and is displayed at each line level in the invoice report from “item.taxrate1″ — I need to then display it in the report summary, concatenated against a label. Example: Total TVA 8% … $100.00.

The issue is that in the PDF/HTML template, item.taxrate1 is a class=”itemtable” while the summary section, is a class=”total”, i.e. “record.—” construct.

Do you have a suggestion on how to capture item.taxrate1 and display it as “record.taxrate1”?

Very much appreciate your look-see.

The tax rate on the first line would be ${record.item[0].taxrate1}.

To concatenate a string with the tax rates across all lines you could use Freemarker’s list functionality:

Total TVA for ${row.name} = ${row.taxrate1}

For a more complicated operation like averaging the tax rates across all lines, you can use Freemarker’s function syntax:

http://freemarker.org/docs/ref_directive_function.html

And if you’re looking for more advanced tax functionality within NetSuite with support for over 140 countries worldwide, please reach out to us for a demo at IndirectTax.Cloud@ThomsonReuters.com – our tax engine is trusted by the world’s top companies and has a new integration available specifically for NetSuite.

[Author]

Posts