web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Fixed Asset Integratio...
Microsoft Dynamics GP (Archived)

Fixed Asset Integration Account Group

(0) ShareShare
ReportReport
Posted on by Community Member

After integrating fixed assets into Great Plains, all of the different assets are going to the same account. Each asset has its correct account group associated with it. I have checked all assets, and their account groups are correct, but when I look at the assets not interfaced report, they are all being interfaced to one particular account group. How can I get this corrected? 

*This post is locked for comments

I have the same question (0)
  • Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Fixed Asset Integration Account Group

    What mechanism did you use to integrate Fixed Assets?

  • Community Member Profile Picture
    Community Member on at
    RE: Fixed Asset Integration Account Group

    We use Integration Manager with eConnect

  • Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Fixed Asset Integration Account Group

    If you check a few of your Fixed Asset records in Financial > Cards > Fixed Assets > General.  You will note there is no value maintained in the Account Group field (this should be true whether you imported this field or not). Typically the Account Group ID is matched to the Asset by the Asset Class ID during integration.

    I tend to use Macros for this process, and not Integration Manager or the Fixed Asset Import Utility. I would recommend making sure you have the Account Group ID mapped to your Asset Classes and then create a macro to update the class of each of your Asset IDs.

  • Community Member Profile Picture
    Community Member on at
    RE: Fixed Asset Integration Account Group

    Because our company has a lot departments, our account groups include the cost centers for each department. All of the Account Group IDs integrated just fine and I have verified they match the asset it is associated with. Our issue is when we look at the assets not interfaced report, Great Plains is placing all of the assets under the same Asset Group ID instead of the correct Asset Group ID that is listed on the Asset Card.

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Fixed Asset Integration Account Group

    Try the following experiment - setup up an Asset Class ID, and assign an Account Group ID to it (make sure this is not the same as the Accounts already assigned), then update the class on an existing asset and/or create a new Asset, assigning the newly created Asset Class ID. The accounts should change to the Accounts Assigned to Account Group ID connected to your Asset Class ID during this process.

    If this bears out, then you need to create/link Asset Class IDs corresponding to all your Account Group IDs, then use a Macro to change the Account Class ID assigned to each of your assets.

    NOTE: If the Asset Class ID is the same as the existing Asset Class ID assigned to an asset, GP doesn't think anything has changed, and will not update Asset settings (like accounts) based on the Asset Class ID change.  So, you would need to change the Asset Class ID to an alternative value prior to making this change.

  • Community Member Profile Picture
    Community Member on at
    RE: Fixed Asset Integration Account Group

    Hello,

    I am trying to set up IM for Fixed asset upload; and running into a few problems. Can you share you're FA import integration with me? I want to see what I'm doing wrong.

    Thanks,

    David W.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans