How to Programming with Dynamics-ax-2012

You have to change the property CountryRegionContextField of the corresponding control to point to the field which has CountryRegionCodes value set (either on table level, or EDT level). I guess you have to explicitly set this property because you can have different forms with the same table as data source,...

Form grid filters

sql,sql-server,view,axapta,dynamics-ax-2012

Yes you can retrieve the filters by getting the form's queryRun's query and packing that into a container to be stored/passed/unpacked. The form has a query, that is passed to QueryRun, then the users puts filters/dynamic joins/etc on that query that belongs to the QueryRun. So you need the modified...

Saving an SQL Server view to the Dynamics AX AOT

We had a requirement for view that could not be designed in AOT. Our workaround approach: design view in AOT with fields only (computed columns with appropriate EDTs) - just add any table (main one) create static server view method with SQL DDL (from SSMS) and execute that ddl with...

How can the visibility of a button in a form be changed dynamically using x++ code?

forms,axapta,x++,dynamics-ax-2012,form-control

FH-Inway's answer is correct from a code-perspective, but I want to comment that what you're doing is incorrect and won't function properly unless your mineTable only has 1 matching record. Currently as written, when the form is instantiated, you basically loop over mineTable and toggle the myButton visible and hidden...

“Unretrieved” value in the table field

axapta,x++,dynamics-ax-2012,morph-x

"Unretrieved" fields are newly created fields which AX 2012 AX by error treats badly. It may also appear if a form query does not contain a field in the field list. You problem is solved by restarting the client or the AOS or both. Or in the second case just...

Using dialog box or creating the form?

reporting,axapta,dynamics-ax-2012

You can use Dialog to prompt the user: Dialog dialog; DialogField field; ; dialog = new Dialog("My Dialog"); dialog.addText("Select to display negative values:"); field = dialog.addField(extendedTypeStr(NoYesId)); dialog.run(); if (dialog.closedOk()) { info(field.value()); //Add result to args ... } // Call the form ... But I would suggest using a simple DropDialog...

AX2012 - Pre-Processed RecId parameter not found

Ok, so now I feel very stupid for spending so much time on that error, when it's such a tiny thing... The erronous line is that one : controller.parmReportName(ssrsReportStr(WHSPickListShipping, Report)); Because WHSPickListShipping is the name of the AX report, but I renamed my custom report clWHSPickListShipping. What confused me was...

Strange behavior with try-catch on Dynamics Ax 2012

try-catch,axapta,x++,dynamics-ax-2012

AX (X++) is strange here (if you are used .NET/Java like try/catch scenario). If you have try inside the transaction, then fist catch cathes the excation (which is Enum and not sort of exception object). From the MSDN: Exceptions Inside Transactions: When an exception is thrown inside a ttsBegin -...

Not all query datasources available on ListPage

axapta,microsoft-dynamics,dynamics-ax-2012

DataSources with JoinMode ExistJoin or NotExistJoin are not available. And make sure that query version on the Data Sources of the list page is same as the query version in the AOT. If not click into Query property and press Enter. See https://msdn.microsoft.com/en-us/library/aa880078.aspx...

How to initialize the enum Field in a Table?

enums,axapta,x++,dynamics-ax-2012

You have only declared TableB in the initValue() method and have not initialized it with any record. This is basically the difference between: Class1 class1 and Class1 class1 = new Class1(). So you need to do: TableB tableb = TableB::find('SearchArgument'); if (tableb) this.fieldA = tableb.fieldb; ...

Object Not Initialized

In my experience this problem usually occurs if the pack/unpack pattern that is used to transfer class attributes from one tier to the other was not implemented for the class. Your comments indicate the same (initialization on client, execution on server)....

Dynamics ax 2012 compiler warning when seting smmOpportunityTable to common

The warning is actually just because the compiler seems to be incorrectly handling the use of the ternary operator. To remove the warning, you can just rewrite as: if (custTable) commonParty = custTable; else commonParty = smmOpportunityTable; if (custTable) is the same as if (custTable.RecId != 0). It literally just...

Form control embedded to DS visible property

table,containers,axapta,x++,dynamics-ax-2012

The help on the Visible property of a fields reads: Determines whether the field should be visible in the user interface. If set the field is not shown in forms or reports, nor can it programmatically forced visible (other than changing the field property!). The only other option is to...

How to write in container field table from code?

Containers are immutable, you therefore have to assign the result of conIns to your container field: myTable.FieldContainet = conIns(myTable.FieldContainet, 1, value); Try to use myTable.FieldContainet += value; instead, it is easier to read and performs better. Second method, if exist container initialized value: container con; con = ["valueI" , "valueII"...

Get caller of menuitem in global menu [closed]

axapta,microsoft-dynamics,dynamics-ax-2012,dynamics-ax-2009,ax

When you are opening a menu item from GlobalToolsMenu it isn't associated with the current form, it works as if you are trying to open a menu item from an independent menu. If you need to get access from the called class to the current form you need to use...

SSRS Report Parameter Stripped

reporting-services,axapta,dynamics-ax-2012

It does appear that the reporting services treat semicolons as special characters. The solution I came up with was to modify my string by changing all the semicolons to commas, but I did this in the PreModifyContract method instead of using SysQueryHelper. Obviously I then had to modify the logic...

Query range not equal to zero

Do not make it harder: qbds.addRange(fieldNum(HcmEmployment,LegalEntity)).value(SysQuery::valueNot(0)); The reason for your failed query expression was the use of queryValue("0") which quotes the zero. Changing that to 0 would work as well, but again too laborious. And even shorter is: qbds.addRange(fieldNum(HcmEmployment,LegalEntity)).value('!0'); To diagnose query errors take a look on the SQL generated:...

ax 2012 - dial functionality in smmContactPerson

I don't think mouse events can be monitored by the interaction class. What about using a good old button?...

X++: Highlighting all records in a grid from a code (including not loaded ones)

php,.net,axapta,dynamics-ax-2012,dynamics-ax-2012-r3

This is what finally worked for me (source). Please note, that InventDim wasn't my main Data Source in this form. InventTransOrigin was the one, but it didn't worked. So I guess, you can have this method if you don't want to show any warnings to the end user: public boolean...

Using PHP to Update Dynamics AX 2012 Workflow

You should use AIF (Application Integration Framework). Then you can call AX AIF services via SOAP (Web Services). Use HTTP adapter instead of default NetTcp (or configure it to use BasicHttp). See https://technet.microsoft.com/en-us/library/hh496418.aspx for the instructions of configuring HTTP Adapter. For workflow actions AIF service is already created (\Services\SysWorkflowApprovalService)....

Dynamics AX 2012 R2 CustClassificationGroup table is missing

axapta,microsoft-dynamics,dynamics-ax-2012

You won't have all AX tables in your StoreDB. In StoreDB, you just have relevant tables you need in standard Retail process (cash&carry, inventory, etc...). If you need to get other standard tables or specific tables, you have to: - add those in StoreDB SQL schema using specific SQL script...

Data from Multiple Data Sources in One Column in Grid

axapta,microsoft-dynamics,dynamics-ax-2012,ax

Try creating a union query and then a view based on that query. Maps are supposed to be used only in X++, and not as data sources in forms....

Synchronize after extended data type changes

database-design,axapta,dynamics-ax-2012

You don't have to synchronize each time you touch EDT. Only synchronize tables using this EDT (or child EDTs) - manually. If you don't know all the tables, then you have to re-synchronize full database. Synchronize is technicality required only when database related properties (string size, array) are changed. If...

Open direct links to AX-objects or datasets from external application

axapta,dynamics-ax-2012,dynamics-ax-2012-r2

There is! It's using AX's drilldown functionality which uses AxHLink.exe to handle dynamics:// URLs, which are passed to the Classes\SysStartupCmd function. You could also create some custom code there if you wanted to launch the AX client executable directly. My question I asked some while back should have a great...

How to convert Dynamics AX Timezone to C# TimeZoneInfo?

c#,axapta,dynamics-ax-2012

It does not sound cool, but I think you will have to provide the mapping table yourself between the Timezone System Enumeration and the name valid to Instantiate a TimeZoneInfo Object. The list of names should be quite static, but remember to catch TimeZoneNotFoundException and InvalidTimeZoneException when using FindSystemTimeZoneById....

Field refreshing after changing record

axapta,microsoft-dynamics,dynamics-ax-2012,dynamics-ax-2009,ax

You have two problems: Use _vendTrans.DefaultDimensioninstead of VendTrans.DefaultDimension in line 3. That is why the same value is in all lines, you are referencing the active record in stead of the record of the grid line. Use display method caching to improve performance of the form. To fix both move...

taskSelectAll ignores focus

Set the grid's AutoDeclaration = Yes then call this code, replacing grid1 with your actual grid control: #define.taskSelectAll(778) element.selectControl(grid1); element.task(#taskSelectAll); OR if you don't want to set the AutoDeclaration = Yes and avoid the added overhead, you can do this: #define.taskSelectAll(778) element.selectControl(element.control(element.controlId('Grid1'))); element.task(#taskSelectAll); ...

Need to include new module in AX 2012

axapta,x++,microsoft-dynamics,dynamics-ax-2012,morph-x

Modules are called models in AX lingo. Read all about Models, Layers, and the Model Store and Working with Models in AOT....

Debugging Report DP class

dialog,position,axapta,x++,dynamics-ax-2012

Please check whether your custom written classes extend SRSReportDataProviderBase, and those classes that you can debug extend SrsReportDataProviderPreProcess.

How to set Dialog text position from code?

You can center the text using the form control: Dialog dialog = new Dialog("Dialog example"); DialogText t1 = dialog.addText(strFmt("Text to show")); DialogText t2 = dialog.addText(strfmt("SecondText to show")); FormStaticTextControl c1 = t1.control(); c1.widthMode(FormWidth::ColumnWidth); c1.alignment(FormAlignment::Center); dialog.run(); The first control is now centered (to the surrounding group). You have to give it ColumnWidth,...

Ax 2012 custom lookup

reporting-services,microsoft-dynamics,dynamics-ax-2012,ssrs-2012,dynamics-ax-2012-r3

TableId tableId = pickTable(); FieldId fieldId = pickField(tableId); info(tableId2name(tableId)); info(fieldId2name(tableId, fieldId)); OR public void lookup() { SysTableLookup sysTableLookup; SysDictField sysDictField; TmpTableFieldLookup tmpTableFieldLookup; Enumerator en; super(); en = SysDictTable::newName(tableStr(InventTable)).fields(false, true, false).getEnumerator(); while (en.moveNext()) { sysDictField = en.current(); tmpTableFieldLookup.TableName = sysDictField.tableName(); tmpTableFieldLookup.FieldMethodName =...

AX 2012 R3 CU8: System.ServiceModel.FaultException: An error occurred

dynamics-ax-2012,aif

Check AIF Exceptions in the AX (System administration - Periodic - Services and Application Integration Framework - Exceptions). You can also enable message logging on the Inbound port (under Troubleshotting select All document versions) and Include exceptions in fault. Don't forget to disable in production or periodic cleanup. ...

Error: Query with id 'DAXSecurityUsersAndRoles' does not exist. How to resolve this?

This menu item is not standard and must be your customization. Check your XPO import.

Relation between VendPackingSlipJour and GeneralJournalEntry

axapta,dynamics-ax-2012,dynamics-ax-2012-r2

It goes from VendPackingSlipJour -> VendPackingSlipVersion -> SubledgerVoucherGeneralJournalEntry -> GeneralJournalEntry It seems there may be more than one VendPackingSlipVersion record per VendPackingSlipJour, then use the VendPackingSlipVersion.findLatest method to find the relevant one. This paper may be of help regarding the ledger rubbish in AX 2012....

How to get a Sales order number against a purchase order

axapta,x++,dynamics-ax-2012,dynamics-ax-2009

In AX2009 table method PurchTable.checkUpdate: salesTable = SalesTable::find(this.InterCompanyOriginalSalesId); ...

Dynamics Ax 2012 Dialog - Questioning Training material

axapta,microsoft-dynamics,x++,dynamics-ax-2012

CustTable.AccountNum field in CustTable is of CustAccount type, which extends CustVendAc EDT. So basically, they both are of the same type. CustTable.CustGroup is of CustGroupId type, so it is ok. CustTable.Currency is of CustCurrencyCode type, which extends CurrencyCode. Use existing methods to validate the record before inserting the record into...

How to remove clock symbol in UTCDatetime Field on form(Dynamics ax)?

axapta,datetime-format,dynamics-ax-2012,dynamics-ax-2012-r3

I fixed this issue. I changed the Property of "TimeZoneIndicator " property to "Never" on form field level. That fixed the issue.

How to find if exist an uppercase character in string?

string,axapta,x++,dynamics-ax-2012,uppercase

The code below tests if a string is one character or more and afterwards finds all the uppercase characters. Numbers are ignored since they cannot be uppercase. static void findCapitalLetters(Args _args) { str testStr = "!#dE2"; int i; int stringLenght = strLen(testStr); str character; //Find out if a string is...

View details control on ax 2012 form

axapta,dynamics-ax-2009,dynamics-ax-2012,dynamics-ax-2012-r2

You have to create Display Menu Item with the selected form. Then you can set newly created menu item for the FormRef property of the Table....

Relation between payment and invoices in ledgerJournalTrans

There is no such direct relation. Usually the invoice issuer provide a payment id (from the payment slip) to be used on the payment. When paying you are supposed to provide the payment id but no law of nature force you to do so. The payment id may be an...

How to clear form control?

microsoft-dynamics,dynamics-ax-2012,dynamics-ax-2012-r2,dynamics-ax-2012-r3

In validate methods you do not need to clear the field. The system does that for you when validate returns false. So instead of this.text('')) just return false. But I doubt that the idea of users entering the full name is really useful at all. If you use NameAlias as...

Enable/Find logging for Dynamics AX Odata service

Found it: Use Service Configuration Editor to edit ax32serv.exe.config. Enable MessageLogging and Enable tracing. Change logging path + save Restart AOS Generate some traffic Analyze Ax32Serv_messages.svclog and Ax32Serv_tracing.svclog with Microsoft Service Trace Viewer.

How to perform a partial string query on Dynamics QueryService?

c#,axapta,dynamics-ax-2012,aif

I already got an answer at https://community.dynamics.com/ax/f/33/p/148074/333993.aspx from Denis Macchinetti. Answer: Denis Macchinetti responded on 29 Dec 2014 10:32 AM Hi Eros In my opinion, you can use a Dynamic Query. Take a look at http://msdn.microsoft.com/en-us/library/gg847959.aspx, Dynamic Query section. Practically, create an AOT class that extends the AifQueryBuilder class. Then...

Conversion from integer to time in ax 2012

data-type-conversion,dynamics-ax-2012

The AX TimeOfDay type is number of seconds from midnight. You can use time2Str function or use div and mod operand to calculate hours and minutes. Example: info(time2Str(31501, TimeSeparator::Colon, TimeFormat::AMPM)); ...

How to keep “Show in content area” when form is open by menuitem from code?

axapta,microsoft-dynamics,dynamics-ax-2012

It happens when the menuitem which is not in any menu is used. So the solution is use menuitem which exist somewhere in the menu. I also see this behavior when the callers args are used instead of creating new Args() like: public static void main (Args _args) { MenuFunction...

Relationship between GeneralJournalAccountEntry and LedgerJournalTrans_Project

There is not a one-to-one relationship. The closest thing would be to use Voucher and TransDate on LedgerJournalTrans to fetch ledger transactions. See this post. There is a white paper describing the AX 2012 ledger posting framework....

SQL Recursive CTE 'where-used' / BOM explosion part 2

sql,sql-server,recursion,dynamics-ax-2012

Here is a version that is easy to understand and maintain: ; WITH CTE AS ( SELECT B.RECID AS MainID , B.ITEMID AS MainItem , BV.NAME , BV.ITEMID AS ParentItem , ECPT.NAME AS ParentItemName , B.BOMQTY , B.UNITID , B.BOMQTYSERIE , 0 AS [level] FROM #BOM B JOIN #BOMVERSION BV...

Only foreign key constraints are allowed on this table AX 2012

foreign-key-relationship,axapta,dynamics-ax-2012,dynamics-ax-2012-r3

The error message is probably misleading. It will be linked to the extended data type with table relation. Try following 1) Check if the EDT you are using is in the 2012 style or 2009 style (2009 has relations). If it is in the old style try to use new...

Getting array from .Net parm method

.net,axapta,dynamics-ax-2012

Because TextFieldParser.ReadLine() is supposed to return a single string (as documented here https://msdn.microsoft.com/en-us/library/6a8fts4w%28v=vs.90%29.aspx) You should be doing parser.ReadFields() (https://msdn.microsoft.com/en-us/library/microsoft.visualbasic.fileio.textfieldparser.readfields%28v=vs.110%29.aspx) Also you've not set TextFieldType = FieldType.Delimited (as documented here https://msdn.microsoft.com/en-us/library/63k8k5sx%28v=vs.90%29.aspx) TextFieldType default value is FieldType.Delimited, so no need to set it....

How to post document date and document number in general journal

if-statement,axapta,x++,dynamics-ax-2012,close

Don't do it like that, you're making more work for yourself. I just wrote this example for you. I hacked up a more complex piece of code I wrote, so the offsetDefaultDimension I just left in for some example code. static void Job3(Args _args) { AxLedgerJournalTable journalTable = AxLedgerJournalTable::construct(); LedgerJournalTable...

How to close the process from class code?

You can start your form with the FormRun class and close it again with formRun.close(). Remember to call formRun.wait() when you want the form to remain open and wait for an action from the user. static void openCloseForm(Args _args) { FormRun formRun; Args args = new Args(); args.name(formstr(MyForm)); formRun =...

How to make grid on list page to be editable?