Fandy Xie's Blog

static void THK_importLedgerJournalTrans(Args _args){ Filename fileName = "C:\\Users\\ksiu3880\\Desktop\\GL Journal test.xlsx"; LedgerJournalId ledgerJournalId = "000425_010"; Name nameDimensionAttribute1 = "Department"... Read More

static void FAN_GLImport(Args _args){ AxLedgerJournalTable header = new AxLedgerJournalTable(); AxLedgerJournalTrans trans = new AxLedgerJournalTrans(); container ledgerDim, offsetDim; LedgerJournalNameId ledgerJournalNameId = "GeneralJR"; Dimen... Read More

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 Read More

SQL复制表的几种方法：仅复制表结构：select * into newTableName from OldTableNamewhere 1 = 2SQL复制整张表 select * into NewTableName from OldTableName只复制列名而不要内容 select * int... Read More

when you install windows 7 OS, the system ask for you enter username and password, then you have not enterany infomation.and press "shift + F10" popup dos windows,finally you enter below dos commad　ROBOCOPY "C:\Users" "D:\Users" /E /COPYALL /XJRMDIR "C:\Users" Read More

In this post, I will take you through a very simple functionality called the intercompany accounting in dynamics AX 2012. This is a simple walk through of the setup required to be able to do intercompany transactions and also we will post and verify the ledger updates for an actual intercompany tran Read More

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 Read More

Below is the small code snippet to get the underlying query of the SSRS report, reset query, prompt the parameters form, add our own ranges and execute the report. You can customize the job as per your requirements. Below I have used CustBaseData.Report report and added my own range on customer grou Read More

在AX2012的Form开发中，微软引入了新的控件ReferenceGroup，它用在Lookup其他表RecId的时候显示更人性化的字段，它的使用还必须从表的索引说起。AX2012的表有这些索引（http://msdn.microsoft.com/en-us/library/hh812105.aspx）：Primary key：主键用来唯一标识一条纪录，比如InventTable的ItemIdx索引，包含ItemId字段，用它标识唯一的一个物料，AX2012要求主键必须只有一个字段，当然必须是唯一的。Alternate Key：可以包含多个字段且索引必须是唯一的，其属性AllowDuplic Read More

1.//Create party for the vendorpublic void createParty(VendorRequestCreate _vendorRequestCreate){ ; if(_vendorRequestCreate.DirPartyType == DirPartyBaseType::Person) { dirPerson.Name = _vendorRequestCreate.VendorName; dirPerson.NameAlia... Read More