Business/Working days in AX
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) { workingdays++; } start++; } info(strfmt(“Total days: : %1”,totaldays)); info(strfmt(“Total working days: : %1”,workingdays)); }
Stop deletion of record from a table
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; }
Send email from AX using live or gmail exchange server
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 mailMessage; System.Net.Mail.SmtpClient myMail; System.Net.Mail.MailAddressCollection mailcoll; System.Net.Mail.MailAddress mailFrom; System.Net.Mail.MailAddress mailTo; System.Net.Mail.MailAddress mailCC; str receiverMailAddress; str mailBody; str smtpServer; str mailSubject; str CcMailAddress; int SMTPPort; #File str mail; str pwd; Dialog dialog = new Dialog(‘Email’); Dialogfield person, emailSubject, emailBody; HcmWorker hcmWorker; UserInfo userInfo; DirPersonUser dirPersonUser; SysUserInfo sysUserInfo; SysEmailParameters parameters; // dialog field to select user to whom email will be send person = dialog.addField(extendedTypeStr(HcmWorkerRecId ), ‘Person :’ ); emailSubject = dialog.addField(extendedTypeStr(Description), ‘Subject :’ ); // Email Subject emailBody = dialog.addField(extendedTypeStr(Notes), ‘Body :’ ); // Email Body if(dialog.run()) { parameters = SysEmailParameters::find(); // Find values from Email Parameters new InteropPermission(InteropKind::ClrInterop).assert(); // gets HcmWorker record based on person selected from user dialog hcmWorker = hcmWorker::find(person.value()); if(!hcmWorker.RecId) // Verify either user exist or not { throw error(‘User not found’); } select firstOnly dirPersonUser join userInfo where dirPersonUser.PersonParty == DirPartyTable::findByName(hcmWorker.name()).RecId && userInfo.id == dirPersonUser.User; select firstOnly sysUserInfo where sysUserInfo.Id == userInfo.id; // Retrieve user info record for selected user mailSubject = emailSubject.value(); mailFrom = new System.Net.Mail.MailAddress(parameters.SMTPUserName ,“Name”); mailTo = new System.Net.Mail.MailAddress(sysUserInfo.Email); //mailTo = new System.Net.Mail.MailAddress(“test1@gmail.com”); //mailCC = new System.Net.Mail.MailAddress(“test2@gmail.com”; mailcoll = new System.Net.Mail.MailAddressCollection(); mailBody = emailBody.value(); try { // using the SMTP server ip //setup in email Parameters smtpServer = SysEmaiLParameters::find(false).SMTPRelayServerName; mailMessage = new System.Net.Mail.MailMessage(mailFrom,mailTo); mailmessage.set_Subject(mailSubject); mailmessage.set_Body(mailBody); SMTPPort = SysEmaiLParameters::find(false).SMTPPortNumber; myMail = new System.Net.Mail.SmtpClient(smtpServer, SMTPPort); // For SSL enabled mail servers. Ex: gmail, smtp.gmail.com, port 465 or 587 myMail.set_EnableSsl(true); pwd = SysEmaiLParameters::password(); mymail.set_Credentials(New System.Net.NetworkCredential(parameters.SMTPUserName, pwd)); mymail.Send(mailmessage); } catch(Exception::CLRError) { throw Exception::CLRError; } mailMessage.Dispose(); CodeAccessPermission::revertAssert(); } } UI of the utility
Failed to create a session; confirm that the user has the proper privileges to log on to Microsoft Dynamics
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/
Number sequence framework step by step
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 legal entities in AX 2012
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)ClassesxRecordDelete (S)Data DictionaryTablesDirPartyTableMethodsDelete – line 14 (S)Data DictionaryTablesDirOrganizationBaseMethodsDelete – line 17 (S)Data DictionaryTablesCompanyInfoMethodsDelete – line 31 (S)ClassesxRecorddbOpInTransaction (C)ClassesFormDataSourcedelete (C)ClassesFormRuntask (C)FormsOMLegalEntityMethodstask (C)ClassesSysSetupFormRuntask 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 are batch jobs in running state stopping this delete process. There are certain steps to get rid of these errors and also to have a smooth delete process without any issue. Select the company (legal entity) which you need to delete. Go to AOT (Press Ctrl + D) and find class “SysDatabaseTransDelete” to delete transactions first. Run class “SysDatabaseTransDelete”, it will prompt you Yes/No option to delete transactions. Delete them first it will take a while depend on the transaction data you have in your system in this company. Open legal entity form from Organization Administration | Setup | Organization | legal entities. Select legal entity for which you deleted transaction data in step 1 and click delete button. It will take a while.
AX 2012 – Import Free Text Invoices – Header and lines – from one excel file
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 custTable; CustomerInvoices customerInvoices; // Customized table Map customerFTI = new Map(Types::String, Types::String); Set failedCustAccount = new Set(Types::String); MapEnumerator mapEnum; SetEnumerator setEnum; LineNum lineNum; ttsBegin; while select customerInvoices order by customerInvoices.AccountNum { if (!customerFTI.exists(customerInvoices.AccountNum) && !failedCustAccount.in(customerInvoices.AccountNum)) { select custTable where custTable.AccountNum == customerInvoices.AccountNum; custInvoiceTable.clear(); if (custTable.RecId != 0) { custInvoiceTable.OrderAccount = custTable.AccountNum; custInvoiceTable.modifiedField(fieldNum(CustInvoiceTable, OrderAccount)); custInvoiceTable.InvoiceId = customerInvoices.InvoiceId; custInvoiceTable.insert(); lineNum = 0; customerFTI.insert(customerInvoices.AccountNum, custInvoiceTable.InvoiceId); } else { if (!failedCustAccount.in(customerInvoices.AccountNum)) { failedCustAccount.add(customerInvoices.AccountNum); } } } if (custInvoiceTable.RecId != 0) { custInvoiceLine.initFromCustInvoiceTable(custInvoiceTable); custInvoiceLine.LedgerDimension = customerInvoices.LedgerDimension; custInvoiceLine.Description = customerInvoices.Description; custInvoiceLine.TaxGroup = customerInvoices.TaxGroup; custInvoiceLine.TaxItemGroup = customerInvoices.TaxItemGroup; custInvoiceLine.Quantity = customerInvoices.Quantity; custInvoiceLine.UnitPrice = customerInvoices.UnitPrice; custInvoiceLine.AmountCur = customerInvoices.Quantity * customerInvoices.UnitPrice; custInvoiceLine.ParentRecId = custInvoiceTable.RecId; lineNum += 1; custInvoiceLine.LineNum = lineNum; custInvoiceLine.insert(); } } ttsCommit; mapEnum = customerFTI.getEnumerator(); info(strFmt(‘Following Free Text Invoices are successfully created.’)); while (mapEnum.moveNext()) { info(strFmt(‘Customer Account : %1 , Invoice Id : %2’, mapEnum.currentKey(), mapEnum.currentValue())); } if (!failedCustAccount.empty()) { info(strFmt(‘Following Customer Accounts are not valid.’)); setEnum = failedCustAccount.getEnumerator(); while (setEnum.moveNext()) { info(strFmt(‘Customer Account: %1’, setEnum.current())); } } }
Stopped (error): X++ Exception: Could not find user at SysWorkflowDueDateProvider
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 level so user MUST be associated with the user. I hope this will help someone who runs into the same issue in the future.
SSRS permissions issue; cann’t able to run from AX non admin user
Question: I have been facing the following issue while running SSRS reports from AX non-admin user. Please be informed that all the required permissions have been assigned from reporting service manager like content manager and browser…even I gave all. ANSWER: There are three areas where I have to define the security. 1- Site Settings 2- Folder Settings 3- Individual Folder Security I was missing the last one.
Microsoft Dynamics AX 2012 R3 Virtual Machine is available
Microsoft has released the Microsoft Dynamics AX 2012 R3 demo machine. Download is available at partnersource and customersource. Early in Macy 2014 Microsoft release Microsoft Dynamics AX 2012 R3 and can also be downloaded from the links mentioned in my previous post . At that time the application was general available and could be installed using the Microsoft Dynamics AX 2012 R3 setup files or you could deploy a virtual machine on Azure. This demo virtual machine can now be run at your own hardware using hyper-V as earlier demo machines versions use to run. However, this AX 2012 R3 demo machine is upgraded with latest Microsoft stack: Windows Server 2012 R2 SQL Server 2014 SharePoint 2013 with SP1 Office 2013 with SP1 You can download the machine from either Customersource or Partnersource. Customersource:https://mbs.microsoft.com/customersource/northamerica/AX/downloads/service-packs/AX2012DemoToolsMaterials Partnersource: https://mbs.microsoft.com/partnersource/northamerica/sales-marketing/demo-tools/virtual-machines/AX2012DemoToolsMaterials