- Nov 15 Thu 2018 17:45
[Dynamic AX/D365] Export file to CSV
- Nov 13 Tue 2018 13:46
[Dynamic AX] Array
str name;
Array Arr = new Array (Types::String);
int i= 1, j;
Int test;
TestTable TestTable;
;
// Create an Str array
// Write some elements in it
while select TestTable
{
Arr.value(i, TestTable.TestTables);//(i, i*2);
i++;
}
j = i;
for (i = 1; i<j; i++)
{
test= Arr.value(i);
while select TestTable where TestTable.TestTables == test
{
info(strfmt("%1", Arr.value(i)));
}
}
- Nov 05 Mon 2018 10:49
[Dynamic AX/365 ] Return Order
Return order:
Return order is the process in which customers return items that they have purchased.
Example:
Customer might return items if it is defective or if it was received incorrectly. You need to create a return order in ax before receiving items back from the customer.
Steps to create Return order in AX 2012:
1. First step is to find invoiced sales order against which return order is getting created.
.
- Nov 02 Fri 2018 16:44
[Dynamic AX / 365] Form Event handler 內找回 Query - addLink, addRange, addOrderByField
| /// <summary> | |
| /// Hooks on Initialized event of the <c>EcoResProductVariantFlavorDisplayOrderView</c> form data source and adjusts data source query. | |
| /// </summary> | |
| /// <param name = "_sender">The data source object that triggers the event.</param> | |
| /// <param name = "_e">Event arguments.</param> | |
| [FormDataSourceEventHandler(formDataSourceStr(EcoResProductVariants, EcoResProductVariantFlavorDisplayOrderView), FormDataSourceEventType::Initialized)] | |
| public void ecoResProductVariantFlavorDisplayOrderView_ValidatingWrite(FormDataSource _sender, FormDataSourceEventArgs _e) | |
| { | |
| if (isConfigurationkeyEnabled(configurationKeyNum(Retail))) | |
| { | |
| _sender.queryBuildDataSource().addLink(fieldNum(EcoResProductVariantFlavor, DistinctProductVariant), fieldNum(EcoResProductVariantFlavorDisplayOrderView, DistinctProductVariant)); | |
| _sender.queryBuildDataSource().addLink(fieldNum(EcoResProductVariantFlavor, Flavor), fieldNum(EcoResProductVariantFlavorDisplayOrderView, Flavor)); | |
| _sender.queryBuildDataSource().addOrderByField(fieldNum(EcoResProductVariantFlavorDisplayOrderView, RetailDisplayOrder)); | |
| _sender.queryBuildDataSource().addOrderByField(fieldNum(EcoResProductVariantFlavorDisplayOrderView, Name)); | |
| } | |
| } | |
| 加range/link 到 新加的datasource [View] (extension) 內: | |
| /// <summary> /// |
- Nov 01 Thu 2018 14:43
[Dynamics AX/365] 更改原form 內的Control 屬性
- Nov 01 Thu 2018 11:27
[Dynamic AX/365] 在extension 內找回 form 的 global variable & Extension Lookup
[ExtensionOf(formStr(DimensionValueDetails))]
final class DimensionValueDetails_extension
- Oct 31 Wed 2018 17:58
[Dynamic AX/365] 把View 和現有Data source join 在一起
[DataSource]
class ABCView
- Oct 26 Fri 2018 18:39
[Dynamic AX/365] Lookup Field - 在edit 時提供已過濾的選擇.
public void lookup()
{
- Oct 26 Fri 2018 11:19
[Dynamic AX/365] 常用AOT Query Range
| Name | Used how | Example |
| dayRange | (dayRange(-1,2)) gives a query result of all records from yesterday until the day after tomorrow.
Note that it is unfortunately not possible to use decimals, only full days work. |
- Oct 26 Fri 2018 10:45
[Dynamic AX/365] DataareaId 如何在SQL 和AOT 找取
SQL : 可以用 curExt() :
where dataareaId = curExt() ;
