5
I am a complete newbie with AX. My boss gave the task of exporting all vouchered/paid invoices from AX to another system in house for reporting. I have to write a SQL script to extract the data. At the moment I am completely lost. Any help would be appreciated.
Hello Joshua Womack,
Have you been able to get your issue resolved in the meantime?
Would be great if you could keep us updated.
Many thanks and best regards,
Ludwig
All right, I changed the version tag to "Dynamics AX 2012" for you. Please ignore my answer, because it's not applicable if you're on AX 2012.
Hello Joshua,
Please have a look at the payment history form that can be accessed for each vendor on the invoice tab in the 'related information' section.
To me it sounds as if you want to get and export those payment data for all vendors.
Probably just have a look how that standard feature is designed.
Best regards,
Ludwig
We are using the AX 2012 version. My requirement has me looking for the Purchase invoices.
Unless you host the production database on-premises, you can't access the database and therefore the whole idea is utterly wrong.
And even if you technically can do it, you shouldn't. Use data entities to export data, possibly to BYOD or Azure Data Lake.
Hi Joshua,
Can you help with following:
1. What version do you operate?
2. Do you need Sales side or Purchase side?
Add little bit more to you question.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
