FormLetter Framework

The formletter framework in Microsoft Dynamics AX is used when posting documents for sales or purchase orders. The framework has been refactored in Microsoft Dynamics AX 2012 to provide better support for customizations, extensibility, and performance.

If you have to create new custom field in Purchase order and required

flow it to all table as FormLetter work. Follow these steps.

Create new field let say 'Remarks' in following tables.

1. PurchTable
2. VendInvoiceInfoTable
3. VendInvoiceJour
4. PurchParmTable

Add an assignment for your new field in  VendInvoiceJour Table Method 'initFromPurchTable'

this.Remarks                = PurchTable.Remarks;

Now create abstract class in AXVendDocumentTableMap class

public abstract Name parmRemarks(Name _remarks = '')

{

}

After this you will need to create two method in VendDocumentTableType classs

As shown below.

protected Name determineDefaultRemarks()

{

    Name remarks;

    remarks = this.purchTable().Remarks;

    return remarks;

}

protected void defaultRemarks()

{

    Name remarks;

    ;

    if (!this.axVendDocumentTableMap().isTableFieldSet(fieldnum(VendDocumentTableMap, Remarks)))

    {

        remarks = this.determineDefaultRemarks();

        this.axVendDocumentTableMap().parmRemarks(remarks);

    }

}

Now register new field in 'VendDocumentTableMap' TableMap  and create its mapping in PurchParmTable and VendInvoiceInfoTable.

Finally add an assignment in PurchFormLetterParmData class as shown below.

parmTable.Remarks= localPurchTable.Remarks;

Unit Of Work Implementation in Dynamics AX

Unit of Work is a new framework , which is being introduced in AX 2012.

It is use to commit number of records in a single Transaction.The main reason for introducing unit of work is that it is impossible to insert the lines table record before its header table  because there is a relation between the header table and the lines table.The Recid of the header table is comes as a foreign key in the child table.

Now we dont have to hold the recid of parent table and also we can insert all data in a single trip . How., Let us Implement this :

1. Create 2 table SKUHeader and SKULine.
2. SKULine is related to SKUHeader by RecId.
3. Go to relation of table and make sure property CreateNavigationPropertyMethods = True by making this property true , system will add appropriate methods to table SKULine
4. create a class as shown blow.

         public class SKUUnitOfWork

        {

           }

   

    5. Now create a method, remember UnitofWork will always used on server

public server static void main(Args args)
{
    SKUHeader                      skuHeader;
    SKULine                        skuLine;

    int                            mycount;
    int                            mycount2;

    UnitofWork unitofWork = new UnitofWork();

    for(mycount=0; mycount<10; mycount++)
    {
     //insert data in parent table
        skuHeader.clear();
        skuHeader.GroupName = 'ProductGroup_' + int2str(mycount+1);
        unitofWork.insertonSaveChanges(skuHeader);

        for(mycount2=0; mycount2<10; mycount2++)
        {
            //insert data in child table
            skuLine.clear();
            skuLine.ProductName = 'Product_' + int2str(mycount2+1);
            skuLine.ProductPrice = int2str(mycount2+1 * 5);
            skuLine.SKUHeader(skuHeader);
            unitofWork.insertonSaveChanges(skuLine);
        }
    }
    //Now insert data in a single trip
    unitofWork.saveChanges();

    info('Done');
}

    6. Finally generate a action type menuItem for SKUUnitOfWork class.

you have done. as you will execute menuItem it will call the main method of the class.
see complete snapshot.