Alfasith AX

Alfasith AX
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا

Sunday, April 13, 2014

Job to copy all the record from one table to another in Dynamic AX

Hi,

// Copy data from one table to another using job
static void CopyData(Args _args)
{
    CustTable custTable ;
    DuplicateTable duplicateTable ;
    ;
    ttsBegin;
    while select custTable
    {
        buf2Buf(custTable ,duplicateTable );  
        duplicateTable.insert();
    }
    ttsCommit;
}

Regards,

Saturday, April 12, 2014

AX 2012 CIL generation / Err: 351

Hi,

Following step gives optimum solution.

1. Stop the AOS.
2. Delete all of the source in the C:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\bin\XppIL directory.
3. Start the AOS.
4. Perform a full CIL generation.

Regards,

Get a table ID in SQL - D365

Hi select ID from SysTableIdView where  SysTableIdView .Name = 'CustTable' Regards,