Dynamics AX

• Automated Tasks in Workflow in Microsoft Dynamics AX 2012: how to configure automated tasks in a workflow
• Project Invoice Proposal Approvals in Microsoft Dynamics AX 2012 R2: how to enable/disable project invoice proposals workflow
• X++ Scenarios that are not supported in CIL
• Inventory blocking: how to prevent items currently in a warehouse from being used in standard processes, without using quarantine orders.
• Troubleshooting the product release process
• Costing and inventory closing: Tips on creating item number schemes
• AX 2012 – How to control the visibility of FactBox on form thru X++
• Fixing code caching on AX environment copies
• Picking, Registration, Reservation, Marking… What’s the difference?
• How to: Debug X++ Code in Workflow
• Dynamics AX Workflow Wanderings: Hints and Tips for Dynamics AX Workflow

Supply Chain Management

• How to Design Good Item Numbers for Products in Inventory

Solution: X++ modifications

First of all the field CustomerRef should be set to visible on the salesline, so end users can modify it. The field is already available in the AOT on the SalesLine table, it is only not visible in the form.

Next, modify the method interCompanyUpdateNow on the PurchLine table: add some code for the new field to be synchronized.

...
||  this.orig().ReturnDispositionCodeId     
        != this.ReturnDispositionCodeId
||  this.orig().ReturnStatus                
        != this.ReturnStatus
||  this.orig().MatchingAgreementLine       
        != this.MatchingAgreementLine
// BEGIN
|| this.orig().CustomerRef                  
       != this.CustomerRef
// END
    )
{
    ok = true;
}
...

public CustRefLine parmCustRefLine(CustRefLine 
                             _custRefLine = '')
{
    if (!prmisDefault(_custRefLine))
    {
        this.setField(fieldNum(PurchLine, CustomerRef), 
                                          _custRefLine);
    }

    return purchLine.CustomerRef;
}

public CustRefLine parmCustRefLine(CustRefLine 
                             _custRefLine = '')
{
    if (!prmisDefault(_custRefLine))
    {
        this.setField(fieldNum(SalesLine, CustomerRef), 
                                          _custRefLine);
    }

    return salesLine.CustomerRef;
}

...
// BEGIN
if (create ||  purchLine.fieldChanged(fieldNum(PurchLine, 
                                             CustomerRef)))
    axSalesLine.aduParmCustRefLine(purchLine.CustomerRef);
// END
...

...
// BEGIN
if (create
||  _salesLine.fieldChanged(fieldNum(SalesLine, 
                                   CustomerRef)))
    axPurchLine.aduParmCustRefLine(_salesLine.CustomerRef);
// END
...

Solution

In MS Word go to Options > Trust Center > Trust Center Settings > Protected View and uncheck Enable Protected View for files originating from the Internet.

Merge-data overview

The following merge-data elements can be added in the e-mail template. The merge-data elements can be used to inform the user about various aspects of the case.

Link the e-mail template to the case category

Start sending mails from your Cases, some data of the case will be merged into the generated e-mail message.

Solution

Some X++ modifications are needed in two Forms.

Form EventCreateRule, method modified on Field EventRule.UserId:

public void modified()
{
  super();

  // BEGIN
  eventRule_SendEmailAddress.text(
        SysUserInfo::find(EventRule.UserId).Email);
  // END
}

Form EventRule, method setControlsActive on DataSource EventRule:

...
else if (!canShowPopUpCheckBox)
{
  alertMeBy.visible(true);
  eventRule_ShowPopUp.visible(false);
  eventRule_SendEmail.visible(true);
  eventRule_SendEmailAddress.visible(true);
  // BEGIN
  //eventRule_SendEmailAddress.text(userInfo.Email);
  eventRule_SendEmailAddress.text(
    SysUserInfo::find(EventRule.UserId).Email);
  // END
}
else
{
  alertMeBy.visible(true);
  eventRule_ShowPopUp.visible(true);
  eventRule_SendEmail.visible(true);
  eventRule_SendEmailAddress.visible(true);
  // BEGIN
  //eventRule_SendEmailAddress.text(userInfo.Email);
  eventRule_SendEmailAddress.text(
    SysUserInfo::find(EventRule.UserId).Email);
  // END
}

if (eventRule.UserId == curuserid())
  eventInboxSingleton.enabled(true);
...

Solution

To make your find method work, you need to pass through the reference to the temporary table.

public static TmpAvgCubicMeterPrices find(
         ProjId                    _projId,
         InventDimCombinationName  _inventDimCombinationName,
         TmpAvgCubicMeterPrices    _tmpAvgCubicMeterPrices,
         boolean                   _forUpdate = false)
{ 
    TmpAvgCubicMeterPrices   tmpAvgCubicMeterPrices; 
    ; 

    tmpAvgCubicMeterPrices.setTmpData( 
              _tmpAvgCubicMeterPrices);

    tmpAvgCubicMeterPrices.selectForUpdate(_forUpdate);

    select firstonly tmpAvgCubicMeterPrices
       where tmpAvgCubicMeterPrices.ProjId
                                                   == _projId  
       && tmpAvgCubicMeterPrices.InventDimCombinationName
                                == _inventDimCombinationName; 


    return tmpAvgCubicMeterPrices; 
}

Solution

The cause of the problem was the SysOperationProgress class. This class can be used to inform the user about status, operation and progress of the system. It was initiated before my changecompany call and closed after it. When the progress bar created by the SysOperationProgress class was refreshed during code execution within my changecompany class, a call is done by X++ to the Docu class. This triggers also a changecompany due my original legal entity. Hence some of my code within my changecompany call was executed in the company to which I did the change, some was done in the company I originated from. And this not all of the time, as it only happened if a refresh happened of my progress bar within the changecompany call. I removed the SysOperationProgress and my problem was solved.