cancel
Showing results for 
Search instead for 
Did you mean: 

Problem in sales tax

Former Member
0 Kudos

Dear All,

We are facing one tax problem in the sales order.

We would like to do the VAT tax include in the Sales unit price.

1)Created condition type "MWSD"

condition class: D(Taxex)

calculation type: H (Percentage included)

condition category:D(Tax)

2) In sales order:

Unit price 1000 USD(include 17% VAT)

That means :

Net unit price :854.70 USD

VAT tax : 145.30 USD

3) But in the accounting document, it show like below:

*******************************************************************************************

Itm PK Account Account short text Assignment Tx Amount

1 01 10642 Mission Hills(China) N1 854.70

2 50 800000 Sales Revenue 20100729 N1 1000.00-

3 40 155090 PRC VAT N1 145.30

*******************************************************************************************

4) We want the accounting document like this:

*******************************************************************************************

Itm PK Account Account short text Assignment Tx Amount

1 01 10642 Mission Hills(China) N1 1000.00-

2 50 800000 Sales Revenue 20100729 N1 854.70

3 40 155090 PRC VAT N1 145.30

*********************************************************************************************

So is it possible to show like above if we make the price is include in unit price?

Thanks

Paul

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Paul,

Check your pricing procedure,Hope you assigned accounts key (for revenue) against a condition which is inclusive of VAT.

Assign the key against condition type which shows net price after tax.

Revert.

Regards

Sanjay

Former Member
0 Kudos

Hi Sanjay,

Yes, we have set the price procedure like below:

*******************************************************************************************************

Step counter Ctyp Desc. Print SuTot Reqt Caltype BasType Acckey

11 0 PR00 Price X A 2 ERL

18 0 Total ERL

220 0 MWSD Tax X 10 80 16 MWD

225 0 Total

********************************************************************************************************

REL - Revenue

MWD - Domestic Tax

But it is still not work.

Could you please give us some suggests?

Tks

Paul

Former Member
0 Kudos

Help,help

Former Member
0 Kudos

Resolved the problem. Tks

Answers (1)

Answers (1)

Former Member
0 Kudos

Dear All,

Is there any people can give us a hand here?

It is very hard...

Tks

Paul