Ali Raza Zaidi

Musing's of ERP Consultant

You are here: Home / Archives for Dynamics 365 for finance and operations / Dynamics Ax 7

Dynamics Ax 7

View Details User Tip MSDyn365FO Dynamics 365 for finance and operations

By

Hi everyone this is user level tip for Dynamics 365 for finance and operations. We can add and remove Values in any drop down or lookup field by right click and from view details on menu. It is very beginner level tip.

Sale Order Processing Part 4 Line Level Discount Sales Trade Agreement Video- D365 for Finance and Operations

By

Fourth video in Sale order processing video series. I shared very precise how to, Line level discount trade agreement and apply it on Sales order.

Required table did not appear in relation drop-down D365 for Finance and Operations.

By

Hi All, I was doing my Pilot project in D365 for Finance and operations. I want to add HCMWorker relation to my custom table. But did not found in drop down.

 

 

 

 

It means model reference(Package) was not included in Current Model. For this

 

For this first check Required model on table and add its reference On AOT

 

 

 

For adding this   click on Dynamics 365 Menu on top. Model Management => Update Model Parameters

 

 

Select your current Model, for example, My Pilot Model is OpnAxPayroll I selected that.

 

 

Select required Models and

 

 

Now I found the HCMWorker in relation dropdown.

Updating Date Effective Tables in AX 2012, Dynamics 365 for finance and operations

By

I was struggling to update Date Effective Table in Dynamics Ax 2012 R3. At least one hour of struggle, finally I update the required record.

 

Only good post which helps is by Agnela GoldBrg.

 

http://ibisinc.com/blog/updating-date-effective-tables-in-ax-2012/

 

One line tip from this post is on Date Effective table, The active record reference can be get with  of

DateTimeUtil::utcNow()

 

Its really small tip, yes learning and solving problem at hand waste hours.

 

Lets take a real world example We have to update Job detail with X++.

 

For HCMJobDetail table following way works for me.

 

hcmJobDetail=    HcmJobDetail::findByJob(hcmJob.RecId,DateTimeUtil::utcNow(),DateTimeUtil::utcNow(),true);

 

We can query on required table  with following  way

 

_validFrom = DateTimeUtil::utcNow();

_validTo =DateTimeUtil::utcNow();

 

select ValidTimeState(_validFrom, _validTo) hcmJobDetail

where hcmJobDetail.Job == _job;

 

 

The complete code snippet which works for me is here.

 

 

HcmJobDetail hcmJobDetail;

HcmJob hcmJob;

HCMJOBID  _id=’XyZ’;

date dateToday,

 

hcmJob = HcmJob::findByJob(_id);

 

_validFrom = DateTimeUtil::utcNow();

_validTo =DateTimeUtil::utcNow();

 

select ValidTimeState(_validFrom, _validTo) hcmJobDetail

where hcmJobDetail.Job == _job;

 

 

hcmJobDetail=    HcmJobDetail::findByJob(hcmJob.RecId,DateTimeUtil::utcNow(),DateTimeUtil::utcNow(),true);

if (hcmJobDetail!=null)

{

try

{

ttsBegin;

 

hcmJobDetail.validTimeStateUpdateMode(ValidTimeStateUpdate::Correction);

hcmJobDetail.SL_TempEndDate = today();

hcmJobDetail.SL_TempStartDate = today();

hcmJobDetail.Note = ” test and test”;

 

hcmJobDetail.update();

 

ttsCommit;

}

catch

{

ttsAbort;

HcmJob::CheckFailed(‘ Unable to update job’);

//    status  = SL_EntityStatus::Error;

}

}

}

 

 

}

Drill through SSRS – Dynamics 365 for Finance and Operations

By

Helped a junior, build a small SSRS expression, who build hyperlink to Course page on SSRS. You can modify it with respect your need.

 

=Microsoft.Dynamics.Framework.Reports.BuiltInMethods.GenerateDrillThroughLink( Parameters!AX_ReportContext.Value, Parameters!AX_UserContext.Value, “HRMCourseTable”, “Display”, “HRMCourseTable”, “hrmCourseId”, Fields!hrmCourseId.Value)

Sales Quotations Dynamics 365 for Finance and operations.

By

In response to Customer/ prospect  request for quotation. Sale and marketing department generate Sales Quotations.

 

This Sales quotation can be generate existing customer. Otherwise D365 OF provide functionality to  register sales Quotation against Prospect.

 

 

 

 

 

 

 

When Customer Response against Sales Quotation, We can confirm Sales Quotation convert to Sales Sale order and Prospect convert to Customer.

 

 

Similar to Sales order , Sale quotation is added in lines section.  When entry is complete, from top menu and sent Sales quotation, Print can be generated.

 

 

 

 

There are multiple options available against Sales Quotations as response. We can find these options are available on “follow up” top tab menu.

 

 

Confirm:, Customer send confirmation so Sales Quotation convert to into Sales Order.

 

Cancel:  Sales Quotations can be cancel, possible there will be no response form Prospect.

 

Lost quotation:  In the case of another company won the quotation we can set as Lost.  It is some kind of cancel. After that quotation is closed for edit.

 

Two options also found in sales and marketing parameter form.

 

 

 

 

 

You find in General tab

 

 

Days campaign  expire, means sales quotation automatic expire the create of sales quotation.

Sales follow up date automatically created quotation creation date plus date mentioned here.

Sales follow up means, date of sales Quotation is created plus days mentioned here in setup.

Customer / Vendor ledger Dimension D365 for finance and operations X++

By

 

In D365 for finance things are little bit change and much more organized. In Dynamics Ax 2012, which consider as classic AX. We get ledger dimension  with DimensionStorage class

 

ledgerDim = DimensionStorage::getDynamicAccount(

‘US-001’,

LedgerJournalACType::Cust);//Account

offsetLedgerDim = DimensionStorage::getDynamicAccount(

‘USMF OPER’,

LedgerJournalACType::Bank);//OffsetAccount

 

 

 

 

In D365 this Microsoft provide LedgerDynamicAccountHelper. Code snippet is here

 

 

 

 

 

 

ledgerDim = LedgerDynamicAccountHelper:

:getDynamicAccountFromAccountNumber(‘US-1001’,

LedgerJournalACType::Cust);

 

offsetLedgerDim = LedgerDynamicAccountHelper:

:getDynamicAccountFromAccountNumber(

‘USMF OPER’,

LedgerJournalACType::Bank);

 

 

Reference http://daxingwitheshant.blogspot.com/2015/04/creating-payment-journal-using-x-in-ax.html

Microsoft Connect portal retired, you have to follow other link

By

 

Hi all, I was trying to download latest Dynamics 365 for finance Dev box vm, but found that Microsoft Connect portal is retired. you can found all information here.

https://docs.microsoft.com/en-us/collaborate/connect-redirect

 

I expect that lastest VM link will available here, As I found latest 7.3 update 12 link here

https://aka.ms/finandops73pu12

 

And it leads us to some share point link, Download is good as compare to old connect link.

 

MetaData Search D365 for Finance and Operations.

By

I was exploring Visual Studio Menu Dynamics 365 . I found Meta Data Search sub menu. Microsoft Has very nice article on this.

It is very good tool to search code reference in AOT.  Suppose I search CustTable reference In AOT. The result is as follow

 

 

Reference : https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/dev-tools/metadata-search-visual-studio

 

Process Busy Indicator D365 for finance and operations

By

Hi All, today I have small tip, During development, I have to process a lot of records. During this , I need Busy screen process indicator.

 

I used following code snippet to create progress busy indicator.

 

For this I have to do following changes in my Class method (Business logic).

  1. Convert required method to Static
  2. Parameter is changed to Container and then required parameter extract from container inside the method.

 

 

So my required method become something like

 

 

Class myProcess

{

 

 

Public static void RunmyProcess(Container _C)

{

Str _Value = conpeek(_C,1);

 

 

 

}

 

}

 

 

 

class RunBtnProcess

{

/// <summary>

///

/// </summary>

public void clicked()

{

 

container _Xyz=[TableName.FieldValue];

super();

SysOperationSandbox::callStaticMethod(classNum(myProcess),
staticMethodStr(myProcess,RunmyProcess),_Xyz, 
'Ledger Record in process', 'Operation completed');

 

 

}

 

}

Reference : Internet.

Parent child form Customization D365 for Finance and Operations

By

Today I just noted down a very simple parent child form customization in D365 for Finance and operations.

 

First step is to create a primary key or alternative key  For this create a Index

and set Alternative key true and Allow duplicate set to no.

 

 

 

Next step expand the table Property and set following properties. With newly created Index.

 

 

As different to Dynamics Ax 2012. Reference field you have to manually created in child table.

 

Now expand relationship node of child and right click and add relation

 

Relationship property window set table

 

 

 

Now relight click on it and add normal relationship

 

 

 

Set new  both side of required field.

 

 

Table relation is complete.

 

As I am fan of old style Dynamics Ax 2012 Style development So I made Customization similar to that.

There are multiple way to build parent child forms, with a new form Patterns of D365 for Finance and operations

 

For Detail page. Add new form in your project and did not select any form pattern.

 

Then add Tab control and add two tab pages, one for Parent and one for child

 

 

Set tab control style property to FastTabs.

 

 

Now add both Tables in data source of form.

 

Set Join Source of child table set parent table

 

Now Drag required fields in group in parent area.

 

 

 

Now in child tab page, Add action pane, Action Tab control ,Button group and add three command buttons with Name add, edit and delete also set their command  type respectively.

 

Also set action tab as Strip.

 

 

Also Set Button group data source property to child data source so Add, edit and Delete works on child table.

 

 

 

 

Now Add grid below action tab and Set its data source to child data source.

 

Also drag child table fields under the grid.

 

Tab page structure look like similar.

 

Now click on tab Design and  Set its data source to Parent Table, so out of the box button on form works for parent table.

 

 

 

Now create three display menu and set one for Edit, one for View and Add new also set object property to detail form.

 

 

Like this. For new  set open mode to new and Set form in object

 

 

Similar edit menu, View menus the difference is open mode.

 

 

 

Now create a new form and a form and apply simple list pattern.

Also resolve pattern requirement, by adding Grid, Action Pane, and Group, Apply pattern on and then add Search

Like follow

 

 

Now drag three display menu drag them in Button group on List page’s action pane.

 

Right click Design and from properties  set New Record Action property to menu button of Action pane so on click on new button redirect to child page in new mode.

 

And set the

 

 

 

Let see the out put

 

 

 

If we click on new button, it will leads us to child page for create new, edit and delete records

 

 

On Clicking on link this will leads to detail page for selected record, which where we can add entries for child records.

 

How to apply application hot fix on Dynamics 365 for finance and operations

By

Hi a couple of days ago, I got chance to apply application hot fixes required to apply on cloud dev environment.

So I made this very short post.

 

 

First Step:

Check in all changes in TFS and make sure no error in AOT.

 

Second step:

 

You need to download hot fix from LCS.

 

 

Third Step:

To download vm RDP file and credential from LCS and login in VM.

 

 

Fourth step:

 

Open visual studio with run as admin.

 

Then from Dynamics 365 menu click on addins and from contex menu click on hot fix.

 

 

 

 

fifth Step:

 

 

Extract the zip file and extract the hot fix file and load into dialog. Also set TFS settings.

 

Apply And in couple of second patch is applied

 

 

Sixth Step:

 

After path applied, Synchronization database from Dynamics 365 menu.

 

 

 

Seventh Step:

Check all compile model, Make sure that all models are check in.

 

 

 

Eighth Step:

 

Resolve error in the case errors occurs,

In my case no error occurs.

 

 

9th step:

 

Check in everything into TFS with hot fix name in comments.

Manually deploy all reports on a D365 for Finance and operations one box

By

Run power shell as an admin and run below command (change path if needed) J:\AosService\PackagesLocalDirectory\Plugins\AxReportVmRoleStartupTask\DeployAllReportsToSSRS.ps1 -PackageInstallLocation “J:\AosService\PackagesLocalDirectory”

 

Reference:

Free introductory course on MVA for Dynamics 365 for finance and operations, enterprise edition.

By

Do you want to introductory session, then this course is for you. Yes it is free any one can watch very basic level course on Microsoft Virtual Academy

https://mva.microsoft.com/en-US/training-courses/introduction-to-microsoft-dynamics-365-for-finance-and-operations-enterprise-edition-17908?l=AHneoTOJE_906312570

Course contents are amazing.

 

 

  •  Course Introduction Time00:01:3701 | Overview
  •  Cloud-Based Solution Time00:02:02
  •  Workspaces Driving Productivity Time00:02:48
  •  Workflows in Your Business Processes Time00:03:34
  •  Reporting Time00:01:12
  •  Industry Focus Time00:02:2902 | Introduction to Functionality
  •  Overview Time00:02:55
  •  Order-to-Cash Time00:00:33
  •  Demo: Order-to-Cash Functionality Time00:07:38
  •  Procure-to-Pay Time00:00:32
  •  Demo: Procure-to-Pay Functionality Time00:08:16
  •  Plan-to-Produce Time00:00:42
  •  Demo: Plan-to-Produce Functionality Time00:05:19
  •  Recruit-to-Hire Time00:00:59
  •  Demo: Create Jobs, Positions, and Recruitment Projects Time00:10:21
  •  Complete an Application and Hire a Worker Time00:00:11
  •  Demo: Complete an Application and Hire a Worker Time00:08:08Post-Course Survey
  •  Post-Course Survey (Optional) Assessment: Full Course
  •  Assessment: Full Course

float value conversion in string SSRS expression and decimal points SSRS dynamics ax 2012 R3.

By

 

 

Today I have to record very small tip. During development of on SSRS report for Dynamics Ax 2012 R3, End user wants a row at the report footer for  analysis. he wants some kind of percentage  calculation with ‘%’.  A For this I have to use CStr ssrs expression function  like

 

Ctr(((sum(DataSet!field.Value) / sum(DataSet!field.Value)))*100)+”%”.

 

Now it is string and shows number of decimal as it result from division. For example  5.4356333. But end user wants formatting like 5.43 .

It is string or text value and SSRS textbox formatting is not apply on it.

 

Following SSRS expression works for me.

 

 

 

Left(CStr(5.4356333),instr(CStr(5.4356333),”.”)+2)

 

 

My Updated expression is something like this

 

Left(CStr(IIF(Parameters!ProductionReportBM2DS_ItemName.Value = “ITEM-00000420”,((sum(Fields!Scrap.Value)/sum(Fields!TotalConsumption.Value))*100),((sum(Fields!CutLength.Value)/sum(Fields!TotalConsumption.Value))*100))),instr(CStr(IIF(Parameters!ProductionReportBM2DS_ItemName.Value = “ITEM-00000420″,((sum(Fields!Scrap.Value)/sum(Fields!TotalConsumption.Value))*100),((sum(Fields!CutLength.Value)/sum(Fields!TotalConsumption.Value))*100))),”.”)+2) +”%”

Custom lookup for Financial Dimension D365 for Finance and Operations (Dynamics Ax 7)

By

Suppose we have to display all values in “Cost Center” financial dimension in custom lookup. For this post I used unbound field.

So first step is we need we need a text box. So drop a control of type “String” ( “Traditionally it is StringEdit Control”).

Right click on “OnLookup” event and click on “copy event handler method”.

Now add a new class in project, update its same as required. For this post I renamed it as FromControlEventHandler

Between opening closing brackets of class, paste the event code, I copied code in previous step.

[FormControlEventHandler(formControlStr(FrmTestDetail, FormStringControl1), FormControlEventType::Lookup)]
public static void FormStringControl1_OnLookup(FormControl sender, FormControlEventArgs e)
{

}

Later update event method with following code snippet, If you are seasonal Ax consultant or developer you will find this very similar to Ax 2012.

/// [FormControlEventHandler(formControlStr(FrmTestDetail, FormStringControl1), FormControlEventType::Lookup)]
public static void FormStringControl1_OnLookup(FormControl sender, FormControlEventArgs e)
{
Query query = new Query();
QueryBuildDataSource queryBuildDataSource;
QueryBuildRange qbrForAccount;
SysTableLookup sysTableLookup;
// DimType dimType;
DimensionAttribute dimensionAttribute;
// SysTableLookup::newParameters(tableNum(CustTable),sender);
sysTableLookup = SysTableLookup::newParameters(tableNum(OMOperatingUnit),sender,true);
sysTableLookup.parmUseLookupValue(false);
sysTableLookup.addLookupfield(fieldNum(OMOperatingUnit, OMOperatingUnitNumber));
sysTableLookup.addLookupfield(fieldNum(OMOperatingUnit, Name));
queryBuildDataSource = query.addDataSource(tableNum(OMOperatingUnit));
queryBuildDataSource.addSortField(fieldnum(OMOperatingUnit,OMOperatingUnitNumber));
queryBuildDataSource.addRange(fieldNum(OMOperatingUnit, OMOperatingUnitType)).value(int2str(any2int(OMOperatingUnitType::OMCostCenter)));
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();

FormControlCancelableSuperEventArgs ce = e as FormControlCancelableSuperEventArgs;
//cancel super() to prevent error.
ce.CancelSuperCall();

}

There is no need to add different classes for each event. You can copy and write events of different controls in single class.
There is another option on form control event, “Find Event Handler”. On click on it, will leads to event handler reference, I we wrote it. For current post I clicked on “Find Event handler”

results in as

Now let see what will our output. So I pressed Ctrl+F5 to form run without debugging.
Cheers, After pressing Edit Button my unbound custom lookup with Specific financial dimension works fine.