Invoice Reversal details -Table & Field details

[Former Member]

Hi all,

I am going to finalise spects for a report which shows all blocked invoices for a period. There are some invoices which are blocked were reversed by some users. When i trial run the report, it is showing all invoices which were blocked irrespective of Open / Reversed.

So when i go for releasing those blocked invoices, i am getting message that Invoice was reversed already !!!

How to filter out this ? where can i get the data of blocked invoices open for release & blocked invoices reversed (no further action) ??

Request for table & fields names to check this

Thanks in advance.

Rajan

[Former Member · Accepted solution]

You can check in VBRK table if the invoice is cancelled or not. If the invoice is cancelled then VBRK-FKSTO will be X else it will be blank. So based on this parameter you can remove those invoices which are reversed.

[former_member217082]

Hi Rajan

Use the the following feilds and table

VBRK - RFBSK and VBRK - FKSTO

Regards

Srinath

[alex_zheng]

Hi Rajan,

For your information, in case of item cancellation(even if he/she

selected all the items in vf11), field FKSTO and SFAKN will not be filled.

Please kindly check note 400000 for the "Item cancellation" part.

In case of item cancellation it is correct that field VBRK-FKSTO is

blank in cancelled invoice, the field VBRK-SFAKN is blank in

cancellation invoices, and VBRK-RFBSK is open in ALL the documents.

Regards,

Alex

[Lakshmipathi]

Field RFBSK in VBRK table will fulfill your requirement.

thanks

G. Lakshmipathi