Extract Accounts Payable Invoice line items using SQL script

(0) Share

Report

Posted on by Godfree_d

Hi, I need to extract Accounts Payable data (invoice lines) with Invoice Types and line numbers using a SQL script, however am not finding any diagram that can help. My source is D365 F&O. Can someone please guide or assist with the query?

I have the same question (0)

All responses (3)

Answers (1)

Sort by

André Arnaud de Cal... 305,354 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi Godfree,

Can you tell what exact business requirement you try to fulfill? Do you need to export data for reporting purposes? Is this environment running in the cloud or on-premise? On customer cloud environments, you don't have direct SQL access.

Was this reply helpful? Yes No
Godfree_d 5 on at

Like (0)

Report
Copy link

Link copied!

Hi André

Thank you for the reply.

The environment is on-premise. So, i need to get an extract of all the invoices (header and Lines) for audit purposes. I do know that there is a report however i would like to use SQL to extract either the individual tables or already join them and extract them.

Regards

Godfrey

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 305,354 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi Godfrey,

The vendor invoices are stored in the tables VendInvoiceJour and item line details in the table VendInvoiceTrans. For cost invoices, you can find line details in the vouchers. (GeneralJournalAccountEntry and GeneralHournalEntry tables).

Was this reply helpful? Yes No