Purchase Order Number Field in Sales Invoice Table

[former_member594505]

Hello:

In SAP Business One 9.3 PL06, does the table that produces data for Sales Invoices contain a Purchase Order Number field?

Thanks!

John

[kvbalakumar]

Hi John,

In general all SAP B1 line table contains the reference of its Base Document.

We can create Procurement Document from Sales Quotation or Sales Order.

Thus in order to get the PO from Sales Invoice, you should link back all its related base document.

Refer this discussion, where similar scenario is discussed https://answers.sap.com/answers/12636409/view.html

Regards,

Bala

[former_member594505]

I still don't see how to extract the PO Number.

[kvbalakumar]

Hi John,

Sales Invoice table don;t have the information about Purchase Order. You should execute the query by relating all the relevant tables/documents in order to get the Purchase details!