RDLC makes conditional visibility easy — set an expression on the Visibility property, and the element hides itself when the condition isn’t met. Word layouts don’t have this option out of the box. In this post, I’ll show you how to mimic that same behaviour in Word layout using AL code. 1. Table Hidden vs…
In Business Central, you can post multiple acquisitions to a fixed asset, but doing so can impact the next depreciation calculations if you are not fully aware of how depreciation is computed. Below are two scenarios illustrating the differences between posting an additional acquisition on the first day of the month versus mid-month. To keep…
Yesterday, I came across a post on the Dynamics 365 Community forum asking how we can publish a blank value to the Currency Code field when using the General Journal Edit in Excel function. The problem arises because this field is validated by the Customer record, automatically pulling the Currency Code from the Customer master…
In Business Central, managing Permission Sets is not always straightforward. You can add or reference existing permission sets within another, creating a hierarchical structure. Within these Permission Sets, there could be Include and Exclude of the same object. Hence, in today’s post, we’ll walk through Permission Sets in Business Central, explaining how they work and…
This is a two part series to introduce Business Central Warehouse Management on a high-level. On the first series, I discussed about the types of warehouses and what are their Inbound and Outbound processes in Business Central. In this series, I will discuss on the Internal movement process on how to move and adjust the…
This is a two part series to introduce Business Central Warehouse Management on a high-level. In Business Central, there are various warehouse configurations available, which can be overwhelming for new onboarding customers, especially those transitioning from system without inventory management capabilities. Hence, in this series, I will simplify and streamline the understanding of the high-level…
In today’s post, we’ll discuss the impact of incorrectly classifying Interim Accounts in the financial statements and how it can affect our reporting. As you know, when “Expected Cost Posting” is enabled, the system requires additional G/L accounts for “COGS (Interim)” and “Invt. Accrual Acc. (Interim)”. Often, when new customers migrate to Business Central from…
Today’s topic focus on the essential steps for accurately migrating open foreign invoices to Business Central. By following the best practice, you can ensure that Accounts Receivable and Accounts Payable balances are precisely maintained and accurately reflected when these invoices are eventually closed within the system. Common Mistake A mistake often made by end-users and…
‘Recurring General Journals’ in Business Central are typically used for regular entries such as rent, utilities, and subscriptions. However, many users overlook the ability to reclassify amounts between different G/L accounts, making this feature an invaluable tool for accountants during year-end closing. In today’s post, I’ll highlight this overlooked feature found in ‘Recurring General Journal’….
In today’s post, I will be covering on how to import Physical Inventory Order’s Recording. The Physical Inventory Order module is commonly used by companies that manage stock or inventory, providing essential functionality for counting and reconciling inventory levels. However, as many know, importing the file isn’t as straightforward as exporting. Understanding the Export File…
A common question I receive from accountants during new project implementations is why bank currency revaluation is recorded under ‘Realized’ rather than ‘Unrealized’ gains or losses. If you are familiar with IFRS, in IAS 21, foreign currency transactions (which can include bank balances in a foreign currency) are accounted for based on exchange rates at…
In this topic, I’d like to discuss how we can manage the CurrentDateTime function in web services. When working with web services, it’s essential to know that the CurrentDateTime function always returns the time in UTC. This can cause issues if the integration with third-party solutions operates in a different timezone. Here’s an article from…
In this post, I will consolidate the commonly used events to transfer custom fields to posted table and ledger entry. Depending on your needs, this may not be the only event available, as there are other events that might better align with your specific requirements. 1. Order to Receipt/Shipment and Invoice (Header and Line) When…
Of course, when setting up a new company, there are many configurations that need to be tailored to specific industries or business nature. Today, I want to highlight a few setups that should be toggled, as they aren’t by default. These apply regardless of the industry or type of business. #1: Posted General Journal Without…
Not all countries or regions have a Microsoft-localized version of Business Central. Refer to the list of supported countries and regions https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/compliance/apptest-countries-and-translations For them, it will be built on top of the international (W1) version. By default, the caption is set to ‘VAT.’ However, today I’ll guide you through the process of renaming it to…