- Jun 24 Wed 2020 15:30
[Dynamics AX/D365] 在Query Range 內加入methods
- Jun 23 Tue 2020 15:17
[Dynamics AX/D365] Data Management - 完整加data entity
- Jun 23 Tue 2020 11:58
[Dynamic AX/365] 在SQL中間加入if else使用
CustTable custTable;
boolean a = false; //this boolean a might be changed to true
Query query;
QueryRun queryRun;
Querybuilddatasource qbds;
QuerybuildRange qbr;
Query = new Query();
qbds = query.addDatasource(tablenum(CustTable));
qbr = SysQuery::findOrCreateRange(qbds, (fieldnum(CustTable, AccountNum)));
if (a == true)
{
qbr.value(queryvalue("DEMO-0001"));
}
else
{
qbr.value(queryvalue("DEMO-0002"));
}
QueryRun = new QueryRun(query);
while (queryRun.next())
{
custTable = queryRun.get(tablenum(CustTable));
info(strfmt("AccountNum %1", custtable.AccountNum));
}
- Jun 15 Mon 2020 10:21
[Dynamic AX/D365] 在website link 中取得parameter value
// Get email template from URL
URLUtility urlUtility = new URLUtility();
- Jun 11 Thu 2020 17:30
[Dynamics AX/365] Mobile Work Process
1. 加新work user:
- Jun 03 Wed 2020 15:19
[Dynamics 365] 根據UserInfo的Locale 來計算datetime format sequence
- May 15 Fri 2020 17:20
[Dynamics AX/365] Error Log Exception
SysInfoLogEnumerator infoLogEnum;
SysInfologMessageStruct infoMessageStruct;
- Apr 21 Tue 2020 10:15
[Dynamic AX/D365] Procurement Category && Attribute Type by X++
//procurement attribute
// find or create brand value
- Apr 21 Tue 2020 10:12
[Dynamics AX/365] AX - 通過X ++創建產品並發布產品 (AX2012 && D365 Code)
- Apr 08 Wed 2020 10:44
[Dynamics AX/365] Add dimensions & dimensions lookup to Excel templates
The Excel integration is one of the powerful tools in Microsoft Dynamics 365 for Finance and Operations. This is helpful tool for accountants to push journal entries through Excel to Microsoft Dynamics 365 for Finance and Operations. The out of the box Excel integration does not have the financial dimensions values, but it could be exposed to the Excel integrations. Of course, the importance of financial dimensions specially the entry will be validated based on the account structure setup.
This blog post will illustrate step by step how to Expose the Financial dimensions on Excel integration. This will need to follow certain steps on Dynamics 365 for Finance and Operations client, Visual Studio, and Excel.