Ali Raza Zaidi

Musing's of ERP Consultant

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

MS Dynamics Ax 7

How to deploy non production database to Production server Dynamics 365 for finance and operation.

By

This activity is not recommended, but most of the time,  before go live , master data is configured on UAT server and rapidly used. And most of functional consultant do not want this activity on production. Due to time saving as well as they are too much busy on different projects. Any how we can do this. There was no option available directly deploy or restore UAT database to production. For this we have to create service request to Microsoft. This is step by step guide.

So first step is to login into LCS and then open your project

From project detail form click on create new service

Machine generated alternative text: 365 for Operations Implementation Project 5/31/2017 and develop oroduction environment mock cutover system health 7/15/2017 Deploy 3/25/2018 Test 5 Operate Description The entire project team should pa te in a Go Live Health check ta ensure all asp f the system are operating as expected; bat ctionaly and technically. Task history ENVIRONMENTS Subscriptions available SeNice requests PRODUCTION Environment hsa state: Deployed Full details SANDBOX: STANDARD ACCEPTANCE TEST V Environment 'at state: Deplcyed Full details SANDBOX: DEVELOP AND TEST V Environment dev state: Deployed Activate Wins-dws u etails

From Service request window. Go to service request and click on add new

Machine generated alternative text: tecycle Services namvcs Operations Implementation Project .A Corporate m ces Work items Open work items Support issues Service requests Hotfix requests Extensibility support requests + Add p Filter View environment details Reschedule Cancel Show cancelled requests Show finished requests onment name -uat Actionable by Sep.•ice Provider Provider Provider Downtime start 1/4/2020 PM (UTC +04:00) 10/9/2018 AM (UTC +04:00) 10/3/2018 AM (UTC +04:00) Downtime end da 144... 63066 61762 Maintenance Operation New deployment New deployment New deployment Service request st... Requested Requested Requested

From popup select Sandbox to production

Machine generated alternative text: ics 365 for Operations Implementation Project View environment details Reschedule Cancel Show cancelled requests Corporate Services LLC.) Show finished requests v"aintenance Operation Qew deployment Qew deployment Qew deployment Environment name Qui-I at Service request st... Requested Requested Requested Actionable by Provider Provide Pr Down 10 10 Create request Select request type Production Point-in-time restore Restore the database of an environment with an automatic backup taken at an earlier date. Sandbox to production Move e copy of sandbox database into production for Go Live Other request Create other requests Cancel

Next window you have to select the time. Sandbox source and prefer down time.

At least 4 hours from the creation of service request and 5 hours minimum downtime required

Machine generated alternative text: ished requests No Actionable by Provider Provider Provider Provider Provider Provider Provider Provider Request for sandbox to production Source environment name 3-uat Target environment name hse Preferred downtime start date 2/7/2020 9 v Preferred downtime end date 2/8/2020 1 v All times are displayed in your 'ocel time zone (currently UTC Please be aware that other users will see the time localized into their time zones. Recommended! To produce a clean database refresh, we recommend performing this action when user activity and batch jobs are minimized in the source em.'lronment. I agree selecting a preferred downtime date and time does not I agree this request will result in a downtime of up to 4 hours wi I agree copying sandbox into production will OVERWRITE the pr Submit Cancel

Check all check boxes for agreed after that submit button will enabled .click on submit for Microsoft request.

They reserve downtime for 5 hours but 90 percent deployment will complete with in couple of hours.

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- 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

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.