Billing - Pricing Procedure - Accounting entries

[former_member209761]

Dear Gurus,

On the basis of business requirement, we are trying to a new pricing procedure and the content of the same are as follows.

20 PR00 (price) ERL eg:10000

50 ZDIS (DEAL) 20 - 49 ZDI :300-

70 AFTER DISCOUNT 20 - 69 9700

390 JVT1 VAT 20 - 20 MW4 1304

500 BASE VALUE 70 - 499 11004

510 INVOICE VALUE 499-509 11004

520 DIFF Rounding

I am confused on the SUBTOTALS to be put against each entry.

Also the entries i am getting in my accounting is

CASH CUSTOMER : 11004

SALES : -10000

SALES DISCOUNT : 300

VAT : -1304

But the enties i need is

CASH CUSTOMER : 9,700.00

SALES :-8695

SALES DISCOUNT : 300

VAT : -1304

I strongly believe i have to restructure the procedure and also this has to do something with SUBTOTALS.

Looking for the expert opinions /suggestions

Thanks & Regards,

Hegal K Charles

[Lakshmipathi · Accepted solution]

Check the following:-

1) In V/06, for the discount condition type ZDIS, for the field Plus/minus, X should have been assigned

2) In V/06, for VAT condition type, both for Condition Class and Condition Category, D should have been assigned

3) In your pricing procedure, for that discount statistical should not have been selected

Still if you face the same problem, please rephrase your explanation as to how your billing value should be since the pricing procedure you listed above is not clear to me.

thanks

G. Lakshmipathi

[former_member209761 · Accepted solution]

Dear Lakshmipathi ,

The settings in the procedure and condition types are as mentioned by you.

My invoice value should be 8696

My MRP is 10000

that there will be a discount of 300

hence the result is 9700

on this amount i will be calculating the VAT of 13.04 % which will be 1304 in this scenario.

The resultant value (9700-1304) is 8,396.00

15% VAT as posted in the previous thread is not relevant (hence no need to consider that)

The invoice value will be 8696

In the pricing procedure,

STEP CNTR CTYP DESCRIPTION FROM TO MAN MDT STAT P SUBTAL REQT ACTY ALTBV ACTKY

20 | 0 | ZMRP | MRP PRICE | X x 1 | ERL

50 | 0 | ZSTL | DEAL | 20 | 49 | | ZDI

70 | 0 | |AFTER DISC.| 20 | 69 | D

390| 0 | JVT1 | VAT | 70 | 70 | x E |MW4

500| 0 | |BASE VALUE| 70 | 499| X X 13 12

503| 0 | |INV VALUE | 499 |500 | X X

520| 0 | DIFF |ROUNDING | 503 |503 | 13 16 4 |RND

for ZMRP mdt is checked, print is X, SUBTOTAL is 1

AFTER DISCOUNT : SUBTOTAL IS 'D'

For JVT1 : PRINT is X, SUBTOTAL is E

BASE VALUE : MDT IS CHECKED , PRINT IS 'X' , REQT IS 13 , ALTCTYP IS 12

For invoice value , MDT is checked and print is X

This is the setting maintained in pricing procedure.

Under the above setting my accounting entries are as follows.

cash customer 11004

sales 10000-

sales disc 300

sales as VAT 1304-

BUT MY ENTRY SHOULD BE

cash customer 9700

sales 8696-

sales disc 300

sales as VAT 1304-

Hope its more clear now.

Thanks & Regards,

Hegal K Charles

Edited by: Hegal . K . Charles on Jun 8, 2011 4:10 PM

Edited by: Hegal . K . Charles on Jun 8, 2011 4:19 PM

[gomatheeswaran_palaniappa · Accepted solution]

Dear Charles,

As far as I know, VAT values will always be added the calculation and you have shown as deductions

The resultant value (9700-1304) is 8,396.00

Can you please confirm on this? If you have setting as blank in JIVT condition type, then please try maintaining -1304 in the condition record which will solve your problem.

Regards,

P Gomatheeswaran.

Edited by: Gomatheeswaran Palaniappan on Jun 8, 2011 12:57 PM

[former_member209761 · Accepted solution]

Dear Gomatheeshwaran

My VAT has to be subtracted from the MRP

ie, 1304 has to be reduced from 10000 = 8696

Currently based on the procedure explained in the previous thread,

this is how the conditions are flowing..

ZMRP MRP Price 10,000.00 INR 1 EA 10,000.00

ZSTL T1 Grp Deal 3.000- % 300.00-

After discount 9,700.00 INR 1 EA 9,700.00

JVT1 VAT 13.040 % 1,304.00

Base value 8,396.00 INR 1 EA 8,396.00

Invoice value 9,490.84 INR 1 EA 9,490.84

DIFF Rounding 0.00 INR 0.00

How to make the base value as 8696 ? ie, substrate the 1304 from 10000 and make this as the base value/ which will be the invoice value.

Thanks & Regards,

Hegal

Edited by: Hegal . K . Charles on Jun 8, 2011 5:28 PM

Edited by: Hegal . K . Charles on Jun 8, 2011 5:29 PM

Edited by: Hegal . K . Charles on Jun 8, 2011 5:29 PM

Edited by: Hegal . K . Charles on Jun 8, 2011 5:29 PM

Edited by: Hegal . K . Charles on Jun 8, 2011 5:30 PM

[gomatheeswaran_palaniappa · Accepted solution]

Dear Charles,

I got your point. Please create a VOFM routine and assign in the calc type at 500th line:

STEP CNTR CTYP DESCRIPTION FROM TO MAN MDT STAT P SUBTAL REQT ACTY ALTBV ACTKY

500| 0 | |BASE VALUE| 70 | 499| X X 13 12

The calc type logic is: KOMP-KZWI1 - XWORKE (Subtotal 1 - Subtotal E)

Please remove From and To reference as we are doing it through calc type. There is a std routine 25 available for this. Please test after assigning this in calc type. If that doesnt work, pl develop a new one with the help of ABAPer.

Regards,

P Gomatheeswaran

[Lakshmipathi · Accepted solution]

Have your pricing procedure as follows:-

100	PR00		
110	ZSTL @ 3%	      100	
120	Subtotal	      100	110
130	JIN7 @ 13.04%                  100	
140	Base Value	       120	130

thanks

G. Lakshmipathi

[former_member209761 · Accepted solution]

Dear Lakshmipathi,

Can you please tell me what all should be maintain in the SUBTOTAL coloum for each condition type?

Also i got a thread which gives the explanation of the SUBTOTAL and its use, but i would be thankful if you can

tell the relevance of different subtotals , with a an example.

Thanks in advance.

Hegal K Charles

[gomatheeswaran_palaniappa]

Hi Charles,

As per your pricing procedure, if you need 9700 as cash customer, PR00 should be 8696. In your case it might have been 10000.

PR00 8696

ZDIS 300-

JVT1 1304

Inv val 9700 (I hope this is what you refer as Cash customer)

Regards,

P Gomatheeswaran