Skip to Content
author's profile photo Former Member
Former Member

Sales Order Net Price is changed when invoice verification is posted via MIRO!!!

Hello All,

I am facing a very strange problem. I created a sales order with 4 items. It was a customer individual requirement so a purchase requisiton and hence a purchase order was linked to the sales order.

In the sales order we added a manual conditon for Freight percent at header level. The calculation base value for this condition type was Net Price in the pricing procedure. All the 4 items got certian value of the Freight as set at the header level. For the third item the net value was 1507.00 EUR before Freight, the Freight percent at header level was 5,8%. 5,8% of 1507 = 87.41, but the Freight value was 87.40.

Calculation of Freigt Value for third item:

The net value of the document at header level without Freight was 3130,40 EUR, Freight at header level was 5,8% of net value at header = 181,56 EUR.

This Freight value was then evaluated for the third item as (181.56/3130.4)*1507(i.e. net value of item w/o Freight)= 87.40 EUR.

The formula being:

Freight Value for item = (Net Freight Value at header / Net Value of header without Freight) * Net Value of the item

The actual problem:

Now, the outbound delivery and customer invoice was created with the same value i.e. Freight with 87.40 EUR only.

After some day the Invoice Verification of the linked purchase order was done and for this third item in the sales order freight value changed from 87.40 EUR to 87.41 EUR, thereby changing the net order value by 0.01 cents.. The customer invoice remains unchanged.

When I see the environment changes of the third item, it gives me 3 changes:

1) Item Credit Price Changed:

Field changed: VBAP-CMPRE

T-CODE = MIRO

OLD Value = 1897,33 EUR

NEW Value: 1897,34 EUR

2) Item credit price changed

Field Changed: VBAP-CMPRE_FLT

T-Code = MIRO

OLD Value = 18973299999999999E+03

NEW Value = 18973399999999999E+03

3) Net price changed

Field Changed: VBAP-NETWR

T-Code = MIRO

OLD Value = 1594,40 EUR

NEW Value = 1594,41 EUR

When you see the condition details of the item, only Freight Conditon changed from 87.40 EUR to 87.41 EUR.

Please note also, that we have FSCM activated for handling Credit Managment for customer.

Why the sales order got changed when creating the invoice verification document?

What resulted in the change of Freight Condition?

Thanks in Advance for help.

Regards!

Pradeep

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Mar 29, 2013 at 06:49 PM

    Dear

    Please share what is fscm and also check if you have assigned any routine to freight condition or not.

    When delivery and invoice is createD then what impacts of this change is there in financials?

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 01, 2013 at 11:31 AM

    Hi Pradeep,

    I have one question, is the sales order completely billed or partially billed.

    Warm Regards

    Aadesh Kamat

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 02, 2013 at 06:48 PM

    Dear,

    If you dont mind ,Can you check ,what is the Value you maintained in the Field of Calculation Type in that Condition Type ? and also check what routines you maintained in V/08 for that Condition Type .

    If you have any doubts please let me know .

    Thanks,

    Naren

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 10, 2015 at 11:50 AM

    This message was moderated.

    Add a comment
    10|10000 characters needed characters exceeded

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.