Dynamics 365 development notes
Hi all, I face this error, while extended existing custom report. I added some fields in temp table, after update logic in dp class, On report data set update.
But at run time report shows this error. While debugging the code, I found the error occur on mapping the new fields in temp table.
Solution :
I build the whole model. After that error was removed.
Hi all, small tip. I faced this issue, when I extend the custom report in D365 for finance and operations. During development on onebox
Solution was simple,
Happy Daxing.
Hi all, In some cases we can need to copy financial dimension from one object to other for example Customer to Sales order or Vendor to purchase order.
In Ax 2012 it little easy. But in D365 For finance and operations, it is little bit tricky.
I did this with following code snippet. With the help of out of box. LedgerDimensonDefaultFacade class i used the merge default dimension method and passed same table dimension in form and to dimension.
Result is interesting.
salestable.DefaultDimension= LedgerDimensionDefaultFacade::serviceMergeDefaultDimensions(CustTable.DefaultDimension,CustTable.DefaultDimension);
In Ax 2012 we get menu name with element.Args().CallMenu name, using taking decision on menu name.
But same logic we need to apply in Extension. But in D365 For finance and operations we did not overlay. Following code snippet helps me to implement similar logic in Extension.
[ExtensionOf(formStr(CustTable))]
final class IaLogisticsContactInfoGrid_Extension
{
/// <summary>
///
/// </summary>
/// <param name=”sender”></param>
/// <param name=”e”></param>
[FormEventHandler(formStr(LogisticsContactInfoGrid), FormEventType::Initialized)]
public static void LogisticsContactInfoGrid_OnInitialized(xFormRun sender, FormEventArgs e)
{
FormRun formRun = sender;
;
info(formRun.args().menuItemName());
}
}
Hi did one customization, where I create Ledger Journal using X++ code. It was working perfectly fine with Ledger General Ledger entries. But threw error on creating Ledger for AR,PR Payment.
I created ledger with following code snippet. But it works only for Ledger for of Type Daily
AxLedgerJournalTable header = new AxLedgerJournalTable();
AxLedgerJournalTrans trans = new AxLedgerJournalTrans();container offsetDim;
LedgerJournalNameId ledgerJournalNameId = “payment”;header.parmJournalName(ledgerJournalNameId);
header.parmJournalType(LedgerJournalType::CustPayment);
header.save();I replaced the above code with following snippet it works perfectly fine, rest of the code is works fine
LedgerJournalName ledgerJournalName;
LedgerJournalTable ledgerJournalTable;
LedgerJournalTrans ledgerJournalTrans;select firstonly ledgerJournalName
where ledgerJournalName.JournalName == parameters.LedgerJournalNameId &&
ledgerJournalName.JournalType == LedgerJournalType::CustPayment;
if(!ledgerJournalName.RecId)
throw error(“@CAM184”);
if(ledgerJournalName)
{
ledgerJournalTable.JournalName = ledgerJournalName.JournalName;
ledgerJournalTable.Name = ledgerJournalName.Name;
ledgerJournalTable.insert();
}
Hi Today I found very interesting post here , where we can use “In” keyword for While select or Select statement.
in will be enum based.
SalesTable salesTable;container con = [SalesType::Sales, SalesType::ReturnItem, SalesType::Subscription];while select * from salesTablewhere salesTable.SalesType in con{Info(salesTable.SalesId);}D365/AX7:SQL IN Operator In X++ Where Clause (Enum Fields Only)
For paging in X++ Query. There are three steps required. Rest of Query Code is same.
We have to set following things in Query data source
Here is code snippet
QueryBuildRange qbr,qbrStartDate,qbrEndDate;
QueryBuildDataSource qbd;
IAPageSize EnumPageSize;QueryRun qr;
Query query = new Query();
Int pageSize = 2;
qbd = query.addDataSource(TableNum(ProjPlanVersion));
qbd.addOrderByField(fieldNum(ProjPlanVersion,HierarchyId));qr = new QueryRun(query);
qr.enablePositionPaging(true);
CurrentPageNumber =1;
startingposition = CurrentPageNumber * pagesize;
qr.addPageRange(startingposition, totalRows);
while(qr.next())
{
Info (“”);
}
I still like the Idea shared by “Gary Vaynerchuk ” Post ” Document dont create” So I document what I face today and resolved.
Today I am facing Project compilation Error in Visual studio output pane, I am struggling to understand Table control, so I can meet the development of my next assignment. Error was
Severity Code Description Project File Line Suppression State
Error One or more errors occurred. —> System.InvalidOperationException: Cannot stop DynamicsAxBatch service on computer ‘.’. —> System.ComponentModel.Win32Exception: The service cannot accept control messages at this time
— End of inner exception stack trace —
at System.ServiceProcess.ServiceController.Stop()
When I open Services, I found that DynamicsAXBatch services is in stopping mode and stuck.
So I killed the service process with CMD command. “taskkill /f /pid [pid number]”
The message already shows the service name. ” DynamicsAXBatch” You can copy it from Service detail dialog.
So Open CMD with run as administrator and run the following command and get pid
sc queryex DynamicsAxBatch
Now I have IP.
And kill the Process Id
taskkill /f /pid 5352
Now I start the service again.
Project is successfully complied.