How to find Sales invoice number from Inspection lot number?

[former_member507842]

Dear Experts,

Is there any tables to find out sales invoice number with the help of Inspection lot number (Goods issue inspection, delivery to the customer).

[former_member507842]

dear experts anybody can help on this issue?

[former_member507842]

dear experts anybody can help on this issue?

[former_member195779]

Dear Vishnu,

Table QALS is containing field Delivery no. Pass this delivery no in table VBRP in refernce field you will get the Invoice no.

Regards,

Amarnath Dube

[muhamed_faisal]

Hi

T code :QA33

Click Dynamic selection - Shift+F4 > Enter the sales order number and execute you will get lot no

From Table:QALS

input sales order number and excute

Faisal

[former_member507842]

Dear Faisal

Thanks for your reply,

In my case i'm having inspection lot number, but i want to find the invoice number for that inspection lot.

[AlbertSAP]

Dear Vishnu Prasath Vasudevan,

from QM point-of-view table QALS contains reference document numbers for inspection lots, such as material document, production/process order, sales order, delivery and so on. I am not familiar with the SD part of the problem, but tables VBFA and VBRP might help to identify the invoice. I hope these 2 information pieces help to find the searched invoice data.

Have a nice day,

Albert

[former_member507842]

Dear Albert,

Thanks for your reply.

QALS table shows inspection lot number, document number,sale order etc.. Same way VBRP provide invoice number, sale order number,etc..

We can able to find invoice number using sale order which we found in QALS table..But it shows all invoice numbers for that sale order..

(But i need to find specific sales invoice number for the given Inspection lot number)