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,

SQL code to upate one Legal entity banner to all the legal entity in D365

 Hi, update companyimage set  companyimage.Image  = companyimageA.Image  from  ( select Image from companyimage where dataAreaid = 'USF...