AX – D365FO – Name and Id of tables in ax 2012

PurchRFQLineMap ( Request for quotation lines 4 )BankGroup ( Bank groups 5 )RFIDProcessStructureTmp ( RFID process structure 6 )BankAccountTable ( Bank accounts 7 )BankAccountTrans ( Bank transactions 8 )BankChequeLayout ( Check layout 9 )BankChequeTable ( Check table 10 )BankDeposit ( Bank deposit 11 )BankTransType ( Bank transaction type 12 )BOM ( BOM lines 18 )BOMCalcTable … Continue reading AX – D365FO – Name and Id of tables in ax 2012

Dynamics 365 Human Resources – Questionnaires

Set up training courses : https://docs.microsoft.com/en-us/dynamics365/human-resources/hr-learning-coursesQuestionnaires : https://docs.microsoft.com/en-us/dynamics365/human-resources/hr-learning-questionnairesCreate questionnaires : https://docs.microsoft.com/en-us/dynamics365/human-resources/hr-learning-design-questionnairesDistribute and schedule questionnaires : https://docs.microsoft.com/en-us/dynamics365/human-resources/hr-learning-distribute-questionnairesDistribute questionnaires using scheduling : https://docs.microsoft.com/en-us/dynamics365/human-resources/hr-learning-distribute-questionnaires-schedulingView and evaluate the results of questionnaires : https://docs.microsoft.com/en-us/dynamics365/human-resources/hr-learning-evaluate-questionnaire-resultsAnalyzing questionnaire results : https://docs.microsoft.com/en-us/dynamics365/human-resources/hr-learning-analyze-questionnaire-resultsCreate an open ended question : https://docs.microsoft.com/en-us/dynamics365/human-resources/hr-learning-create-open-ended-question

AX – D365FO – Adding a Reference Group Lookup in Microsoft Dynamics AX 2012

In Microsoft Dynamics AX 2012, we can use a reference group to display the auto identification of a foreign key in a form. By using the ReplacementFieldGroup property of the reference group control, we could also choose to display a column instead of the auto identification of the foreign key. Sometimes, we need to filter … Continue reading AX – D365FO – Adding a Reference Group Lookup in Microsoft Dynamics AX 2012

AX / D365FO – num2Str Function

Converts a real number to a string. str num2Str( real number, int character, int decimals, int separator1, int separator2) Parameters ParameterDescriptionnumberThe real number to convert to a string.characterThe minimum number of characters required in the text.decimalsThe required number of decimal places.separator1A DecimalSeparator enumeration value.separator2A ThousandSeparator enumeration value. Return Value A string that represents the number. … Continue reading AX / D365FO – num2Str Function

Visual Studio 2017 – Git failed with a fatal error

Solution : Navigate to C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\Common7\IDE\CommonExtensions\Microsoft\TeamFoundation\Team Explorer\ and delete the Git folder.Make sure that there is no version of Git installed on your system, remove it by going to Control Panel → Program and Features (TortoiseGit does not need to be removed from my experience, just native git installations).Open up the Visual Studio 2017 installer and untick "Git For Windows" in installation … Continue reading Visual Studio 2017 – Git failed with a fatal error

AX – D365FO – AX 2012 Table inheritance with example

Step-1 Create a table called 'BaseTable'Step-2 Set table property 'supportInheritance' to 'Yes'Step-3 Create a filed name called 'InstanceRelationType' extends 'RelationType'Step-4 Set table property 'InstanceRelationType' to 'InstanceRelationType'Step-5 Create two filed called Id and Name as shown below screen Step-6 Create another table called 'ChildTable'Step-7 Set table property 'supportInheritance' to 'Yes'Step-8 Set table property 'Extends' to 'BaseTable' … Continue reading AX – D365FO – AX 2012 Table inheritance with example

AX – D365FO – Computed columns in Views examples

Computed columns have been using in SQL server since many versions but this feature was available Dynamics AX since version 2012.Follow steps described here to learn how to create view and walthrough the complete example to understand how can we add computed columns in AX 2012 Views.More examples can be found from here --> http://daxmusings.codecrib.com/2011/10/computed-view-columns-in-ax-2012.html Well, here is an … Continue reading AX – D365FO – Computed columns in Views examples

AX – D365FO – Apply user options

Finance and Operations apps offers some various color themes and element sizes to create an aesthetically pleasing interface. You can use the User options page to control basic features and behavior of your environment that are specific to you as a user. The system administrator can control these user options from the Users page in the System administration module. Watch this … Continue reading AX – D365FO – Apply user options

AX – D365FO – How to save filters as a fast inquires in Dynamics 365?

In dynamics 365, you can create multiple filters in the same form or report and save itand you can retrieve this filters as fast inquires For example, all sales order form you can create a filter on sales type:: return order  as the below (all return order)go to accounts receivables/orders/all sales orders /options tab click advanced filter /sort … Continue reading AX – D365FO – How to save filters as a fast inquires in Dynamics 365?