-

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

[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

How to run Our Design in SalesPackingSlip Standard SSRS report?

-
How to run  Our Design in SalesPackingSlip Standard SSRS report? To run our Design in a standard SSRS Report(SalesPackingSlip), do this in the controller class. //Class Declaration Part in the controller class     MenuItemName                    reportChina;     #define.chineseReport('SalesPackingSlipOriginal')     #define.reportDesign('SalesPackingSlip.ReportNew') //outputReport Method in controller To run the report protected void outputReport() {     if (this.parmReportChina() == #chineseReport)     {         this.parmReportName(#reportDesign);         this.parmReportContract().parmReportName(#reportDesign);         formLetterReport.parmReportRun().settingDetail().parmReportFormatName(#reportDesign);     }     super(); } //parmReportChina Method in controller To set a...
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