VF11 cancel a lot of invoices

[Former Member]

I need to cancel a lot of invoices (approx 1600). What is the best way of doing this? In VF11 i can copy/paste 14 inovices, then page down, and then copy/paste 13 new. This is way to time consuming. Is there any other standard way of doing this or do I need to develop a program to be able to batch cancel all this invoices?

Kind regards

[Former Member · Accepted solution]

I suggest developing a Batch-input program based on VF11 transaction.

Because you will cancel one invoice in each transaction step, that is a very easy development IMHO.

Best Regards,

Franck

[Former Member]

Hi,

The invoices that are created via Background jobs or by collective run will be generated with Group Number.

The Group number will have the list of invoices generated. You can use Reverse all functionality.

Go to Easy access - > SD -> Billing -> Information system - > Billing documents - > Log of collective Run ( V.21)

You can give the date on which the background job was run or the invoices are created. Hit execute and you can see the Group number.

Select the Group number and click Documents. You can see the list of invoices created under the Group number.

Make sure those are the invoices that need to be cancelled in the Group number . Then click "Reverse all ".

This will cancel all the invoices created by that collective run or by Background job.

But If you want to cancel the invoices randomly then best method is upload all the invoices via BDC/LSMW technique in VF11 transaction code and process it.

If you are satisfied with this answer please let me know.

[rupkbh]

hi, i am facing a problem when cancelling more than 14 invoices through bdc recording.

Normally , in vf11 , after entering 14 invoice numbers , i press enter and then click on the scroll bar , to get the further input fields.

Now , while recording these steps through BDC, the pressing of the scroll bar to get further input fields is not captured. The BDC OK code which is captured is /00 , which is basically for enter is not working.

Now can I insert more than 14 invoices through BDC recording.

[Former Member]

In VF11 itself you can cancel the "N" number of invoices

just enter all the invoices in th sequentialy list and execute it will generate different cancel invoice numbers

Thanks an Regards

Kishore

[Former Member]

Hi Dear ,

You can make SCAT file of VF11 Tcode for cancelation of 1600 Billing documents & you can cancel datewise billing doc. at a one stroke.

Thanks,

Santosh G.

[Former Member]

Hi Dear ,

You can make SCAT file of VF11 Tcode for cancelation of 1600 Billing documents & you can cancel datewise billing doc. at a one stroke.

Thanks,

Santosh G.

[Former Member]

Hi Santhosh,

Can you explain about SCAT file in detail.

[Former Member]

Hi,

The SCAT is similar to LSMW/BDC, as it is used to upload the data as required, in your case delete the invoice via VF11. Please refer the below usefull link for the same.

http://www.sap-img.com/general/scat-what-is-it-and-how-to-used-it.htm

You may also use VF11 itself to cancel the multiple invoices, as you need to input invoice number under docuement colomn, when you execute, system will generate multiple invoice numbers.

regards

Vivek.

Edited by: Vievk Vardhan on Dec 7, 2009 5:45 PM

[Former Member]

My Dear,

Please refer answer of vivek for scat details

Santosh G,

[Lakshmipathi]

Apart from the suggestions given already, please also dont forget to cancel the corresponding excise invoices

thanks

G. Lakshmipathi

[Former Member]

Hi,

Try with LSMW or BDC for mass cancellation of invoices.

regards,

santosh