List of Cancelled Invoices

[saif_urrehman]

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

[former_member209761 · Accepted solution]

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