Relation between invoice and delivery note

[Former Member]

Hi everybody, could you tell me please, how could i find the list of delivery notes for a customer. i need to find a relationship between a invoice ahave and delivery note related to this invoice.

thank you

[Former Member]

that's more like it, thank you, but i can't find it, it says it doesn't exist. Is there any other document where i could find invoice number through a delivery number or vice versa.

Thanx again

[Former Member]

Hi,

Good evening and greetings,

You can use the table VBFA and create a small query using SQVI to generate the information needed...This table holds the information of preceeding and succeeding documents, like Delivery and Invoice.

Please reward points if found useful

Thanking you

With kindest regards

Ramesh Padmanabhan

[Former Member]

Sorry , may be i explained myself wrong. I don't need any report, i just have a delivery note number but not the invoice's one. So basically, my client lost the invoice in question number and he asks me to recover it knowing nothing but the delivery note number. I think they are related, but i don't know how how and where i could see this relation.

[Former Member]

My mistake

Look up the delivery and select document flow.

VLO3N enter delivery number and hit F7.

[Former Member]

You could write a custom report based:

This is a link to the tables and their joins....

http://www.erpgenie.com/abap/tables_sd.htm