how to know if my sales invoice has a credit or debit memo?

[Former Member]

Dear Experts

  Please tell me how we can track if a sales invoice has a credit or debit memo? Which table can i find this?

We have a report of sales values for line itemwise. After doing VFRB the original sales value should get added or deducted as  in case of debit memo or credit memo in my report. But how do i tell my ababper if my sales order or invoice has a credit memo or debit memo?

Regards

yezdevan

[piyush_gajera]

Hello,

Please check field VBTYP in VBRK table itself. Here document category field is available, from there you can find that what kind of category of that document is.

Refer below screen shot.

Pl check accordingly.

Thank$$

PG

[Former Member]

Thanks Raj, and Lakshmipathy.

thread is answered.

[Lakshmipathi]

You need to validate the field VBTYP_N in VBFA table where if it is "O" or "P", then you can conclude that they are Credit Memos (O) and Debit Memos (P) respectively.

G. Lakshmipathi

[Former Member]

Hi,

It is based on the billing document type.

Please refer to the below screen print:

If you are looking for the table where you can find the relation between Invoice - Credit / Debit memo then use - VBFA table