-

How to create a table?

  1. In the AOT, expand the Data Dictionary node.
  2. Right-click the Tables node, and then select New Table.
  3. Right-click the table, and then click Properties.
  4. Rename the table by modifying the Name property.
  5. To specify the table as temporary, set the Temporary property to Yes.
  6. Modify additional table properties, as needed. 
  7. To delete the table, right-click it, and then click Delete.


Comments

Post a Comment

Popular posts from this blog

Running the SSRS Report and Saving in Local drive using X++ Code with renaming the same report next Occurrence in AX 2012

-
Running the SSRS Report and Saving in Local drive using X++ Code with renaming the same report next Occurrence in AX 2012 Write the below code in Controller Class  of the Report public static void main(Args _args) {     //KKSalesPackingSlipController controller = new KKSalesPackingSlipController();     //controller.parmReportName(ssrsReportStr(KKSalesPackingSlipReport, PrecisionDesign2));     ////controller.parmReportName(ssrsReportStr(KK_CustInvReport, Report));     //controller.parmArgs(_args);     //controller.startOperation();     LogisticsAddressCountryRegionId     logisticsAddressCountryRegionId;     SrsReportRunController              controller = new SrsReportRunController();     SRSPrintDestinationSettings         printSettings;     KKSalesPackingSlipContract          c...
Read more

How to calculate On Hand Inventory Per Day

-
How to calculate On Hand Inventory Per Day class KK_OnHandPerDay {            /// <summary>     /// Runs the class with the specified arguments.     /// </summary>     /// <param name = "_args">The specified arguments.</param>     public static void main(Args _args)     {                ItemId itemId;         InventTrans inventTrans;         InventDim inventDimCriteria, inventDimLoc;         InventDimParm inventDimParm;         InventSumDateDim inventSumDateDim;         TransDate start, finish;         int c;         int onHandTotal;         InventLocationId inventLocationIdLoc;         start = str2date("6/24/2019", 213);//3/12/2019    ...
Read more

[AX2012] Get Email for Customer / Vendor (with specific roles)

-
Get Email for Customer / Vendor (with specific roles) static void KK_Email (Args _args) {     DirPartyLocation dirPartyLocation;     LogisticsElectronicAddress elecAddress;     LogisticsElectronicAddressRole elecAddressRole;     LogisticsLocationRole locRole;     Email   email;               while select dirPartyLocation         where dirPartyLocation.Party == 22565427693     {         while select elecAddress             where elecAddress.Location == dirPartyLocation.Location             && elecAddress.Type == LogisticsElectronicAddressMethodType::Email         {             while select elecAddressRole                 where elecAddressRole.ElectronicAddress ...
Read more