Skip to Content
avatar image
Former Member

How to find Sales invoice number from Inspection lot number?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Apr 03 at 11:41 AM

    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

    Add comment
    10|10000 characters needed 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)

  • Apr 03 at 01:37 PM

    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

    Add comment
    10|10000 characters needed 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.

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

    dear experts anybody can help on this issue?

    Add comment
    10|10000 characters needed 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

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

    dear experts anybody can help on this issue?

    Add comment
    10|10000 characters needed characters exceeded