Cancelled Invoic not released to FI

[Former Member]

Hi Friends,

I have an invoice with 2 line items which is released to FI. Now I want to cancel this invoice.

But unknowingly while cancelling this invoice with VF11, I have selected only 1st line item (with selection list) and created cancelled invoice. Now this cancelled invoice has not generated a reverse accounting document automatically. I tried to release this cancelled invoice to FI, where I got a message that there is inconsistent in amounts. I hope this is checking with original invoice a/c document where it has full value.

Now how to resolve this issue.

I need to cancel the full original invoice. Kindly help.

Ratna

[Former Member]

Hi,

Thank you guys for cooperating me. I have resolved the issue. Here it goes. It may help to some one.

In standard SAP we can cancel partial of the original invoice and it can be released to accounts normally. There will be no error. When you cancel the full invoice the posting key will be 12 and when you cancel partially it will trigger posting key as 11 and in this case it will touch the user exit EXIT_SAPLV60B_008 where we have written a code that if accounting line item having a payment term starting with A (advance), then posting key should be replaced with 09 and special GL indicator should be replaced with A. (FI department needs to hit the advance value of normal invoice directly to separate GL). So this is affecting for cancel invoice also like 09 and A, where it is not correct in FI module for negative values. In this case it should be 19 and A, which I changed in the code now based on the billing document category. So finally I have released both the partially cancelled invoices with 19 and A for the line item having payment terms starting with A and other line item with 11 and blank having payment term starting with other than A.

Hope this helps someone.

Ratna

[former_member558460]

Hi,

Its really helpful thanks for it. Will you please also share how you did R and D for it. How it strike to your mind to check  exit EXIT_SAPLV60B_008, it will be more helpful for us.

Thanks

Asim

[Former Member]

Hi Experts,

Can anyone help me out on this please.

Ratna

[Lakshmipathi]

As I already said, since the issue you are facing is a weird one, you have to raise a OSS note.

G. Lakshmipathi

[gomatheeswaran_palaniappa]

Hi Ratna,

I think there is a way in FI.  Check with your FI consultants whether they can reverse the resp G/Ls manually in FI.  Please have this as a final option if nothing works out.  I think they will key in equal reverse amount manually and post it to the resp G/L with the invoice number as reference.  Before that the G/L settings should allow manual postings. To change that setting, it may require very high level approval from finance users.  Also, its better to do this during non office hours as you have to revert it to original setting once done.

Regards,

P Gomatheeswaran.

[former_member184701]

dear, you would try to cancel the second item as well.

as soon your amounts are consistent you will be able to post them in FI.

regards,

[Former Member]

Hi PPIO,

   Thanks for your reply. I did that. Now there are two separate cancelled invoices which are not released to accounts. Now when I tried to release 1st cancelled invoice to FI   I am getting the same inconsistent amount and even when I tried to release the 2nd cancelled invoice also, I am getting the same error.

Kindly help.

Ratna

[former_member184701]

dear, just another idea...

can you please try to cancel these two invoices (which are not released to FI) ?

if you're able, please cancel them and return to your previous document trying to cancel both items at once.

regards,

[Lakshmipathi]

where I got a message that there is inconsistent in amounts

What was the message number ?

G. Lakshmipathi

[Former Member]

Hi,

These two are cancelled invoices generated with S1 billing type. But for this S1 billing type there is no cancelling billing type assigned in VOFA. So I am not able to cancel this cancelled invoices.

Ratna

[Former Member]

Hi Laksmipathi,

Message number is F5704. " Inconsistent amounts ".

Ratna

[Lakshmipathi]

Though the following notes does not explain solution for the issue what you have, I feel, to some extent, it will help you.

• Note 62005 - F5704 'Inconsistent amounts' release to accounting
• Note 146671 - F5704 when releasing cancellation document
• Note 205339 - Cancellation of already billed revenues in revenue tables
• Note 440722 - TP:F5704 for billing document with many items

G. Lakshmipathi

[Former Member]

Hi Lakshmipathi,

Thank you for your reply. I have already checked all these notes. My support package is higher than the given in these notes. So I hope these are not required for my system.

Can you guide me further.

Ratna

[Former Member]

Hi Ratna,

Are you allowed to change the configuration of the S1 billing type in your system?  If so, you could add a cancellation billing type and cancel the cancellation invoices.  I have done this in at least one of our SAP systems and it seemed to work fine.