MIRO Cancellation Posting

[Former Member]

Hi Expert,

We have created one import PO and subsequently made two  invoice verification for the delivery cost and again the same has been cancelled. The details are given below with quantity and value in company code currency and foreign currency. Upon cancelling the Invoice, system giving an unexpected figures in the price difference account

Account Entry - At the time of first MIRO 

Quantity  -     Amount

3,000.000  -   39,434.00 Posted in  USD

1,300.000   -  2,468.00   Posted in KES (company code currency)

Posting entry Entry                                 

Vendor Account      CR.    39,434.00-    USD(doc cur)         3,446,914.11-    KES (loc cur)

Freight Clearing Ac    DR. 39,434.00    USD (doc cur)            3,446,914.11    KES (loc cur)

Cancellation Entry

Vendor Account      Dr            39,434.00    USD (doc cur)          3,446,914.11    KES (loc cur)

Freight Clearing Ac    Cr         178,552.49-    USD                     2,406,545.66-    KES

Price Diff - RM            Cr        0.00    USD                              1  040,368.45-    KES

Price Diff - RM            Dr       139,118.49    USD                     0.00    KES

Account Entry - At the time of Second MIRO 

Vendor Account       Cr. 2,468.00-    KES

Freight Clearing Ac   Dr.  2,468.00    KES

Cancellation Entry

Vendor Account Dr           2,468.00

Freight Clearing Ac CR   1,042,836.45-

Price Diff - RM    Dr.       1,040,368.45

we have already checked the SAP note no. 46564 & 1609927 related to this issue.Now the problem is that we are unable to identify the huge amount posted to the price difference account during cancellation of invoice.

in note no. 1609927, they have provided solution that difference can be find by calculation in EKBE table but in this case PO related information cant be find in EKBE table(as good receipt is not here).

Please provide solution...

Regards

Regards

[Former Member]

Dear Paresh.

As per above can you please explanation what is date of  Goods Received booking and date of invoice may be different check both the date exchange rate due to that you are getting difference  check the (OB08)

Hope your this may resolve your issue.

thanks

Trinath Gujari

[Former Member]

Hi Trinath,

thanks for reply...

it didnt happen because of exchange rate. it is system behavior. Example you have done two Delivery Cost MIRO with different price for one PO. Now if you reverse any MIRO then system will post some amount in price difference account. Kindly read the  note no. 46564 & 1609927, you will have idea why it is happening.

we did OSS for the same ,SAP has given following formula to calculate price difference amount and it is true..

EKBZ (PO history for delivery costs).

values and the formula VWERE = MENGE/REMNG-WEMNG * (AREWR - WEWRT)

Hope You understand..

Regards

[Former Member]

its already raised..got solution..its system behavior...we have to calculate price difference amount by formula given by them..it happens when you do more than one Miro  with different price/amount for one PO..

Formula is as below..

(MENGE / (REMNG-WEMNG)) * ( AREWR - WEWRT)

Regards

[Former Member]

Hi ,

Formula details where I can get in system ...

[Former Member]

Raise this problem to SAP.

thanks

SKKS