Tax Calculation on freight for India

[Former Member]

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

[Prasoon]

Hi,

   Refer the doc:

Regards,

AKPT

[former_member221362]

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.

Please follow the below steps

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