List of billing that has not been cancelled

[Former Member]

Is there a transaction or a way in SAP to show all the invoice that has not been cancelled? for example, a list of all the invoice of one customer that has not been cancelled. Showing only invoice with no reference of S1 cancellation invoice.

[jpfriends079 · Accepted solution]

Use Tcode SE16 for Table VBRK and add Field FKSTO - Billing document (from menu bar goto Settings then Field Selection and select field FKSTO) is cancelled provide input as NO from selection list.

Execute the result

Thanks & Regards

JP

[Lakshmipathi]

The other work around is that in table VBFA, you key in all the billing documents and in "Follow on Document", you maintain the billing document cancelled and execute.

thanks

G. Lakshmipathi

[Former Member]

HI,

You can get all the Documents which were not cancelled from VBRK table

From the VBRK-FKSTO ( FKSTO is teh field for the cancellation status) put the FKSTO as Blank and check the Billing documents,

You will get all the documents which were not cancelled

regards,

santosh

[ivano_raimondi]

Hello Joseph,

you could check in table VBRK the records with KUNAG (or KUNRG) = Customer number and FKSTO = blank.

This method is not good for item cancellation, because with item cancellation VBRK-FKSTO is not set).

Best regards,

Ivano.