- Oct 27 Wed 2021 11:09
-
[D365] SysQuery
- Oct 15 Fri 2021 11:54
-
[D365FO] COC FORM BUTTON IN D365 CHAIN OF COMMAND
COC FORM BUTTON IN D365 CHAIN OF COMMAND
Yes with the new version it is possible to have a COC on a form BUTTON IN D365 .
It has the similar syntax as we use to follow as shown below.
[ExtensionOf(formControlStr(FormToExtend, Button1))]
- Jun 02 Wed 2021 16:14
-
[Dynamics AX/365] 在Dialogs 內加入自訂Lookup 功能
class CustomizedLookup extends RunBase
{
DialogField fieldAccount;
CustAccount custAccount;
DialogField dialogField , dialogText1, dialogText2, dialogText3 , dialogText4;
- Jan 18 Mon 2021 14:25
-
[Excel] 加入developer VB Code && 將幾萬條RECORD 分開不同SHEET 再分開不同XLS

加入developer VB Code
- Dec 30 Wed 2020 10:48
-
[Dynamics AX/365] Postal Address SQL
Below are the sample queries to get the vendors and customers addresses and contact details. Change the code according to your requirement.
All Vendors
SELECT * FROM VENDTABLE WHERE VENDTABLE.DATAAREAID='CEU'
All Addresses - Vendor
SELECT * FROM DirPartyPostalAddressView JOIN VENDTABLE ON DirPartyPostalAddressView.PARTY =VENDTABLE.PARTY
- Dec 03 Thu 2020 14:08
-
[Dynamics AX/365] 簡易解開Workspace LOCK

1. 找尋workspace, server 的資料:
C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE>TF.exe workspaces /owner:* /computer:*
也可以:
tf workspaces /owner:* /computer:COMPUTERNAME /collection:http://TFSSERVER:8080/tfs/COLLECTIONNAME
2. Delete workspace from server:
- Nov 10 Tue 2020 15:33
-
[Dynamics AX/365] 如何自定義標準EXCEL模板 - Customize standard excel template

目的: 加financial dimension 入去excel template
1. 第一, 要先將自家的financial dimension 加入ODATA (之前有篇教學)
Visual Studio → Dynamics365 → Addins → Add financial dimensions to Odata option to seperate the financial dimensions to Odata option to seperate the financial dimensions into different columns
2. 在standard Excel Template 下做更新:
The standard Excel templates can be accessed from Organization Administration → Setup → Office → Integration → Document Templates.
- Nov 03 Tue 2020 15:14
-
[Dynamics AX/365] 用SQL 尋找AXDB 內table id, field id...
Table name from table id
以下語句返回數據庫中 table id 9669的名稱,如上所述,我們正在尋找field id 為0的行。
- Oct 30 Fri 2020 15:21
-
[Dynamics AX/365] Create a Cloud Hosted D365 for Operations Environment創建用於操作環境的雲託管D365

- Openlcs.dynamics.comin your web browser.
- Log in with your credentials.
- Select theLCS projectyou want to add a Azure subscription to from the list.
- Click theHamburgermenu button.
- SelectCloud-hosted environmentsfrom the list.
- Oct 30 Fri 2020 10:45
-
[Dynamics AX/365] CompView 例子
public class InventSum_View extends common
{
private static str prepareInventPhyStr(str key)
{
#define.ViewName(InventSum_View)
- Oct 22 Thu 2020 09:27
-
[Dynamics AX/365] Event 合集
[DataEventHandler(tableStr(CustTable), DataEventType::Inserting)]
public static void CustTable_onInserting(Common sender, DataEventArgs e)
{
CustTable custTable = sender as CustTable;
custTable.inventSiteId = InventParameters::find().DGS_MainInventSiteId;
- Oct 20 Tue 2020 15:58
-
[Pixnet] 簡單將CODE 加入PIXNET!
