Warning: Undefined array key "Play" in /homepages/7/d756825262/htdocs/clickandbuilds/365Community/wp-content/themes/Nexus/epanel/custom_functions.php on line 1812

Warning: Trying to access array offset on value of type null in /homepages/7/d756825262/htdocs/clickandbuilds/365Community/wp-content/themes/Nexus/epanel/custom_functions.php on line 1812

Warning: Undefined array key "Play" in /homepages/7/d756825262/htdocs/clickandbuilds/365Community/wp-content/themes/Nexus/epanel/custom_functions.php on line 1826

Warning: Trying to access array offset on value of type null in /homepages/7/d756825262/htdocs/clickandbuilds/365Community/wp-content/themes/Nexus/epanel/custom_functions.php on line 1826
Dyn365GP Archives - 365 Community

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Avoid Document Number Errors When You Post Item Journals

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 Application section is Avoid Document Number Errors When You Post Item Journals. To avoid or fix errors related to the order of… Continue Reading azurecurve’s...

Read More

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Use Different General Ledger Accounts For Payables, Receivables

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 Application section is Use Different General Ledger Accounts For Payables, Receivables. Sometimes businesses want to post… Continue Reading azurecurve’s...

Read More

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Adjust Exchange Rates Easily, Replace The Built-In Batch Job

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 Application section is Adjust Exchange Rates Easily, Replace The Built-In Batch Job. When companies operate in multiple countries… Continue Reading...

Read More

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Use Power Automate To Post Adaptive Card Or Link To Business Central Record

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 Adapt faster with Microsoft Power Platform section is Use Power Automate To Post Adaptive Card Or Link To Business Central… Continue Reading azurecurve’s...

Read More

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Remove Modification Limits For Triggering Flows

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 Adapt faster with Microsoft Power Platform section is Remove Modification Limits For Triggering Flows. Processing large datasets… Continue Reading azurecurve’s...

Read More

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Support Dynamic Environment And Company In Power Platform Connector

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 Adapt faster with Microsoft Power Platform section is Support Dynamic Environment And Company In Power Platform… Continue Reading azurecurve’s Article on...

Read More

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: New Approval Workflow Experience With Power Automate Templates

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 Adapt faster with Microsoft Power Platform section is New Approval Workflow Experience With Power Automate Templates. Advanced… Continue Reading azurecurve’s...

Read More

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Get Started With More Sample Power Automate Templates And Power Apps

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 Adapt faster with Microsoft Power Platform section is Get Started With More Sample Power Automate Templates And Power… Continue Reading azurecurve’s Article...

Read More

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Use Business Events To Notify And Trigger External Systems

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 Adapt faster with Microsoft Power Platform section is Use Business Events To Notify And Trigger External Systems. Business events… Continue Reading...

Read More

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Series Index

This post is part of a series on the new functionality available in Wave 2 of Microsoft Dynamics 365 Business Central 2022. This release is the second with which I will be working since my move to Dynamics BC from Dynamics GP last year. In this series of posts, I am going to take a look at what is new with Business Central in this release wave. My understanding is the announced new… Continue Reading azurecurve’s Article on...

Read More

Moving website to Hugo

This post is for any WordPress followers and email subscribers… I am getting ready to move my website away from WordPress, which means whoever is subscribing to this via the WordPress subscribe or email subscription features will no longer get notifications of new posts. I do not yet have a plan or method for subscriptions to content with the new site other than an RSS feed. For those of you… Continue Reading Jen...

Read More

SQL Scripts for Microsoft Dynamics GP: PO Receipt History View

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 creates a SQL view on the history of PO receipts including the purchase price variance. CREATE VIEW uv_AZRCRV_POReceiptHistory AS /*Created by Ian Grieve of azurecurve | Ramblings of… Continue Reading azurecurve’s...

Read More

SQL View to Return the Accounting Period Starting and Ending Dates in Microsoft Dynamics 365 Business Central

While Microsoft Dynamics 365 Business Central is mainly used by clients in the cloud rather than on-premise, there are still some clients using the on-premise version. I was talking to one recently who was looking to create some transactional reports and needed to get the start and end dates for the accounting periods. For some clients, who use calendar months, this would be easy, but in the… Continue Reading azurecurve’s...

Read More

SQL Scripts for Microsoft Dynamics GP: SQL Trogger on PO invoice Insert to Change GL posted Date

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 created a SQL trigger on the Posting Definitions Master Dup (SY00500) table to change the GL Posting Date to current date when a transaction is created. This script was created for a… Continue Reading azurecurve’s...

Read More

Inactive OneDrive Account Cannot be Removed

I’ve been connected to a few OneDrive accounts over the years, only a small number of which are still in use. One of them was a business account which I wanted to remove, but was unable to do so. I should have disconnected my PC from it and deleted the folders and files before the account was closed, but I forgot to do this. I was able to unlink the PC so the account didn;t show in OneDrive,… Continue Reading...

Read More

SQL Scripts for Microsoft Dynamics GP: Update Inactive Flag on Items from CSV

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 update the inactive flag on items from a CSV allowing items to be set to inactive or back to active en masse. /*Created by Ian Grieve of azurecurve | Ramblings of an IT Professional… Continue Reading azurecurve’s...

Read More

In Microsoft Dynamics 365 Business Central (Administration), how do I… Use Company Badges to Identify Companies or Environments

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. one of the new items of new functionality in Dynamics BC 2022 Wave 2 is the “company badges” which was announced as part of… Continue...

Read More

SQL Scripts for Microsoft Dynamics GP: Update Items Default Purchasing Unit of Measure from CSV

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 default purchasing unit of measure on items from a CSV file. It will validate the item during the import and if there are any errors these will be presented to the user and… Continue Reading azurecurve’s...

Read More

Change Alignment of Windows 11 Taskbar

Ever since Windows 95 Windows has had a taskbar at the bottom of the screen (by default although you can change the placement. The icons on the taskbar are aligned to the left on all versions of Windows until Windows 11 where the icons are in the middle of the taskbar. While I do try to take some updates to Windows and other apps, this is one too far. My main problem is that because it is… Continue Reading azurecurve’s...

Read More

SQL Scripts for Microsoft Dynamics GP: Assign All Items to All Site Bins

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 will assign all items to all site bins. /*Created by Ian Grieve of azurecurve | Ramblings of an IT Professional (http://www.azurecurve.co.uk) This code is licensed under the Creative… Continue Reading azurecurve’s...

Read More

In Microsoft Dynamics 365 Business Central (Customisation), how do I… Copy Profile Personalizations to Another Environment

This post is part of the In Microsoft Dynamics 365 Business Central (Customisation), 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 in this series, I showed how customizations could be made via a profile for sharing. This is very… Continue Reading...

Read More

SQL Scripts for Microsoft Dynamics GP: Import Site Bins From CSV

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 will allow for the import of bins from a CSV file. The supplied site is validated to ensure it exists before the data is imported; if any errors then errors are presented to the user and… Continue Reading...

Read More

In Microsoft Dynamics 365 Business Central (Customisation), how do I… Create Customizations for Other Users Using Profiles

This post is part of the In Microsoft Dynamics 365 Business Central (Customisation), 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. So far I’ve shown how to personalize Dynamics BC to make pages, FactBoxes and action bars, but only for the user you’re log in… Continue...

Read More

SQL Scripts for Microsoft Dynamics GP: Insert National Accounts from CSV

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 allows a user to insert National Accounts from a CSV file. I created this script fairly recently for a client who was implementing the National Accounts module and had a lot of accounts… Continue Reading...

Read More

Restore Windows 10 Style Right-Click Context Menu in Windows 11

I’ve added a Windows 11 laptop to the set of computers that I use. While I can live with most of the differences, one which immediately caused me problems was the new shrunken right-click context menus. You can click on Show more options, but two of the options I use the most (for 7-zip and Notepad++) are on the show more section: I did some digging around and the Windows 10 style right-click… Continue Reading...

Read More

SQL Scripts for Microsoft Dynamics GP: Update Accounts and Distributions on Work Status Sales Transactions from Item Card, Tax Details or Posting Account 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 ppdates the accounts and distributions on work status sales transactions from Item Master (IV00101), Sales/Purchases Tax Master (TX00201) or Posting Account Master (SY01100) tables. /*

Read More

In Microsoft Dynamics 365 Business Central (Customisation), how do I… Understand the Best Way of Personalizing the Action Bar

This post is part of the In Microsoft Dynamics 365 Business Central (Customisation), 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 in this series, I covered how to personalize the action bar. There are two main recommendations I’d… Continue Reading...

Read More

SQL Scripts for Microsoft Dynamics GP: Update Accounts Receivables Distribution on Work Status RM Transactions from Posting Account 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 Accounts Receivables distribution on work status receivables transactions from the Posting Account Master (SY01100) table. /*Created by Ian Grieve of azurecurve | Ramblings… Continue Reading azurecurve’s...

Read More

Microsoft Excel Column Headers Showing as Numbers Instead of Letters

I had a strange occurrence recently with Microsoft Excel where the column headers changed from letters to numbers. I’d didn’t notice initially, but it was when I was working with a formula that I realised it wasn’t putting letters in the cells but an odd numbering style. When I looked into why I discovered the column headers were numbers: I did some digging and found an option on the Formulas… Continue Reading...

Read More

SQL Scripts for Microsoft Dynamics GP: Update Accrued Purchases Distribution on History Receipts from Posting Account 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 will update the Accrued Purchases distribution on history receipts from Posting Account Master (SY01100) table. I think this script was created as a client created a new accrual account… Continue Reading...

Read More

All Versions of Microsoft Dynamics NAV Now Out of Mainstream Support

On Tuesday last week, 10th January 2023, the last version of Microsoft Dynamics NAV supported by Microsoft under mainstream support, which was NAV 2018, moved out of mainstream support into extended support. Microsoft’s “Modern Lifecycle” policy means that applications like Dynamics NAV have mainstream support for 5 years followed by 5 years of extended support. Under mainstream support… Continue Reading...

Read More

SQL Scripts for Microsoft Dynamics GP: Update Inventory Distribution on Work Status Purchase Orders from the Item Card

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 update the Inventory distribution on purchase orders as a work status to the account on the Item Master (IV00101) table. /*Created by Ian Grieve of azurecurve | Ramblings of an IT… Continue Reading azurecurve’s...

Read More

In Microsoft Dynamics 365 Business Central (Customisation), how do I… Personalize the Action Bar

This post is part of the In Microsoft Dynamics 365 Business Central (Customisation), 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. If you’ve been following this series, you’ll have seen that we can do a lot to personalize Dynamics BC including pages and… Continue...

Read More

SQL Scripts for Microsoft Dynamics GP: Update Accounts Payable Distribution on Work Status PM Transactions from Posting Account 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 will update the accounts payable distribution on all open purchasing transactions from the Posting Account Master (SY01100) table. /*Created by Ian Grieve of azurecurve | Ramblings of… Continue Reading azurecurve’s...

Read More

Applying a Word Concordance File to Create an Index

When working with a large document such as a book, a common requirement is to add an index to the end so that important words or phrases can be indexed for easy lookup. While you can tag words for the index within Microsoft Word a better way to do in bulk is to use a concordance file. This is basically a separate two column file containing a list of words to index in the first column and how… Continue Reading azurecurve’s...

Read More

SQL Scripts for Microsoft Dynamics GP: Update Inventory Accounts from Item Class

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 accounts on an inventory item from the linked Item Class. The script was written after some accounts were updated and the user opted not to roll-down the changes to the… Continue Reading azurecurve’s...

Read More

In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the Action Bar

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. Each page in Dynamics BC has a different set of actions depending on the page type, and the processes that the page supports…. Continue Reading...

Read More

SQL Scripts for Microsoft Dynamics GP: Migrate Vendor Emails from Active Docs to Standard Email Fields

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 will copy vendor emails from the Active Documents table to the standard Dynamics GP email fields where they weren’t already present. This script was written for a client who was… Continue Reading azurecurve’s...

Read More

Enable Email Conversations in the Outlook Desktop Client

I hated threaded email when it first came out, but I’m now used to it and as it turns out prefer it to non-threaded. I discovered this after changing jobs; my old work laptop had threaded emails enabled and the one at the new job didn’t. I worked that way for a few weeks and it was fine as I was doing a lot of learning and not involved in many projects. As soon as that changed and I started… Continue Reading...

Read More

SQL Scripts for Microsoft Dynamics GP: Vendor Emil Addresses from Standard Fields and Active Docs

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 email addresses for vendors from both the standard Dynamics GP fields as well as Active Docs. The email addresses from Active Docs are returned as a semi colon… Continue Reading azurecurve’s...

Read More

In Microsoft Dynamics 365 Business Central (Customisation), how do I… Personalize the FactBox

This post is part of the In Microsoft Dynamics 365 Business Central (Customisation), 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 with pages, the FactBox can also be personalized. Whether the FactBox is on a list page or a card card, or any other type of… Continue Reading...

Read More
SQL Scripts for Microsoft Dynamics GP: Select Workflow Comments for Work Status Batches
Jan06

SQL Scripts for Microsoft Dynamics GP: Select Workflow Comments for Work Status Batches

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 will return all unposted batches and the workflow approval comments which have been entered; it was used within a customisation of workflow in Dynamics GP which allowed the returned… Continue Reading azurecurve’s...

Read More

In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the FactBox

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. On list and card pages there is a FactBox which displays at the side of the page; by default the FactBox is usually visible,… Continue Reading...

Read More
SQL Scripts for Microsoft Dynamics GP: Remaining Budget By Year Using PO Commitment Budget
Jan05

SQL Scripts for Microsoft Dynamics GP: Remaining Budget By Year Using PO Commitment Budget

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 for a client who wanted to be able to see how much of the annual PO commitment budget was remaining. It takes into account postings to the GL, PO commitments and entered… Continue Reading azurecurve’s...

Read More
Excel Snippets: Formula to Calculate Monthly Value of a Mortgage with Monthly Interest
Jan05

Excel Snippets: Formula to Calculate Monthly Value of a Mortgage with Monthly Interest

I might not post many Excel snippets, but I’m collecting them into a small Excel Snippets series to make them easy to find. I’ve been using this formula for quite a while now, but have to admit that I did not create it and no longer remember from where I got it. The basic use is that you would have the starting amount in cell C2 and then use this formula in the next cell down and replicate… Continue Reading...

Read More
SQL Scripts for Microsoft Dynamics GP: Get Items Showing Quantities By Type
Jan04

SQL Scripts for Microsoft Dynamics GP: Get Items Showing Quantities By Type

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 items at each location and the different quantities on each quantity type (such as on hold, allocation and on different types of open transactions). /*Created by Ian… Continue Reading azurecurve’s...

Read More
In Microsoft Dynamics 365 Business Central (Customisation), how do I… Understand the Best Way of Customising a Card Page
Jan04

In Microsoft Dynamics 365 Business Central (Customisation), how do I… Understand the Best Way of Customising a Card Page

This post is part of the In Microsoft Dynamics 365 Business Central (Customisation), 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 covered in the previous article, it is possible to personalize a card page by adding, moving or removing fields, adding or… Continue Reading...

Read More
SQL Scripts for Microsoft Dynamics GP: Vendors With Emails From Primary, Remit and Purchase Addresses
Jan03

SQL Scripts for Microsoft Dynamics GP: Vendors With Emails From Primary, Remit and Purchase Addresses

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 user to check information; it returns basic information on the vendor along with bank details and email addresses for the addresses linked to the vendor as… Continue Reading azurecurve’s...

Read More
Excel Snippets: Add n Months to Current Date
Jan03

Excel Snippets: Add n Months to Current Date

I might not post many Excel snippets, but I’m collecting them into a small Excel Snippets series to make them easy to find. I was have a tendency to track personal financial data in Excel and was recently updating my electricity usage sheet and wanted to set a date column to auto incremement by one month for each row. I did some checking and found that the EDATE function can be used to get the… Continue Reading...

Read More
SQL Scripts for Microsoft Dynamics GP: GL Account Transactions With Amount in One Column
Jan02

SQL Scripts for Microsoft Dynamics GP: GL Account Transactions With Amount in One Column

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 a while ago for a client who wanted a SQL query to use in SSRS; it was put together in conjunction with the finance team to return the data exactly as they wanted (including… Continue Reading...

Read More