Cecile's D365 Business Central Online Blog

Don’t Overdo It — Leave That Local Currency Blank! When setting up Business Central, remember that your local currency (LCY) is already defined in the General Ledger Setup — no need to create it again on the Currencies page. Adding the same currency there can confuse the system, causing errors such as “Currency Code cannot be found in the related table.” It also leads to inconsistent setups where some records use a blank currency and others use the LCY code. To keep things clean and accurate, leave the Currency Code blank for your local currency in bank accounts, customers, and vendors. Business Central automatically treats blanks as your local currency — so keep it simple and let BC do its thing! If you’ve ever run into this error in Business Central 👇You're not alone! "The field Currency Code of table Gen. Journal Line contains a value (LCY) that cannot be found in the related table (Currency)." This error pop-up when using Bank Account in General Journal: The Root Ca...

  Project Accounting in Dynamics GP vs. Business Central: A Side-by-Side Comparison When comparing Dynamics GP Project Accounting (PA) with Business Central Projects (Jobs) , the differences become much clearer when you see both the conceptual structure and the transaction flows . Dynamics GP and Business Central take very different approaches—yet both aim to give businesses the tools to manage costs, billing, and profitability effectively. For organizations considering the move from GP to Business Central, it’s important to understand not just the terminology changes, but also how the overall project accounting flow shifts. In this post, I’ll walk through a side-by-side comparison of GP’s contract and cost category structure versus Business Central’s job, task, and planning line approach—complete with flow diagrams, key features, and links to official Microsoft documentation to help you navigate the transition with confidence. Visual Flow Comparison Dynamics GP – Project Accou...

  Ready to Move from GP to BC?  Start Your Cloud Migration Journey Today https://bcmigrationassessments.com/ This website  is the online home for Microsoft’s Dynamics GP-to-Business Central Migration Assessment Tool . This tool is designed specifically to help organizations planning their move from Microsoft Dynamics GP (Great Plains) to Dynamics 365 Business Central in the cloud. 🔍 What It Does: Migration Readiness Scan: The tool connects to your existing GP SQL database to assess the data, modules, customizations, ISVs, and overall setup of your system. Risk & Complexity Insights: It analyzes the structure and identifies potential migration issues—such as unsupported customizations or problematic data formats—and offers suggestions to address them early. Migration Roadmap: You receive a personalized report outlining which companies/modules are ready to move, what data tables to migrate, and what steps (like testing or cleanup) will help ensure a smooth cloud ...

  Last week, a Business Central developer asked me a simple yet important question: “What’s the customer table equivalent in Dynamics GP?” That moment sparked an idea. As more technical professionals find themselves supporting both Dynamics GP and Business Central—or migrating entirely to the cloud—I realized how helpful a side-by-side table reference could be.  I’ve always admired the work of Victoria Yudin , whose GP table list has been a go-to resource for the entire Dynamics GP community.  Although I’ve never met her in person (not even a photo!), her contributions have left a lasting impact on so many of us working with GP. Inspired by her legacy, I decided to take it one step further by mapping those well-known GP tables to their Business Central equivalents . My hope is that this reference will serve as a bridge for those transitioning to Business Central Whether you're mapping data, building reports, or just navigating unfamiliar territory, I hope t...

  Whether you're a Business Central power user, consultant, or developer, sometimes you just want a quick look under the hood of your environment. That’s where Table Information comes in—a hidden gem in Business Central that gives you insight into what’s happening behind the scenes. Why Use the Table Information Page? Understanding what tables are being used, how large they are, and how many records they contain is especially helpful when: Diagnosing performance issues  Cleaning up test or training environments  Estimating storage impact  Reviewing customizations or ISV extensions  Step-by-Step: How to Access Table Information Here’s how you can view detailed info about every table in your current company: Go to “Tell Me” Search Press Alt + Q or click the magnifying glass 🔍 in the upper-right corner. Type: “Table Information” Select the Table Information page from the search results. Explore the Page You’ll see a list of all tables...