Creating a Business Central Cloud & Bitbucket CICD Pipeline
In my bitbucket repository, I enabled pipelines and added branch restrictions for security purposes. Also I used Repository variables within in my bitbucket repository associated to my service principal set up in Azure app registration. This CICD pipeline allows my team to merge code to our main branch to auto-deploy-install our extension in our BC […]
Adding an internal PO system into Business Central as a bolt on
I noticed that Business Central’s Purchase Order module is not simple and therefore could be a deterrent for certain users. Since our finance staff have committed to using Business Central, having procurement use the BC inherent PO module would make life easier in terms of data centralization and end-to-end PO to PI auditing. I noticed […]
Transitioning NAV on-prem to BC Cloud in 2025
This process has changed from 10 months ago. NAV on-prem needs to transition to BC14 on-prem to BC 25 on-prem to BC cloud. Pre-requisites: NAV on-prem to BC 14 transition: First follow to upgrade application code: https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrading-the-application-code to create application .txt files. Follow the steps here: https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-unmodified-application-v14-v25 Run the cloud migration setup in a new […]
How to export existing report layouts and code to customize them to your needs in Business Central
There was a need by my client to modify the existing base Cheque report used in business central’s cheque run process. I did not want to create a new layout from scratch due to time constraints and wanted to leverage existing layouts. First, I checked to see what the report object id was in Report […]
How to update custom column values in Business Central post data migration
I have a scenario where I have migrated base NAV data over to Business Central cloud. Some custom fields for tables were not ported over to the cloud tables. As such, I needed to find a way to create these new fields in the existing tables and back sync data over to these new fields. […]
Prevent Posting of Transactions W/O Specific Dimensions in Business Central
Navigate to the Dimensions page and select the required dimension and select Account Type Default Dim. under the edit list tab. Set TableID to the appropriate table. In my case, I set it as 15: G/L Account. In addition, set the Value Posting field to Code Mandatory.
Adjusting Item Sales Unit Price in Business Central
In the case where a company wants to adjust an item’s unit price based on a flat profit rate of 20%, you have two options: 1. Run the Adjust Item Costs/Prices batch job: Fill in what to adjust, the adjust field, adjustment factor (multiply the adjustment field amount by this value) and rounding method. 2. […]
Direct Cost Applied Accounts in Business Central
When purchasing inventory in Business Central, we see that it creates 4 entries: The reason for this is that having separate purchase accounts in BC provides an easy way to view inventory purchases. It allows for reporting to capture cost of goods sold more clearly as COGS = Beginning Inventory + Purchases – Ending Inventory […]
Posting Transactions Directly to The G/L in Business Central
General Journals are used to post transactions directly to G/L – bank, customer, vendor, and employee accounts. Access General Journals. Fill out the necessary fields in the journal line and Post. This will directly post this journal line to the G/L, whereas, payment and sales journals start from a purchase invoice or sales order and […]
Posting Group Types in Business Central
Posting groups are ways for us to map things(vendor or customer) to GL accounts, basically acting as a map to the proper G/L account.