-
Hey Tom, I was unable to find a specific method on QueryBuildDataSource of course as you probably didn't either. I did have a thought, though, that if you use the QueryBuildDataSource.autoSum() to add the aggregate column, you can then use that column in an emulator if statement that checks the value...
-
Hi, How can I add HAVING clausule to query in AX? I build query by QueryBuildDataSource by adding additional suming and grouping steatments but I need to filter resoult by checking value of sum. I make CustTransSplit table that splits custTrans record by goup of iitems, I want too check if values are...
-
Aon Corporation needs an experienced Developer Analyst for one of their companies in Chicago, IL. Aon is a global leader in risk management, insurance and reinsurance brokerage, human capital and management consulting, and outsourcing with more than 43,000 employees in 500 offices in more than 120 countries...
-
Aon Corporation needs an experienced Senior Developer for one of their companies in Chicago, IL. Aon is a global leader in risk management, insurance and reinsurance brokerage, human capital and management consulting, and outsourcing with more than 43,000 employees in 500 offices in more than 120 countries...
-
Excellent opportunity to lead the support of Financial systems within a well-known global entertainment company in the San Fernando Valley, California, USA. Systems include: Dynamics GP 9 FRx Hyperion Excellent compensation (up to $105k) and benefits package for the right candidate, depending on experience...
Posted to
Jobs Offered
(Forum)
by
pvit1
on
Thu, Jun 12 2008
Filed under: employment, analyst, full time opening, sql server, ERP Support, Dynamics GP, Los Angeles, LA
-
Hello, I'm trying to make the connection between Nav 5.0 and Outlook through the addin outlook, but after 1 week worked almost full time i'm a little bit tired. I've looked inside this forum but for say the truth i've not find something clear or who could help me. The case and the configuration...
-
Hi There We are looking for a Senior AX Developer who would be interested in Permanent work! The position would NOT Require relocation and travel would be at the mid-level portion for the first 6 months. We are looking for experienced AX Developers- please have at least 3-4 years experience within pure...
Posted to
Jobs Offered
(Forum)
by
sandyfrancis
on
Fri, Feb 1 2008
Filed under: development, employment, dynamics ax, jobs, microsoft dynamics, ERP, axapta, full time opening, sql server, X++, Senior Developer
-
Thanks for the help, I have access to the SQL Server database, but per Waldo's reply it doesn't look like that will do me any good. It looks like I'll have to duplicate the way the formula works in T-SQL if I'm going to work directly off the db.
-
The calculation formula is a properties. Properties are saved in the object's definition the object's definition is saved in the blob field of the Object Table. This field is binary (exporting it, you'll get a fob-type of file). So unfortunately, you will not be able to read it.
-
Well I'm still working on my CRM environment. And CRM also seams to have more issues. Whereas you in NAV have many companies in one database, then this is not possible in CRM (so I have been told). But I'm looking to create a setup where we have one NAV database with several companies. Each of...