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

Cancelled invoice number in list of billing docs VF05N

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Posted on Dec 05, 2015 at 11:33 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2015 at 04:25 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • 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 😊

  • Posted on Dec 04, 2015 at 10:58 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 05, 2015 at 06:20 AM

    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 😊

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2015 at 04:07 PM


    Untitled.png (172.5 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 07, 2015 at 01:22 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

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.