6 Replies Latest reply: Nov 15, 2012 9:15 AM by Saif ur Rehman RSS

List of Cancelled Invoices

Saif ur Rehman
Currently Being Moderated

Hi SD experts,

 

I need to extract all invoices cancelled for a particular period. i am currently using VF05N and getting Billing Document number not INVOICE NUMBER. i can see invoice number by giving billing document via one of our Z report but its still missing something and confusing by not giving number for some specific material types ( as it was made for only one material type).

 

I have tried my best to search forums but unable to get a specific answer. if this question has already been answered plz guide me towards that via link.

 

Thanks

  • Re: List of Cancelled Invoices
    Hegal . K . Charles
    Currently Being Moderated

    Dear saifji,

     

    As far as i know, billing document number is same as your invoice number.

    if you want to get the list of cancelled invoices, You can use VF05 , selection criteria in the bottom as BILLING DOCUMENTS in FI

     

    or more accurate way is to use a query (SQVI) with table VBRK , give the period in ERDAT (from and to)

    and the filter the list with SFAKN = X

     

    Check and revert back.

     

    Thanks & Regards,

     

    Hegal K Charles

    • Re: List of Cancelled Invoices
      Saif ur Rehman
      Currently Being Moderated

      Dear Hegal K Charles !!

       

      Thanks for your reply. yes you are right invoice and billing document number are same. it was mistake in our Z report as Accounting Document number field was named as Billing Doc.

       

      VF05N is giving me All "Accounting Documents number" whereas i need to have all Invoice numbers. These two documents have been assigned different number ranges.

       

      in VF05 i have to give input like Material / Payer etc. whereas in VF05N i can have all documents only by giving respective date range.

       

      Looking for your reply

  • Re: List of Cancelled Invoices
    Hegal . K . Charles
    Currently Being Moderated

    Dear saifji,

     

    You can give the material or payer in VF05

    and you can give billing date in VF05N

     

    If you want to have billing date. payer, material etc as the selection criteria, it is better you go for a QUERY

    Use the Tcode SQVI

    Use option : Table Join

    Tables to be used are : VBRK and VBRP

    You can check billing date in VBRK, payer in VBRK, material in VBRP as selection

    You can then list the other relevant details needed from both VBRK and VBRP by checking the LIST.

     

    You can search the forum for 'QUERY' to understand how to develop a query.

    I think there will not be a standard report for your requirement and query is something which will solve your requirement and

    it easy.

     

    Thanks & Regards,

     

    Hegal K Charles

  • Re: List of Cancelled Invoices
    KRISHNA KUMAR
    Currently Being Moderated

    HI,

     

    Check with this VBRK table in se16,once you enter your sales org press excute then check with coloum "CANCELED" it will be mentioned with "X-CANCELED" or "BLANK".

     

    Regards,

    Krishna.

  • Re: List of Cancelled Invoices
    saju som
    Currently Being Moderated

    Hi,

     

    Option 1:

    In VF05N itself give Cancellation Doc type & Execute.

     

    Option 2:

     

    Check SE11- VBRK and field is FKSTO for Billing documents cancelled

     

     

    Regards,

     

    Saju.S

Actions