cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

This message was moderated.

former_member184065
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Pradeep,

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

Warm Regards

Aadesh Kamat

Former Member
0 Kudos

Hi Adesh,

The sales order is completely billed.

Regards!

Pradeep

moazzam_ali
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi,

FSCM stands for Financial Supply Chain Maangement, this is a product extension of SAP credit management with some additional functionalities. You activate the solution thrrough SAP Switch Framework Business Functions.

A standard routine for base calculation type is assigned in the pricing procedure for the Freight Conditions. The routine number is 2, which means that the base for the calculation is the net value.

Our FICO guys say that there is no financial impact as the outbound invoice was already booked with freightr value 87.40 EUR, but still we would like to know the reason for this problem and if possible a solution so that this does not happen again.

Thanks

moazzam_ali
Active Contributor
0 Kudos

Dear

Everything seems ok to me. After delivery and billing this change will not transfer in FI. Still if you need to investigate in this issue then I would suggest you to raise OSS note as there is no other check point in my mind.

Thank$