SQL Scripts for Microsoft Dynamics GP: list of Open Payables Distributions
This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posting 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 Payables distributions for transactions with a current transaction amount not equal to 0. /*Created by Ian Grieve of azurecurve | Ramblings of an IT Professional… Continue Reading Ian Grieve’s...
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Inventory Put-aways in Basic Warehousing
This post is part of the In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), 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. As I mentioned in this article on the different levels of inventory and warehouse management, put-aways… Continue Reading Ian...
Can Microsoft SQL Server 2022 Developer Edition be Used for Demos and Testing?
I’ve been creating a new dev/demo/test environment recently and have already posted some articles about how I install and configure Windows on the servers; as I am also installing the latest version of SQL Server I thought that I’d post articles about that as well, which is coming up soon. One though occurred to me though and that was which version of the SQL Server I could use with a valid… Continue Reading Ian...
SQL Scripts for Microsoft Dynamics GP: List Open Purchase Order Lines
This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posting 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 open purchase order lines from POs with a remaining sub total amount. /*Created by Ian Grieve of azurecurve | Ramblings of an IT Professional… Continue Reading Ian Grieve’s Article on their blog...
Microsoft Dynamics 365 Business Central User Can’t See Manufacturing Pages Despite Permissions
I fielded a query from a customer recently where they reported that when doing some testing in a Microsoft Dynamics 365 Business Central sandbox environment (they were considering using the Manufacturing functionality), they had assigned permission sets which gave access to Manufacturing windows, but when they searched or browsed the role explorer they could not see the pages from… Continue Reading Ian Grieve’s Article on...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Use Actions to Navigate or Fix Errors From Inline Validation Dialog
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The eighth of the new functionality in the User experiences section is Use actions to navigate or fix errors from inline validation dialog. Business Central validates data… Continue Reading Ian...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Search for Pages and Data in the Mobile App
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The seventh of the new functionality in the User experiences section is search for pages and data in the mobile app. More and more people use mobile phones or tablets to… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Peek at Summarized Data From Editable Fields
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The sixth of the new functionality in the User experiences section is Peek at summarized data from editable fields. Peek view offers a quick and easy way to access and… Continue Reading Ian Grieve’s...
Add Missing Prefix to Purchase Order Number in Continia Software’s Document Capture
I’ve been doing some work with a client recently, helping them implement Document capture (DC) from Continia Software. One of the queries which cam eup, was how to add a prefix onto a purchase order number. The issue was that they were sending purchase orders out with a company specific prefix (e.g. FAB- for Fabrikam, Inc. or CRO- for Cronus UK, Ltd.), but when the invoice came in, the… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Manage User Expectations with Selection Context-Based Actions
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The fifth of the new functionality in the User experiences section is manage user expectations with selection context-based actions. Microsoft have made the experience of… Continue Reading Ian Grieve’s...
Problem Recognising Lines on Telephone Bill in Continia Software’s Document Capture
I was doing some work with a client implementing Document Capture (DC) from Continia Software. This is an extension for Microsoft Dynamics 365 Business Central which allows PDF invoices to be scanned and (optionally) matched against purchase orders and/or receipts. I provided some training to clients on doing the setup of vendor templates and let them get on with creating the required… Continue Reading Ian Grieve’s Article...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Share Readable Deep Links to Pages and Records
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The fourth of the new functionality in the User experiences section is share readable deep links to pages and records. Like many web applications, Business Central offers… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Distinguish Browser Tabs When Multitasking
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The third of the new functionality in the User experiences section is distinguish browser tabs when multitasking. Users work more efficiently in Business Central when they… Continue Reading Ian...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Get to Data Search From Anywhere in Business Central
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The second of the new functionality in the User experiences section is get to data search from anywhere in Business Central. Office workers spend up to 20 percent of their… Continue Reading Ian...
Regular Expression to Recognise Item Number Format in Continia Software’s Document Capture
I was doing some work for a client helping them implement Continia Software’s Document Management solution; this is a widely used extension for Microsoft Dynamics 365 Business Central which scans invoices, and other documents, and uses OCR (Object Character Recognition) to match the scanned invoice with the Business Central transaction. While preparing for a training session, I discovered that… Continue Reading Ian...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Add Existing Table Fields to Optimize Your Pages
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. 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 2: Performance Gain Reducing Locks in the Database
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The fifth of the new functionality in the Service and platform section is performance gain reducing locks in the database. Microsoft will minimize the use of database… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Pages Load Faster in Client
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The fourth of the new functionality in the Service and platform section is pages load faster in client. By optimizing the opening of most page types in the client, you’ll… Continue Reading Ian...
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Set Default Bin for Items
This post is part of the In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), 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. In the last article in this series, I covered how to configure the bin contents and mentioned that when… Continue Reading Ian...
ClassicPress Plugins Available From azurecurve | Development in 2023: Widget Announcements
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 54th plugin is Widget Announcements. Announce holidays, events, achievements and notable historical figures in a widget. Announcements can be… Continue Reading Ian Grieve’s...
ClassicPress Plugins Available From azurecurve | Development in 2023: Username Protection
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 53rd plugin is Username Protection. Remove anonymous access to usernames in ClassicPress to help mitigate brute-force attacks. For visitors who… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Faster Application Scenarios
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The third of the new functionality in the Service and platform section is faster application scenarios. By optimizing the speed of select scenarios in the application, you… Continue Reading Ian...
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Bin Contents
This post is part of the In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), 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. With the bins now created for the location (either manually or in bulk), the bin contents can now be… Continue Reading Ian...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Data Loads Faster in the Server
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The second of the new functionality in the Service and platform section is data loads faster in the server. Improving the data loading speed on the server benefits all… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Get Power BI Reports for Reporting and Data Analysis on Finance, Sales, and Inventory
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The first of the new functionality in the Service and platform section is get Power BI reports for reporting and data analysis on finance, sales, and inventory. End users… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Discover Report and Data Analysis Content Easily
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The second of the new functionality in the Reporting and data analysis section is discover report and data analysis content easily. End users can now discover report and… Continue Reading Ian Grieve’s...
Microsoft Dynamics 365 Business Central Developer Associate Certification Announced
Microsoft have recently announced a new Microsoft Dynamics 365 Business Central Developer Associate certification which will be available from January 2024, via the MB-820: Microsoft Dynamics 365 Business Central Developer (beta) examination. Business Central developers create apps that extend the solution—whether developing new modules or modifying existing ones—and are responsible for… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Analyze, Group, and Pivot Data on Queries Using Multiple Tabs
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The first of the new functionality in the Reporting and data analysis section is analyze, group, and pivot data on queries using multiple tabs. End users and data analysts… Continue Reading Ian...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Enhancements to Excel Add-in
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The first of the new functionality in the Productive with Microsoft 365 section is enhancements to Excel add-in. Bulk editing, co-authoring, and analysing data in Excel… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Set Initial Role Before First Sign-in for a Better First-Run Experience
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The second of the new functionality in the Onboarding section is set initial role before first sign-in for a better first-run experience. Trial and onboarding experiences… Continue Reading Ian Grieve’s...
New Role with Ocean Dynamics as a Microsoft Dynamics 365 Business Central Functional Consultant
It doesn’t seem that long since I https://www.azurecurve.co.uk/2022/09/things-change-farewell-farewell-my-friends-or-i-have-a-new-job-working-with-microsoft-dynamics-365-business-central/’>joined 4PS Construction Solutions and started working with Business Central, so this was not an article I was expecting to write any time soon, but I have, as of today, taken up a new role with Ocean… Continue Reading Ian...
ClassicPress Plugins Available From azurecurve | Development in 2023: URL Shortener
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 52nd plugin is URL Shortener. Create your own fully integrated URL shortener for your posts, pages and custom post types. Shortcode or function… Continue Reading Ian Grieve’s...
ClassicPress Plugins Available From azurecurve | Development in 2023: Update Admin Menu
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 51st plugin is Update Admin Menu. Allows the reorganisation of the ClassicPress admin menu allowing you to move more often used menu entries to… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Modify Texts on the Welcome Banner and Skip Banner Intro State
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The first of the new functionality in the Onboarding section is modify texts on the welcome banner and skip banner intro state. Partners can give new users a warm welcome… Continue Reading Ian Grieve’s...
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Create Bins in Bulk
This post is part of the In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), 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. In an earlier article, I covered creating bins for a location manually, but Business Central does contain… Continue Reading Ian...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Large Companies to Report Payment Times
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The third of the new functionality in the Legislation section is large companies to report payment times. In countries where it’s required, companies can report payment… Continue Reading Ian...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: E-documents Core as a Global Solution
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The second of the new functionality in the Legislation section is e-documents core as a global solution. The Dynamics 365 Business Central E-documents module enables… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Digital Vouchers
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The first of the new functionality in the Legislation section is digital vouchers. You can have one or more sourced documents for each of GL register as proof of a… Continue Reading Ian Grieve’s...
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Processing Stock Using Bins
This post is part of the In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), 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. When you have a location configured for and with bins added, users must now use the bins whenever they… Continue Reading Ian...
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process Stock Using Bins
This post is part of the In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), 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. When you have a location configured for and with bins added, users must now use the bins whenever they… Continue Reading Ian...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Cancel Cloud Migration Replication Runs
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The third of the new functionality in the Governance and Administration section is cancel Cloud Migration replication runs. Administrators can cancel an ongoing… Continue Reading Ian Grieve’s Article...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Improved Update Release Processes
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The second of the new functionality in the Governance and Administration section is improved update release processes. Improved update release processes ensure that… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Assign More Granular Administration Rights
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The first of the new functionality in the Governance and Administration section is assign more granular administration rights. Administrators’ access rights can be better… Continue Reading Ian...
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Add Bins to a Location
This post is part of the In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), 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. In the previous article of this series, I showed how bins can be made mandatory for a location. In this… Continue Reading Ian...
ClassicPress Plugins Available From azurecurve | Development in 2023: Toggle Show/Hide
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 50th plugin is Toggle Show/Hide. Toggle shortcode can be used to show/hide content. [toggle style=1]content[/toggle] to use toggle… Continue...
ClassicPress Plugins Available From azurecurve | Development in 2023: To Twitter
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 49th plugin is To Twitter. To Twitter includes the following functionality; Automatic tweeting of posts and pages to Twitter as they are… Continue Reading Ian Grieve’s Article...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Use the Built-in Rich Text Editor to Enter Data
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The fourth of the new functionality in the Development section is use the built-in rich text editor to enter data. Rich text editing capabilities improve the user… Continue Reading Ian Grieve’s Article...
Accessing Microsoft Learn During Your Certification Exam Now Allowed
I was surprised to see a comment on LinkedIn earlier this week saying that Microsoft had made some changes to the certification exams, whereby you are now able to access the Microsoft Learn site during an exam. This is surprising, but in a lot of ways does make sense, This change is confirmed by the exam duration and exam experience page on Microsoft Learn, which details some important… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Turn Off Indexes as a Partner
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The third of the new functionality in the Development section is turn off indexes as a partner. The last piece in the database performance tuning toolbox for partners is… Continue Reading Ian Grieve’s...
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Turn Off Data Analysis Mode on Pages and Queries
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2. The second of the new functionality in the Development section is turn off data analysis mode on pages and queries. When first introduced, the data analysis mode was… Continue Reading Ian Grieve’s...