Skip to main content

Dynamics GP to Business Central - Fixed Assets Tables

 

In Dynamics GP

The Fixed Assets module is a standalone subledger that integrates with General Ledger, Payables, and Purchasing.

📌 Key Fixed Asset Features in GP:

  • Asset acquisition from Payables or manually

  • Depreciation methods (Straight Line, DB, etc.)

  • Asset books for financial and tax reporting

  • Retirement, transfers, and revaluation

  • Reporting by class, location, and type


In Business Central
📌 Key Fixed Asset Features in BC:

  • Asset setup and tracking

  • Acquisition via Purchase Invoice or Journal

  • Multiple depreciation books

  • Standard and custom depreciation methods

  • Insurance, maintenance, and budgeting support


Fixed Assets Tables

GP TableDescriptionBC TableBusiness Central Equivalent
FA00100Asset General Information Master5600Fixed Asset
FA00200Book Master5611FA Depreciation Book
FA00400Asset Account Master5601FA Posting Group
FA00500Lease MasterN/ARequires Extension or ISV (no lease module by default)
FA00600Insurance Master5628Insurance (Policies)
FA00700Retirement Master5621FA Journals > Disposal Entry
FA00800Transfer Master5621
5609		FA Transfer Entry
FA Location
FA00902Financial Detail Master5601FA Ledger Entry
FA00905General Ledger Interface Work81Gen. Journal Line (Unposted)
FA01100FA-AP Posting Master5622FA G/L Journal or FA Acquisition via Purchases
FA01400Asset Purchase Master5622FA Acquisition Entry
FA01500FA Activity Master5601FA Ledger Entry
FA40200Book Setup5611FA Depreciation Book
FA40201Asset Class Setup5607FA Class
FA40202Book Class Setup5611FA Depreciation Book
FA40203Book Setup (for Depreciation)5611FA Depreciation Book
FA41100Location ID Setup5609FA Location
FA41200Insurance Class SetupN/ACustom via Dimensions or Extension
FA41300Account Group Setup5606FA Posting Group
FA41500Structure ID SetupN/ANot applicable -custom tracking
FA41600Lease Company SetupN/AHandled via extension or external tool
FA41900Projections (Depreciation)ReportFA Projection Value (Report)
FA42400Physical Location Setup5609FA Location Code
FA49900Company Setup5603FA Setup




Labels:

Comments

Post a Comment

Popular posts from this blog

D365 Business Central - Table Information Page

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

Bridging the Gap: Dynamics GP to Business Central Table Mapping

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

DUG Webinar: Dynamics GP to Business Central - The Ultimate Beginner's Guide

This session is designed to give you a head start in working with Business Central so you quickly feel at home in transitioning from Dynamics GP to BC without the hustle of reading through hundreds of pages of documentation. What you'll learn: Mastering the user interface of Business Central Navigating in Business Central Editing records in Business Central Creating new records in Business Central Finding records in Business Central Personalizing the user interface of Business Central Being prepared to work with Business Central on a daily basis
Post a Comment
Read more