Condition type for discounted material

[Former Member]

Hi,

Our scenario is like this:

Material A is to be sold with 10.00 discount. Regular selling price is PHP25.00

I added condition type K004 to our exisiting PR01 condition type.

in V/08, this is how much condition type are arranged

ZMVP

PR01

K004

Net Value Item

Total

ZEWT

MWSI

NETW

Computation of output tax should be net of the 10.00 discount.

Following the conditions below, this is how the transaction is recorded

A/R-Customer 15.00

Sales Disct 10.00

Output tax 2.68

Sales SD 22.32

What will i do to make the transaction record as this?

A/R-Customer 15.00

Sales Disct 8.92

Output tax 1.61

Sales SD 22.31

Computation of output tax should already be net of the discount.

Thank you.

Rachelle

[Former Member]

ZMVP

PR01 = 15.00

K004 = 10% on PR01 ie = 1.50

Net Value Item . Should be equal to 15.00 - 1.50 = 13.50

ZEWT

MWSI = 2.68

NETW

So in your pricing procedure make the entries like this

ZMVP

PR01

Detremine the price. Type PRICE in description and post to subtotal 2.

Then key in Discount conditions, say K004

Net Value use Calculation type 2

Tax Use Requirement 10 and Cond base value 16

Total Calculation type 4.

This should fix your problem. If no, please explain in detail your problem with the value against each relevant condition type in your sales order.

Thanks

Sai

[Former Member]

Hi Rachelle

Your requirement is not clear in your above statements, please provide the data wrt (fill the values for each)

ZMVP

PR01

K004

Net Value Item

Total

ZEWT

MWSI

NETW

and your expected as well.

[Former Member]

Hi,

This is our requirement

Selling price 25.00

Discount 10.00

Output tax should be - 1.60 (output tax computation is net of discount)

A/R to customer 15.00

This is our existing condition

ZMVP - Statistical is flagged. Subtotal - B, Reqt - 4

PR01 - Required and Statistical are both flagged. Reqt - 2

K004 - AcctK - ERS

Net Value for Item

Total - Print - X, SubTotal - 1

ZEWT - Caltype - 2

MWSI - From 400, Required is Flagged, Print - S, Reqt - 10, AcctK - MX3

NETW - Cal Type - 25, AcctK ERL

With the set-up of conditions above, output is

A/R-Customer - 15.00

Discount - 10.00

Output tax - 2.67

Sales - 22.32

Thank you,

[Former Member]

Hi,

Check the result you are asking for yr Dr & Cr total does not match pls rewrite the entries.

Regards

Sanjay

[Former Member]

correction of entry:

Computation of output tax should be net of the 10.00 discount.

Following the conditions below, this is how the transaction is recorded

A/R-Customer 15.00

Sales Disct 10.00

Output tax 2.68

Sales SD 22.32

What will i do to make the transaction record as this?

A/R-Customer 15.00

Sales Disct 8.92

Output tax 1.61

Sales SD 22.31

Computation of output tax should already be net of the discount.

[Former Member]

correction of entry:

Computation of output tax should be net of the 10.00 discount.

Following the conditions below, this is how the transaction is recorded

DR A/R-Customer 15.00

Sales Disct 10.00

Credit Output tax 2.68

Sales SD 22.32

What will i do to make the transaction record as this?

DR A/R-Customer 15.00

Sales Disct 8.92

Credit Output tax 1.61

Sales SD 22.31

Computation of output tax should already be net of the discount.