Pricing Procedure calculating discounting incorrectly

[sumanth_naidu]

Hi All,

Please check the following pricing procedure and Invoice accounting document.

The posting in FI in the Line item  2 ,  1140.00 should exclude 140  and show 1000.00  and

The posting  in FI  for line item  3,

should include the  Freight 140 + 3954.39 = 34094.00

Accounting Entry:

Can anyone suggest me the changes to achieve the above requirement.

regards,

nandu

[neeraj_lal]

nandu nanny

Looks like you directly posted customer query to forum without much analysing.....

Your requirement is not clear at all.

1. why business want to exclude 140 and this is value of which condtion type??

2.  How  you are getting this value :Freight 140 + 3954.39 = 34094.00? What logic you are looking for?

3. Where is invoice screen or details?

Its important to post clear requirement in SDN so we can understand issue. We do not know your business so put your query in such a way that a person who do not know your business can understand your requirement.

Regards

[sumanth_naidu]

Hi Neeraj,

Thanks for the suggestions and support given,

140 is Vat on Freight condition ZFWT, and 3954.39 is Vat calculated on Quantity, the business requirement is to add the Freight calculated 140 to the Total Vat calculated to MWIG(MWST) 3954.39 +140=.34094.00

Kindly check and advice.

regards,

nandu

[jpfriends079]

Hello nandu nanny

Rightly guided by Neeraj.

Information shared is to many and too less to help.

Anyways, ZFWT - Freight TAX SA. We can't make out, whether this is tax or freight condition type. B'coz of account key I have to assume. This a freight condition type. Further,

It is not clear. How you are determining value of the condition type. It should be condition record or manual entry. As it is not getting referred from any other condition type in the pricing, as "from" field & Alt Base value routine field is blank.

Now, tax.

You have 4 Tax cond type

MWI1 - This get calculated based on Routine 80-Absol.Value SalesPr. & from step 70. Plant required for calculation. Store result in Subtotal 3.  No account key for account determination.

MWI2- This get calculated based on Routine 80-Absol.Value SalesPr. & from step 199. Plant required for calculation. Store result in Subtotal 4. No account key for account determination.

MWI3- Reference step is 280. Used for export. Store result in Subtotal G.  No account key for account determination.

MWIG-Reference step is 280. Used for domestic. Store result in Subtotal G. No account key for account determination.

Please redesign your pricing procedure again. Frankly, it is totally a mess.

Cheers, JP

[eduardo_hinojosa]

Hi

You have a formula VOFM in the subtotal (VOFM 999). Please, set a break-point and debug the value for XKWERT.

Regards

Eduardo

ps. the VOFM 999 is the report RV64A999.

[sumanth_naidu]

Hi Eduardo,

Thanks for the support

can you suggest us the changes that are to be done to arrive at the solution.

Regards,

Nandu

[eduardo_hinojosa]

Hi

You tell us that condition doesn't fit with your requirements. Or debug it in this report (VOFM) setting a break point (although I can't see level 105 works in other condition) or check the values in the conditions tab in the billing document and do an analysis.

In the other hand, level 61 is ERF no MWS (is it for taxes? If yes, try to change it and check it, run VF11 and do the invoice again).

I hope this helps you

Eduardo

[kyusufzai]

Can you please add a screen shot of your billing document item pricing. I want to see the condition types .