ax 2012-clear usage data

  • Dec 07, 2017

how to clear all user usage data? if we do it for specific user we can do is: File->Tools->Option Click Usage Data On General Tab, find the reset button and click it same like we do it for All Users but we must call the forms from AOT open the AOT AOT->Forms->SysLastValue Goto All Usage […]

Read More

this is part 2 of view record on LogisticsPostalAddress you can see the part 1 here when you have task to view the record using query, we can use view duplicate LogisticsPostalAddressView to LogisticsPostalAddressView2 change validTimeStateEnabled to No   and use this view to get the data

Read More

how to add days in x++

  • Nov 10, 2017

this is simple code to add days in x++ TransDate transDate = 12/20/2017; ; transDate = transDate + 5; info(strFmt(“%1”, transDate));

Read More

thanks to Robert Tattersall to share the article about InventSite and LogisticsPostalAddress I’d copied here incase this article moved/deleted 5 May 2016 9:27 PM This document explains technical details for connecting Site with it’s address and contact information (e.g. phone, and email), and should help anyone who is attempting to customize existing code, or write new code, […]

Read More

this is what I’ve found while playing LogisticsPostalAddress X++ query this is the first part of logisticspostaladdress, see the part 2 here I created a X++ query like this source below select LogisticsPostalAddress where LogisticsPostalAddress.RecId=5637155184 the result was 0 the problem is, the record was exists on the table, but why it is hidden on […]

Read More

In Out Inventory Stock

  • Oct 30, 2017

I’ve just made a Form Application that calculate In Out Inventory Stock, enter the filter, and press the Calculate button and this is how I do it create a temporary table called GLK_TBL_INOUTINV Table Type : InMemory the Fields are: DateFinancial (extended), DatePhysical (extended), Description, InventLocationId (extended), InventSiteId (extended), ItemId (extended), ItemName (extended), QTYAwal, QTYAkhir, QTYIn, […]

Read More

I got a project form that calculate fields on the grid on fly, we can use a display method for this solution so this is how I do it on the datasource ds, we create a method, and we passed the method on the grid

Read More

void clicked() { super(); startLengthyOperation(); sysDatabaseLog_ds.research(); endLengthyOperation(); } thanks to msdn, let me copy paste the links and the article here How to: Create Progress Indicators Dynamics AX 2009 Other Versions Use a progress indicator during operations that take more than 2 seconds. Use an hourglass mouse pointer if the process takes 2-7 seconds. Use […]

Read More

Tips Reference Category Group Fields We need to add information about salesman according each address on these customers This is how we did it Go to AOT, open form LogisticsPostalAddress  open table LogisticsPostalAddress fill the property like the picture below while you type extended data type, please aware, there will be warning box “to add […]

Read More

select statement in x++

  • Sep 04, 2017

Im copy paste the manual from msdn about select statement in x++, I hope it usefull for ax programmer Select Statement Syntax [AX 2012] Updated: February 3, 2012 Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012 SelectStatement = select Parameters Parameters [ [  FindOptions  ] [  FieldList  from ] […]

Read More