on 07-13-2007 6:26 AM
Dear All,
How can we list out all cancelled invoices. (Excise invoice INDIA-CIN). Is there is any standard report or tcode then please tell me.
With Regards
Ashwani K Mathur
Hi Kumar,
If you go in VF03 Header level,Header tab page...you can find out a check box as cancelled.This check box is set automatically by the system once you cancel the invoice.The field is FKSTO.This field is avialable ijn VBRK table.
So go to SE16,give table VBRK,along with other selection criteria as per requirement ..give FKSTO field value as "X"
So system will give you all invoice list for cancelled invoices.
You can do it this way or as Datta told you can prepare Querry report on this.
Reward points if useful
Regards,
Amrish Purohit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Ashwani,
I am not sure whether or not you have any standard report to fetch this type of data. but you can as well make your won Query taking fields like
FKTYP: Order / delivery Related
FKDAT: Invoice date
FKART: Billing TYpe
FKSTO: Cancelled Invoice
Take any other fields you want as selection criteria and you can get this type of data.
OR you can go and check in SE 16 giving this selection criteria and get all the cancelled invoices during the selectin criteria.
Hope this helps
Reward points if it helps
Regards
Srini
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.