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

Version 4 V4 Question
1

Hi,

I need your kind advice.

Let say in my ticket, customer purchases 5 items, 3 items are subjected to 6% tax, and 2 items are zero-rated tax. I need to print out the Tax Summary at the bottom of my receipt.
But the tax base and tax amount of zero-rated are not printed in the receipt. Second question is how can I ensure that my tax base are always 2 decimal places, eg.7.30.

My product prices are exclude from tax, hence, my tax base has to be exclude from tax as well.

Below is my Sample Ticket:

PERNIAGAAN HENG
GST No.: 12345678 BRN No.: A12345678
░░░░░░░░░░░░░░ R e c e i p t ░░░░░░░░░░░░░
Date/Time:02/02/2015 5:03 PM
Receipt No:111
RM

1 7 UP 325ml SR - 6% 1.80
1 Beras Jati 5kg ZR - 0% 13.00
1 Beras Petani 10kg ZR - 0% 26.00
1 7UP 1.5L SR - 6% 3.50
1 100PLUS 500ML SR - 6% 2.00

Subtotal: 46.30
GST 6%: 0.44
Total: 46.74
Tendered Total: 50.00
Change Total: 3.26
GST Summary:
Tax Code Tax Base Tax Amount

SR - 6%: 7.3 0.44
ZR - 0%:

        T H A N K   Y O U

Below is my Ticket Template:

[LAYOUT]
-- General layout
<EB>
<C00>PERNIAGAAN HENG
<DB>
<C00>GST No.: 12345678  BRN No.: A12345678 

<T>Receipt
<L00>Date/Time:{TICKET DATE} {TICKET TIME}
<L00>Receipt No:{TICKET NO}

<R00>RM  
<F>-
{ORDERS}

<F>=

<J00>Subtotal:|{PLAIN TOTAL}
<J00>GST 6%:|{TAX TOTAL} 
<J00>Total:|{TICKET TOTAL}
<J00>Tendered Total:|{TENDERED TOTAL} 
<J00>Change Total:|{CHANGE TOTAL}


<C00>GST Summary:
<J00>Tax Code|Tax Base   |Tax Amount
<F>-
{TAXES}


<F>=

<C10>T H A N K   Y O U


[PAYMENTS]
<J00>{PAYMENT NAME}|{PAYMENT AMOUNT}

[ORDERS]
-- Default format for orders
<J00>{QUANTITY} {NAME}|{ORDER TAX TEMPLATE NAMES}  |{TOTAL PRICE} 
{ORDER TAGS}

[ORDERS:Gift]
-- Format for gifted orders
<J00>- {QUANTITY} {NAME}|**GIFT**
{ORDER TAGS}

[ORDERS:Void]
-- Nothing will print for void lines

[ORDER TAGS]
-- Format for order tags
<J00> * {ORDER TAG NAME} | {ORDER TAG PRICE}


[TAXES]
<J00>{TAX NAME}:|[={TOTAL TAXABLE AMOUNT}-{TAX AMOUNT}]   |{TAX AMOUNT}
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
3

Hi,

Thank you for your reply. I manage to get the decimal places and 0% tax base printed correctly now.

1 Like