Hi Guys,
I am having problems using the universal connector on an SQL database for Dynamics AX.
We are just testing it and have created some simple NL formulas generating rows from the Ledger Table in AX. For some reason the rows being generated are populating data from all the companies in the database?
I have tried to use the company= filter but it will not allow me to select information for any other company but the default one. I have however found a field in pretty much every table in AX called the DATAITEMID that appears to allow you to select the company. Would this now mean that in every formula I would need to specify this?
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi Meemz,
You are right. In Dynamics AX the data of all companies are stored within the same table. The "Company=" option does not work as it is meant to be used for the NAV connector only.
However, if you use the DATAAREAID Field as your filterfield and the AX company code as your filter you will achieve what you wish. This needs to be done in every NL Function.
I've been using Jet Reports on Dynamics AX for a couple of years now and it works perfectly! I recommend to get the Friendly names option implemented - please download and read the PDF document on the Universal connector for more info. -
Jet Reports Historic Posts Hans : Any AX Data View to share ? :D
Please sign in to leave a comment.