Dynamics AX 2012
mahailiang
2008年结缘于AX......
展开
-
字段值的另类写法
_record.(fieldNum(InventTable,ItemId)) == "1000"效果等同于:inventTable = _record;inventTable.ItemId == "1000";原创 2017-07-04 09:33:40 · 714 阅读 · 0 评论 -
AX功能索引(Dynamics AX 2012 R3 CU12)
1. 将文件拖到此处 应收账款-常用-收款-收款-明细-点击Grid中的文档小图标2. 树状打印设置 应付账款-设置-窗体-表格设置-常规-打印管理3. 在Excel中编辑 应收账款-日记帐-价格/折扣-价格/折扣协议日记帐-行-在Exel中编辑4. Grid中全选复选框 应收账款-日记帐-付款-付款日记帐-输入客户付款5. 图形化展示数据原创 2017-10-09 14:32:54 · 1273 阅读 · 0 评论 -
双击消息打开窗体
SysInfoAction_FormRun infoAction;infoAction = SysInfoAction_Formrun::newFormname(formStr(LedgerJournalTable)); infoAction.parmCallerBuffer(ledgerJournalTable); info(str原创 2017-11-01 11:32:59 · 346 阅读 · 0 评论 -
安装AX2012R3流程
承接了一个任务,把一个环境的Dynamics AX 2012 R3转移到一个全新的环境中。中间因一些误操作,给完成任务带来了很多麻烦。特纪录下来,以防下次再犯。(两个环境域名不一致,A, B 这也给安装的过程带来了一些的麻烦,尤其是报表的部署。)虚拟机:Hyper-V操作系统: Windows Server 2012 R2报表工具:Visual Studio 2013(AX 201原创 2017-09-01 14:36:02 · 1535 阅读 · 0 评论 -
客户信用额度
SalesTable下新建方法void custCreditLimit(CustAccount _custAccount){ CustCreditLimit custCreditLimit; AmountMST balance; AmountMST orderBalance; CustTable custTable原创 2017-09-14 14:16:07 · 1012 阅读 · 0 评论 -
SSRS编译异常中断解决办法
AX2012中在做“生成完整的CIL”时,如果出现中途断掉,动作未执行完毕,那么在很多报表访问时会出现如下错误:Display order key must be a number between 0 and 99999.The [ReportName].getAttributes() reflection API could not create and return the S原创 2016-07-25 12:36:14 · 567 阅读 · 0 评论 -
AX2009 销售订单的不同情况生成不同的订单号
View Code class FormRun extends ObjectRun{RGD_SalesorderSourse SalesorderSourse ;} 有很多客户习惯了EXCEL,在他们使用AX的时候,习惯的先在EXCEL将销售,采购订单创建好,然后直接导入到AX系统中,客户有时想区分系统中地销售,采购订单是在标准系统创建的转载 2017-11-21 10:46:58 · 695 阅读 · 0 评论 -
AX调用.dll
1,将DLL拷贝到C:\Program Files (x86)\Microsoft Dynamics AX\50\Client\Bin2,在AOT添加引用,在选择你拷贝的DLL,确定。//Accessibility3,调用JOB如下static void Job79(Args _args){ InteropPermission perm转载 2017-11-21 10:53:53 · 570 阅读 · 0 评论 -
AX2012 常用表关系(客户地址,联系信息)
//客户地址信息static void CustAddressInformation(Args _args){ CustTable custTable; DirPartyTable dirPartyTable; DirPartyLocation dirPartyLocation; LogisticsL转载 2017-11-21 11:00:25 · 1905 阅读 · 0 评论 -
分割采购订单
将采购订单分割为数量为1的行:static void SplitPurchLine(Args _args){ PurchQty qty; PurchTable purchTable; PurchLine purchLine; purchTable = PurchTable::find("PO-0001");原创 2017-11-16 11:09:58 · 288 阅读 · 0 评论 -
AX代码调用打印机
Form Button:void clicked(){ PrintJobSettings printJobSettings; ; super(); printJobSettings = new PrintJobSettings(GUIParameters.PrinterSetting); printJobSettin原创 2017-10-13 15:49:43 · 488 阅读 · 0 评论 -
使用Management Host Control
OverviewManaged host control in Microsoft Dynamics AX 2012 is used to host a .NET or WPF control on a Microsoft Dynamics AX form. It is used to enhance the usability of the application and provides转载 2017-10-10 17:12:42 · 702 阅读 · 0 评论 -
临时表Lookup数据源
...sysTableLookup.parmQuery(query);sysTableLookup.parmTmpBuffer(TmpTableFieldLookup);sysTableLookup.performFormLookup();原创 2017-09-09 17:04:43 · 248 阅读 · 0 评论 -
DynamicsPerf 2.0 Deployment Guide
INTRODUCTIONThe tool DynamicsPerf (Performance Analyzer for Dynamics) is used by Microsoft Dynamics Support team, Premier Field Engineers and Product Group team members to diagnose performance iss转载 2017-07-06 16:17:27 · 450 阅读 · 0 评论 -
AX 2012 SSRS Failed-tempuri.org
report in AX 2012 that use SSRS are vendors, transaction list in general journalsometimes you’ll found an Error in AX 2012 like the picture below,The formatter threw an exception while trying to转载 2017-07-17 16:51:46 · 560 阅读 · 0 评论 -
币种金额转换
static void calcAmountMST(Args _args){ CurrencyExchangeHelper helper; helper = CurrencyExchangeHelper::construct(); helper.parmExchangeDate(syste原创 2017-04-18 10:58:14 · 922 阅读 · 0 评论 -
用DefaultDimension获得某成本中心的值
// 用DefaultDimension获得某一个成本中心的值。// 用法:getDimensionValueTID(common.defaultDimension, "Center");public static str 255 getDimensionValueTID(RecId defaultDimension, Name dimName){ DimensionAttr原创 2017-08-01 15:05:41 · 249 阅读 · 0 评论 -
取得不同类型的客户地址
public static LogisticsPostalAddress getPostalAddressByType(DirPartyRecId _party, LogisticsLocationRoleType _type){ DirPartyLocation partyLocation; DirPartyLocationRole partyLoca原创 2017-08-02 18:20:30 · 253 阅读 · 0 评论 -
Vend Aging Report数据存储转换图
AX Version: Dynamics AX 2012 R3原创 2017-07-27 17:38:26 · 286 阅读 · 0 评论 -
Ax 2012批量部署报表
1. 在管理工具中右击“Microsoft Dynamics AX 2012 Management Shell” 选择"Run as administrator".2. 进入根目录:PS C:\3. 输入:Publish-AXReport –ReportName *原创 2017-08-25 13:32:19 · 787 阅读 · 0 评论 -
重新索引Model数据库
USE MicrosoftDynamicsAX_model;DECLARE @name varchar(100) DECLARE authors_cursor CURSOR FOR Select [name] from sysobjects where xtype='u' order by id OPEN authors_cursor FETCH NEXT FROM au原创 2017-08-25 18:49:41 · 202 阅读 · 0 评论 -
AX 2012 MultiSelectionHelper (取多条记录)
Args args; FormRun formRun; MultiSelectionHelper selection; SNY_CustConsInvoice_Input CustConsInvoice_Input; ; args = new A转载 2017-09-15 16:50:03 · 372 阅读 · 0 评论 -
insert_recordset 临时表
在lookup或者类中,用insert_recordset方法向临时表插入数据后,需要用select tmpTable来初始化临时表的buffer,数据才可以正常呈现。如:public static void lookupRate(FormStringControl _contrl, TNK_ToRisk_C原创 2017-12-11 17:48:36 · 451 阅读 · 0 评论 -
取得税率Code和税率的值
取得税率Code:public static TaxCode taxCodeFromSalesLine(SalesLine _salesLine){ TaxGroup taxGroup; TaxItemGroup taxItemGroup; TaxGroupData taxGroupData; TaxOnI原创 2017-12-14 14:06:34 · 584 阅读 · 0 评论 -
获得员工部门
UserId userId = curUserId();info(HcmWorker::find(DirPersonUser::findUserWorkerReference(userId)).primaryDepartmentName());原创 2017-12-17 15:22:05 · 179 阅读 · 0 评论 -
按站点计算现有量
void getAvailQty(Args _args){ InventOnhand inventOnHand; InventDimParm inventDimParm; InventQty availQty; ; itemId = YOURITEMID; inventDim.inventSiteId = YOU...原创 2018-08-14 16:30:59 · 265 阅读 · 0 评论 -
AX2012环境转移数据库提示错误
Object Server 01: Fatal SQL condition during login. Error message: "The internal time zone version number stored in the database is higher than the version supported by the kernel (10/7). Use a newer...原创 2018-08-21 21:54:14 · 518 阅读 · 0 评论 -
生成DefaultDimension的值并更新CustTable
生成DefaultDimensionstatic void CreateDefaultDimension(Args _args){ DimensionAttributeValueSetStorage valueSetStorage = new DimensionAttributeValueSetStorage(); DimensionDefault ...原创 2018-09-04 14:29:10 · 261 阅读 · 0 评论 -
MainAccount获得LedgerDimension
void MainAccountNum2LedgerDimension(MainAccountNum _MainAccountNum){MainAccount mainAccount = MainAccount::findByMainAccountId("1108040");container myContainer;LedgerDimensionAccount LedgerDimens...原创 2018-09-22 21:53:53 · 281 阅读 · 0 评论 -
获得Query中用户输入的查询条件
SysQuery::findOrCreateRange(SysQuery::findOrCreateDataSource(queryRun.query(), tableNum(GeneralJournalEntry)), fieldNum(GeneralJournalEntry, AccountingDate)).value() ; SysQuery::findOrCreateRange(...原创 2018-10-28 10:53:27 · 854 阅读 · 0 评论 -
LedgerDimension相关函数
As we know that Microsoft Dynamics AX 2012 has all new financial dimension framework and which is a really good enhancement in AX but for developers it is bit complex at the same time if you try handl...转载 2019-04-16 13:01:53 · 918 阅读 · 0 评论 -
查看会计期间是否打开
FiscalCalendars::checkLedgerPeriodDateModule(Ledger::fiscalCalendar(), inventCountingTable.CountingDate, SysModule::Ledger, false);原创 2019-04-18 10:52:09 · 744 阅读 · 0 评论 -
判断某个维度值是否存在
public static boolean exitsDimension(OMOperatingUnitType _omOperatingUnitType, //运营单位类型 OMOperatingUnitNumber _omOperatingUnitNumber, //运营单位编号 ...原创 2019-05-15 10:44:09 · 325 阅读 · 0 评论 -
AX2012 代码创建产品信息
static void UploadProductMaster(Args _args){ CommaTextIO csvFile; container readCon; counter icount,inserted; Dialog ...原创 2019-05-13 15:34:49 · 576 阅读 · 0 评论 -
单位转换
protected Qty Convert(Qty _QtyBatch,ItemId _itemId,SalesUnit _itemUnit,SalesUnit _salesUnit ){Qty salesQty;salesQty = UnitOfMeasureConverter::convert(_QtyBatch,UnitOfMeasure::unitOfMeasureIdBySym...原创 2018-06-24 15:04:34 · 2047 阅读 · 0 评论 -
get Dimension fields
VendTrans_ds.object(fieldId2Ext(fieldNum(VendTrans, Dimension), 2)).validate();原创 2018-05-13 10:22:16 · 162 阅读 · 0 评论 -
AlwaysOn – Example AX TEST environment configuration concepts and points of interest
Consider a scenario where you are running AX 2012 and your Dynamics AX databases are part of a SQL Server AlwaysOn Availability Group (AG). I’ll discuss some concepts and points of interest below whic转载 2017-12-27 10:39:49 · 508 阅读 · 0 评论 -
编译PayrollTaxEngineUtil错误
在进行到编译应用时“Compile application”出现很多错误:SeverityPathLineColError messageError\Classes\PayrollCalculatePayStatementBenefits\classDeclaration125Syntax er转载 2018-01-12 10:26:49 · 248 阅读 · 0 评论 -
调用bing上地图
smmUtility::mapIt(LogisticsPostalAddress::findByLocation(logisticsLocation.RecId));原创 2018-01-22 11:50:08 · 1596 阅读 · 0 评论 -
给display字段增加筛选功能
给display字段增加筛选功能void context(){ int selectedMenu; real test; formrun fr; Args ag; Itemname strtext; querybuilddataSource qb1; queryrun qr; query q; PopupMe转载 2018-01-17 09:43:56 · 284 阅读 · 0 评论