How can I print out Tax Base for Zero-Rated Products in TAXES?

Version 4 V4 Question
2

The reason your 0% items are showing no value is because the [ ... ] brackets by design does not print anything within it if any of the values contained therein are empty.

Try changing this:

<J00>{TAX NAME}:|[={TOTAL TAXABLE AMOUNT}-{TAX AMOUNT}]   |{TAX AMOUNT}

To this:

<J00>{TAX NAME}:|[=F(TN('{TOTAL TAXABLE AMOUNT}')-TN('{TAX AMOUNT}'),'0.00')]   |F(TN('{TAX AMOUNT}'),'0.00')

The TN() function ensures the value is a Number (not a blank). The F() function is for formatting output.

If that doesn’t work either, continue to adjust it until you get the desired output.

See here for more formatting options and functions:

1 Like