随笔分类 - X++
摘要:1、创建盈亏日记账 // Copyright (C), 2021, CEU Co., Ltd. // USR Changed by 2021-09-24T16:33:07 谢宇帆 // Version : 1.0 // Description : // Return : static void Lo
阅读全文
摘要:For simple user operation posting packing slip with purchase order. we added a function button onQuality Orders Form.// VAR Changed by Xie Yu Fan.Fandy 谢宇帆void YIP_PostPurchPackingSlip(){ PurchFormLetter_PackingSlip purchFormLetter; SysQueryRun chooseLinesQuery; PurchParmUp...
阅读全文
摘要:// VAR Changed by Xie Yu Fan.Fandy 谢宇帆static void XIE_FindMenu(Args _args){ Dialog dlg = new Dialog("搜索菜单名称"); DialogField dlgName = dlg.addField(typeId(name)); name menuName; void findMenu(SysDictMenu _sysDictMenu, name _MenuName, str _path = "" ) { SysMenuEnum...
阅读全文
只有注册用户登录后才能阅读该文。
摘要:findLastColumnint findLastColumn(SysExcelWorksheet _sysExcelWorksheet, boolean _data = true){ #Excel #define.Star('*') SysExcelRange sysExcelRange; int ret;; sysExcelRange = _data ? _sysExcelWorksheet.cells().range(#ExcelDataRange) : ...
阅读全文
摘要:For set dynamic height for controls in reporton executeSection method:method 01 real maxHeight; str maxStrValue = this.maxStrControlName(); ReportStringControl maxStrControl = element.design().controlName("maxStrControlName");; maxHe...
阅读全文
摘要:To refresh datasource args caller, you must add override method close on form like source code below :public void close(){ FormRun callerForm; ; callerForm = element.args().caller(); callerForm.dataSource().reread(); // callerForm.dataSource().refresh(); // -1 means...
阅读全文
摘要:To get financial dimension value from worker position, add a new method inhcmWorkerTable with script like below:public static str getDimensionValue (HcmWorkerRecId _workerRecId, Name _DimensionName, utcdatetime _asOfDate = DateTimeUtil::utcNow()){ DimensionAttribute...
阅读全文
摘要:1. Add a new method inhcmWorkertable, and add this script :public static client void lookupWorkerByLegalEntity(FormStringControl _lookupctrl, Int64 _LegalEntity){ SysTableLookup sysTableLookup; Query query = new Query(); QueryBuildDataSource qu...
阅读全文
摘要:static void THK_importLedgerJournalTrans(Args _args){ Filename fileName = "C:\\Users\\ksiu3880\\Desktop\\GL Journal test.xlsx"; LedgerJournalId ledgerJournalId = "000425_010"; Name nameDimensionAttribute1 = "Department"...
阅读全文
摘要:static void FAN_GLImport(Args _args){ AxLedgerJournalTable header = new AxLedgerJournalTable(); AxLedgerJournalTrans trans = new AxLedgerJournalTrans(); container ledgerDim, offsetDim; LedgerJournalNameId ledgerJournalNameId = "GeneralJR"; Dimen...
阅读全文
摘要:Today I want to talk about executing SQL statements in X++ on both the currentAX database and external databases. This is something probably every AX developer will have to do at some point.You’ll want to do this for many reasons; to execute stored procedures, to improve performance, to get data fro
阅读全文
摘要:Common requirement is to show the reports in customer’s language.[example : Quotations, sales confirmations, invoices, Free text invoices, Return order acknowledgements , Agreements, Purchase order confirmations etc].This was easily achievable in Dynamics AX 2009 reports by usingelement.design().lan
阅读全文

浙公网安备 33010602011771号