GuanXX的专栏

在文本中粘贴以下代码另存为XPO文件即可导入AX中Exportfile for AOT version 1.0 or laterFormatversion: 1***Element: CLS; Microsoft Business Solutions-Axapta Class: SysMultiTableLookup unloaded at Monday 9/22/2008; ----------

申明:con += [["a","b"]];取值:str a,b;[a,b] = conPeek(con,1);

 在ProdTable中有多个动作会对ProdTableJour进行更改，如：物料消耗工艺路径消耗完工入库成本计算下面将举例说明物料消耗主要类的调用情况:ProdJournalCheckPostBOM -> ProdJournalCheckPost.Main -> JournalcheckPost.Run -> JournalCheckPost.runPost ->

类:ProjectNode 可以用这个类获取Project的相关信息，比如创建人，创建时间等等...表:UtilElements 存放AOT中的表，窗体，类的创建人，创建时间，修改人，修改时间等相关信息...static void testAOT(Args _args){ ProjectNode node; TreeNodeIterator i; TreeNode subNode; void fin

<br /> <br />public class ReportRun extends ObjectRun<br />{<br />    FormDataSource      fds;<br />    FormRun                    fr;<br />    Common                    common;<br />    InventJournalName  ijn;<br />}<br /><br />public void init()<br />{

Open SysSetupFormRun in AOT, and override its run() with the following code:public void run(){;super();this.design().colorScheme(FormColorScheme::RGB);this.design().backgroundColor(WinAPI::RG

除了使用View:DefaultDimensionView之外，我们还可以使用下面的方式取得维度的内容http://axinternals.blogspot.com/2011/09/default-dimension-storage-in-ax-2012.htmlstatic void ShowVendDefaultDimensions(Args _args){

来源：http://sumitsaxfactor.wordpress.com/2011/12/16/getting-individual-dimension-combination-valuesdimension-storage-class-ax-2012/static void getDimensionCombinationValues(Args _args) {

X++ CODE TO GENERATE ALERT FOR RECORD IN DAX 2011EventInbox andEventInboxData are two tables which will store the data related to alerts.So one can easily generate alert by creating a re

最近在安装AX 2012 Retail Pos 的时候碰到一个奇怪的问题，发现物料没有同步到Retail DB中去，谷歌来谷歌去终于发现一个别人的解决方法，抄过来用用~~~Dynamics AX 2012 for Retail: Items not showing in POSI recently came across a case where items were no

void importSize(){ #File Filename filename;// = @'C:\Desktop\AX2012.txt'; CommaTextIo iO; Dialog dialog = new Dial

void createVariants(){ ecoResDistinctProductVariant ecoResDistinctProductVariant; EcoResProductVariantDimensionValue EcoResProductVariantDimensionValue; RefRecId

static void Job7(Args _args){    InventTable     inventTable;    ;    select InventTable where inventTable.ItemId Like B*;    while (inventTable)    {        info(inventTable.ItemId);        n

 static void ExpressionsInQueryRanges_2(Args _args){    Query                       q;    QueryRun                    qr;    QueryBuildDataSource        qbd;    QueryBuildRange             qbr;    Inv

Here are some sample jobs:Simple select statement examplestatic void selectExample(Args _args){CustTable custTable;int counter;;select * from custTable;while(custTable.AccountNum){print custTable.Name

findRange:        qbr = qbs.findRange(fieldnum(InventTable , ItemId));        qbr.value("B-pack2");        替换之前的查询条件.addRange:        qbr = qbs.addRange(fieldnum(InventTable , ItemId));       

Not Like in Dynamics AX In X++, we can use Like *someIdentifier to implement the Like keyword.e.g.     select firstonly purchTable        where purchTable.purchId like 00007*; However

    inventDimParm.initFromQueryAutoSumFields(qbdsOldDim);    inventDimParm.initFromQueryBuildRange(qbdsOldDim);    inventDimParmTmp.initItemDimAllGrp();    inventDimParm = InventDimParm::orParms(inven

 供参考：public void displayOption(Common _record, FormRowDisplayOption _options){    LedgerJournalTrans localJournalTrans;    ;    localJournalTrans =  _record;    super(_record, _options);    if

delete action 4个选项的意思: NONE:该delete action失效. Cascade:删除该行相关表的行,主要用户具有主从表关系的表中,比如删除主表,从表的相应的数据也删除;注意两点:该方法在delete的super()方法中执行,该方法的执行在一个tts中;Restricted:若相关表存在相关记录,则不能删除,比如有交易记录的话,就不能删除相应的customer.

有是需要几个字段联合起来做条件，可以使用以下方法：static void AX_Sql(Args _args){    PurchLine       purchLine;        while select purchLine        where purchLine.PurchPrice + purchLine.LineAmount == 18    {        info(s

取出字符串中的字符如下列代码：strKeep("ABCAD","A")return "AA"  

static void Job3(Args _args){    LoginProperty   LP ;    OdbcConnection  dbConn;    Statement       sqlStatement;    Statement       sqlS;    ResultSet       sqlResult;    ;    LP = new LoginPropert

 server static void JobSQL(Args _args){    Connection  c;    Statement   s;    ResultSet   r;    SqlStatementExecutePermission   permission;    str         sql;    str         gy;    ;    gy = "

 static void Job18(Args _args){       Form                     form;       FormRun                  formRun;       Args                     args;       FormBuildDesign          formBuildDesign;      

第一步：配置表Basic > Setup > Data Crawler > Table Setup    第二步：启用搜索Basic > Setup > Data Crawler > Data Crawler  试试看是不是可以找到你想要的东西了，呵呵

static void TEC_BuildDefaultDimension(Args _args){ DimensionAttributeValueSetItemView dimAttrValueSetItemView,dimAttrValueSetItemView_Header; DimensionAttributeValueSetStorage dimAttrValue