Hello,
I added 10% Vat on Food items and also selected tax included on tickets. And it is showing correct on order screen. But when i use print bill it adds tax amount extra to the ticket total. And why is happening that. Included vat shouldn’t add extra on ticket total. I want the tax amount to be included in ticket total. I am sharing screenshots.
Can you share your printer template with us?
[LAYOUT]
– General layout
####
###
#####
PH-##,TNT-##
-
Vat Reg:##
MUSAK-##
Guest Bill
Number of guests:{TICKET TAG:Guest Count}
Date:{TICKET DATE}|Time:{TIME}
{ENTITIES}
Ticket No:{TICKET NO}
-
Qty Item Name |Price| P.Total
-
{ORDERS}
=
Total:|{PLAIN TOTAL}
Total Payment:|{PAYMENT TOTAL}
=
Gross:|{TICKET TOTAL}
{DISCOUNTS}
{TAXES}
{SERVICES}
Payments:
{PAYMENTS}
-TOTAL PAYMENT:|{TENDERED TOTAL}
-RETURNED AMOUNT:|{CHANGE TOTAL}
=
[DISCOUNTS]
{CALCULATION NAME} {CALCULATION AMOUNT}:|{CALCULATION TOTAL}
[TAXES]
{TAX NAME}:|{TAX AMOUNT}
[SERVICES]
{CALCULATION NAME} {CALCULATION AMOUNT}:|{CALCULATION TOTAL}
[PAYMENTS]
-{PAYMENT NAME}:|{PAYMENT AMOUNT}
[ORDERS:Void]
VOID ORDER!
– Nothing will print for void lines
[ORDERS:Gift]
– Format for gifted orders
-{QUANTITY} {NAME}|GIFT
[ORDERS]
– Default format for orders
-{QUANTITY} {NAME}|{PRICE}| {TOTAL AMOUNT}
[ORDER TAGS]
– Format for order tags
* {ORDER TAG NAME} | {ORDER TAG PRICE}
[ENTITIES:Table]
– Table entity format
Table: {ENTITY NAME}
[ENTITIES:Customers]
– Customer entity format
Customer: {ENTITY NAME} | {ENTITY DATA:Phone}
[ENTITIES:Waiter]
– Customer entity format
Waiter:{ENTITY NAME}
[ENTITIES:Adminstrator]
– Customer entity format
Guest Of:{ENTITY NAME}
Here is the printer template
Could you please repost but enclose the template text in the code tags using the </> button in the editor. Without it the formatting is stripped.
[LAYOUT]
-- General layout
<BMP>
<C11>####
<C00>###
<C00>#####
<C00>PH-##,TNT-##
<F>-
<J00>Vat Reg:##
<J00>MUSAK-##
<T>Guest Bill
<J00>Number of guests:{TICKET TAG:Guest Count}
<J00>Date:{TICKET DATE}|Time:{TIME}
{ENTITIES}
<L00>Ticket No:{TICKET NO}
<F>-
<J00>Qty Item Name |Price| P.Total
<F>-
{ORDERS}
<F>=
<EB>
<J00>Total:|{PLAIN TOTAL}
<J00>Total Payment:|{PAYMENT TOTAL}
<F>=
<J01>Gross:|{TICKET TOTAL}
{DISCOUNTS}
{TAXES}
{SERVICES}
Payments:
{PAYMENTS}
<J00>-TOTAL PAYMENT:|{TENDERED TOTAL}
<J00>-RETURNED AMOUNT:|{CHANGE TOTAL}
<DB>
<F>=
<C00>
<C00>
[DISCOUNTS]
<J00>{CALCULATION NAME} {CALCULATION AMOUNT}:|{CALCULATION TOTAL}
[TAXES]
<J00>{TAX NAME}:|{TAX AMOUNT}
[SERVICES]
<J00>{CALCULATION NAME} {CALCULATION AMOUNT}:|{CALCULATION TOTAL}
[PAYMENTS]
<J00>-{PAYMENT NAME}:|{PAYMENT AMOUNT}
[ORDERS:Void]
<J00>VOID ORDER!
-- Nothing will print for void lines
[ORDERS:Gift]
-- Format for gifted orders
<J00>-{QUANTITY} {NAME}|**GIFT**
[ORDERS]
-- Default format for orders
<J00>-{QUANTITY} {NAME}|{PRICE}| {TOTAL AMOUNT}
[ORDER TAGS]
-- Format for order tags
<J00> * {ORDER TAG NAME} | {ORDER TAG PRICE}
[ENTITIES:Table]
-- Table entity format
<L00>Table: {ENTITY NAME}
[ENTITIES:Customers]
-- Customer entity format
<J00>Customer: {ENTITY NAME} | {ENTITY DATA:Phone}
[ENTITIES:Waiter]
-- Customer entity format
<J00>Waiter:{ENTITY NAME}
[ENTITIES:Adminstrator]
-- Customer entity format
<J00>Guest Of:{ENTITY NAME}
Using your template with the following ticket that has 15% tax included in call items:
Tax conifg:
Ticket config:
So your template seems correct.
Could you show us how you are adding VAT? Is it with a tax template, or are you using calculations?
Yes, adding with the tax template.
Well, shoot. To be cliché, it works on my machine.
But looking at your screenhshots, the management screen looks different. What version are you using? Maybe I can try with the version you’re using and see what the results are.
I am using SambaPOS4
This was fixed with v5 update.
There’s been so many improvement in just the short time I’ve been using SambaPOS, I can’t imagine the leaps and bounds made from V4 to V5 current.
Grab a V5 license - it’ll be the best 250 bucks you spend all year - unless you’re going to Tijuana, but that’s a discussion for a different time.
Hello Jesse, I am using the same database with sambapos v5. I updated the database following this method. On print preview the calculation is correct and that’s what I want. But when I print the ticket that shows wrong calculations for the same ticket. Can you please tell me what am I doing wrong?
Hello @shihab_abid,
Seems like Always Exclude Tax field in your Print Bill Print Job is selected, if you deselect it, the issue will be resolved.
Main Menu > Manage > Printing > Print Jobs > Print Bill > Always Exclude Tax > This should not be selected.
You can check below image as reference.
