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

MIRO Cancellation Posting

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 22, 2013 at 11:24 AM

    Raise this problem to SAP.

    thanks

    SKKS

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 23, 2013 at 07:25 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 26, 2013 at 06:28 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

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.