Notifications
Announcements
No record found.
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?
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.
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
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).
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 551 Most Valuable Professional
André Arnaud de Cal... 450 Super User 2025 Season 2
BillurSamdancioglu 278 Most Valuable Professional
