Ali Raza Zaidi

A practitioner’s musings on Dynamics 365 Finance and Operations

alirazazaidi

On hand Inventory for Item X++ extensions Dynamics 365 for finance and operations

by

Today is very small tip. Today is Eid day, Very warm wishes for Eid holidays.
Here is code snippet for  on hand inventory method. I wrote with extension.
For for extension. create a new class and add attribute on Extension fo Class.
[ExtensionOf(tableStr(PurchLine))]
public static class  PurchLine_Extension
{
    [SysClientCacheDataMethodAttribute(true)]  //This attribute will cache your display method.
    public static display Real  MYOnHand( PurchLine _this)
    {
        InventOnHand inventOnhand;
        InventDim       InventDim;
        InventDimParm inventDimParm;
        inventDimParm.initFromInventDim(_this.inventDim());
        inventOnHand = InventOnhand::newParameters(_this.Itemid,_this.InventDim(),inventDimParm);
        return inventOnHand.availPhysical();
    }
}

Error CREATE UNIQUE INDEX ON DBO.PROJHIERARCHYSORTING Dynamics 365 for finance and Operations

by

I faced this problem while restoring staging database from 8.0 to latest version.
Microsoft did not provide any solution to extended index. You can add new indexes on table extension, but did remove or modified on existing indexes.
Severity    Code    Description    Project    File    Line    Suppression State
Error        CREATE UNIQUE INDEX I_17901NODEREFERENCE ON DBO.PROJHIERARCHYSORTING(PARTITION,DATAAREAID,TYPE,REFID,REFNODEID); —> System.Data.SqlClient.SqlException: The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name ‘dbo.PROJHIERARCHYSORTING’ and the index name ‘I_17901NODEREFERENCE’. The duplicate key value is (5637144576, atd, 0, , 0).            0
One solution I found that DBO.PROJHIERARCHYSORTING is have some kind of sorting data, And When we open Work Break down structure
this table is auto populate some kind of internal usage for sorting.
So I truncate the DBO.PROJHIERARCHYSORTING table and as result Database Synchronization successfully completed.
And opening WBS of existing table, I found data at SQL server level.
Happy DAXING.
There is no solution to extend table index on table.  So only solution to truncate the table.

Change Text/BackGround Color Based Off Cell Value in Grid Dynamics 365 for finance and operations

by

Hi all, today I got opportunity to change color of Grid Cell based on some condition.
I achieved this by following code snippet.
First all I set Auto declaration to true of  required control in grid,
Second I add overwrite displayOption of grid data source.
This code snippet is interesting. It triggers for every row on grid.
And if you see below code snippet method signature shows the Common _Record. With this common _record, we can get current row of data source. And this we can apply some condition
Suppose we what to customer Name background to red who has credit limit is less then 1000  Following works
  public void displayOption(Common _record, FormRowDisplayOption _options)
        {
            CustTable custTable = _record as CustTable;
            if ( custTable.CreditLimit  < 1000)
            {
                _options.affectedElementsByControl(CustName.id());
                _options.backColor(WinApi::RGB2int(255,0,0));
                _options.textColor(WinApi::RGB2int(255,255,255));
            }
            super(_record, _options);
        }
Happy DAXing.
No more MVP

I am no more MVP, but every ending is a new beginning. Let embrace it.

by

Common saying that, Maintain anything is more difficult to achieve it. I maintained my MVP status for 5 years. I got my first MVP award  back in 2014. I was not awarded this year, thanks God, now life is little more easier for me. I have to spent time to wrote blog post. Most of the time when I had nothing to share, then I have to do R&D. And did not engaged any activity that creates more responsibility, because I need time to wrote blog post.

It’s certainly creates lot of learning opportunity, but consumes lot of time.

Now I feel light weight and able to focus on those things which are more important than MVP.

Anyhow, I habitual to write posts, This blog will continue. But now things are more open like

CRM, SQL Server, C#. And Happy DAXing.

 

I still have more than 12 years coding experience.  Many tough projects delivered. Projects kick off, develop, delivered and closed off.  I worked for client side, Partner side and as independent consultant. And more importantly I am self-taught programmer. I learned by self VB 6, VB.net, C#, oracle reporting  6i, oracle reporting 10 G, Biztalk 2008 R2, Biztalk 2010, BizTalk 2013, Ax 2012, AX 2012 R3 and now Dynamics 365 for finance and operations. My experience is  customization, integrations, Report development and I have good knowledge of ERP processes. Now I have to play on my experience and deliverable.

How to populate form data source with temp table. Dynamics 365 for finance and operations

by

Hi, There are many scenario, when we do calculation and bind it with Grid in dynamics 365 for finance and operations.

For these scenario, we populate temp table at run time and bind it to form data source.

We wrote code init() initialization method of data source to bind temp table to populate.

I used following code snippet for data populate temp table based data source.

public void init() // init method of form data source.
{
Temptable temptable;
super();
tempTable.Field1= “Baba Zaidi”;
tempTable.insert();
tempTable.Field1= “Dynamics 365 Corner “;
tempTable.insert();
TempDBExampleTable.linkPhysicalTableInstance(tempTable);
}

Happy Daxing.

Small tip, but I learn it today, Again Document not create.

The batch task you entered is not valid. Enter a different batch task. Dynamics 365 for finance and operations

by

During development, I got this error, when try to type newly created class that need to be run in batch processing.

That class I manually type because it was not appear in a list new task form inside batch job.

Later I found that I did not implement the canGoBatchJournal() method of RunBaseBatch

After adding following code snippet in my class, it will start to show in batch job task list.

 

 

How to load number sequence class on UAT or Production server Dynamics 365 for finance and operations.

by

In Dev machine, we can call runnable class to load number sequence, but UAT or production server Visual Studio is not in our access.

In UAT or production server we can run number sequence load class in browser.  with following command.

usnconeboxax1aos.cloud.onebox.dynamics.com[company]&mi=SysClassRunner&cls=[job/runnable class name]

For current example, if my class name is xyzNumberSeqLoadModule

you can add class name after basic url as

SysClassRunner&cls=xyzNumberSeqLoadModule

usnconeboxax1aos.cloud.onebox.dynamics.com&mi=SysClassRunner&cls=xyzNumberSeqLoadModule