Blog2019-02-02T00:55:38-06:00

Unable to Configure Report for PrecisionForms – Record Already Exists

July 3rd, 2017|Categories: Bottomline PrecisionForms, Dynamics AX 2012|

Symptom:Cannot create a record in Delivery destinations (BT_DPA_AOT_ReportDestinations). AOT object ID: 13, 2.The record already exists.Solution:The unique index for the BottomLine tables is RecID.  Run the following SQL statement on your AX database.  Replace DATABASE with the name of your AX database.IF [...]

Export AX Ledger Transactions via SQL

June 2nd, 2017|Categories: Dynamics AX 2012, SQL|

This SQL serves as a starting point to include any number of financial dimensions.SELECT GENERALJOURNALENTRY.SUBLEDGERVOUCHER as Voucher, DIMENSIONATTRIBUTEVALUECOMBINATION.DisplayValue as [Account+Dims], MAINACCOUNT.MainAccountID as [Account], DIMENSIONATTRIBUTELEVELVALUE.DisplayValue as [Dept], GENERALJOURNALACCOUNTENTRY.ACCOUNTINGCURRENCYAMOUNT as AmountMST, GENERALJOURNALACCOUNTENTRY.TRANSACTIONCURRENCYAMOUNT as AmountCur, GENERALJOURNALACCOUNTENTRY.TRANSACTIONCURRENCYCODE as CurrencyCodeFROM DynamicsAX2012.GENERALJOURNALENTRYINNER JOIN DynamicsAX2012.GENERALJOURNALACCOUNTENTRY ON GENERALJOURNALENTRY.RECID [...]

Finding invalid document handling references

May 10th, 2017|Categories: Dynamics AX 2009, Dynamics AX 2012, Dynamics AX 4.x|

static void listDocuHandling_InvalidPaths(Args _args){    DocuRef                 docuRef;    DocuValue               docuValue;    SysOperationProgress    progress;    Common                  common;    ;    setPrefix("Invalid document handling file references");    // Initialize progress indicator    select count(RecId) from docuRef;    progress = new SysOperationProgress(1, true);    progress.setTotal(docuRef.RecId);    progress.setCaption(funcname());    while select docuRef    join docuValue    where docuValue.RecId [...]

Workflow Error: Application Cannot Be Started

February 4th, 2017|Categories: Dynamics 365 Finance, Supply Chain Mgmt (AX 7, 8, 10, Operations)|

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) [...]

Determine table ID in SQL

January 10th, 2011|Categories: Dynamics AX 4.x|

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 [...]

Go to Top