Cancelled invoice number in list of billing docs VF05N

[Former Member]

My client requirment is while doing monthly report of a particular month using T-code VF05N

in this VF05N we can filter what billing type we want. even i'm selecting F2, this F2 is also one of cancelled one only. But user couldn't able to find the cancelled invoice number, for this any enhancement is required?

how to give solution to this to find out the cancelled invoice number in that list of billing docs.

Thanks in advance.

Regards

sandy

Discussion title was edited by: Jyoti Prakash - Please precise and meaningful subject title for your discussion.

[former_member184555]

In the selection screen of VF05N, under 'Selection Criteria' check the option 'Billing Documents in FI' and execute. The cancelled invoice will be F2 Billing type and the cancellation invoice will be S1 Billing type. You will find both the documents in the list.

[Former Member]

In theexample  screen shot VF05N, highlighted one is cancelled billing. in the list User how can he able to identify? i.e 90000110 F2 is cancelled.

[former_member562353]

Dear Sandy,

As far as I know, VF05N dose not show if a billing document is cancelled along with the number of cancel invoice. It simply lists all invoices, including cancel invoices as well. You can create an InfoSet (SQ02) using a join between tables VBRK and VBFA. The foreign key in VBFA for invoice number is VBELV. The cancel invoice number will be recorded in VBELN field. Afterwards, you need to create a query (SQ01) based on the InfoSet you have created in the former step.

Feel free to request more information just in case.

Hope that helps

[Former Member]

[michael_kozlowski]

You can try with an enhancement as described below:

1. Append new field for canceled invoice in STRUCTURE ERPSLS_BILLDOC

2. Do an impilict enhancement in INCLUDE ERPSLS_BILLDOC_VIEW_DATA_SEF01 in FORM DATA_CHECK and fill new field. Information about canceled invoice you will find in table VBFA for Invoice (VBELV) look for VBELN with VBTYP_N = 'N' (indicates a canceled invoice)

Hope this will be helpful.

[former_member227920]

This message was moderated.

[michael_kozlowski]

You need ABAP Knowledge to implement suggested solution. If you are not an ABAPer please ask an ABAPer for help to append structure and do some enhancement in program.

Basically use trx SE11 for append of structure and trx SE80 for enhancement.

[former_member562353]

Hi Sandy,

In VBFA if you fill the VBELV field with the invoice number, you can find the cancel invoice number in the field VBELN. Note that the value "N" in the field VBTYP_N indicates that the subsequent document is a cancel invoice.

Hope that helps

[former_member212707]

Firstly.. "Hi" is not a subject

if you want to obtain the Cancellation invoice for an F2 you can easily do so from table VBFA by giving the F2 invoice as the input. VF05n should give you the cancellation if you include the invoice type S1 in the input. Please test.

Thanks,
Ravin