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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
ClassicPress Plugins Available From azurecurve | Development in 2023: Add Twitter Cards
[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 2nd plugin is Add Twitter Cards. Add Twitter Cards to attach rich photos to Tweets, helping to drive traffic to… Continue Reading Ian...
ClassicPress Plugins Available From azurecurve | Development in 2023: Add Open Graph Tags
[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 1st plugin is Add Open Graph Tags. Add Open Graph Tags to attach rich photos to social media posts to Facebook… Continue Reading Ian...
SQL Scripts for Microsoft Dynamics GP: Validate and Insert/Update Vendor Emails 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 is the customer equivalent of the ,a href=https://www.azurecurve.co.uk/2021/07/validate-and-insert-update-vendor-emails-in-microsoft-dynamics-gp-from-a-text-file/’>vendor script I… Continue Reading Ian...
SQL View to Return Budget Amounts by Accounting Period in Microsoft Dynamics 365 Business Central
I posted a SQL view towards the end of January which returns the start and end date of accounting periods in Microsoft Dynamics 365 Business Central. The SQL view below uses that view to return the budget figures from Dynamics BC for each accounting period grouped by account and the global and budget dimensions. — drop view if it exists IF...
SQL Scripts for Microsoft Dynamics GP: Generate Standard Cost Update Macro from Text File Import
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 text file and generates a Dynamics GP macro which can be played back to update the standard costs. There is built in error handling to validate the supplied item… Continue Reading Ian...
Reset BitLocker PIN
The new work laptop is protected with a BitLocker PIN which needs to be entered each time the laptop is started. This is all well and good and I think protecting the laptop and any client data it may contain is a good idea; however, after several weeks of entering the PIN, I apparently forgot what it was and couldn;t start the laptop. I spoke to the tech team and they gave me the recovery code so… Continue Reading Ian...
SQL Scripts for Microsoft Dynamics GP: Assembly Transaction Quantities Required
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 returns a list of work status assemblies and the quantity required for the assembly. CREATE VIEW uv_AZRCRV_AssembleQuantityRequired AS /*Created by Ian Grieve of azurecurve | Ramblings… Continue Reading Ian Grieve’s...
In Microsoft Dynamics 365 Business Central (Administration), how do I… Create a Sandbox for a Preview Release
This post is part of the In Microsoft Dynamics 365 Business Central (Administration), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central. While I intend to cover the Release 2023 Wave 1 preview which has just been made available, the same process will hold true… Continue Reading Ian...
SQL Scripts for Microsoft Dynamics GP: Sales Invoice Query
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 returns work status sales invoices which are linked to a history status sales order and along with data for the work transaction returns the originating transactions order number and… Continue Reading Ian Grieve’s...
Enable Auto Unlock for BitLocker Protected External Drive
I travel a lot for work and sometimes carry files with me on a SSD which has BitLocker enabled to ensure no-one else can access the files should I lose the device. In January 2020 I published an article on using PowerShell to unlock an encrypted drive using PowerShell. I did it that way as I was working onsite and wanted to be able to plug a drive in when needed, but not manually type the… Continue Reading Ian Grieve’s...
SQL Scripts for Microsoft Dynamics GP: Workflow Assignment Review
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 was created to allow a client to easily review the workflow step assignments. /*Created by Ian Grieve of azurecurve | Ramblings of an IT Professional (http://www.azurecurve.co.uk) This… Continue Reading Ian Grieve’s...
In Microsoft Dynamics 365 Business Central (Administration), how do I… Start a Free Trial (Updated for the new “customised trial”)
This post is part of the In Microsoft Dynamics 365 Business Central (Administration), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central. Back in August when I was early in this series, I wrote an article about how you sign up for a free trial of Microsoft… Continue Reading Ian...
ClassicPress Plugins Available From azurecurve | Development in 2023: Series Index
[featured-index key=’classicpress’]I started developing plugins for WordPress back in 2013; this was so that I could add some required functionality to this site which wasn’t available as standard or in third-party plugins. I switched to developing for ClassicPress in late-2018 and migrated all of my sites to it in early 2019. I made this change because WordPress introduced the Gutenberg editor… Continue...
SQL Scripts for Microsoft Dynamics GP: Update Item Replenishment Method for Manufacturing
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 replenishment method on all item/site combinations: /*Created by Ian Grieve of azurecurve | Ramblings of an IT Professional (http://www.azurecurve.co.uk) This code is… Continue Reading Ian Grieve’s...
Browser Extension to Force All Microsoft Dynamics 365 Business Central Pages to Open Maximised
One of the things I’ve been finding somewhat annoying with Dynamics BC is that pages open in a small size and need to be manually maximised. It turns out that I am not the only one to think this; Milan Milinčević, a Dynamics 365 Business Central developer with experience of .NET and JavaScript, also thought this, but had the skills to do something about it and created a plugin for Chrome and… Continue Reading Ian...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Copy And Paste Readable Hyperlinks
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 seventh of the new functionality in the User experiences section is Copy And Paste Readable Hyperlinks. Working productively with Business Central often requires… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Tailor Action Bar To Fit Your Needs On Document Lines
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 sixth of the new functionality in the User experiences section is Tailor Action Bar To Fit Your Needs On Document Lines. Personalizing actions can improve… Continue Reading Ian Grieve’s Article on...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Get Unblocked Using Actionable Error Messages In Select Application Areas
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 fifth of the new functionality in the User experiences section is Get Unblocked Using Actionable Error Messages In Select Application Areas. To help you get unblocked… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Get More Productivity Out Of An Optimized Action Bar On All App Pages
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 fourth of the new functionality in the User experiences section is Get More Productivity Out Of An Optimized Action Bar On All App Pages. A promoted section of the… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Access Actions And Navigation Menu Efficiently With Keyboard
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 third of the new functionality in the User experiences section is Access Actions And Navigation Menu Efficiently With Keyboard. Organizations are looking to streamline… Continue Reading Ian...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Drag And Drop Files Onto The File Upload Dialog
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 second of the new functionality in the User experiences section is Drag And Drop Files Onto The File Upload Dialog. Business processes often require documents or other… Continue Reading Ian...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Add Existing Table Fields To Optimize Your Pages
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 first of the new functionality in the User experiences section is Add Existing Table Fields To Optimize Your Pages. The Microsoft Cloud empowers SMBs to adapt quickly… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Configure Security Controls For Teams Cards
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 second of the new functionality in the Productive with Microsoft 365 section is Configure Security Controls For Teams Cards. The Microsoft Cloud delivers… Continue Reading Ian Grieve’s Article on...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Experience Enhanced Adaptive Cards In Teams
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 first of the new functionality in the Productive with Microsoft 365 section is Experience Enhanced Adaptive Cards In Teams. Sharing Business Central records as cards… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Refresh Of Content To Support Modern Tooltip UI
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 third of the new functionality in the Onboarding section is Refresh Of Content To Support Modern Tooltip UI. Better guidance in field tooltips helps people understand… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Modern Tooltips Are Easy To Read And Understand
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 second of the new functionality in the Onboarding section is Modern Tooltips Are Easy To Read And Understand. A smooth experience onboarding to Business Central is… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Easily Find And Install Payroll Apps From Within Business Central
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 first of the new functionality in the Onboarding section is Easily Find And Install Payroll Apps From Within Business Central. Easily find and install the right… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Audit File Export Eases Saf-T Compliance
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 second of the new functionality in the Legislation section is Audit File Export Eases Saf-T Compliance. SAF-T (Standard Audit File for Tax) is an international… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Non-Deductible, Partly Deductible Vat Expands 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. The first of the new functionality in the Legislation section is Non-Deductible, Partly Deductible Vat Expands Functionality. Users in all relevant regions have improved… Continue Reading Ian Grieve’s...
How to Perform a Bank Reconciliation in Business Central
Let's learn how to perform a bank reconciliation in Dynamics Business Central. Bank reconciliation is a critical aspect of business accounting, helping you to ensure that your bank statement matc…(read more) Continue Reading Jo deRuiter’s Article on their blog Microsoft Dynamics Community Let’s learn how to perform a bank reconciliation in Dynamics Business Central. Bank reconciliation is a critical aspect of...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Transfer Environments Between Azure Ad Tenants
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 fourth of the new functionality in the Governance and administration section is Transfer Environments Between Azure Ad Tenants. In some cases, administrators may want… Continue Reading Ian Grieve’s...