Accounting Document not posted for Cancelled Invoice -error in FI interface

[Former Member]

Hi,

When I create a billing document then an accounting document gets created automatically in the background and then when I cancel the billing document no accounting document gets generated and the field Posting Status in header Detail of Billing document updated as "Errors in Financials Interface.

I tried to release it for Posting via VFX3 but failed due to below error message in Log:

"Incorrect doc.no.: 4900000005. Select document number between 3000000000 and 3099999999"

I have checked the Number range assignments to the Invoice type and Accounting type.

The number range is same for both Invoice type (Y0F2) and Cancelled Invoice type (Y0S1).

The Accounting document type (RV) is also same for both the cases. But it is working fine for Y0F2 (Acounting document generated and cleared automatically). But not working fine for Cancelled Invoice (Y0S1).

Can anybody please help me find out a solution to the issue.

Thanks, Ram.

[former_member202678]

Hi,

The error message F5151 refers to the number range of the FI document.

Please have a look at the note 1259505: FAQ: New cancellation procedure in SD, which covers this issue in detail.

Question 5:

***********************************

Q5. What is the FI document type, generated by the cancellation ?

In the old cancellation procedure, the FI document type is always

determined in SD, and passed to FI (the same when a normal invoice -

not a cancellation - is transferred to accounting).

In transaction VOFA there is the field 'Document type' (TVFK-BLART).

If this field is filled, then the FI document will have the document

type maintained here.

If TVFK-BLART is empty, then the FI document will get the default

document type 'RV'.

If the new cancellation procedure is performed, the FI document type is

always determined in FI, based on the document type of the FI document

to be reversed.

In transaction OBA7 the FI document type has assigned the field 'Reverse

document type' (T003-STBLA).

If it is filled, then the FI cancellation document will get the document

type maintained here.

If T003-STBLA is empty, then the FI document cancellation will get the

same document type as the cancelled FI document.

Notice that an unexpected FI document type can cause the error message

F5 151.

Example:

F2 invoice 90000001 was released, creating an accounting document with

document type 'RV'.

This F2 invoice is reversed by the S1 billing document 70000001.

In customizing of SD there is:

Billing Type Document Type

F2 RV

S1

In customizing of FI there is:

Document Type Number range Reverse Document Type

RV 00 AB

AB 01 AB

The FI number ranges (object RF_BELEG) are:

No From number To number Ext

00 0090000000 0099999999 X

01 0100000000 0199999999

Different situations can occur, due to these customizing settings of the

FI document type, caused by the type of cancellation.

If the new cancellation is used:

The FI document type 'RV' has 'Reverse Document Type' = 'AB'.

Document type 'AB' has number range '01' set as internal.

So the FI document will have its own number included in

100000000-199999999.

There is no issue.

If the old cancellation is used:

The cancellation billing type S1 has no 'Document type' maintained, so

the FI document will get document type 'RV'. It has number range '00',

set as external number range.

So the FI document should get the same number of S1 billing document.

But the S1 billing document has number 70000001, not included in the

interval of number range '01'.

This will cause error F5 151.

***********************************

I hope this information helps you.

[Former Member]

I do have couple of AR invoices when reversed picked up RV doc types. I had to maintain the config to follow the new cancelling procedure. But Is there any way to cancel/reverse the RV docs that were created as part of Old cancelling procedure so it will not show as out of balance. I know its a Finance question but anyone who faced this issue - what was the solution you opted for cancelling/reversing the incorrect RV docs.

Edited by: thallamprasad on Dec 14, 2010 11:10 PM

[Former Member]

Hi,

Please double check in VOFA transaction if Y0S1 is listed as cancellation document for Y0F2. Maybe you have there still S1 which might be linked to different number range.

Best regards

Witek Prawecki