public void exportCSV(str _filename)
    {

文章標籤

lionlionchopper 發表在 痞客邦 留言(0) 人氣()

  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)));
        }
    }


lionlionchopper 發表在 痞客邦 留言(0) 人氣()

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.
.

 

lionlionchopper 發表在 痞客邦 留言(0) 人氣()

/// <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>
    ///

lionlionchopper 發表在 痞客邦 留言(0) 人氣()

 

/// <summary>

lionlionchopper 發表在 痞客邦 留言(0) 人氣()

[ExtensionOf(formStr(DimensionValueDetails))]
final class DimensionValueDetails_extension

lionlionchopper 發表在 痞客邦 留言(0) 人氣()

 [DataSource]
    class ABCView

lionlionchopper 發表在 痞客邦 留言(0) 人氣()

 public void lookup()
        {

lionlionchopper 發表在 痞客邦 留言(0) 人氣()

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.

lionlionchopper 發表在 痞客邦 留言(0) 人氣()

SQL : 可以用 curExt() :

where dataareaId = curExt() ;

lionlionchopper 發表在 痞客邦 留言(0) 人氣()