Dynamics AX

• Dynamics AX: On Hand Inventory: Table describing the information in Items On hand form
• Troubleshooting Upgrade and CU Batch jobs stuck in a waiting status in Dynamics AX 2012
• Test Data Transfer Tool (beta) for Microsoft Dynamics AX 2012 [AX 2012]: The Microsoft Dynamics AX 2012 Test Data Transfer Tool (beta) (DP.exe) is a command-line tool that exports data from a Microsoft Dynamics AX 2012 business database in a production or non-production environment. The tool also imports data into a Microsoft Dynamics AX 2012 business database in a non-production environment. The non-production environment can be either a development or test environment.
• Dynamics AX 2012 Excel Add-in - Issues and Solutions (Method UpdateRecIdVisibility not found): The purpose of this post is to outline some issues you may encounter when using Dynamics AX 2012 Excel Add-in for import of data and provide solutions to resolve them.
• Overview of Microsoft Dynamics AX build numbers
• Deploy the default cubes [AX 2012]: Microsoft Dynamics AX includes a default project for Microsoft SQL Server Analysis Services that you can deploy. This project includes analysis cubes that you can use. You can deploy the project, and the cubes that it contains, by using either the Analysis Services Project Wizard or Windows PowerShell. The procedures explain how to use both methods.
• Walkthrough: Analyzing Cube Data in Excel: You can analyze data by using Microsoft Office Excel to connect to a Microsoft Dynamics AX OLAP cube.

Project Accounting

• Accruals

Functionality

What it does is, when you create a project purchase order, it creates automatically for you a marked item requirement on the project purchase order (and not anymore the annoying virtual inventory transaction which makes upon receipt of the project purchase order, items are consumed immediately on the project).

Upon receipt of your project purchase order, the popup still comes where you can choose to consume the items immediately, but you don't need to do it. Making it possible to ship actually after receipt of your project purchase order, your goods on a latter moment in time and keep it in between in your warehouse (and probably break the marking and reservation so you can use the bought goods for another more urgent project).

Changes in AX 2012 R2

The Item requirements form moved from the Manage to the Plan tab in the ribbon.

You can create Sales orders of Order type Item requirements. As consequence, you can create as many Item requirements Sales orders as you want on the same project. Hence you could group your Item requirements based on Delivery date, and also if that group of item requirements changes of Delivery date, you can simply adapt it on the Sales order heading in stead of having to do it Order line by Order line.
Although you can create Sales orders of Order type Item requirements, you still can’t post the Packing Slip from the Project sales orders form: you still can only book it on the Item requirements form.

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.