Page breaks in Dynamic Ax Reports
How do you insert page breaks in Dynamic AX reports? ...
dynamics-ax
How do I get the previous field value in the modifiedField method of a Dynamic Ax table?
I would like to be able to perform some logic in the table.modifiedField method which compares the previous value of a field to the new value. How do I get to the previous value? ...
What is the best way to print columns from different tables on the same row using the Axapta reporting tool?
It seems like each body section in an axapta report can only print columns from a single table(consistantly). For instance: I have a report that has the following tables: SalesLine, InventTable and CustTable. Then I would like to print columns from each of this tables on the same row. It seems like I can do this when placing the field...
Dynamics AX: How can corrected tax be coded in the Invoicing Input / Update of Purchase Orders - Posting Function?
Corrected Tax has coding support in the LedgerJournalEngine but this functionality is not available for invoicing update via the Purchase Order Screens. The scenario is as follows: On the invoicing screen of the Purchase Orders I want to add a field for corrected tax per invoice line. Corrected Tax must override the default tax calcu...
Installing Dynamics AX 4.0 SP2 on SQL Server 2008
Is it possible to install AX 4.0 SP2 on SQL Server 2008 and Windows Server 2008 ...
Dynamics ax 4.0, opening form without applying filter on current record.
I have form with VendTable grid for example, which has CustAccount field. I want to place button, click on which will open CustTable form where all customers are visible. If I just put CustTable menuitem, then clicking on it will open CustTable form, but in this form only one record is displayed - one that has the same AccountNum as in...
Axapta: How can the Table Name, Not the Table ID, be used as a select in the Select Dialog of the Database Log Report?
Currently only the Table Id can be used which is meaningless as it is a number. A little bit of code example would really be great. ...
How to reference a report datasource table using x++
I'm unable to find the proper syntax for referencing the CustInvoiceTrans table of the SalesInvoice report datasource. Here's the context: I've created a new classification field on the InventItemGroup table and need to get the data from this field for each item on the invoice, and then summarize this data on the header of the invoice...
Axapta: Convert utcDateTime to date
What is the best way to convert a utcDateTime value to a date type so I can use the global datetime functions on it? int timeDiff; date _now = systemdateget(); ; select firstOnly myUTCDateTime from _myTable timeDiff = Global::yearDiff(_now, _myTable.myUTCDateTime); info(strfmt('%1', timeDiff); Thanks ...
Can PHP communicate with Dynamics AX business connector?
PROBLEM: I need to feed data from a PHP script into Dynamics AX. METHOD: I suppose the easiest way to do this is by using the Dynamics AX Business Connector. QUESTION: Is it possible to connect to the Dynamics AX Business Connector directly from a PHP script? If so: How? ...
Creating Tables and Retrieving Query results with Dynamics AX 2009 business connector
I'm writing a C# command line tool to fetch data from AX and to add data (create new tables) to AX. Fetching data from an AX table is easy and documented here: http://msdn.microsoft.com/en-us/library/cc197126.aspx Adding data to an existing table is also easy: http://msdn.microsoft.com/en-us/library/aa868997.aspx But I cannot figure o...
Unable to Connect to Reporting Services
I have a problem, when deploying report libraries through Axapta tool or directly from node in Dynamics Ax. I'm receiving the error: Unable to connect to http://xxxxx/reportserver/ReportService2005.asmx as specified in the config file for the report server at c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServ...
VendInvoiceJour.InvoiceAccount <- VendTable.AccountNum relation
Hi. I have following situation: I need to join VendInvoiceJour.InvoiceAccount <- VendTable.AccountNum and take VendTable.Vendgroup. In all cases (queries,or even views) Dynamics ax joins tables VendInvoiceJour.OrderAccount<- VendTable.AccountNum not VendInvoiceJour.InvoiceAccount <- VendTable.AccountNum. I`m trying to use this kind of q...
Is there a way to "embed" a form in another form
I have a form and I want to embed it in another form. I want to keep both form, but I would prefer to avoid duplicating the first form. Is there a way to "attach" a form to a tab page for example? ...
How to select for an empty datetime in Dynamics AX 2009
I have a table with a field name "StartDateTime" of type "DateTime". I want to do a query where those fields are null. In the table browser, I see these fields as " 00:00:00", where non-empty fields are like "2010-09-14 00:00:00". I tried using without success: this.query().dataSourceTable(tableNum(smmActivities)).addRange(field...
Controlling HTML from WebParts in Microsoft Dynamics AX
I have a website running in Microsoft SharePoint which uses menus and other data from Dynamics AX 4.0. I have a weblet in the website where I fetch a menu from Dynamics AX, which uses the WebMenuWebLet and WebVertMenuHTML classes to generate the HTML to be displayed on the page. I have now tried to strip everything from the weblet to rec...
Reports are printed without margins. Dynamics AX
Reports are printed without margins. With the margins of the printer the text appears cut off. The same occurs for the pdf files (without margins). ...