Skip to Content

Pricing Procedure calculating discounting incorrectly

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

pastedImage_1.png (51.3 kB)
pastedImage_2.png (55.4 kB)
pastedImage_6.png (69.5 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Aug 30, 2013 at 12:46 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • author's profile photo Former Member
    Former Member
    Posted on Aug 30, 2013 at 11:45 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 30, 2013 at 12:05 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.