A practitioner’s musings on Dynamics 365 Finance and Operations
I found following links for Dynamics Perf 2.0
http://blogs.msdn.com/b/axinthefield/archive/2015/12/18/what-s-new-in-dynamicsperf-2-0.aspx
http://blogs.msdn.com/b/axinthefield/archive/2016/01/03/dynamicsperf-2-0-scheduling-engine.aspx
http://blogs.msdn.com/b/axinthefield/archive/2016/01/06/dynamicsperf-2-0-is-here.aspx
http://blogs.msdn.com/b/axinthefield/archive/2015/12/30/dynamicsperf-2-0-deployment-guide.aspx
Suppose we have to insert data into VendGroup table through TSQL, this scenario usually appear when integration or data migration team inject data into AX using TSQL without using AIF.
There are two tables are important SQLDICTONARY and SYSTEMSEQUENCES.
SQLDictonary table contains the table id for example Vendtable has 490 id.
SYSTEMSEQUENCES table contains the sequence number in nextVal field.
I used following code snippet which helps me to insert into AX through TSQL.
declare @tableId as int = (select tableid from SQLDICTIONARY where name like 'VendGroup' and FIELDID=0);
print @tableId;
declare @recId as bigint =(select nextval from SYSTEMSEQUENCES where TABID=@tableId and name='seqno');
print @recId;
select @recId set @recId =@recId + 1;
print @recId;
insert into DBO.VENDGROUP ([VENDGROUP],[NAME],[RECID],DATAAREAID,CREATEDBY,DEL_CREATEDTIME,CLEARINGPERIOD,PAYMTERMID,RECVERSION) values ('80','TSQLTest',@recId,'usmf','ALICIA',19372,'Net10','Net10',0 );
update SYSTEMSEQUENCES set NEXTVAL = @recId where TABID=@tableId and name='seqno';
reference:
Here is little tip regarding look up.
A few days ago, I have to take join with employee with my custom table. if you check that The primary key of HCMWORKER IS RecId.
So I have to create worker relation based on primary key i.e recid.\
But when I drop the foreign key on form Grid. It creates reference group. And surprising this create out of the box lookup with similar to same based on alternative key.
Now there is query appears that we have to filter it the workers of certain cariteria. for example you can certain designation or not terminate. now I face question how to add custom lookup in Reference group. Now there is no lookup function and same time if exists it will not work.
After searching I found referenceLookup method at data source field instead of grid text field. So Overwrite the method and similar code snippet creates the similar to out of the box lookup. You can extend it according to need.
public Common lookupReference(FormReferenceControl _formReferenceControl)
{
HcmWorker HcmWorker;
Query query = new Query();
QueryBuildDataSource queryBuildDataSource;
QueryBuildRange queryBuildRange;
SysReferenceTableLookup sysTableLookup = SysReferenceTableLookup::newParameters(tableNum(HcmWorker), _formReferenceControl, true);
;
sysTableLookup.addLookupField(fieldNum(HcmWorker, PersonnelNumber));
sysTableLookup.addLookupField(fieldNum(HcmWorker, Person));
queryBuildDataSource = query.addDataSource(tableNum(HcmWorker));
return sysTableLookup.performFormLookup();
}
Reference I used for this post, They help me during doing day to day task
http://devexpp.blogspot.com/2013/06/dynamics-ax-custom-reference-group.html
https://dynamicsaxposed.wordpress.com/2011/11/04/sysreferencetablelookup-class-for-reference-group/
Now in Dynamics Ax 7, now developer can declare variable/object where they need it. Instead ax 2012, where variable declaration is only possible in very beginning of method or function.
For ( int counter =0; counter < 10; counter++)
{
If ( counter >10)
{
Int value= counter+10;
}
Else
{
Real percentage = (counter *20) /100;
}
}
That’s good: Its ease to developer to declare variable where he needs.
That’s bad : it will disorganize the code, Its look better as in Ax 2012 that variables will declare in separate section. It was better to search reference of class object or table buffer
Finally I found that in new Dynamics Ax finally statement introduce in exception handling statement.
try
{
}
catch
{
}
finally
{
}
It means, everything written in finally must be execute. For testing this functionality I just create a runnable class and written following code.
class HelloWorld
{
/// <summary>
/// Runs the class with the specified arguments.
/// </summary>
/// <param name = "_args">The specified arguments.</param>
public static void main(Args _args)
{
ColorDC dc = new ColorDC();
ColorSc Sc = new ColorSc();
try
{
dc.parmColorName("Red");
Sc.InsertColor(dc);
dc.parmColorName("Green");
Sc.InsertColor(dc);
} catch (Exception::Error)
{
info("error");
}
finally
{
info("finally");
}
}
}
When run the code.
I found Info box in browser as
Today I had to troubleshoot the Inventory journal DMF import, which previously working fine. But somehow it start to throw “Lot ID not specified. Import cancel. Hour of hours debugging reveals nothing. Finally I found some warnings in Database synchronize. These warnings described some index errors on DMF entity tables and need to drop and recreate them.
So I delete the DMFInventJournalEntity table at SQL Server level and from AOT right click on table and click on synchronize. This recreate the require table at SQL server level.
Or ignore the old entity create a new entity and import data with that.
Purpose of This post to explore the runnable classes to test the logic, checking the traditional X++ (AX 2012) code and new table explorer in Dynamics Ax 7. This post is based on Dynamics AX (Dynamics AX 7) CTP 8.
In new Dynamics Ax (Dynamics AX 7) there is no more AX Jobs. For testing certain logic we have to use runnable classes.
Suppose we have to test the logic for some service, which has data contract and Service contract classes.
Right click inside solution explorer and add new object and select runnable class.
Add test logic as
class HelloWorld
{
/// <summary>
/// Runs the class with the specified arguments.
/// </summary>
/// <param name = “_args”>The specified arguments.</param>
public static void main(Args _args)
{
ColorDC dc = new ColorDC();
ColorSc Sc = new ColorSc();
dc.parmColorName(“Red”);
Sc.InsertColor(dc);
dc.parmColorName(“Green”);
Sc.InsertColor(dc);
}
}
Now expand the project properties and set my Hello world class a start up object
To explore the debug feature I add a break point and press F5. With debug window a new diaglonsitic tool runs, which shows memory and space used by my code processing.
I just test the traditional X++ code, Its works the same way as it was in Morphix editor in tradition AX (2012).
public void InsertColor(ColorDC Colorobj)
{
MyColorTable _Color;
Name _Name;
_Name = Colorobj.parmColorName();
select * from _Color where _Color.ColorName== _Name;
if (_Color==null)
{
try
{
ttsBegin;
_Color.ColorName = _Name;
_Color.insert();
ttsCommit;
}
catch
{
ttsAbort;
}
}
}
Now right click on table and from properties popup menu click on table browser.
The new table browser inside Visual studio show me the values just inserted during debugging of above mentioned code.
During customization, the requirement for client is met by feature built for certain region ie. China and Brazil. Instead of develop that functionality we have to enable this functionality to available in other region too. For this we have to clear the “CountryRegionCodes” property.
If we remove this property from menu, menu item, extended data types, enums, tables and forms.
Then this functionality will be available in all legal entities of every region. And more importantly we have to debug the code to remove any country or region specific checks.
By writing of this post, I just download the AX7 CTP8 Vm and configure on my machine.
I successfully configure it on hyper V. Only one tricky point is external network adapter in Hyper V.
First step is download VHD and extract it to some place. If you are registered to AX 7 Feedback program, then you must have vhd download link.
After the download, run the self-extract exe and extract the Vhd at specific location.
Step 2. Create a new external network adapter
Open hyper v console, and create new external network. As I am using wireless network, so I select it as bridge for using internet inside VM. You can use your Ethernet network as bridge.
Step 3 Create a new Vm.
Select generation 1 vm in next step
Set 8 GB ram to vm, recommend ram is 16 GB.
Select network adapter we created in previous step.
Select use existing hard drive and select the Vhd extracted in previous steps.
Click on next and click on finished.
Run the VM and click on connect button. Login in with “Administrator” and Password is “pass@word1”
When VM is running you find new network connection ask your permission, Click on Yes button.
Please check that network is working fine inside VM. Some times it will gives error “network has not assigned ip address”. If external network adapter will not work then you have to create internal network and use that.
For this I create Internal network adapter in Hyper v. For currently I created a new internal adapter with name
“GateWayToInternet”.
Now open the network and sharing center in windows. either using wifi or Ethernet. right click on it and from properties window select sharing tab.
check the checked box for sharing internet and from drop down select the v Ethernet (which we create in one above step). stop the vm and use newly created internal network adapter in its network setting. When you start the vm. it will successfully access the internet and let you access ax 7 in browser.
For more detail for Internal networks setting please use following link, I used it for configuration.
http://wordsideasandthings.blogspot.com/2013/01/hyper-v-internal-virtual-network-and.html
Wait a few minutes and then open Internet Explorer and type following url
https://usnconeboxax1aos.cloud.onebox.dynamics.com
This will lead you at login page
For login you need to use some office 365 account. Currently I used my other account which i created for Microsoft Dynamics CRM trail. Possible if office 365 account did not work then register for CRM trail. 🙂
You may found “Provision tool” on the desktop of VM”.
Right click on it and run it as administrator.
enter your office 365 account and click on submit.
wait a few minutes. When success message popup login with office 365 account.
If your network Adapter is successfully configured, AX 7 welcome page will open, other wise you will find error page.
Today I have to delete all legal entities from one of MS Dynamics Ax 2012 environment.
During this I got following error while deleting legal entities.
“Can not record , The corresponding AOS validation failed”.
This error clearly shows that Transnational data exists in that legal entity.
I follow these steps to clear all legal entities.
Some but on some legal entities delete button is still disabled. Because there is no important data as well I want to delete all legal entities, I manually delete the data in RCHYRELATIONSHIP table.
Otherwise I have to delete the organization hierarchy data carefully.
Following two links help me to solve this issue.
http://daxture.blogspot.com/2014/09/delete-legal-entities-in-ax-2012.html
https://community.dynamics.com/ax/f/33/t/139605
