Skip to Content
0

How to find Sales invoice number from Inspection lot number?

Apr 03 at 10:53 AM

70

avatar image
Former Member

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).

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Albert Molnar
Apr 03 at 11:41 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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)

0
Muhamed Faisal Apr 03 at 01:37 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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.

0
avatar image
Former Member Apr 13 at 04:36 AM
0

dear experts anybody can help on this issue?

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
avatar image
Former Member Apr 23 at 05:10 AM
0

dear experts anybody can help on this issue?

Share
10 |10000 characters needed characters left characters exceeded