Ali Raza Zaidi

Musing's of ERP Consultant

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

Dynamics 365 for Operations

How to enabled document attached on processed records Dynamics 365 for finance and operations

By

In many cases, document attachment disabled on processed records. Usually this happened with respect to business requirements. For example when Purchased order invoiced and settled in ledger, attachment add, edit and delete can be disabled. Only existing attachment can be view on these documents.But some cases we have to forcefully enabled document attachment on these processed records.

I used following code snippet to enable the document attachment. 

/ <param name="args"></param>
    [PostHandlerFor(formStr(DocuView), formMethodStr(DocuView, setEnabled))]
    public static void DocuView_Post_setEnabled(XppPrePostArgs args)
    {
        FormRun formRun; 
			//= sender;
        formRun  =Args.getThis();
        formrun.design().controlName("ctrlAdd").enabled(true);
        FormDataSource      DocuRef_DS =formRun.dataSource("DocuRef");
        DocuRef_DS.allowEdit(true);
        DocuRef_DS.allowCreate(true);
        DocuRef_DS.allowDelete(true);

    }

New courses are available for MB-700 solution architect certification on Microsoft learn

By

Microsoft just update the certification link. The courses are just quick start, rest is up to you.

https://docs.microsoft.com/en-us/learn/paths/become-solution-architect/https://docs.microsoft.com/en-us/learn/modules/becoming-solution-architect/index

https://docs.microsoft.com/en-us/learn/modules/discover-customer-needs/index

https://docs.microsoft.com/en-us/learn/modules/propose-solution/indexhttps://docs.microsoft.com/en-us/learn/modules/work-with-requirements/index

https://docs.microsoft.com/en-us/learn/modules/fit-gap-analysis/index

Validate Event form control Extensions- Dynamics 365 for finance and Operations

By

Very handy and quick tip. How to validate and cancel / failed validation logic in Dynamics 365 for finance and operations.. Here is
FormControlCancelEventArgs is key to return false in the case of validation fail.Very similar logic works for form data source field validate events. 

[FormControlEventHandler(formControlStr(BabayeeDaForm,  _BabayeDaTextBox), FormControlEventType::Validating)]
    public static void BabayeeDaForm_BabayeDaTextBox_OnValidating(FormControl sender, FormControlEventArgs e)
    {
var args = e as FormControlCancelEventArgs;
ret = checkFailed(' Main nahee mananah.');
            args.cancel(ret );
}

How to get calling menu name in extensions Dynamics 365 for finance and operations

By

Today is small tip, Many times, we have to took decision based on the name of menu  on which form is called. By getting menu name we can use same form for different purposes.  We can write logic based on current form called from which menu item.

Following is the code snippet helps you to achieve this.

[FormEventHandler(formStr(LogisticsContactInfoGrid), FormEventType::Initialized)]
    public static void LogisticsContactInfoGrid_OnInitialized(xFormRun sender, FormEventArgs e)
    {
        FormRun formRun = sender;
        
        if (formRun.args().menuItemName() == "CustomerLogisticsContactInfoGrid")
        {
            FormDataSource      LogisticsElectronicAddress_ds =formRun.dataSource("LogisticsElectronicAddress");
            LogisticsElectronicAddress_ds.InsertIfEmpty(true);
            LogisticsElectronicAddress_ds.object(fieldNum(LogisticsElectronicAddress, Locator)).mandatory(true);
        }

MB-300 global address book and other address books Dynamics 365 for finance and Operations

By

We are here

What is Global Address Book

Global Address book is common or single repository in Dynamics 365 for finance and Operations. The basic idea is that, everything is Party either it is Person, Organization, Customer, Vendor, Employee, worker, competitor or Contact.

Data is associated with Party, That have, Address, phone number,  email.

It is possible that one Party is Customer in one legal entity and Vendor in other legal entity.  Change in any place reflect any places.

Party detail can be vary based on either party is organization or  person.

Customer, vend, Contacts, Employee, worker, Applicate all identified as Party Role

The link between Global Address book and all other object can be explained clearly by Microsoft documentation

Machine generated alternative text: Address Book t: Perso Customer Prospect Worker user can belong to one or more Or anization is a type of Part plays a role of Vendor Competitor Applicant Contact c o o Can have one or more relates to o Location can have Quotation Sales Order Invoice Request for Quote Purchase Order More entities

Party Roles are considered to be as follow.

Customer is person or organization, who purchase goods or services from one or more legal entities.

Vendor is person or organization from organization purchase goods or services.

Contact. Is person that representor from vendor who communicate with organization.

Competitor– Person or organization, who provide the similar services or goods.

Applicant. A person, who applied to Job posted in your organization.

Points needs to consideration for Configure Global Address book

Points need to care before Configure Global Address book in your organization.

  • Sequence of First Name, Last Name and middle name in your organization.
  • Party record is delete automatically on deletion of Employee, worker, vendor or customer.
  • Notification in the case of Duplicate Party.
  • Should the Data Universal Numbering System (DUNS) number be included in a party record’s information?
  • If the DUNS number is included in a party record, should the uniqueness of the number be checked?
  • Party default, as organization or Person.
  • Role setup for private addresses.

Reference :

https://docs.microsoft.com/en-us/learn/modules/plan-config-global-address-book-finance-operations/

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/fin-ops/organization-administration/overview-global-address-book

MB-300- Certification guide Determine when to use workspaces Dynamics 365 for finance and operations

By

Hello, welcome to this post, In this post I will explain about navigation concept. If we go through the skilled measured PDF released measured by Microsoft it is follow

  • Determine when to use Workspace.
Machine generated alternative text: Exam MB-300: Microsoft Dynamics 365: Core Finance and Operations - Skills Measured The content of this exam was updated on November 1, 2019. Please continue scrolling to the red line section below to view the changes. Use common functionality and implementation tools (20-25%) Identify common Microsoft Dynamics 365 Finance and Operations features and functionality • • determine when to use workspaces identify use cases for Power Platform appsl including Power Apps, Power Bl and Microsoft Flow identify and differentiate between the global address book and other address books demonstrate Work Items functionality emonstrateMicrosoftDnamics365hnance andO eratlons naviation techni ues identify Inquiry and Report types available in a default installation

So what is workspace.

Workspace is one window to all operations performed by one role. Yes.

As this blog post is notes, So I can copied and paste things from different blogs added reference here.

So According to Microsoft

A workspace is defined as…

  • Part of the primary navigation mechanism.
  • A form that supports a business activity (a logical group of tasks that make up the work of a target persona).
  • A way to provide an initial overview and to increase productivity in the activity by allowing simple tasks to be completed directly in the workspace.
Machine generated alternative text: WORKSPACE Works ace Tile Pane Tabbed List Container Works ace Chart Pane Related Links Panel

When to use Workspace.

  • Provide deeper understanding of his task.
  • Without leaving Workspace End user can access all of pages.
  • Get Statistics of all operations, for example number of new sales order confirmed. Number of sales order delivered. And Number of Invoices generated.
  • Reduce the need of navigation.

If we explore the Customer Payments workspace it will something similar.

Machine generated alternative text: New OPTIONS p Customer payments Summary Record customer payment Customer transactions Invoices past due Payments not settled Find transactions Settlement history Customer invoices past due Filter V Number FT-INV-OOO... CUS-INV CUS-INV -00... SALE-CR-NT... CUS-INV-OO CUS-INV-OO CUS-INV-OO CUS-INV-OO CUS-INV-OO CUS-INV-OO CUS-INV-OO CUS-INV-OO CUS-INV-OO CUS-INV-OO CUS-INV-OO CUS-INV-OO CUS-INV-OO CUS-INV-OO CUS-INV-OO CUS-INV-OO CUS-INV-OO Customer 1 Payment Journals - not posted Payment Journals - not posted assigned to me Electronic payments sent need bank confirmation Due date Y 07/11/2019 07/11/2019 06/11/2019 06/11/2019 17/10/2019 17/10/2019 20/10/2019 20/10/2019 20/10/2019 20/10/2019 20/10/2019 20/10/2019 20/10/2019 20/10/2019 20/10/2019 20/10/2019 23/10/2019 23/10/2019 23/10/2019 23/10/2019 23/10/2019 Currency AED USD AED AED AED AED AED AED AED AED AED AED AED AED AED AED AED AED AED AED AED Amount 5,200.00 2,280.60 250.00 125.00 10,000.00 1,200.00 1,170.00 1,170.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 15,903.00 15,903.00 15,903.00 15,903.00 15,903.00 Balance 5,200.00 780.60 250.00 -125.00 10,000.00 1,200.00 1,170.00 1,170.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 15,903.00 15,903.00 15,903.00 15,903.00 15,903.00 CD Related information Reports Customer aging report Customer balance list with credit limit Customer posted paymentjournal rep... Deposit summary by customer report Deposit summary by date report Deposit slip report Detailed due date list report All customers Customer invoices due today Customers on hold Deposit slips A IN) Integratio Customer Integratio Customer Integratio Customer Integratio Customer Integratio Customer Integratio Customer Integratio Customer Integratio Customer Integratio Customer Integratio Customer Integratio Customer Integratio Customer Integratio Customer Integratio Customer Integratio Customer Integratio Customer Integratio Customer

Tiles

Rectangle box which behaves like a menu button. When you click on it, it will leads you to specific page. This contains specific information, that 10 Sales are pending for confirmation, 2 Sales orders are invoiced.

For example Sales Invoice workspace contains Something similar.

Machine generated alternative text: Customer payments Summary Record customer payment Customer invoices past due 1 Payment Journals - not posted Payment Journals - not posted assigned to me Electronic payments sent need bank confirmation All customers 0 Customer invoices due today Customers on hold 0 Deposit slips

List pages. This section contains the list pages For example sales Invoice contains following List Page.

  • Invoice past due
  • Payments not settled
  • Find transactions
Machine generated alternative text: Customer transactions Invoices past due Payments not settled Find transactions Filter V Number FT-INV-OOO... CUS-INV -00... CUS-INV SALE-CR NT CUS-INV-OO CUS-INV-OO CUS-INV-OO CUS-INV-OO CUS-INV-OO CUS-INV-OO CUS-INV-OO CUS-INV-OO CUS-INV-OO CUS-INV-OO CUS-INV-OO CUS-INV-OO CUS-INV-OO CUS-INV-OO CUS-INV-OO CUS-INV-OO CUS-INV-OO Settlement history Customer Integratio Customer Integratio Customer Integratio Customer Integratio Customer Integratio Customer Integratio Customer Integratio Customer Integratio Customer Integratio Customer Integratio Customer Integratio Customer Integratio Customer Integratio Customer Integratio Customer Integratio Customer Integratio Customer Integratio Customer Due date Y 07/11/2019 07/11/2019 06/11/2019 06/11/2019 17/10/2019 17/10/2019 20/10/2019 20/10/2019 20/10/2019 20/10/2019 20/10/2019 20/10/2019 20/10/2019 20/10/2019 20/10/2019 20/10/2019 23/10/2019 23/10/2019 23/10/2019 23/10/2019 23/10/2019 Currency AED USD AED AED AED AED AED AED AED AED AED AED AED AED AED AED AED AED AED AED AED Amount 5,200.00 2,280.60 250.00 125.00 10,000.00 1,200.00 1,170.00 1,170.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 15,903.00 15,903.00 15,903.00 15,903.00 15,903.00 Balance 5,200.00 780.60 250.00 -125.00 10,000.00 1,200.00 1,170.00 1,170.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 3,900.00 15,903.00 15,903.00 15,903.00 15,903.00 15,903.00

One optional link based on Graphs and Charts. Something similar.

Machine generated alternative text: 92.47%

Then comes Related links.

This section, contains hyperlinks with in Dynamics 365 for finance and operations which are related to workspace, for example. Sales Invoice workspace contains following links.

Machine generated alternative text: Related information Reports Customer aging report Customer balance list with credit limit Customer posted paymentjournal rep... Deposit summary by customer report Deposit summary by date report Deposit slip report Detailed due date list report

References

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/user-interface/build-workspaces
https://docs.microsoft.com/en-us/learn/modules/navigate-finance-operations/2-navigation-elements

Out of the box workflow list Dynamics 365 for Finance and Operations

By

For future reference, I copied the list of out of the box workflow in Dynamics 365 for finance and operations from Microsoft learn.

General ledger workflow types

The following workflow types are available for General ledger. Each type corresponds to a journal type:

  • Ledger daily journal workflow – Use this type to create approval workflows for daily journals.
  • Ledger allocations journal workflow – Use this type to create approval workflows for allocation journals.
  • Ledger eliminations journal workflow – Use this type to create approval workflows for eliminations journal.
  • Advanced ledger entry workflow – Use this type to create approval workflows for advanced ledger entries.

Accounts payable workflow types

The following workflow types are available for Accounts payable:

  • Freight Invoice Approval – This workflow supports invoice approval.
  • Vendor invoice line workflow – Use this type to create review workflows for vendor invoice lines.
  • Vendor invoice approval journal workflow – Use this type to create approval workflows for vendor invoice approval journals.
  • Proposed vendor changes workflow – Approve the proposed vendor change.
  • Vendor disbursement journal workflow – Use this type to create approval workflows for vendor disbursement journals.
  • Vendor invoice journal workflow – Use this type to create approval workflows for vendor invoice recording journals.
  • Vendor settle promissory note journal workflow – Use this type to create approval workflows for vendor settle promissory note journals.
  • Vendor redraw promissory note journal workflow – Use this type to create approval workflows for vendor redraw promissory note journals.
  • Vendor invoice workflow – Use this type to create review workflows for vendor invoices.
  • Vendor bank remittance journal workflow – Use this type to create approval workflows for vendor bank remittance journals.
  • Vendor invoice register journal workflow – Use this type to create approval workflows for vendor invoice register journals.
  • Vendor draw promissory note journal workflow – Use this type to create approval workflows for vendor draw promissory note journals.

Accounts receivable workflow types

The following workflow types are available for Accounts receivable:

  • Customer free text invoice workflow – Use this type to create approval workflows for free text invoices.
  • Customer draw bill of exchange workflow – Use this type to create approval workflows for customer draw bill of exchange journals.
  • Customer settle bill of exchange workflow – Use this type to create approval workflows for customer settle bill of exchange journals.
  • Customer redraw bill of exchange workflow – Use this type to create approval workflows for customer redraw bill of exchange journals.
  • Customer payment workflow – Use this type to create approval workflows for customer payment journals.
  • Customer protest bill of exchange workflow – Use this type to create approval workflows for customer protest bill of exchange journals.
  • Proposed customer change workflow – Approve the proposed customer change.
  • Customer recurring invoice workflow – Use this type to create approval workflows for recurring invoices.
  • Customer bank remittance workflow – Use this type to create approval workflows for customer bank remittance journals.

Budgeting workflow types

The following workflow types are available for Budgeting:

  • Budget plan workflow – Use this type to create and review workflows for budget plans.
  • Budget register entry workflow – Use this type to create review workflows for budget register entries.
  • Budget account entry workflow – Use this type to create review workflows for budget account entries.
  • Commitments approval workflow – Use this template to create approval workflows for commitment documents.
  • General budget reservation workflow – Use this template to review general budget reservation documents.

Cash and bank management workflow types

The following workflow type is available for cash and bank management:

  • Bank reconciliation journal approval workflow – Use this type to create approval workflows for Bank Reconciliation journals.

Expense management workflow types

The following workflow types are available for expense management:

  • Travel acquisition workflow – Use this type to create approval workflows for travel requisitions.
  • Expense line item auto posting – Use this type to create line item automatic posting workflows for expense reports.
  • Expense report auto posting – Use this type to create document automatic posting workflows for expense reports.
  • Expense line item – Use this type to create line item approvals for expense reports.
  • VAT tax recovery – Use this type to create approval workflows for VAT tax recover.
  • Cash advance request – Use this type to create approval workflows for cash advance requests.
  • Expense report – Use this type to create document approvals for expense reports.

Fixed asset management workflow types

The following workflow types are available for fixed assets:

  • Ledger post fixed assets journal workflow – Use this type to create approval workflows for post fixed asset journals.
  • Ledger fixed assets budget journal workflow – Use this type to create approval workflows for fixed asset budget journals.

Human resources workflow types

The following workflow types are available for human resources:

  • Worker project experience – Use this type to create workflows for worker project experiences from employee self service.
  • Transfer worker – Use this type to create workflows for transferring workers using Personnel actions.
  • Human resources actions workflow – Use this type to create workflows for personnel actions, such as to create new positions or to modify positions.
  • Change worker fixed compensation – Use this type to create workflows for requesting fixed compensation changes for workers by using Personnel actions.
  • Worker position of trust – Use this type to create workflows for worker positions of trust from employee self service.
  • Worker courses – Use this type to create workflows for worker courses from employee self service.
  • Worker loaned amount – Use this type to create workflows for worker loaned items from employee self service.
  • Worker review – Use this type to create workflows for worker review.
  • Worker image – Use this type to create workflows for worker images from employee self service.
  • Worker education – Use this type to create workflows for worker education from employee self service.
  • Worker identification number – Use this type to create workflows for worker identification number from employee self service.
  • Worker skills – Use this type to create workflows for worker skills from employee self service.
  • Worker certificates – Use this type to create workflows for worker certificates from employee self service.
  • Hire worker – Use this type to create workflows for hiring workers by using Personnel actions.
  • Worker professional experience – Use this type to create workflows for worker professional experiences from employee self service.
  • Worker course registration – Use this type to create workflows for worker course registration.
  • Terminate worker – Use this type to create workflows for terminating workers by using Personnel actions.

Organization workflow types

The following workflow types are available for organization:

  • Signing limits workflow – Use this template to create a workflow for review of signing limit requests.
  • Create management workflow – Use this type to create a workflow for cases.
  • Document handling – Workflow type for document handling.

Procurement and sourcing workflow types

The following workflow types are available for procurement and sourcing:

  • Invoice received notification workflow – Use this type to create invoice received notification workflows for unconfirmed product receipts.
  • Product receipt failed notification workflow – Use this type to create notification workflows for failed product receipts.
  • Vendor rebate approval – Vendor rebate workflow approval type.
  • Purchase agreement approval workflow – Use this type to create approval workflows for purchase agreements.
  • Purchase order line workflow – Use this type to create review and approval workflows for purchase order lines.
  • Unconfirmed product receipt rejection notification workflow – Use this type to create notification workflows for rejected unconfirmed product receipts.
  • Purchase requisition line review Use this type to create review workflows for purchase requisition lines.
  • Catalog import approval – Use this type to create review workflows for imported catalogs.
  • Delivery due date notification workflow – Use this type to create delivery due date notification workflows for unconfirmed product receipts.
  • Vendor add application workflow – Use this type to create approval workflows for vendor add application requests.
  • Purchase order workflow – Use this type to create review and approval workflows for purchase orders.
  • Catalog import product approval Use this type to create review workflows for imported catalog products.
  • Purchase requisition review – Use this type to create review workflows for purchase requisitions.

Project management and accounting workflow types

The following workflow types are available for project management and accounting:

  • Review original budget workflow – Use this type to review an original budget.
  • Review timesheet line workflow – Use this type to review a timesheet line.
  • Request for quotes workflow – Use this type to review request for quotes.
  • Resource request line workflow – Use this type to review resource request lines.
  • Review timesheet workflow – Use this type to review a timesheet.
  • Review project invoice proposal workflow – Use this type to review project invoice proposals.
  • Review project quotation workflow – Use this type to review project quotations.
  • Review budget revision workflow – Use this type to review a budget revision.

Retail workflow types

The following workflow types are available for retail:

  • Retail sales line workflow – Use this type to review retail sales line price override.
  • Retail catalog line workflow – Retail catalog approval workflow type.
  • Retail sales quotation line workflow – Use this type to review retail sales quotation line price override.

Sales and marketing workflow types

The following workflow type is available for sales and marketing:

  • Create customer rebate workflow – Customer rebate workflow type

Time and attendance workflow types

The following workflow types are available for time and attendance:

  • Time and attendance journal registration workflow – Use this type to create approval workflows for time and attendance journal registration records
  • Time and attendance days total workflow – Use this type to create approval workflows for time and attendance days total records.

Reference : https://docs.microsoft.com/en-us/learn/modules/create-use-workflows-finance-operations/2-types

List of technical learning Paths on Microsoft Learn – Dynamics 365 for Finance and Operations

By

Hi all, I just created a list of technical learning paths on Microsoft learn.
Amazingly simple, good and easy to learn.
Hope you all enjoy, learn and take benefit from these links

application cannot be started. Contact the application vendor – Workflow Dynamics 365 for finance and operations

By

Hi all, today, while opening Workflow designer, I found following error

application cannot be started. Contact the application vendor

For this I have to clear the cache with following statement, in Command prompt

 

rundll32 dfshim CleanOnlineAppCache

 

Happy Daxing.

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

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

 

 

 

Allow duplicate check Global Address Book Dynamics 365 for finance and operations.

By

Dynamics 365 for finance and operations provide functionality of check Party Name already exists in Global Address book, So End user can select instead create a new one if required.

Here is video I shared this functionality in small less then 5 minutes series.

 

 

The internal time zone version number stored in the database Dynamics 365 for finance and operations

By

I  faced database Synch Error after deploying latest code to my Onebox VM.

 

The internal time zone version number stored in the database is higher than the version supported by the kernel (15/13). Use a newer Microsoft Dynamics 365 for Finance and Operations kernel

 

 

Solution is

Open local Database in SQL server management Studio

And run following Query on AXDB.

 

update SQLSystemVariables set VALUE = 7 where parm =’SYSTIMEZONESVERSION’

 

 

Reference:  http://dilliraj.blogspot.com/2016/07/the-internal-time-zone-version-number.html