Procedure to create custom logs in Dynamics NAV
Whether you are a small sized business, a mid-sized one or a large business, Microsoft dynamics nav upgrade is all you must do to gain new heights in your business. Elements NAV clients are passing up the genuine advantages of moving up to Dynamics NAV in the present cloud-based condition. Microsoft is persistently seeing approaches to ad lib the Enterprise Resource Planning Systems or ERPs. In the event that you overhaul Dynamics NAV, you will be exploiting improved usefulness, new highlights, and upgraded abilities, you can help efficiency, diminish costs, and improve client assistance. Utilizing Microsoft Dynamics NAV Inventory Management, organizations can do errands, for example, setting up elective merchants, mind stock gathering the executives, and get the necessary investigation report easily. Introduction: To track changes that are made to records in a particular table and to store them sequentially in NAV, logs have to be created. Using logs we can record changes that are made to standard or custom fields in a table. In this article, I will be demonstrating the steps required to setup logs in NAV. Pre-Requisite: Microsoft Dynamics NAV 2017 Procedure: 1. Navigate to ‘Change Log Setup’ Page using the NAV windows or web client. 2. In the actions tab, choose ‘Tables’ under Setup group to select the tables and the fields on which changes are required to be logged. 3. A list of all the standard and custom tables will be displayed. Logs can be created on three events: Initially when the record is created, log will be created with the initial value of the selected field to be logged. When the record is modified, log will be created in the system with the old and new value of the selected field to be logged. When the record in deleted, log will be created in the system. 4. You can either select some fields to be logged or select the All fields option. If you select ‘some fields’, click on the ellipses (…) to select the fields on which log will be created. If ‘All fields’ has been selected, by default all the table fields changes will be logged. 5. I have created a log entry on ‘Item’ table on two fields ‘No.’ and ‘Car status’. Car status is a custom field with option datatype. 6. On clicking the ellipses (…) when ‘Some Fields’ is selected, the table field list will be displayed. Select the event when a log record has to be created i.e. Log Insertion, Log Modification or Log Deletion. 7. Now on the Change log setup page, select the ‘Change Log Activated’ checkbox. 8. After creating a record in ‘Item’ table and modifying the values of the ‘Car status’ field, the following logs are created in the system. Date and Time when the log is created is stored which will be useful to get history of events performed in the system at any point. The user ID who is creating and modifying records will be stored. Table caption stores the table name which is selected. Primary Key Field 1 Value stores the Item No. i.e. the unique field in the table. Type of change will be stored i.e. Insertion, Modification or Deletion. For option fields, the old value and new value is stored. Conclusion: These are the steps required to create logs in NAV which will track changes made to the fields selected in the change log setup.
Share Story :
Installing Multiple CRM Portals Instances for Microsoft D365 CRM Online.
Introduction: In this blog, we shall see how can a user install multiple Portal Instances for Microsoft D365 CRM Online. Pre-Requisites: D365 CRM Portals D365 CRM Environment Overview 1. A user can set up more than one Portal for a given D365 Environment provided that the second portal is different from the first portal that is installed. For eg: If the user has already installed a community portal then the user will have to install a different type of portal like partner portal , employee portal etc. 2. The user cannot install two portals of the same type. For eg. If the user has already installed a customer portal then he cannot install multiple portals which are customer portals. 3. As we know that a user can have multiple portals associated with the same D365 (CRM) instance and along with a single D365 Subscription the user gets out of the box a single portal license, which means that the user gets only one free portal add-on. 4. The user can go to the Instance page and install multiple portals as shown below in the available multiple options. In order to have a second portal add-on on the D365 instance the user will have to follow the Steps given below: Step 1: Opening the Admin Center. Â Go to D365 and open admin as shown below. Step 2: Opening the Purchase Service In the Admin Center Page click on the Billing option in the left side menu bar and select Purchase Services under that. Step 3: Selecting the Subscription In the Purchase Services, we will have to find the following subscriptions which are as follows: Dynamics 365 Enterprise Edition – Additional Portal Dynamics 365 Enterprise Edition – Additional Portal Page Views **Note: These Licenses are only shown to the user if they have a purchased license and are not using trial version of the license
Share Story :
Recover deleted emails in Office 365 – For Administrators
Introduction: Sometimes users accidentally can remove their emails from inbox and deleted items folder. You can find the deleted mail in Recover deleted items. There also might be a situation when a user cannot find a deleted email in their Office 365 mailbox, a user will probably ask you to recover missing mails. You can recover it directly through Exchange Online using the In-Place eDiscovery & hold options (You must be a Global Administrator in Office 365). Steps: To recover deleted emails, follow the steps below: 1. Login to your Office 365 account and go to the Admin app. 2. On Left pane, extend Admin centers and click Exchange (Exchange Admin Center). 3. Go to Permissions > Admin Roles. From list of roles select Discovery Management and click on Edit icon. 4. On resulting window, go to members section and click + to add a member. Search for your name and click add and Ok. Save it. 5. Sign out and Sign In again, so that changes take effect. 6. Once permission is assigned to you, go to the Compliance Management section and then In-Place eDiscovery & hold. Click + icon 7. Provide a name for your search and, optionally, a description. Click Next. 8. You can choose a mailbox you want to search. Select the Specify mailboxes to search option, and then click on the + icon to add a mailbox. Click Next. 9. The next step is to specify criteria for a search query. Click the Filter based on criteria option, and adjust search options to your needs. When you need to provide more than one keyword in a search query, you need to separate them with OR or AND, not commas. 10. In the same window, click on the Select message types and select Email. Click OK. You can similarly search for contacts, meetings, etc. 11. Once you adjusted search query to your needs, click Next. 12. In the In-Place eDiscovery and hold page click Next without choosing any options as we don’t want to place any content on hold. 13. Now, your settings will be saved. Once the process is completed, click Close. 14. Select the search you created and click Refresh to update the information displayed in the details pane. The status of Estimate Succeeded indicates that the search has finished. 15. In details pane, click Preview search results to view the items. This helps you identify the items you are looking for. 16. If you can’t find an item by previewing search results, then you can copy the search results to a special mailbox (called a discovery mailbox) and then open that mailbox in Outlook on the web to view the items. On the copy search results page, click Browse. Under the display name, click Discovery Search Mailbox, and then click OK and Copy (shown in above image). When the copying is complete, click Open to open the Discovery Search Mailbox to view the search results (shown in below image). The search results copied to the Discovery Search Mailbox are placed in a folder that has the same name as the In-Place eDiscovery search. 17. After you find the item you’re trying to recover for a user, the next step is to export the results from the search you ran to Export to PST. The user will use this PST file in the next step to restore the deleted item to their mailbox. Click below arrow mark as shown in below image. 18. Click on Run to install eDiscovery tool. 19. Click on Browse button to add location and leave the enable deduplication & include unsearchable items option. 20. After providing PST location click Start, it will ask for Office 365 admin credentials, after providing the same download will start. 21. The last step is to just send this PST file to the user so that he can restore. User need to use the outlook desktop app to restore deleted item by using a PST file. Click to Open Outlook Data File, browse the file and click OK. The PST file appears in the left-nav bar in Outlook. Expand the same and right-click the item you want to recover and then click Move > Inbox. In the below image, you can see recoverable items. Conclusion: You can easily recover the deleted mails of users even if it is deleted from deleted items and are not shown under recover deleted items.
Share Story :
Deployment Document: TIBCO Cloud Integration Agent
Introduction: This document contains the steps on how the TIBCO Cloud Integration Agent with custom connector for Dynamics GP can be deployed on server. Install a TIBCO Cloud Integration on-premise agent A TIBCO Cloud Integration agent needs to be installed on the server where the target data store resides. Download TIBCO Cloud Integration agent You can download and setup an agent from https://app.scribesoft.com Once logged in to TIBCO Cloud Integration portal in the server where the target data store resides, navigate to ‘More’ and then ‘Agents’ and then click on ‘+’ and ‘On-Premise Agent’ to create a new agent. Please refer the screenshot below: A new window will open where you can click on Install On-premise Agent to download the agent as shown below: On clicking Install On-premise Agent, TIBCO Cloud Integration will provide you to download the agent. You need to save the same to your local system. Copy the Agent Key in your clipboard; it will be used during Installation of Agent. Navigate to the location where the ScribeInstaller was downloaded and start the installation Make sure pre-requisites are setup to be able to successfully continue with the installation and click Next: The wizard will start. Click Next until you see the screen where Agent Key is asked by the installer. Enter the same key which appeared on the screen where new agent was provided to be downloaded. And click next. Select where you want to install the TIBCO Cloud Integration agent. Finally click Install Agent. Let the setup continue. Click Finish once the setup completes. Turning TIBCO Cloud Integration Agent on and off TIBCO Cloud Integration Agent on your system is a Windows Service which can be stopped, started and restarted. View Services application on your Windows machine to locate the TIBCO Cloud Integrationweb service Locate Scribe Online Agent in the Services. This is where you can start and stop service in the event of updating the DLLs for the Scribe Online connector. Deploying Scribe Online connector on the target system Deploying the Scribe Connector to the target system consists of copying the required DLLs and PDBs to the following folder in the Scribe Online Agent directory located on the target machine: Locate Connectors folder in the Scribe Online Agent directory. Folder named “DynAD Connector” contains DLLs and PDBs required to be available in the Scribe Online’s Connector folder. This folder needs to be copied in the Scribe Connector’s Connector folder. The address for Scribe Online Connector is: C:\Program Files (x86)\Scribe Software\Scribe Online Agent\Connectors Once the folder is pasted to the Connector folder, the agent needs to be started again. Navigate to View Local Services on the machine and locate Scribe Online Agent and start the same as shown below. For the Custom GP Connector developed for AKA, the following files are required to be copied in the “DynAD Connector” folder. Note: Since the project is divided into 2 DLLs across a Visual Studio solution, CFS.Connector.GPConnector.dll and CFS.GPClient.dll are the 2 DLLs and their respective PDDs are required. Required Files: Connector.GPConnector.dll and CFS.Connector.GPConnectorA part of the GP connector (.dll) and its PDD file GPClient and CFS.GPClientA part of the GP connector (.dll) and its PDD file Core.ConnectorApi.dllThis .dll file is required by the ScribeOnline agent to be able to access the Scribe API provided by ScribeOnline. Json.dll and Newtonsoft.Json These .dll files are required by the connector to be able to JSON file stream where the fields of the target connector are retrieved. JSON files – 5.1 DynADCampaignHeader.json 5.2 DynADCampaignLineItem.json 5.3 DynADSalesCommission.json 5.4. DynADCampaignErrorLog.jsonThe above files are the JSON files which contain the fields required by Dynamics GP entities. These files need to reside in the folder as the .dll require these. Important: These files also need to be present in the C:\Windows\System32 of the system. Updating Solutions with newly installed Scribe Online Agent Login to Scribe Online Portal through https://app.scribesoft.com Open a Solution and resign the Solution with newly installed Agent. Repeat this for all the Solutions. Conclusion: By following the mentioned steps, you can deploy the Scribe Online Agent with custom connector for Dynamics GP on server.
Share Story :
Power BI Embedded in Microsoft Dynamics 365 Operations
Microsoft power BI is a collection of features and online services that enables you to share your findings, analyse and visualise data in the form of dashboard and reports and the whole process is termed as power bi analytics. Utilizing the Microsoft Power BI Integrations, you can import information that is huge from different sources into the Power BI work area. You can alter the information or plan on changing it in the wake of bringing in to your framework. The Microsoft Power BI Service now and then is alluded to as Power BI or app.powerbi.com. You can keep awake to date with all the fundamental data that truly matters to you. Force BI arrangement will assist you with conquering the greater part of the issues you are looking for effortlessly. Introduction: In this article, we will see how to embed Power BI in Microsoft Dynamics 365 Operations. Steps: Register your Dynamics 365 Operations as a web app on Azure AD. Open link: http://dev.powerbi.com/apps Login to your Power BI account Fill the required details: App Name App Type: Select as ‘Server-Side Web app’ Enter a redirect URL: Your instance URL with /oauth at the end Enter a homepage URL: Your instance URL Choose API access you need. Click Register App. Once the app is registered, you will get Client ID and Client Secret. Copy these 2 keys, you will need it later. Navigate to Power BI settings in Operations which is under System Administration section. Enter the details in Power BI configuration: Client ID: Paste the Client ID Key from Power BI registration Application Key: Paste the Client Secret key from Power BI registration Redirect URL: Your instance URL with /outh at the end Enable the Power BI Navigate to Reservation Management for instance and you will see a Power BI column. Click on Get Started. Authorize Power BI by clicking on ‘Click here to provide authorization to Power BI’ You will be redirected to the new window with authorization success message Now, you can select reports and dashboards from Power BI and pin them to your workspace.
Share Story :
Deploy a Microsoft Dynamics NAV Database to Azure SQL Database
Dynamics 365 for finance and operations is the ultimate solution for all the modern-day organisations facing issues on ERP level and this is the reason it is the most trusted software in the world which all modern-day organisations have adapted. Get a live perspective on the entirety of your numbers and information investigation from Microsoft elements for money related administrations. This cloud-based Microsoft ERP framework gives the important data you have to convey vital, information-driven bits of knowledge to key divisions. Mechanize your stockroom procedures to lessen operational expenses. With Microsoft ERP, your distribution center supervisors can all the more likely control their set aside, quality-control, and picking activities. Furthermore, with an adaptable work process motor, they can quickly react to changing business needs. Introduction This article describes how to deploy Microsoft Dynamics NAV database to Microsoft Azure SQL Database. To deploy a Microsoft Dynamics NAV database to Azure SQL Database, the database must be exported as a data-tier application (DAC) file, which is known as a .bacpac file. This can be performed by using the SQL Server Manager. Pre-requisite Microsoft Azure subscription and access to the Azure Management portal Microsoft Dynamics NAV database is installed on a SQL Server Database Engine instance. SQL Server Manager is also installed on the same computer. Access to the Microsoft Dynamics NAV installation media (DVD). Purpose: The purpose of this article is to deploy NAV Database on Azure SQL database and to access the deployed Database from Microsoft Dynamics NAV Development Environment. Steps: 1. Create and configure an SQL Database Server in Azure a. Create a SQL database in Azure. Click the New button found on the upper left-hand corner of the Azure portal. Select Databases from the New page, and select SQL Database from the Databases page Enter the Database name, resource group, select source Under Server, click Configure required settingsand click on Create a new server. Fill in the details Server name – valid server name Server admin name, password, Location. Here location is the location name where the Virtual Machine is stored When completed the form click on Select. Click Pricing tier to specify the service tier and performance level for your new database. Use the slider to select 20 DTUs and 250 GB of storage. For more information on DTU see what-is-a-dtu After selected the amount of DTUs, click Apply. Click Createto provision the database. On the toolbar, click Notifications to monitor the deployment process b. Create a server level firewall rule The SQL Database service creates a firewall at the server-level that prevents external applications and tools from connecting to the server or any databases on the server unless a firewall rule is created to open the firewall for specific IP addresses. To set a server-level firewall rule, click on SQL Database > Overview page > click Set server firewall on the toolbar as shown in the following image: The Firewall settings page for the SQL Database server opens. Click Add client IP on the toolbar to add the IP address of the computer that is currently being used and then click Save. A server-level firewall rule is created for the current IP address. Make a note of the SQL Database server name because it will be required later. 2. Deploy the existing Microsoft Dynamics NAV Database to an Azure SQL database. Deploy a databse to SQL Azure wizard is used to deploy database between an instance of the Database Engine and an Azure SQL Database server. The wizard uses a Data-tier Application (DAC) BACPAC archive file to deploy both the data and the definitions of database objects. Limitation and Restriction: The Deploy Database wizard supports deploying a database: From an instance of the Database Engine to Azure SQL Database. From Azure SQL Database to an instance of the Database Engine. Between two Azure SQL Database servers. The wizard does not support deploying databases between two instances of the Database Engine. Using the Deploy Database wizard: In the VM, open SQL Server Management studio(SSMS). Click on File > Connect Object Explorer. Connect to the location of the database you want to deploy. You can specify either an instance of Database Engine or a Azure SQL Database server. In Object Explorer, expand the node for the instance that has the database. Expand the Database Before deployment, remove the windows authenticated users as these will cause failure of the transfer process. To remove the windows login user, navigate to Security under the Database in NAV > Users >Click on the Windows user then delete. Right click the database you want to deploy, select Tasks, and then select Deploy Database to Microsoft Azure SQL Database. This opens the Introduction page, click on Next. In the Deployment settings page, click on connect and specify a path to store the .bacpac file in the Temporary file name. Specify the Azure SQL Server name, authentication is SQL Server authentication and enter the login name and password for the server and click on connect. Specify the Edition of Microsoft Azure SQL Database, Maximum database size and service objective then click on Next. This information can be viewed in the Overview of the Azure SQL Database. The progress of the deployment can be viewed in the summary tab. This may take few minutes. The Result is displayed after completion of the deployment of NAV Database to Azure SQL Database. The Database deployed can be viewed in Azure SQL database. Below is the figure showing the deployed database ‘Demo Database (10-0)’ from NAV to Azure. 3. Set up endpoints for the Microsoft Dynamics NAV client services. To add the endpoint you need to follow the below steps, Click on the Virtual Machine( VM) > overview > Resource Group . This will open an overview for the resource group. select NetSecurity (Network Security Group) then click on Inbound Security Rules. 4. Configure a Microsoft Dynamics NAV Server instance on the virtual machine. To configure SQL Server authentication: Set up an Encryption key Configure SQL Authentication on Database Configure SQL Server authentication on Microsoft NAV Sever Instance (Non-Multitenant) or Configure SQL Server authentication on Microsoft NAV Sever Instance (Multitenant Deployment) Follow the below steps to set up an encryption key and configure SQL Authentication on … Continue reading Deploy a Microsoft Dynamics NAV Database to Azure SQL Database
Share Story :
Create Customer Assets in D365 Partner Field Service Portal
Introduction: This blog explains how to configure Create Customer Assets Page in D365 Partner Field Service Portal. Steps of Implementation: 1. Create a new Entity Form in D365 Field Service. Create a new Form for Customer Asset Entity with name “Portal Customer Asset – Create” and publish as shown below. Create Entity Form with name “Create Asset” as shown below. Open “On Success Settings”, set On Success as “Redirect” and Web Page as “Assets” as highlighted below. Set Submit button on Entity Form, Click on “Submit” Action and enter label as “Create Asset”, as shown below. Create a new Entity Form Data to set “Expose to Customer” equals “True”. Select Type as “Attribute” and select Attribute Logical Name as “Expose to Customer”. Check on “Set Valule on Save”, select Type as “Value” and enter Value as “true”. 2. Create a new WebPage in D365 Partner Field Service Protal. Open Assets Page. Click on New => Child Page in Administrative Panel. Enter details as below and click on Save button. 3. Add Create button in Assets Entity List in D365 Field Service. Open “Assets Customer Web View” record in Entity List as highlighted below. Open Grid Configuration Section in Options Tab. Create new Action “Create”, Select Target Type as “Web Page” and select Redirect to WebPage as “Create Assets ( Partner Portal )” as shown below. Conclusion: Above description in blog helps users to create Customer Assets from D365 Partner Field Service Portal. Create button on Asset List Page. Create Asset form. New Asset record is shown in list. Blog Tips: How to redirect to page after a record is created successfully by using “On Success Settings” tab. How to set data on record from D365 Portal automatically by using Entity Form Metadata. How to show data created in D365 Field Service Portal as soon as it is created by setting field “Expose to Customer” equals to true.
Share Story :
Increase/Decrease Inventory from Item Card in NAV 2017
Introduction: With Microsoft Dynamics NAV 2017, we can increase or decrease the inventory of an item from the item card itself. Steps: 1. Navigate to Item card. 2. Select assist Edit next to Inventory and enter the New Inventory. 3. If New Inventory is less than current inventory a Negative Adjustment will be passed behind the scene. 4. If New Inventory is greater than current inventory a positive Adjustment will be passed behind the scene. 5. As soon as we enter new Inventory and click ok. 6. System Looks for an Item Journal template, Create a New Batch for the Item Journal. 7. Insert a New Item Journal Line with Default Location as Blank. 8.Post the Transaction. Important points to remember: 1. All the Transaction posted with this will always post with Blank Location Code. 2. The process will not work if item is Mandatory Serial / Lot Tracked. 3. Unit of Measure will be picked from Item Base Unit of Measure.
Share Story :
Create Job -Human Resource Management (Dynamics 365 Finance & Operation Enterprise)
For the modern-day organisations that have global scalability and digital intelligence, dynamics 365 for finance and operations is definitely the need of the hour. Make more precise interest estimates to improve your items’ accessibility and limit your stock expenses. The apparatus utilizes Microsoft SQL Server determining calculations, Microsoft Excel perceptions, and Dynamics 365 for Finance and Operations models—for conjectures you can rely on. Get perceivability across associated circulation, client assistance, deals, and promoting frameworks so you can develop your items and procedures to meet rising desires. Get continuous data on practically any gadget, whenever. Elements 365 for Finance and Operations improves and quickens business process changes. What’s more, it’s situated in the cloud, so it coordinates with inheritance frameworks and scales universally effortlessly Introduction: Job is collectivity of tasks and responsibilities which are required of worker who perform a job. Pre-requisites: Before setup jobs, need to create below elements: • Job Title • Job Function • Job types • Compensation level • Survey company • Skills and skills level • Certificate type • Test type • Education • Screening type • Job tasks • Areas of responsibilities Steps: Below are steps to create department- Click Human resources > Jobs > Jobs. Click New In the Job field, enter a name for the job. In the Description field, type a brief description of the job. In the Title field, select a title for the job. In the Maximum number of positions field, indicate the number of positions that are allowed for the job: Maximum positions – Select this option and enter the maximum number of positions that are allowed for the job. Unlimited – Select this option to indicate that an unlimited number of positions are allowed for the job. In the Full-time equivalent field, enter an employment factor from 0 to 1. The value 1 indicates a full-time job. For part-time employment, enter a number between 0 and 1. For example, enter .5 for a half-time job. In Description Fast tab, enter detail description of the job. Click on the Job classification fast tab In the Job type field, select a job type to associate with the job. In the Function field, select a job function. Click on Compensation fast tab. In the Level field, select a wage level for the job. In the Survey company field, select the survey company that is responsible for the survey that was applied to establish the market-based pay range for this job. In the Reference job field, enter the job code that the survey company uses for this job. In Market Price Range information, specify market based pay range in source field. In Low threshold, control threshold and high threshold, specify minium, basic and maximum amount that paid to worker who assigned for this job. On Skills fast tab, enter skills required for the job. In level field select skills level and in importance field, select importance level (From1 to 6) On the Certificates fast tab, optionally enter certification requirements for the job and importance of the certificate On the Tests FastTab, enter tests for workers are required to pass for the job. On the Education FastTabs, optionally enter educational requirements for the job and the importance of the education. On the Screenings FastTab, optionally enter any screening that workers are required to pass for the job. On the Job tasks FastTab, optionally enter job tasks to the job template. On the Areas of responsibility FastTab, optionally enter areas a worker is responsible for in jobs. Conclusion: By attaching job to position you can assign position to worker and it will help to maintain and track Job tasks, responsibilties, Skills, education, certifications, tests.
Share Story :
How to change the name of Custom App in Dynamics 365
Introduction: This blog consists of steps to change the name of the custom app in Dynamics 365. Initially the app name is “Dynamics 365-custom” as shown below. Steps: We can change the name to our organization name as shown below: Navigate to Settings–> Administration–>System Settings In General Tab–> Set options for the default app:Dynamics 365-custom–>Change the default app name The App name is changed to “CloudFronts Apps” and will be visible as below: Conclusion: Like this way, you can change the name of custom application in Dynamics 365.