A practitioner’s musings on Dynamics 365 Finance and Operations
Hello everybody!
Form the following links you can download the Microsoft Dynamics Ax2012 R3 with Demo data.
CostumerSource
https://mbs.microsoft.com/customersource/northamerica/AX/downloads/service-packs/AX2012DemoToolsMaterials
PartnerSource
https://mbs.microsoft.com/partnersource/northamerica/sales-marketing/demo-tools/virtual-machines/AX2012DemoToolsMaterials
Enjoy to discover numerous new features included in this new version!
During customization in Dynamics we usually check that what data store in Tables. For this I am more found of using SQL server then using table explore in AOT. When we upgrade code from Dynamics Ax 2012 to R2, We found that many tables did not appear in SQL Server. Examples are EcoResProduct , BankLCImport and BankLCImportLine table.
It is not recommended by Microsoft to bypass Dynamics Ax 2012 and direct query on tables in Sql server. But sometimes it is requirement to get data direct form Sql Server. We finally found that if we build view in Dynamics on those tables either by creating Queries or by directly on table. These views are available in SQL Server. We can use that custom View in our query instead of tables in Sql server.
Yesterday, I got error when I run the view which created on “” table in Dynamics Ax 2012
“You are not authorized to access table ‘VBankLCImport’ (VBankLCImport). Contact your system administrator”.
Error was misleading because in development environment User have full access rights. And this error is not appear while running any view.
I also reset the license key, but problem does not resolve.
Finally it revealed that this error appear due to no field is added inside the view. I select the one key and drag and drop on fields in view section. Then right click on view. It successfully show me the values.
We can create transaction entries in different currency. For Example default currency set of Legal entity is “USD” and we have to create Purchase Order in Pak Rupees.
For this purpose we have to create exchange in Dynamics Ax.
The link of currency exchange is Ledger module, in Setup section and under currency. You can saw it as follow.
Click on Currency exchange rates
Select “Default” from Exchange rate Type. By default application exchange rate from “Default”. And then click on New Button, from right pane select From Currency to USD and To Currency select PKR.
By Default From date Set to “Current Date” and To Date set one month to after current Day. You can modify it as per your requirement.
In current scenario 1 USD is equal to 150 Pak rupee.
There is also Start Date which is used as effective date, It means, between from date and to Date we can use multiple exchange rate.
Now you can create Purchase Order in Pak rupees, The Values are automatically converted into Pak rupees.
To verify that we create two Purchase order first in USD and second one in Pak rupees and verify that Item price are came in different values.
First we create Purchase Order with USD dollar and then create PO with and see the purchase Item price.
Now we create Purchase Order in Pak rupees and see the unit price.
Consider a scenario where, I required a StringEditControl and Clicking on Control a lookup is open where the list of Customer of selected Legal Entity are available. And After Selecting required Customer, Customer Id Or AccountNum is return form Lookup form.
For This purpose we have to create form, which will used as look Up.
Create a New form. Name It “FormCustomerLookUp”
In Data Source Create and New dataSource Name It CustomerTable and Point to CustTable.
Expand the Design node and Right Click on It and Add Grid, Now from CustomerTable Data Source, Drag and drop “AccountNum” and “Party” on Grid. It will create two String Edit Control on Grid bound with CustomerTable.
Now Select on “StringEdit:CustomerTable_AccountNum” select Properties. Form Properties window Set Its Auto declaration property to True.
Now expend the Methods Node form and Right click and override the Init method from there and add following line of code there.
element.selectMode(CustomerTable_AccountNum);
Now right click on Design Node and Update following properties.
Width=360
Style=LookUP.
Now Create a form where this lookup will use. For this Article I have to create very simple form with only on stringEdit textbox.
On its Design Right click and create StringEditButton with Name “LookUpTest” and from Its property window Auto Declare Property is set to Yes and lookupButton property to “Always”.
Now Add two method, One used to Register control with Lookup, and Second method will use to call lookup form and gets its value.
protected void configureCustomerLookUp(FormStringControl stringControl)
{
if (stringControl)
{
stringControl.visible(true);
stringControl.registerOverrideMethod(
methodStr(FormStringControl, lookup),
identifierStr(CustomerLookUp), this);
}
}
Second method will be called on lookup button click
private void CustomerLookUp(FormStringControl stringControl)
{
Args args = new Args(identifierStr(FormCustomerLookUp));
FormRun lookupFormRun;
args.parm(“”);
args.caller(this);
lookupFormRun = ClassFactory::formRunClassOnClient(args);
lookupFormRun.init();
stringControl.performFormLookup(lookupFormRun);
lookupFormRun.wait();
}
If you have already some knowledge above code is easily Understanable, where Ax form Name set in args and instance of from is created at runtime and then attached the form to string controls performLookUp method.
Now run the form. And click on lookup button on textbox.
Click on LookUp Button
Selected Value will show on text box when you click on lookup grid
Nice Experiments, Now you can use This functionality as you want,
As per my understanding for commands, Examples are more easily understand and quick solution instead of syntax.
For model store export/import we have to use Dynamics Ax Management Shell. You can find “Dynamics Ax Management Shell” at All Programs, Administrative Tools and Microsoft Dynamics Ax Management Shell.
Export Command Syntax (Windows PowerShell) :
Export-AXModel –Model <name> -File <Filename.axmodel>
Example : abcd is name of Model, file name can be different model store name.
Export-AXModel -model abcd -file c:\abcd.axmodel
Import Command Syntax (Windows PowerShell)
Install-AXModel -File <Filename.axmodel> -Details
Exmaple :
Install-AXModel -File C:\abcd.axmodel –Details
In the case of some files exist in another model then add “-Conflict Push”
The complete command is here
Install-AXModel -File C:\abcd.axmodel -Details -Conflict Push
If you check the online user in Administrator Module, You may be found some session with inactive and block status. These inactive and block session are due to crashing of AX clients. These sessions are not create any problem, but possible issues with limited number of active users under Dynamics Ax license. Best approach to clear these inactive and block session form Dynamics Ax to avoid any future conflict with Licensing. All these session information is stored in “SysClientSessions.” Table.
Second Problem we usually face that when we start AOS service, it take too much time change status from Starting to started. One of many reason for this phenomena that AX try to query and located any Active session in SysClientSessions. To reduce the time is to remove all session inactive from SysClientSessions table or possible remove the inactive and block session form Database. In “SysClientSessions” Status with status 0 (Inactive), Status 2 (Ending Waiting for AOS), 3 (Ending –Block).
Perform following steps.
delete from SysClientSessions where status in(0,2,3)
Hopes this will works to start AOS service faster than previously.
System Requirements for Microsoft Dynamics Ax 2012 R3 Updated by Microsoft. For this purpose Microsoft uploaded a new document , you can download it from this link
http://www.microsoft.com/en-pk/download/details.aspx?id=11094
We can get standard sql from AOT Query object through X++ code.
Following X++ Code used to get Standard Sql out of EcoResProductListPage
static void Job2(Args _args)
{
Query query;
query = new Query(queryStr(EcoResProductListPage));
info(query.dataSourceNo(1).toString());
}
Updated version for “Inside Microsoft Dynamics Ax 2012” is now out. It is updated for AX 2012 R3 version.
What’s new :
You can purchase inline from:
