PIT - Excise and VAT included

tthyagu

Hi

I have some issues in the PIT computation. I give two scenarios as under.

Case 1 PIT is Base price + Excise

The PIT Price is 116480
Then if I choose the PIT structure for excise then the system is giving the Base price as 100000 and excise duty is 16480

This is correct

Case 2 PIT is Base price + Excise + VAT

The PIT price is 121139.2
Then I choose the PIT structure with VAT and Excise duty.


The Base price should come as 100000
But it is giving the base prices as 104545.20

How to set right this?

Any suggestions please?

Thank u.

Regards
T.Thiyagarajan

ssingla

PIT Price

What is PIT.
Anyhow seems to be price inclusive of tax. Navision standard works on basic price and then do the forward calculation and calculates the taxes on it. Are u using customized version or LS retail or other retail solution :?:
In the case of backward calculation see whether you have selected the base formula correctly.

tthyagu

This is Navision India version with Hotfix 6.0

The Price inclusive of Tax (MRP) concept is given here.

Regards
T.Thiyagarajan

darshanm

Hi,

I did below setup in my cronus NAV4.0 DB(HF 6.0)

On Item card

Price Incl of Tax = Yes
PIT Stru = EXC + VAT
In both the Struct lines PIT is selected
VAT is calculated as Sales tax functionality

Unit Price = 121,139.20
BED=16%, eCess= 2%, SHE=1%

VAT = 4%

In Sales Inv, I didnt select any Structure in header

Item Qty - 1 Nos

after calulating Structure system gives me

Price Exlv VAT = 100000
Excise amount = 16,480.00
TAX amount = 4,659.20

tthyagu

Thanks Dhrasan for your reply.

I did the same (Structure Excise & sales Tax) in my database.

I am getting a base value of 10399.92

And no VAT is computed.

I am missing some setup.

Can u pls tell me where I am going wrong?

Regards
T.Thiyagarajan

ssingla

I am assuming that you are using Sales tax setup for VAT.

Check the Purchase/Sale line the relevant VAT parameters are coming i.e. Tax Group code, Tax Liable, Tax % etc. If anything is missing then check for the same.

darshanm

Hi tthyagu,

Mr. Sandeep is right. Please check your sales tax related setup.
If tax area code is not coming in sales line, then check the setup.

tthyagu

I am using the Tax setup for calculating VAT.

I am getting the Tax Area Code, Tax Group code, PIT Structure etc in the Sales Line.

After running the function of Calculate Structure values I get the following values for the PIT of Rs 12114

In the Sales Line the Unit Price excluding VAT shows Rs 9986.00

Where as the Statistics window shows the following values
Amount excluding VAT 10003
Excise Amount 1646
Tax amount 465
Net Total 12114

What is the issue?

There is one field called Amount to Customer UPIT which shows a value of Rs 12097. This comes when we calculate from 9986 forward.

Can some body point out the issue here?

Thanks & Regards
T.Thiyagarajan