Former Member

# Tax Calculation on freight for India

Hi ,

When I am posting the customer invoice with freight charges the system is taking wrong tax base amount.Please find following scenarios for clear understand:

Scenario I:

At Item level my product cost is Rs1000 ,Tax code is 534(Dom.Sales-Goods(CST)) and I am giving frieght charges at Pricing Rs500.

System Calculation:

Total Item Net Value- Rs1000

Freight - Rs 500

Total Invoice Value - Rs1500

CST 2% on Rs.1500 i.e - Rs 30

Total invoice value with Tax - Rs1530

Actual Calculation should be:

Total Item Net Value- Rs1000

Freight - Rs 500

Total Invoice Value - Rs1500

CST 2% on Rs.1000 i.e - Rs 20

Total invoice value with Tax - Rs1520

Scenario II:

At Item level my product cost is Rs1000 ,Tax code is 537(Dom.Sales of Goods(Excise and VAT)) and I am giving frieght charges at Pricing Rs500.

System Calculation:

Total Item Net Value- Rs1000

Freight - Rs 500

Total Invoice Value - Rs1500

BED 12.36% on Rs.1500 i.e- Rs 185.40

VAT 14.5% on Rs.1685.40 i.e Rs 244.38

Total invoice value with Tax- Rs 1929.78

Actual Calculation should be:

Total Item Net Value- Rs1000

Freight - Rs 500

Total Invoice Value - Rs1500

BED 12.36% on Rs.1000 i.e- Rs 123.60

VAT 14.5% on Rs.1623.60 i.e Rs 235.42 (1000+500+123.60=1623.60)

Total invoice value with Tax- Rs 1859.02

Scenario III:

At Item level my product cost is Rs1000 ,Tax code is 538(Dom.Sales of Goods(Excise and CST)) and I am giving frieght charges at Pricing Rs500.

System Calculation:

Total Item Net Value- Rs1000

Freight - Rs 500

Total Invoice Value - Rs1500

BED 12.36% on Rs.1500 i.e- Rs 185.40

CST 2 % on Rs.1685.40 i.e Rs 33.70

Total invoice value with Tax- Rs 1719.11

Actual Calculation should be:

Total Item Net Value- Rs1000

Freight - Rs 500

Total Invoice Value - Rs1500

BED 12.36% on Rs.1000 i.e- Rs 123.60

CST 2% on Rs.1123.60 i.e Rs 22.47 (1000+123.60=1123.60)

Total invoice value with Tax- Rs 1646.07

Kindly provide solution . Thanks in advance.

Regards,

Srikanth

10|10000 characters needed characters exceeded

• Mar 21, 2014 at 11:16 AM

Dear Srikanth,

This price component covers the freight amount determined automatically or entered manually. Depending on the business configuration settings it is possible to determine a fixed freight amount or to make the freight dependent on the net weight of the goods you sell.

you do not want 'Freight' as 'Price Component' to be consider ,you need to maintain the relevant scoping question.

1.Go to the Business Configuration work center.

2.Go to Implementation Project view ->Edit Project Scope.

3.Go to section: "4 Question".

4.Scoping Element:'General Business Data'->'Product and Service Pricing'->'Sales Price Specifications'.

5.Under Question related to 'Frieght' ,you need to uncheck the option for not considering the 'Freight' component in the Price Calculation.

6.next and complete the scoping.

hope this helps you.

Regards,

Suresh