Sap B1 query to link OINV to OPLN

[former_member922921]

Hi guys,

I need assistance in a query to show which pricelist was used for specific invoice.

Am basically generating a report to show invoices and pricelists used.

Eg

Invoice Number 1 Pricelist: Distributor Pricelist

Invoice Number 2 Pricelist: Wholesale Pricelist

is there a column in OINV i can link to OPLN

Your assistance will be highly appreciated.

[former_member922921]

Hi

I would like to know how I can link Invoices to Pricelist Table in SAP B1. Sometimes users change the pricelists as is their right but we would like to generate a report to show which have been changed from the default that is in the Business Master Partner Data.

If OINV had a column called ListNum or PriceList it would have solved this issue.

Could there be a way we can link marketing documents to pricelists table.

Kindly assist.