Not able to cancel a Purchase invoice using Tcode MR8M

[Former Member]

Hi friends,

when I am trying to cancel a Purchase invoice using Tcode MR8M I got the following error:

"Inconsistent amounts

Message no. F5704

Diagnosis

Item "0000000020" in the FI/CO document has the debit/credit indicator "S". Amounts in the FI/CO interface are assigned a +/- sign as follows:

Debit amounts are greater than or equal to zero

Credit amounts are less than or equal to zero

Not all the amounts in item "0000000020" meet this specification.

System Response

Data cannot be processed.

Procedure

This is a system error. It may be the case that one or more amount fields in the calling application were not filled correctly (as regards the above-mentioned specification)."

can any one help me to resolve this error. your help is greatly appreciated.

Lakshminarayana

[former_member183690]

Hi

This error usually will get when we posted to incorrect GL account , even we have face the same error

try to put the correct GL account while passing the credit memo .

[Former Member]

Hi Hidyath,

Thanks for your response. Actually here I want to cancel a MM invoice through Tcode MR8M. Since this issue is in Production system, I can not post a Credit memo.

Best Regards,

Lakshminarayana

[former_member198032]

Hi,

  The cause for the error is the inconsistent posting line item for the creditor line item.

  In subroutine CHECK_SHKZG (program SAPLFACI) the system checks the debit credit indicator of the posting line items.

  Please check the internal table ACCIT_FI (fields KOSTL, KOART and SHKZG) for your custom invoice.

  Although the creditor amount has a negative sign the debit credit indicator (SHKZG) is 'S' (DEBIT). For a negative amount the system expects 'H' (Credit) instead of 'S' (Debit).

  Because of this inconsistency the error message F5 704 'Inconsistent amounts' is issued.

  Also, normally the message F5704 appears in simulation or posting process because system tries to distribute the skonto amount to each invoice items (either reference to PO, to G/L account or to material).

Regards,

Cristiano

[milind_joshi7]

Hi Laxminarayana,

I believe you need to check the GR and IR clearing is happened or not.
This may happened because of the line item are cleared between GR and IR against the said Invoice or so.
If the clearing is correct then check under which period are you trying to reverse.

I don't feel so there is any issue from configuration cause if your other invoices are able to get reverse using the MR8M then this also should be.

Thanks !!

Milind joshi

[milind_joshi7]

Hi ,

Please check the FICO & MM Period for the reversal posting is open or not.

Thanks

[Former Member]

Hi Milind,

I checked the FICO & MM Periods and they are opened for posting.

Thanks and Regards,

Lakshminarayana

[Former Member]

Hi SAP Guys,

Can you kindly help me in solving this issue, as still I am not able to cancel the Invoice document and I am having priority to solve this issue.

BR,

Lakshminarayana

[former_member183424]

Can you please check this OSS note 880690 - F5 704 periodic posting runs (RAPERB2000, RAPOST2000)

[Former Member]

Hi Dibyendu,

I checked the SAP Note 880690,from the information provided in that note, only first point that is "

• In the general ledger, a second (and possibly a third) local currency is managed, which differs

from the company code currency in the affected company code." is relevant to my issue as we are using USD as a Document currency and SEK and CHF as 2nd and 3rd currency.

Also we are using SAP ECC 6.0 system.

BR,

Lakshminarayana

[former_member183424]

This note is valid for 600 version.

[Former Member]

Hi Dibyenddu,

let me check whether this note is applicable to my issue or not. Thanks for your help.

Thanks and Regards,

Lakshminarayana

[Former Member]

Hi Dibyendu,

Note 880690 is not applicable as we are using SAP Support package SAPKH60511 but Note is valid upto SAPKH60002 support package.

Best Regards,

Lakshminarayana

[milind_joshi7]

Hi Lakshinarayana,

Please check whether the Invoice line items clearing is processed or not ?

this might some time having an issue because of the Clearing is passed for those Invoice.

Thanks !!

Milind Joshi

[Former Member]

Hi Milind,

Thanks for your response. I have checked the document and there is no clearing happened to the invoice.

BR

Lakshminarayana

[Former Member]

Hi Guys,

Can you kindly help me in solving this issue, as still I am not able to cancel the Invoice document and this is a Production issue so I am having priority to get rid of this issue.

BR,

Lakshminarayana

[former_member388328]

Hi Lakshminarayana,

If you don't mind can you please share screen shot  the fi document screen shot from FB03 and MR8M cancellation error.

Thanking you

Vengaiah

[Former Member]

Hi Vengaiah,

Thanks for your response. Please find the screen shots as you requested

MR8M

FB03

Best Regards,

Lakshminarayana

[former_member388328]

Hi Lakshminarayana,

Are using any validations in FI in your system. Can you please check, if you have any validation on 628000 g/l.

Thanking you

Vengaiah

[Former Member]

Hi Vengaiah,

Can you kindly let me know how to check if a GL account is having validation or not.

I have checked through GGB0 and GGB1 but i didn't find anything.

Best Regards,

Lakshminarayana

[former_member198650]

Hi,

1. Have you manually posted the GL account entry at MIRO or just input the amount in unplanned posts and it posts the amount to this GL as per configuration in OBYC?

2. If you still cannot identify then you can post credit memo for the invoice.

Regards,

Mukthar

[Former Member]

Hi Mukthar,

Thanks for your response. I have not posted the GL account manually.

I am trying to cancel or reverse a GR/IR invoice.

Thanks and Regards,

Lakshminarayana

[former_member198032]

Hi,

some possible reasons as reference:

1.The changing in the tax between posting the original document and the

cancellation document would cause such an issue.

2.Normally, the cause of message F5704 in simulation or posting process

is:

In the invoice process system try to distribute the skonto amount to

each invoice invoice items (either reference to PO, to G/L acount or to

material).

The distribution's logic is:

A. at first set rest_skonto_anteil = skonto amount.

B. calculate and distribute the skonto amount for first some items (not

last item) as following:

Skonto_anteil = ( item amount + unplanned del.cost ) *

                  skonto amount / skonto basis amount (net summe of

                  item's amount).

and change  rest_skonto_anteil = rest_skonto_anteil - Skonto_anteil.

C. copy (distribute) rest_skonto_anteil to the last invoice item.

But, because of calculation rounding difference, the skonto amount

which has been copied (distributed) via step C, can be more

than the amount in this item.

In this case you can receive message F5704 in invoice simulation or

posting process.

And it is difficult to resolve the calculation rounding in the invoice

process.

Hope this was helpful for you.

Cristiano

[Former Member]

Hi Cristiano,

Thanks for your response. I have checked the Tax codes between the original document and cancellation document and both are same.

coming to your point # 2. , can you kindly elaborate this point as i am not able to understand rest_skonto_anteil

Best Regards,

Lakshminarayana

[former_member198032]

Hi,

Did you do a changing in the tax between posting the original document

and the cancellation document? This would cause such an issue. Please

change your tax settings back how it was at the time of posting the

original document. Should this not be possible please try to post a

credit memo instead. Please see also note 387909 for further information.

regards,

Cristiano

[Former Member]

Hi Cristiano,

There is no changes in the tax. It is same in the original as well as in cancellation documents. Note 387909 is applicable if any changes done in the tax, but as i said there is no changes in the tax between the documents.

BR

Lakshminarayana

[Former Member]

Please check SAP note 354499.

It may be helpful to resolve the issue.

Best Regards,

Chirag Panachal

[Former Member]

Hi Chirag,

Thanks for your response. I have checked the Note 354499. This Note is valid for prior to 4.7 release and we are using ECC 6.0 so it is not applicable.

Best Regards,

Lakshminarayana