Skip to Content

SAP B1 -> Invoice : where is stored the purchase price list number ?

Hello Experts,

I need to know where is stored the purchase price list number in invoice documents.

Someone can help me ?

Thanks.

Guillaume

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 08 at 09:26 PM

    Hello Guillaume...

    I think you are asking for AP Invoice since you say "Purchase Price List".

    If that is the case, the OPCH table has a field called "GrossBase". But remember, if the Purchase Price is system generated (i.e., Item Cost) then it will be a negative 5.

    Regards, Zal

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 09 at 08:32 AM

    Hi Guillaume,

    Goto Form setting->select Document Tab->then goto table->goto Price list and Change pricelist

    Thank you,

    Aziz

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 10 at 12:03 PM

    Hi Zal and Aziz,

    Thank you for your answers.

    Zal is right.

    I asked for AR Invoice and the field which interests me is OINV.GrossBase.

    Thanks again.

    Have a nice day.

    Guillaume

    Add comment
    10|10000 characters needed characters exceeded

    • More than welcome Guillaume...thanks for marking this answered - good info for other looking into this type of information!

      Regards - Zal