How do i link the Purchase Order with Vendor Invoice in SQL?

[kodycarl]

Hello,

How do i link the Purchase Order with Vendor Invoice in SQL ? i look in the llx_commande_fournisseur table and the llx_facture_fourn table and i dont see a link to JOIN on.

Please help.

[isoscent]

Which SQL you are using?

[isoscent]

Which PO program, If Dolibarr Third Parties/Vendor then must be connect upon the Installation if third Party Apps(Say Excel) then either you can use ODBC or download the SQL connector say Your are using (MySQL) then download the driver to link to any Apps you might be having.

[altatof]

hello @kodycarl
I think you should look in the llx_element_element table

[kodycarl]

for the sql i am using mysql to write

[milenmk]

DO NOT mess directly in SQL.

Open any “Purchase order” card, and at the bottom, you have “Related Objects”. Click on the “Link to” on the right side, choose “Link to Vewndot invoice”, and you will get the list of vendor invoices with a radio button in front. Mark the proper invoice and click the “LINK” button at the bottom.

Same applies for the “Vendor invoice” card.

[isoscent]