Microsoft Dynamics 365 and Power Platform Library

People came across issues like report is not showing data on report or data is not per their expectation. It is really hard to judge where it goes wrong and what needs to be correct in which class RDP, Contract, UI or Controller. Following sample job can be used to debug SSRS report processing data and lead to find what goes unexpected. For more information about classes and table used in this example please read my previous post static void FF_ReportDPTest(Args _args) {     // temp table declaration     FF_ReportTmpTable       ffReportTmp;     // RDP class binded with FF_Report     FF_ReportDP             dataProvider = new FF_ReportDP();     // Contract class for report parameters     FF_ReportContract       contract = new FF_ReportContract(); ...

Continue from my previous post where I developed an example using all SSRS framework classes. One of them is controller class which is used to call SRS report from AX forms. Just for the note controller class is used for following purposes. Modifying a report query based on the input data Modifying report contract data based on the input data Control a report parameters dialog Open different reports/designs from the same menu item based on the input data Reports that are opened from a form Example; how to call report from AX form button/menuitembutton click void clicked() {     CustOpenInvoices        custOpenInvoicesLocal;     SrsReportRunController  controller = new FF_ReportController();     SrsReportDataContract   contract;     FF_ReportContract       rdpContractClass;   ...

Code commenting is one of the best practice for any software development which really helps other team mates or future developers to understand code quickly. Code comments should be enough expounding for others. MS Dynamics AX provides diverse possibilities to comment out code in much better and generic way through scripts. This can be used by right click in any method within AOT objects as shown; Here we also have tagging option to use generic way to comment out our code and this could be really helpful when working on big projects. MS Dynamics AX uses a class EditorScript behind these scripts tool, I added a following method under this class for specific code comment pattern. public void tagging_CodeModifications(Editor editor) {     #Define.NextLine( '\n' )     int currentLineNo = editor.selectionStartLine();     int currentCol    = editor.selectionStartCol();   ...

Following job is to calculate business days/working days in AX using base calendars. In my case base calendar name is "24/5" you can change it as per your setup. static void businessdaysInPeriod(Args _args) {     WorkCalendarSched workCalendarSched;     date start;     date end;     counter workingdays;     counter totaldays;     CalendarId primCalendar= "24/5" ;     ;     start = str2date ( "21-11-2014" , 123 );     end   = str2Date ( "26-11-2015" , 123 );     workCalendarSched = new workCalendarSched();     while (start<=end)     {         totaldays++;         if (workCalendarSched.isdateopen(primCalendar,start)== true )         {  ...

Recently came across an issue where records from customized tables were being deleted occasionally. Following wat did a quick fix for me to stop further records delete from table.  Overwrite delete method on table and comment super(). This also stops deletion from code, e.g. if we write query delete_from table this commented super will prevent user to delete record from table. public void delete() {     //super(); } This will also stop deletion from code too. e.g. It worked fine but records can also be deleted by pressing Ctrl+F9 on table browser. To handle this situation I overwrite validateDelete method on table and returned False from there. public boolean validateDelete() {     boolean ret;     ret = super ();     return false ; }

You may find few more posts over this topic to send emails from AX using live (Hotmail) or gmail exchange server. This is really helpful when we don’t have exchange is in place sometimes due to high cost or you just want to send emails for testing or demo purpose. Let’s see what parameters need to setup and how can we achieve this requirement. Go to System Administration | Setup | System | E-mail parameters P.S. I am using a dedicated email account at outlook (Hotmail) domain for this example. NTLM option can also be used; TechNet article is more helpful to get more information on these parameters. Here is the job I wrote to send email for selected user. I name it SendTextMail as in my following post I will be writing to send invitation from AX using Hotmail or Gmail exchange server. //SmtpSSL static void SendTextMail(Args _args) {     System.Net.Mail.MailMessage             mai...

I faced this issue  " Failed to create a session; confirm that the user has the proper privileges to log on to Microsoft Dynamics" when I imported MS contoso data into my new created AX environment. Though this is not specific to MS contoso data import, you can have on original post which solved my problem too. http://www.ksaelen.be/wordpresses/dynamicsaxblog/2013/02/ax2012-r2-db-sync-failed-to-create-a-session/

There are many posts over the internet address Number Sequence framework, I found a worth sharing slides which tells you; How to create new number sequence How to use number sequence in form How to use number sequence in X++   Microsoft dynamics ax2012 : Number Sequence Framework, Step by Step from Hamdaoui Mohamed Amine

Delete a legal entity seems to be a straight forward option in AX, just click on delete button on legal entity form. This does not work sometimes as per your thoughts and you face errors like below. Cannot delete a record in Ledger (Ledger). The corresponding AOS validation failed. Stack trace: Call to TTSCOMMIT without first calling TTSBEGIN. Stack trace (S)\Classes\xRecord\Delete (S)\Data Dictionary\Tables\DirPartyTable\Methods\Delete - line 14 (S)\Data Dictionary\Tables\DirOrganizationBase\Methods\Delete - line 17 (S)\Data Dictionary\Tables\CompanyInfo\Methods\Delete - line 31 (S)\Classes\xRecord\dbOpInTransaction (C)\Classes\FormDataSource\delete (C)\Classes\FormRun\task (C)\Forms\OMLegalEntity\Methods\task (C)\Classes\SysSetupFormRun\task OR Cannot delete a record in Batch job (BatchJob). The corresponding AOS validation failed. These errors appear when you have transaction data in the legal entity which you are after for delete or there ...

I got a requirement to upload free text invoices into AX 2012 from one excel file. All the header and lines information was in one excel sheet so I had to came up with different solution than the import process described on many blogs or can be done through built in AX classes. However, those import process work perfectly if you have data into seperate files or only for one record. Here is the  job which I used to import free text invoices into AX 2012. In this job I used a table CustomerInvoices (new created table) which contains the data of all excel file. You can easily find out how to import data from excel then instead of using this table you can directly use the excel rows to get the data and insert into Free Text Invoice tables. static void CreateFTInvoicesFromTable(Args _args) {     CustInvoiceTable    custInvoiceTable;     CustInvoiceLine     custInvoiceLine;     CustTable ...

I developed a custom workflow and its setup its corresponding configuration, I was able to submit and everything but ended up getting the following error in my workflow history when the workflow system tried to assign it to user which is the part of managerial hierarchy. "Stopped (error): X++ Exception: Could not find user at SysWorkflowDueDateProvider-resolve SysWorkflowDueDateProvider-resolveDueDate SysWorkflowQueue-resume" I setup the workflow assignment for managerial hierarchy (position hierarchy) which was correctly setup under Human Resource > Common > Positions > Position hierarchy. Later when I checked the worker association with users I found that under user relation screen the user IDs are wrongly associated with workers.  Unfortunately this error message was coming due to wrong or missing worker and user assoication which is a must step for workflow to be processed perfectly. Workflow always work on Employee (worker) level not on user ...