Technical Web Log

I just came across a scenario where I had to import the Projects as WIPs from legacy system. For that I imported Projects and Project Contracts in the System, partly using DIXF and partly using excel add-in. During the import, I figured out that Funding Rules Allocation were not updated, so I had to write a custom job to updated that. Later, I saw that Financial Dimensions on Projects were imported correctly but those on Funding Source were empty, so I wrote following job to see which dimensions are currently attached to the Project Contract. I am sharing it with you all so somebody might not need to reinvent the wheel. Happy DAXing! ☺ static void getProjContractDims(Args _args) {     InventTable         inventTable;     SysExcelApplication application;     SysExcelWorkbooks   workbooks;     SysExcelWorkbook    workbook;     SysExcelWorkshe...

Courtesy: http://dynamicsteaching.com/ Source: This entry was posted in 2012 Dynamics Ax Logistics and tagged Ax 2012 Dynamics Ax Dynamics Dynamics Dynamics 2012 Dynamics Ax Dynamics Ax Learning Dynamics Ax Training one time supplier one time vendor vendor account on November 17, 2013 by vivek I came across a requirement about sales or purchase of an item from a vendor or sales to some customer only once. I came across following blog well conversed by the author. It covers the procurement part, but receivable can be handled in the similar way through AR module. One time vendor concept is used to handle the suppliers with whom we transact once. A Separate sequence is maintained in Ax in order to not mixing them with regular vendors . Refer the setups; Assign a separate number sequence for one time vendors in AP @ Accounts Payable -> Setup -> Accounts payable parameters -> One-time supplier Select one time vendor @ Accounts Payable -> S...

Source: http://www.windowsnetworking.com/kbase/WindowsTips/WindowsServer2008/AdminTips/ActiveDirectory/WhatAllPortsAreRrequiredByDomainControllersAndClientComputers.html This article explains the key port requirement for Client computers and Domain Controllers communicating with each other. Active Directory communication takes place using several ports. These ports are required by both client computers and Domain Controllers. As an example, when a client computer tries to find a domain controller it always sends a DNS Query over Port 53 to find the name of the domain controller in the domain. The following is the list of services and their ports used for Active Directory communication: UDP Port 88 for Kerberos authentication UDP and TCP Port 135 for domain controllers-to-domain controller and client to domain controller operations. TCP Port 139 and UDP 138 for File Replication Service between domain controllers. UDP Port 389 for LDAP to handle normal queries from client...

Source: http://kpytko.pl/active-directory-domain-services/adding-additional-domain-controller-windows-server-2012/ Courtesy: Krzysztof Pytko Why do we need to add additional Domain Controller? This answer is very simple: “for services redundancy” or “for domain authentication improvement in remote Site”. In case of server failure, we still have another one which can provide necessary services in our network, which avoids business discontinuity. First of all, we need to install new box or virtual machine with a server operating system that is supported in domain environment. To check what Windows Server versions can be installed and promoted as Domain Controller, we need to check   Domain Functional Level . To determine Domain Functional Level, please follow my another article on the blog titled:   Determine DFL and FFL using PowerShell You may find one of these Domain Functional Levels supported by Windows Server 2012 Domain Controllers: Windows Server ...

courtesy: http://www.andesoft.net/creating-bom-journal-using-x-code-ax-2009-ax-2012/ https://community.dynamics.com/ax/f/33/t/96262.aspx http://learnax.blogspot.com/2010/01/x-code-to-create-and-post-inventory.html static void createBomJournal_working(Args _args) {     InventJournalTable      journalTable;     InventJournalTrans      journalTrans;     InventJournalTableData  journalTableData;     InventJournalTransData  journalTransData;     InventTable             inventTable;     InventDim               inventDim;     Counter                 cnt;     InventJournalCheckPost  journalCheckPost = new InventJournalCheckPost();     InventTransId           inventTransId, inventTransIdFather;     InventBat...

Dynamics Ax Live: How to filter records in a form by code : The standard filter functionality in Ax forms is a neat and powerful feature. Using this filter functionality in your code is something you...

A simple job to get position/designation and department of an employee using employee id: static void WorkerPositionDepartment(Args _args) {     HcmWorker                       hcmWorker;     HcmPositionWorkerAssignment     hcmPositionWorkerAssignment;     OMOperatingUnit                 oMOperatingUnit;     HcmPositionDetail               hcmPositionDetail;     HcmJob                          hcmJob;     HcmPosition             ...

Alfasith AX: Error: No connection could be made because the tar... : Hi, This error will arise in many different cases. 1. Some time it thrown when you open any reports in Dynamic AX 2012 2. Some t...

MicrosoftDynamicsAxapta: Types of Lookup : Lookup  for Field in form with Range  : public void lookup() {     Query q = new Query();     QueryBuildDataSource qdbs;    ...

This post describes how to run an SSRS report through x++ code and passing report parameters as well. Its a simple code and comments are added for further ease in code understanding! public static void runSSRSReport() {     SrsReportRunController controller;             controller = new SrsReportRunController();     controller.parmLoadFromSysLastValue(false);      // write report name and its design in quotes that you want to run     controller.parmReportName("ReportName.DesignName");      // set additional, optional properties like setting landscape to true     controller.parmReportContract().parmPrintSettings().landscape(true);          // set print destination screen/printer/file etc.     controller.parmReportContract().parmPrintSettings().printMediumType (SRSPrintMediumType::S...

Courtesy: http://www.doens.be/2010/03/catching-a-key-press/ When you want to catch a key-stroke on a form, you can override the method task() The default method will look like this: public int task ( int _taskId ) { int ret; ret = super ( _taskId ) ; // write you're code here return ret; } Now you just need to check the _taskId , to know witch key you have stroke. You can compare this withe the values from the Task-macro. // Task-ID values, to be used with formControl's // return value from the method task() //--------------------------------------------------------   #define. taskF1 ( 257 ) #define. taskCtrlQ ( 264 ) #define. taskEnter ( 288 ) #define. taskShiftEnter ( 307 ) #define. taskNew ( 260 ) #define. taskSave ( 272 )   #define. taskShortCutMenuKey ( 519 ) #define. taskAlt ( 520 )   #define. taskCut ( 770 ) #define. taskCopy ( 771 ) #define. taskPaste ( 772 )   #define. taskDeleteKey ( 773 ) #define. tas...

I came across client's requirement to integrate barcode scanner and printer with AX in their production process. So inventory in (pick list generation) was done using barcode scanner, and at the end of each process (RAF journal) production sticker is generated with Item id and its batch number. First of all, le tme tell you that barcode scanner is just like an external keyboard attached to system, its drive gets auto-installed in windows (I tried on windows 7). As soon as driver gets installed yoou can test the scanner by opening a notepad and scanning some barcode, which will input contained information on notepad. Same would be the case in AX. You just need to place cursor on a field and scan the barcode. No integration tool required whatsoever. So it's pretty simple and easy. I used custom code to generate code39 barcode, and added a table field (with EDT barcodeStr) to save barcode string having item and batch number separated by % symbol, so I might be able to parse ...

Source: http://www.dynamics101.com/2013/09/developing-ssrs-report-using-report-data-provider-microsoft-dynamics-ax-2012/ Overview There are multiple methods to develop SSRS reports in Microsoft Dynamics AX 2012. This tutorial will guide you in developing Report Data Provider (RDP) based SSRS reports. RDP based SSRS Reports are used when complex business logic cannot be achieved using AOT query. Pre-requisites Microsoft Dynamics AX 2012 Visual studio 2012 SQL Server Reporting Services (SSRS) must be configured Reporting services extensions must be installed in Dynamics AX Important Concepts Report Data Provider (RDP) Class Report Data Provider Class is an X++ class that is used to access and process data for a SSRS report. The RDP class processes the business logic based on a specified parameter and/or query and returns a dataset to the reporting services. In order to create a RDP class in AX, you have to extend that class with SRSReportDataProviderBase . T...