Streamline Asset Management: A Practical Guide to Dynamics GP Fixed Assets

Table of Contents

This article provides a practical guide on how to set up Fixed Asset Management in Microsoft Dynamics GP. Efficiently managing fixed assets is crucial for accurate financial reporting and strategic decision-making within any organization. Dynamics GP offers a robust module to handle this, but proper setup is key to unlocking its full potential.

Step 1: Setting Up Fixed Asset Management Before Asset Information Entry¶

Before you begin adding any asset details into Fixed Asset Management, it’s essential to lay the groundwork by configuring the necessary setup information. This initial setup is crucial for the system to function correctly and meet your company’s specific needs. Some setup steps are mandatory, while others are conditional based on your organizational requirements. These configurations are accessed through various windows within Fixed Asset Management.

To navigate to these setup windows, follow these steps based on your Dynamics GP version:

• For Microsoft Dynamics GP 10.0 and later versions: Go to Tools on the Microsoft Dynamics GP menu, then Setup, navigate to Fixed Assets, and select the desired window.
• For Microsoft Dynamics GP 9.0 and earlier versions: Go to Setup on the Tools menu, then Fixed Assets, and select the window you need.

Required Setup Information¶

These setup windows are essential and must be configured before proceeding with asset management. They form the backbone of your Fixed Asset Management system.

• Book Class Setup
  

The Book Class Setup window is used to define detailed parameters for each asset class and the associated books that will be used for depreciation. Typically, you will create a book class record for each asset class and for each book you intend to use for depreciation calculations and reporting. This setup ensures that depreciation is calculated and recorded correctly for different asset categories across various books.

• Book Setup
  

Utilize the Book Setup window to define the different books required for your Fixed Asset Management reporting. Dynamics GP allows you to create up to 32 books per company, giving you flexibility in reporting and depreciation scenarios. At least one book must be set up for asset depreciation, though not all assets need to be included in every book. This allows for tailored depreciation and reporting based on specific needs like tax or internal management.

• Build Fixed Assets Fiscal Calendar
  

The Build Fixed Assets Fiscal Calendar window is critical for creating the fiscal calendar that Fixed Asset Management will use for depreciation calculations. This calendar should encompass all necessary periods, including past and future years, to ensure accurate depreciation over the asset’s life. Dynamics GP will model these periods based on the fiscal periods already set up in your general ledger or eEnterprise system, maintaining consistency across your financial data.

• Class Setup
  

Use the Class Setup window to define your asset classes and groups. These classifications are based on shared characteristics such as account information, insurance details, and depreciation rules. Setting up at least one class is mandatory in Fixed Asset Management. Every new asset added to the system must be assigned to a specific class, ensuring proper categorization and consistent treatment within each group.

• Company Setup
  

The Company Setup window allows you to define parameters that govern various processes within Fixed Asset Management. Crucially, you designate the corporate book that will interface with the general ledger in this window. Furthermore, Company Setup allows you to configure:
- Account information options, controlling how account details are handled within the system.
- Automatic addition of book information, streamlining the asset setup process.
- User data format, ensuring consistent data entry and reporting.
- Purchasing series integration, linking asset acquisition to purchasing processes.
- General information settings, covering other company-wide fixed asset parameters.

• Quarter Setup

The Quarter Setup window is used to define the start date, middle date, and end date for each quarter of the fiscal year. This is necessary if you plan to use the mid-quarter averaging convention for depreciation calculations. It is also required if you intend to use mass retirement or mass transfer processes, ensuring accurate calculations and consistent period definitions across these functions.

Conditionally Required Setup Information¶

Depending on your company’s specific needs and practices, you may need to configure these additional setup windows. They offer more granular control and cater to specific asset management scenarios.

• Account Group
  

The Account Group window allows you to define groups of accounts for default settings. When an asset is added, all accounts associated with the assigned account group will be automatically populated into the asset’s account record. This feature streamlines data entry and ensures consistency in account assignments for similar asset types.

• Insurance Setup
  

Use the Insurance Setup window to group assets that share similar insurance rates, inflation rates, and depreciation rates for insurance purposes. This is particularly useful for managing insurance policies and calculating insured values of asset groups efficiently.

• FA-AP Post Accounts Setup
  

The FA-AP Post Accounts Setup window is used to define account numbers that will trigger integration with Payables Management and Purchase Order Processing modules in Dynamics GP. Typically, you will enter Fixed Asset Management clearing accounts in this window. This setup automates the asset capitalization process when assets are acquired through payables or purchase orders.

• Lease Company Setup
  

Use the Lease Company Setup window to define valid lease companies if your organization leases assets. This window allows you to maintain a list of approved lessors, facilitating proper recording and tracking of leased assets.

• Location Setup
  

The Location Setup window is used to define valid asset locations, grouped by city, county, and state. This setup is often used for property tax reporting, allowing you to categorize assets by their geographical location for tax compliance and reporting.

• Physical Location Setup
  

Use the Physical Location Setup window to define specific physical locations within your organization. This is useful for tracking assets with physical labels and for conducting physical inventory audits. It provides a more granular level of location tracking compared to the general Location Setup.

• Retirement Setup
  

The Retirement Setup window is used to define valid retirement codes that can be used when disposing of assets. These codes help categorize the reasons for asset retirement, providing valuable data for asset lifecycle analysis and reporting.

• Structure Setup
  

Use the Structure Setup window to define valid structure IDs. These IDs can represent cost centers or other organizational segments, and are often linked to segments within your chart of accounts. This setup allows you to categorize assets by organizational structure, facilitating reporting and analysis by department or cost center.

Step 2: Entering Existing Assets¶

Once the setup is complete, the next step is to enter your existing assets into Microsoft Dynamics GP. It’s crucial to choose the right method for data entry to ensure accuracy and efficiency. We recommend using one of the following methods:

• Manual Entry using Asset Cards:
  
  
  

You can manually enter asset information using various asset cards within Dynamics GP, including:
- Asset General Information: Captures basic details like asset ID, description, and acquisition date.
- Asset Account Information: Records the relevant general ledger accounts associated with the asset.
- Asset Book Information: Specifies book-specific details such as depreciation methods and conventions.
- Other asset windows: For more detailed information, refer to Chapter 4, “Fixed Asset Management cards,” in the FixedAssets.pdf document, located in the Documentation subfolder of your Microsoft Dynamics GP application folder. This method is suitable for smaller asset quantities or when data needs to be entered directly.

• Asset Import Export Utility:
  

Dynamics GP provides an Asset Import Export utility for importing asset data from external files. This tool is ideal for handling large volumes of asset data and allows for efficient data migration from spreadsheets or other systems. Ensure your import file is properly formatted according to the utility’s requirements.

• Conversion Service:

For migrating Fixed Asset Management data from an existing Dynamics GP installation to a new one, consider using a conversion service. These services specialize in data migration and can ensure a smooth and accurate transfer of your asset data, minimizing disruption and data integrity issues.

Avoid using Dynamics Table Import or similar tools directly for asset data import. These tools are not recommended for Fixed Asset Management due to the complex, multi-table structure of asset data and the critical need for data consistency. Inconsistencies can lead to significant errors in depreciation calculations and financial reporting.

Specifically, ensure the following data points are consistent for each asset book:
- Cost: The original cost of the asset.
- Year-to-date depreciation amount: Depreciation calculated for the current fiscal year.
- Life-to-date depreciation amount: Total depreciation calculated since the asset’s acquisition.
- Depreciated-to-date information: The date up to which depreciation has been calculated.

When adding assets at the end of a fiscal year, the year-to-date depreciation should be zero, and the depreciated-to-date information should reflect the last day of the year. Otherwise, the life-to-date depreciation must include the year-to-date depreciation, and the depreciated-to-date information should be the date through which depreciation was last calculated. Also, verify that the current fiscal year in the book setup record is correctly set to the current fiscal year.

Step 3: Reviewing Reports¶

After entering your assets, it’s crucial to review reports to verify the accuracy of your data entry. Reports like the Depreciation Ledger report and the Depreciation Detail report are invaluable for this purpose.

• Depreciation Ledger Report: Provides a summary of depreciation for each asset or asset group.
• Depreciation Detail Report: Offers a detailed breakdown of depreciation calculations for each asset.

Refer to Chapter 19, “Reports,” in the FixedAssets.pdf document for more information on available reports and their usage.

Balance the following totals against your previous system’s balances to ensure data integrity:
- Total cost per book: Verify the total asset cost for each book matches your prior records.
- Total life-to-date depreciation: Confirm the accumulated depreciation matches historical data.
- Total year-to-date depreciation: Ensure current year depreciation aligns with expectations.

Optionally, you can run projected depreciation for future periods and review the periodic projection reports. This allows you to forecast depreciation expenses and plan for future financial periods.

Step 4: Processing the General Ledger Interface¶

Fixed Asset Management in Dynamics GP automatically generates general ledger entries when you add assets and process depreciation. These entries are stored in the Financial Detail file.

For detailed instructions on processing the general ledger interface, consult Chapter 14, “General Ledger integration,” in the FixedAssets.pdf document.

Review the report generated from the general ledger interface to ensure that the account numbers in your Asset Account records are correctly configured. This step is critical for maintaining accurate financial records and ensuring proper posting to the general ledger.

Important: If you have previously posted asset-related entries directly to the General Ledger in Dynamics GP, do not post the financial entries generated by Fixed Asset Management to avoid duplication. Instead, create the batch in Fixed Asset Management and then flag the records in the Financial Detail file as processed. The system will then automatically add the batch number, transaction date, and timestamps to these records. Afterward, delete the automatically created FATRX xxxx batch to prevent duplicate postings.

Step 5: Deleting the Batch Created During General Ledger Interface Processing¶

When you process the general ledger interface in Fixed Asset Management, a batch is automatically created. As highlighted in Step 4, it is crucial that you do not post this automatically generated batch to the General Ledger in Dynamics GP, especially if you’ve already accounted for these transactions. Deleting this batch after flagging the records in the Financial Detail file is a necessary step to prevent double-counting of financial transactions and maintain the integrity of your general ledger.

By following these steps diligently, you can effectively set up and utilize Fixed Asset Management in Dynamics GP to streamline your asset management processes, ensure accurate financial reporting, and gain valuable insights into your asset portfolio.

---

Do you have any experiences or questions about setting up Fixed Asset Management in Dynamics GP? Share your thoughts in the comments below!