Skip to main content

Posts

Dynamics GP to BC: MultiCurrency

Understanding Multicurrency, Exchange rate and Reporting Currency Differences When moving from Dynamics GP to Business Central, one of the first configuration areas that looks familiar—but works very differently—is Currency Setup.   Both systems support multicurrency transactions, but their design philosophies, data structures, and reporting capabilities are distinct. This post breaks down the setup, exchange rate configuration, and reporting currency handling side-by-side to help GP users clearly see how things translate in Business Central. Currency Setup In Dynamics GP, even your local (functional) currency needs to be set up just like any other foreign currency, it is driven by Currency ID. Click on Accounts to setup the Posting Accounts per Currency ID. After creating your Currency ID, you'll create your Multicurrency Exchange Table for AVERAGE, BUY, & SELL for each currency. Why GP has Average, Buy, and Sell Exchange Tables? In Dynamics GP , multiple exchange rate ...
Post a Comment
Read more
Recent posts

Planning Ahead for 2026 Conferences!

If you’re in the Microsoft Business Applications world — especially working with Dynamics 365 Business Central — 2026 is shaping up to be another exciting year for learning, networking, and community growth. Here are some of the top conferences already announced: DATE EVENT LOCATION WEBSITE April 27-29, 2026 Directions North America 2026 Hyatt Regency Orlando https://www.directionsna.com/ May 5-7, 2026 European Collaboration Summit 2026      Cologne, Germany      https://collabsummit.eu May 13-15, 2026 Directions ASIA 2026 Ho Chi Minh City, Vietnam https://www.directionsforpartners.com/asia2026 May 12-15, 2026 DynamicsCon Fontainebleau Las Vegas Las Vegas, Nevada dynamicscon.com May 12-15, 2026 Women In Tech Global Conference® 2026 Virtual & In-person https://www.womentech.net/women-tech-conference May 25-27, 2026 DynamicsMinds 2026 Portorož, Slovenia (Europe https://www.dynamicsminds.com/ June 11-12, 2026 BC TechDays Antwerp (Belgium) https://bctechday...
Post a Comment
Read more

BC Pro Tip: Don’t Double-Dip Your Local Currency!

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...
Post a Comment
Read more

Dynamics GP to BC: Project Accounting

  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...
Post a Comment
Read more

Dynamics GP to BC - Migration Assessment

  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 ...
Post a Comment
Read more