Bottomline PrecisionForms: Cannot Send Failed Email Notice
The Bottomline PrecisionForms Email service can send the helpdesk an email whenever an error is encountered. It is important that you configure this correctly otherwise errors will be shown in the trace log.BTEmail,No from address available for SMTP, cannot send failed email noticeSteps to correct or configure1. Open Bottomline PrecisionForms Email2. [...]
Workflow Error: Application Cannot Be Started
Recently I was trying to set up a workflow in AX 7 / Dynamics 365 for Operations. I was unable to open the workflow editor.After clicking the details button I found the following:Deployment Identity : Microsoft.Dynamics.AX.Framework.Workflow.WorkflowEditorHost.application, Version=7.0.4307.16141, Culture=neutral, PublicKeyToken=c3bce3770c238a49, processorArchitecture=amd64...System.Deployment.Application.InvalidDeploymentException (Zone) - Deployment and application do not have matching security zones.The [...]
Bottomline PrecisionForms Email: File Did Not Contain an Email Header
Bottomline PrecisionForms is a powerful tool for formatting and delivering beautiful reports and forms (invoice, PO, BOL, RFQ...) from Dynamics AX. I have been using this tool for almost ten years now. You might encounter the following issue when setting up the Bottomline PrecisionForms Email server.File did not contain an [...]
Optimizing installing ISV solutions in AX 2012 (Compare Tool)
When integrating a comprehensive ISV solution into your AX environment there is always the possibility that there is a conflict: perhaps the ISV solution was built for a different version of AX, or you already have several other solutions installed. This means spending significant hours comparing objects, almost to the [...]
Check and Fix the Next AX Record ID for All Tables
** This was tested on AX 4.0 SP2The following script will check and update the next record ID for every table in AX. This is useful if you copied data from one environment to another. After running the script you must restart the AOS. At the end you'll see a [...]
Wrong Argument Types in Variable Assignment
During the development of a class occasionally we may receive this error messagewrong argument types in variable assignmentThe error only occurs when during runtime. I believe the issue is that the server has one copy of the class whereas your client has a different copy. you can resolve the issue [...]
Emailing embedded images from Dynamics AX
When I first tried sending an email with images it showed the standard image not found image from Microsoft internet exploder.This was the image in all the emails sent by AX.We are using AX 4.0 SP2 with hotfixes applied....I began to dig...I found that the image path is replaced with [...]
SQL Server Reporting Services: Fixing “Could not generate a list of fields for the query”
Many times when creating an SSRS report I get the message "Could not generate a list of fields for the query" especially when using datasources which include temporary tables or very complex queries. Sometimes clicking the Refresh fields button on the query toolbar does indeed fix the issue and other [...]
Determine table ID in SQL
Create this function to easily get the table number within a SQL statement.-- =============================================-- Create date: 2010.11.01-- Description: Gets the AX table ID for the table name-- =============================================ALTER FUNCTION [dbo].[fnAXTableID] ( -- Add the parameters for the function here @tableName nvarchar(40))RETURNS intASBEGIN -- Declare the return variable here DECLARE @tableNum [...]
Change default layers when comparing code
During the integration of system patches or third-party layers I found it annoying to continually select a certain layer when using the compare tool. Multiply the time it takes by 400 or more nodes and you get an unhappy developer.Fixing this problem is very easy. Just add the following code [...]
Convert Axapta Time in SQL
AX 4.0 stores time in the database using the seconds since midnight. So in order to view the time (military format) we must divide. Here is an example:SELECT TOP 20 StartTime AS [Seconds since midnight], CAST(StartTime/60/60 AS VARCHAR(2)) + ':' + RIGHT('0' + CAST(FLOOR((StartTime/60.0/60.0 %1)*60) AS VARCHAR(2)), 2) AS [Start [...]
Disable users who are not active in Active Directory
Occasionally when auditors come by I like to disable all user accounts in AX which have been disabled in Active Directory. Even though AD will not let them login auditors have a hard time understanding it, so I disable the users. Many times we do not get notification that someone [...]
Line ###-Offset voucher does not exist in account ______.
If a vendor transaction is reversed but an AP check has been printed (and the payment journal not posted) you may get this error. Essentially the record which was marked for settlement by the check has been deleted so it does not exist (VendTransOpen was deleted when the invoice was [...]
Get the next unique file name
Sometimes you are saving a temporary file so you don't want to delete or overwrite anything that already exists in a directory...there is a nice function to find the next unique file name.fileNameTemp = Global::fileNameNext(fileOriginalsPath + fileName);
Show the call stack in the infolog
info(con2str(xSession:: xppCallStack(), 'rn'));
Rename items quickly
Here is a little script to rename items quickly. Just provide a CSV file with old and new item number. I found that making the CSV file was faster than making a job to intelligently rename items because I could use Excel functions and review the new item numbers faster.static [...]