March 19, 2015

X++ code to get AssestId in AX 2009

static void assetIdCheck(Args _args)
{
     LedgerTable     ledgerTable;
     LedgerTrans     ledgerTrans;
     AssetTrans      assetTrans;
     ;
     select AssetId from assetTrans
     join ledgerTrans join ledgerTable
     where assetTrans.Voucher == ledgerTrans.Voucher && ledgertrans.AccountNum == '110110';

     info (assetTrans.AssetId);
     info (ledgerTrans.AccountNum);

}


No comments:

Post a Comment