Sending the Customer Group records From D365 to Outlook: Logic Apps POC

Sending the Customer Group records (D365) to Outlook:

Step 1: Login to the Azure portal with your credentials


Step 2: Search Logic App, and click on it


Step 3: Click create button on the right corner below


Step 4: Give Name and select an Existing resource or create a new resource group and click create


Step 5: Select Blank logic app

Step 6: Perform the following steps :

                1 Create request

                2 Create Response

                3 Take Dynamics 365 operations and select get records


                4 Sign in with your credentials

                5 Add instance and Entity Name

                6 In next step add office 365 outlook and sign in with your credentials

                7 Add To, Subject and Body (Give the field names that needs to be send via mail)

                8 Save the Logic App Designer


                9 Click run, Once the Logic app runs successfully you will see all the green check marks




Extensions In D365

Table Extensions :

The following table lists each table method and its events.

Published Table method Preceding event Succeeding event
validateWrite ValidatingWrite ValidatedWrite
validateDelete ValidatingDelete ValidatedDelete
validateField ValidatingField ValidatedField
validateFieldValue ValidatingFieldValue ValidatedFieldValue
modifiedField ModifyingField ModifiedField
modifiedFieldValue ModifyingFieldValue ModifiedFieldValue
Insert Inserting Inserted
Update Updating Updated
Delete Deleting Deleted
Initvalue InitializingRecord InitializedRecord
FinalDeleteValidation Executed when a delete operation is performed on a table object, before the operation is committed to the underlying database table N/A
FinalInsertValidation Executed when an insert operation is performed on a table object, before the operation is committed to the underlying database table N/A
FinalReadValidation Executed when a read operation is performed on a table object. N/A
FinalUpdateValidation  Executed when an update operation is performed on a table object, before the operation is committed to the underlying database table. N/A


In Ax upgradations we might get some DB synchronization issue like below errors:

Error :

Cannot select  a record in Global address book(some table name)

Sql error description: Invalid column name ‘XXXX’(some field name)

Below are the steps to follow:

–Step 1. To create a temptable and pass all records into temptable

SELECT * INTO DirPartyTable_Temp FROM DirPartyTable


–Step 2. Deleting the Main table

DROP TABLE DirPartyTable


–Step 3. Your Main table will get recreated after DB Sync

—perform you DB synchronization from AOT


–Step 4. Import data from DirPartyTable_Temp to DirPartyTable


SELECT * FROM DirPartyTable_Temp

If you face any error here like fields count is not matching then check some new fields are added in to Main table create same fields in temp table and run the above code again.


–Step 5. Drop your temp table created at stage 1.

DROP TABLE DirPartyTable_Temp

perform you DB synchronization from AOT

What’s New in AX 7.0

What’s New in AX 7.0

What’s new in Technologies?

•Technologies : Win32 -> HTML, CSS, JavaScript based; no plugins RPC-> Services communication, Hosted through modern Browser or Windows Store App
•Low latency between logical control and AOS, 
•High latency between physical control and logical control 
•All X++ runs on server tier,
•Form app state on server, 
•Deltas keep control state in sync, 
•Web server to support WAN usage
•Single Page Application,
•Common browser actions for new windows/tabs,
•Back button for all forms and panels
•Simplifying navigation and form management
•URL updating for direct navigation items
•Parent record context

What new in basic functionalities?

•Fully web base function (setup /configurations/operation/reporting)
•Very colourful web base client with new slider functionality
•New Fleet management module coming in
•New task recorder function has been introduce, which you can play from AX and it will guide you the all the steps in AX itself.
•Workflow ribbon has been removing, workflow operationally has been changed. But configuration of the workflow is same like AX2012 R3 CU9.Optional workflow on all create/edit processes.
•EP/ESS has been remove, its replace via ESS/MSS workspaces
•Error messaging or warning messaging look change like LCS.
•Lots of reports layout changed with nice look and fill which can be used as external business documents.

What new in module specific functionalities?

•Financial statement reports now migrated to management report. There is no standard financial statement report available via SSRS reporting. Deployed Management reporter with AX 7.0, it means you no need to install separately.
•There are new 16 default reports available for General ledger module.
•Few navigation in GL form got changed i.e., legal entity of the main account move to as a fast tab in main account form. 
•Budget planning has enhanced, now it’s more easy to use for user and as well as consultant to configure.
•Mis Charges posted in Product receipt has introduced in AX 7.0

•Human resource management now more easy to market due to web capability. Now it’s can complete with other HRMS specific product. 
•Employee master is very easy to create.
•New workflow has been in introduce for loan equipment request via ESS workspace.
•Expenses management module is now support calendar view expenses report preparation with itemized capability.
•Project Accounting module has few new changes; role base estimation which has introduced in workforce scheduling. It’s also integrated with WBS of a project. Its support role base operation, automatic team generations
•Pricing for the role also introduced, which help the sales team and project team do a cost & revenue analysis with role. 
•WBS template export and import function introduced, which help the project manager use this function without MS project server 2013 integrations
•360 degree view available for resource available with graphical view. Resource load visibility also available from the same view.