Parameters for Excel File Path in Microsoft Power BI
When I am working on, building and/or designing my Microsoft Power BI reports, I go back and forth between my desktop PC and my notebook. If my data source is a local file, like an Excel file, it can be tricky. Tricky, that is, if you do not use parameters for the file path. I use this feature now, EVERY time I work with local data. Saves me oodles of time and frustration! Check it… Continue Reading Belinda Allen’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Easier to Create Opening Balances for Item Tracked Inventory
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 1. The seventeenth of the new functionality in the Application section is Easier to create opening balances for item tracked inventory. Businesses can easily move the… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Demo Tool and Data for Warehouse and Inventory Scenarios
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 1. The sixteenth of the new functionality in the Application section is Demo tool and data for warehouse and inventory scenarios. To help partners demonstrate the advanced… Continue Reading Ian Grieve’s...
List Rows, Select Columns, and Lookup field – Power Automate / Dataverse
Suppose we want to retrieve the value of the source campaign lookup of the lead records. The schema name of Source Campaign is – campaignid To get its GUID in the Select columns of list rows we can specify it as _campaignid_value i.e. _lookupschemaname_value The other option is if we specify the schema name in … Continue reading “List Rows, Select Columns, and Lookup field – Power Automate… Continue Reading...
MB-220 Configure marketing applications (15–20%)
The MB-220 certification is divided into 8 major sections. The first of these sections is all about configuring the application to work optimally. It contains the following four sub-sections; Configure the Dynamics 365 Marketing app Configure organization settings Configure and manage marketing settings Manage insights I referred to several blogs and learning materials in the
Dynamics 365 Business Central and .NET 6
The upcoming Dynamics 365 Business Central 2023 Wave 1 version introduces an important server change: the NST server now runs on .NET 6. This is a huge improvement to the entire platform expecially in terms of performances and resource optimizations: Up to 30% faster AL runtime The NST is using less memory But this new changement has also an effect on partners: .NET interops with… Continue Reading demiliani’s Article on...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Catalog Items Use Standard Number Series, Can Include in Blanket Sales Orders
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 1. The fifteenth of the new functionality in the Application section is Catalog items use standard number series, can include in blanket sales orders. It’s now easier for… Continue Reading Ian...
Microsoft Release 2023 Wave 1: Form creation and management in Real-Time Marketing – Part 2
In our previous blog, we saw how we can create an advanced form in Real Time Marketing. This blog will be a continuation of the same. Here, we will see how we can manage a form. Edit a Live form: The Edit button on the top of the ribbon bar allows you to update a published form. Begin editing your live form and when you save, your changes will automatically be published. Unpublish your live form: Choosing the...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Add More Columns to Pages for Better Insight
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 1. The fourteenth of the new functionality in the Application section is Add more columns to pages for better insight. Different businesses and users need different… Continue Reading Ian Grieve’s Article...
Viva Sales: Administrator Settings
I wrote two articles about Viva Sales back in August of last year, when it first became available in preview. If you haven’t read those articles, you can read part 1 here and part 2 here. Viva Sales has been generally available since October of 2022. Since the release, there have been some enhancements to Viva Sales. Last week I wrote an article about the new suggested email replies… Continue Reading Dian Taylor’s...
Viva Sales-Administrator Settings – YouTube
Viva Sales-Administrator Settings In this video I will show you how to access the administration settings for Viva Sales. This will allow you to configure forms that are used in Viva Sales, make fields editable, etc. Related Article: Viva Sales: Administrator Settings I wrote two articles about Viva Sales back in August of last year, when it first became available in preview. If you haven’t read those articles, you can read part...
Agents not receiving calls in Omnichannel Voice – Dynamics 365 Customer Service
Recently we saw a few of our agents were not receiving the calls/notification for incoming conversations. Apart from checking the Routing Diagnostics, we can refer to the Omnichannel Ongoing Conversation Dashboard (available for the Omnichannel Supervisor role) In our case, we realized that the ongoing conversation was in Wrap-up status for the agent. And also … Continue reading “Agents not… Continue Reading Nishant...
Continia Certified: Continia Document Capture Professional User
Since I startedworking with Microsoft Dynamics 365 Business Central last year, I’ve also been learning some of the add-ons which are commonly used. One of those add-ons is Document Capture from Continia Software. They seem pretty well organised and have a Continia Learn which is very much along the same lines as Microsoft Learn; you can also do an exam for each of their products which results… Continue Reading Ian...
Using Focused View And Up Next In Model-Driven Apps
Even if you don’t read the Wave 1 and Wave 2 release notes in full detail, it’s ALWAYS a good idea to pay attention to the areas that you and your team use regularly. There is one feature that might potentially go un-noticed but it will be pushed out to users automatically meaning you had better understand what it does and how it works before you start getting asked questions about it right?… Continue Reading Megan...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Removed Functionality
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 1. When announcing the upcoming releases Microsoft do state that changes may be made up to delivery timelines or projected functionality may not be released (see the Microsot… Continue Reading Ian...
Vendor multisourcing feature with Planning Optimization
Vendor multisourcing is a common need retrieved in a lot of contexts. Sometimes, customers want to select the appropriate vendor according to specific criteria such as evaluation, lead time, availability, or simply a key allocation. Until now the Master Planning didn’t offer such function, there were only the possibility to setup the default supplier on the item and schedule a planned order… Continue Reading Yohann...
Async onSave preventDefault with external call
One of our current projects is the migration of an onPrem Dynamics 365 to the Cloud. Part of that is refactoring existing JavaScript implementation. The current implementation had an onSave function which prevented the save process based on a call to the WebAPI. It took me some time to migrate the function, therefore I thought it might be interesting for others to know how to write an async… Continue Reading Benedikt’s...
How to create Sales Order in Business Central using Power Virtual Agent?
Now, when chatbots are becoming a more and more popular way of communicating with customers, all users would like to do more via chatbots. As Microsoft’s response to tools that can make chatbots, there is Power Virtual Agents, and the real power of Power Virtual Agent (PVA) is enormous. But as business application specialists, we always try to think about how to connect it to some of our… Continue Reading Marko Totovic’s...
ClassicPress Plugins Available From azurecurve | Development in 2023: BBCode
In this series of articles, I am going to introduce each of the plugins I have developed for ClassicPress, a hard-fork of WordPress, which was originally created to provide an alternative, yet compatible, CMS without the Gutenberg block editor. The 4th plugin is BBCode. Allows users to use standard bbcodes in posts and pages in place of HTML tags. The following bbcodes can be used: Bold:
ClassicPress Plugins Available From azurecurve | Development in 2023: Avatars
[featured-index key=’classicpress’]In this series of articles, I am going to introduce each of the plugins I have developed for ClassicPress, a hard-fork of WordPress, which was originally created to provide an alternative, yet compatible, CMS without the Gutenberg block editor. The 3rd plugin is Avatars. Upload a new avatar and set as the default avatar and allow users to upload their own… Continue Reading Ian...
❤️🔥Dynamics 365 Copilot y Business Central
Nuevo Video en mi canal de Youtube. Os comparto el video que he publicado en el canal de YouTube Tech Sphere Dynamics. ¿Te gustaría mejorar el marketing de tus productos con Dynamics 365 Copilot para Business Central? En este video te voy a mostrar cómo puedes añadir descripciones de marketing atractivas y personalizadas para cada producto usando la inteligencia artificial de… Continue Reading Javier.Armesto’s Article on...
SQL Scripts for Microsoft Dynamics GP: Update Item Engineering File from a Text File
This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posted the scripts I wrote against Microsoft Dynamics GP over the 19 years before I stopped working with Dynamics GP. This script uses BULK INSERT to update values in the IVR10015 table for existing items. /*Created by Ian Grieve of azurecurve | Ramblings of an IT Professional (http://www.azurecurve.co.uk) This… Continue Reading Ian Grieve’s...
Error Calculating Depreciation in Microsoft Dynamics 365 Business Central
I’ve been doing a lot of work with a client to, amongst other tasks, implement the Fixed Asset module in Microsoft Dynamics 365 Business Central. We ran through the configuration and then started testing that everything worked correctly. It was all going well until we tried to calculate depreciation when we encountered an error message: Gen. Jnl. Batch Name must have a value in FA Journal… Continue Reading Ian...
Dynamics 365 Business Central in 2023 release wave 1
It’s always nice having to prep a webinar about “what’s new in Business Central”. It makes you being very busy with what’s next, and forces you to dive into it :-). Not always easy though, because – even today – there isn’t too much documentation online yet (it’s not fully released either, so .. quite obvious). So, while prepping this, I did take some notes, which I’d be...
Microsoft Power Platform URLs and IP address ranges
Microsoft Power Platform requires some of the URLs that are to be configured in the Firewalls or need to add them in your browser proxy settings to access them. If the endpoints are not configured properly, this will have an impact on accessing the Power Platform services or some features might not be loaded in Power Apps, Dataverse, Dynamics 365 etc. Follow the below links and configure to access all the resources without any issue...
Yoda : «Business Central Wave 1 de 2023 around the corner is already ,get ready your must»
No, this is not Star Wars nor is the post about how to prepare for the update. Today I want to talk about some of the new features that we will have in Business Central wave 1 2023, to be launched in April next year. According to the release plan published by Microsoft, these are some of the improvements that we can enjoy: Data analysis One of the most interesting novelties is the… Continue Reading Javier.Armesto’s Article...
SQL Scripts for Microsoft Dynamics GP: Update Item Resource Planning on Item Quantity Master from Text File
This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posted the scripts I wrote against Microsoft Dynamics GP over the 19 years before I stopped working with Dynamics GP. This script uses BULK INSERT to update the item resource planning fields on Item Quantity Master (IV00102). /*Created by Ian Grieve of azurecurve | Ramblings of an IT Professional… Continue Reading Ian Grieve’s Article on their...
Yoda : «Business Central Wave 1 de 2023 a la vuelta de la esquina ya esta ,prepararte tu debes»
No esto no es Star Wars ni tampoco el post va sobre como prepararnos para la actualización. Hoy quiero hablaros de algunas de las nuevas funcionalidades que tendremos en Business Central en la wave 1 de 2023, que se lanzará en abril del próximo año. Según el plan de lanzamiento publicado por Microsoft , estas son algunas de las mejoras que podremos disfrutar: < h2 class=”wp-block-heading...
Microsoft Edge Extension: Don’t Close Window With Last Tab
While I mainly use the Vivaldi browser I do use Microsoft Edge for work related browsing. However, there is one feature of Vivaldi which I really miss when using Edge and that is when closing the last tab in the browser you’re returned to the speed dial. With Edge when you closet the last tab, the entire browser closes; something which I always forget and am constantly annoyed by. I am so used… Continue Reading Ian...
ISV License Generator v0.6 released
Yesterday I released a new version of ISV License Generator with full support for the SHA-256 hash function after fixing an issue with it. What’s new in ISV License Generator? In this new version the support to generate Dynamics 365 Finance and Operations licenses using the SHA-1 hash has been removed, and it will use… Continue Reading ISV License Generator v0.6 released ariste.info ISV… Continue Reading Adrià Ariste...
Your Power Apps user settings are probably wrong
Are the date, time, number and currency fields looking funny in your app that uses Dataverse? Here’s where to fix the settings & why managing them is so complex. Continue reading Your Power Apps user settings are probably wrong at Jukka Niiranen. Continue Reading Jukka Niiranen’s Article on their blog Your Power Apps user settings are probably wrong – Jukka Niiranen When you’re starting to use a brand new...
Using Coalesce Function to handle null value in Power Automate – Dataverse
Recently in one of our flows, we were getting the below error – InvalidTemplate. Unable to process template language expressions in action ‘List_rows_:_Region’ inputs at line ‘0’ and column ‘0’: ‘The template language function ‘replace’ expects its first parameter ‘string’ to be a string. The provided value is of type ‘Null’. Please see...
SQL Scripts for Microsoft Dynamics GP: Create Macro to Delete Items
This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posted the scripts I wrote against Microsoft Dynamics GP over the 19 years before I stopped working with Dynamics GP. This script selects all items from Item Master (IV00101) and creates a Dynamics GP macro which can be played back to delete the items. It was created as some items were imported during an… Continue Reading Ian Grieve’s Article...
Identify deprecated JS code in your Power Platform solution using Solution Checker
Here’s how you can identify deprecated code used in your Power Platform solution. Continue Reading priyeshwagh777’s Article on their blog Identify deprecated JS code in your Power Platform solution using Solution Checker Recently, you must’ve received an intimation from Microsoft saying that ODATA v2 is now deprecated. See this link:...
FA Posting Type Must Not Be “” on a General Journal in Microsoft Dynamics 365 Business Central
As I announced in September, I am now working with Microsoft Dynamics 365 Business Central. I have been climbing a steep learning curve, but I think I’ve got a handle on most of the basics now. It is sometimes the little things which are catching me out. I was doing some testing with fixed assets and ran into an issue trying to enter an asset acquisition: FA Posting Type Must Not Be on a Gen…. Continue Reading Ian...
How to – Configure Voicemail Workstream and Queue – Dynamics 365 Customer Service
When we configure the Voice demo, we can see 2 workstreams and queues created for Voicemail one for individuals other for voicemail of type group. The Default Group Voicemail Workstream has the following intake rule defined. And following Route to Queue Rule Configuring Voicemail… Continue Reading Nishant Rana’s Article on their blog How to – Configure Voicemail Workstream and Queue – Dynamics 365 Customer...
Deliver personalized customer experiences with Copilot in Dynamics 365 Marketing and Customer Insights
It's the dawn of a new era in customer experience where AI is transforming the way businesses connect with their audiences. Microsoft is proud to be at the forefront of this shift, using Azure OpenAI Service to empower marketers with new levels o…(read more) Continue Reading Jim Nakashima and Ryan Jones’s Article on their blog Microsoft Dynamics Community It’s the dawn of a new era in customer experience where...
SQL Scripts for Microsoft Dynamics GP: Update Mfg Cost Accounts from Mfg Item Class Setup
This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posted the scripts I wrote against Microsoft Dynamics GP over the 19 years before I stopped working with Dynamics GP. This script updates the manufacturing cost accounts on the items using the accounts on the linked classes; this script was created for a client where it was found that classes had been updated and… Continue Reading Ian Grieve’s...
How to Set a Default Printer in Windows 11
I’m sure that setting a default printer in Microsoft Windows used to be quite simple. However, I was having problems with Windows never defaulting to the same printer and the one it suggested was never the one I wanted. I did some poking around and it actually took me a few minutes to work it out. This was on a Windows 11 machine, but it ay have been the same on Windows 10 without my having… Continue Reading Ian...
Características Mandatorias – Dynamics 365 Supply Chain Management Ver. 10.0.32
Aquí les dejo un resumen especialmente de las características que vendrán activadas por defecto en la versión 10.0.32 y que NO pueden desactivarse: Inventario y Logística: Limite la cantidad de líneas de pedido de ventas por tarea por lotes: ayuda a optimizar el rendimiento del sistema al publicar confirmaciones, listas de recolección, albaranes y facturas al limitar la cantidad… Continue Reading Juan...
Viva Sales – Suggested Email Replies (preview) – YouTube
Viva Sales – Suggested Email Replies (preview) In this video I will discuss the new suggested replies feature in Viva Sales, which allows sellers to quickly generate automatic email responses from Viva Sales using AI. Related Article: Viva Sales: Suggested Email Replies I am sure you’ve heard of Viva Sales, which was launched by Microsoft last year in October of 2022. If you haven’t heard of it, it’s definitely...
Table Customisation Of Real-time Marketing Journeys
Creating and managing your Real-time Marketing Journeys just got easier. I’ve been asked many times about how to link Journeys to a Campaign or add additional details to provide different ways to sort and review them. If you are on the latest version (at least 1.92.2019.0, you can now edit the Journey table. You’ll need to look for the Journey table with the logical name of msdynmkt_journey to… Continue Reading Megan...
Data Upgrade from Business Central 19 To Business Central 20.
Hi Readers, It's been a while since I recorded this but forget to update here in blog. There were so many questions regarding upgrading from Business Central 19 to Business Central 20. #alupgrades, #businesscentral, #dataupgrade Read Complete Article » Continue Reading Saurav Dhyani’s Article on their blog Data Upgrade from Business Central 19 To Business Central 20. It’s been a while since I recorded this but forget...
Viva Sales: Suggested Email Replies
I am sure you’ve heard of Viva Sales, which was launched by Microsoft last year in October of 2022. If you haven’t heard of it, it’s definitely time you learned about it! Microsoft Viva Sales is an application that makes selling easier. It works with Microsoft Outlook and Microsoft Teams to automatically record and view information about customers in a customer relationship management (CRM)… Continue Reading...
Dynamics 365 Business Central 2023 Wave 1 release: hidden AL gems for Power Platform integrations
The upcoming Dynamics 365 Business Central 2023 Wave 1 release (version 22) together with the new AL extension version 11.X will introduce some hidden new AL code-related features for improving the integration with Power Automate and Power Platform + Dataverse in general. For integrating Power Automate flows in Dynamics 365 Business Central pages, two new customaction types are… Continue Reading demiliani’s Article on...
How to – Enable Desktop notifications when the app is in the background – Dynamics 365 Customer Service (Omnichannel – Voice)
Below is how the notification appears to the agents for the incoming conversation. In case the app is in the background the agent might miss the notification. To avoid this scenario we can enable Desktop notifications. Navigate to Agent Experience >> Workspaces >> Notification Templates (Manage) in the Customer Service Admin center … Continue reading “How to – Enable Desktop… Continue...
Free Practice Assessments for Microsoft Certifications
Microsoft has released the below Practice Assessments for the Microsoft Certifications and more exams to come soon for Practice. Click on the links to start the practice Assessment before taking the actual exam to gain more confidence. SNOPractice Assessment1AI-900: Microsoft Azure AI Fundamentals2AZ-104: Microsoft Azure Administrator3AZ-204: Developing Solutions for Microsoft Azure4AZ-305: Designing Microsoft Azure Infrastructure...
SQL Scripts for Microsoft Dynamics GP: Update Min Order Qty and Average Lead Time on Vendor Item From Text File
This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posted the scripts I wrote against Microsoft Dynamics GP over the 19 years before I stopped working with Dynamics GP. This script imports a tab delimited file and updates the Min Order Qty and Average Lead Time on Vendor Item card; there is error handling built in to ensure the vendor item exists. If there are… Continue Reading Ian Grieve’s...
Error Stating G/L Account Missing Even Though it Exists When Raising Journal in Microsoft Dynamics 365 Business Central
I was talking to a client recently about an issue where I advised them to create a general journal to correct a posting issue. They followed up a short time later saying that when they tried to enter the journal, they were receiving an error message: Validation Results The field Account No. of table Gen. Journal Line contains a value (60200) that cannot be found in the related table (G/L… Continue Reading Ian Grieve’s...
Electronic signatures feature
The electronic signatures need is more and more often on the table when discussing with customers and prospects. Regarding this topic you have to know that Dynamics 365 Finance & Supply Chain Management offers some capabilities to cover this. What is exactly the purpose of electronic signature? Some definition means that It helps guarantee compliance and accountability, and may be either… Continue Reading Yohann...