SQL-Ledger Homepage

SQL-Ledger User Forum

Forum index page

Log in | Register

Back to the board
Thread view  Mix view  Order
venky4025(R)

16.04.2018, 18:07
 

GST Tax does not show correctly in Invoice (General)

I am using Kit assembly for spare parts in the sales invoice and it seems to work well as it pulls all the parts automatically in the invoice. But when I print the Invoice (pdf/html) it shows/calculates wrong amount for GST.

The GST shows up correctly on the AR Sales invoice on the web page

Subtotal 168,480.00
GST 8,424.00
Total 176,904.00

But when I print the invoice, it does not include the Kit amount (actually it only includes $5 from the kit and does not add GST to rest of the kit value. Please see below:

Subtotal 168,480.00
GST on 162,995.00 8,149.75
Balance Due 176,629.75

I have checked all the parts in kit assmebly have both GST and PST checked.

Value of rest of items : 162,990.00
Value of kit: 5,490.00
So GST should have calculated on total of 168,480 and not 162,995.00.

I am not sure why it adds $5 to the base amount either.

Dieter Simader(R)

16.04.2018, 18:37

@ venky4025

GST Tax does not show correctly in Invoice

Tax is calculated on the individual items, not on the total for the kit.

I just checked into this and it works out ok.

Which version are you using?

venky4025(R)

16.04.2018, 19:12

@ Dieter Simader

GST Tax does not show correctly in Invoice

Tax is calculated on the individual items, not on the total for the kit.

I just checked into this and it works out ok.

Which version are you using?

We are using version 3.2.6

The individual parts have cost assigned but no sales price. I just added the total value of the kit.

Dieter Simader(R)

16.04.2018, 19:20

@ venky4025

GST Tax does not show correctly in Invoice

The cost for the individual items is only for calculating input tax credits.
you must also have a selling price for the individual items.
The selling price for the whole kit can be different but the tax is always calculated on the individual selling price for the items.

venky4025(R)

16.04.2018, 19:42

@ Dieter Simader

GST Tax does not show correctly in Invoice

I tried adding sell price for some of the individual items But, it did not seem to make any difference to the taxbase nor GST. The funny thing is that the it takes a value of $5 for the parts for some reason.

I tried something different this time. I change the value of kits from
$5,490.00 to $10,490.00 to see if makes a difference. I suspect that there could be an issue with the decimal places when calculating from kit value.

The GST changed from:
GST on 162,995.00 8,149.75
to:
GST on 163,000.00 8,150.00
So it seems to be dividing the value of kit by 1000 for some reason.
When I change value of kit to $13,490.00
GST changes to:
GST on 163,003.00 8,150.15

venky4025(R)

16.04.2018, 20:36

@ Dieter Simader

GST Tax does not show correctly in Invoice

I tried adding sell price for some of the individual items But, it did not seem to make any difference to the taxbase nor GST. The funny thing is that the it takes a value of $5 for the parts for some reason.

I tried something different this time. I change the value of kits from
$5,490.00 to $10,490.00 to see if makes a difference. I suspect that there could be an issue with the decimal places when calculating from kit value.

The GST changed from:
GST on 162,995.00 8,149.75
to:
GST on 163,000.00 8,150.00
So it seems to be dividing the value of kit by 1000 for some reason.
When I change value of kit to $13,490.00
GST changes to:
GST on 163,003.00 8,150.15

Dieter Simader(R)

16.04.2018, 21:32

@ venky4025

GST Tax does not show correctly in Invoice

It is a formatting issue when figuring out the ratio for the discount.

Edit IS.pm and change line 344 to

$r = $sellprice/$p{0};

venky4025(R)

16.04.2018, 23:52

@ Dieter Simader

GST Tax does not show correctly in Invoice

Thank you. That worked!!

Back to the board
Thread view  Mix view  Order
1024 Postings in 338 Threads, 367 registered users, 147 users online (0 registered, 147 guests)
SQL-Ledger User Forum | Admin contact
RSS-Feed
powered by my little forum