Open Forum

Expand all | Collapse all

Fixed Assets

  • 1.  Fixed Assets

    Posted Oct 01, 2019 04:07 PM
    We are currently switching over to GP for fixed assets and we are importing multiple companies. Can we import by company or do they all need to be in one spreadsheet? Once we get them imported will there be a way to run reports sorted by company?

    Michael Bodamer
    Indianapolis Motor Speedway
    Indianapolis IN

  • 2.  RE: Fixed Assets

    Posted Oct 02, 2019 01:33 AM

    You can only import one company at a time if you're using Integration Manager. If you're using SmartConnect you can import multiple companies.


    You can have all the data in one sheet or one company per sheet.


    If you are using Integration Manager and have multiple companies in one sheet, you will need to apply a filter to the data in your source queries.


    Charles Allen

    Senior Consulting Manager | BKD

    2700 Post Oak Blvd. Suite 1500

    Houston, TX 77056

    713.499.4629 Direct

    713.494.2104 Mobile




    ****** BKD, LLP Internet Email Confidentiality Footer ******

    Privileged/Confidential Information may be contained
    in this message. If you are not the addressee indicated in
    this message (or responsible for delivery of the message
    to such person), you may not copy or deliver this message to
    anyone. In such case, you should destroy this message, and
    notify us immediately. If you or your employer do not consent
    to Internet email messages of this kind, please advise us
    immediately. Opinions, conclusions and other information
    expressed in this message are not given or endorsed by my
    firm or employer unless otherwise indicated by an authorized
    representative independent of this message.

    Any tax advice contained in the body of this email was not
    intended or written to be used, and cannot be used, by the
    recipient for the purpose of avoiding penalties that may be
    imposed under the Internal Revenue Code or applicable state
    or local tax law provisions.

    These discussions and conclusions are based on the facts
    as stated and existing authorities as of the date of this
    email. Our advice could change as a result of changes in the
    applicable laws and regulations. We are under no obligation
    to update this information if such changes occur. Our advice
    is based on your unique facts and circumstances as you
    communicated them to us and should not be used or relied
    on by anyone else.


  • 3.  RE: Fixed Assets

    Posted Oct 03, 2019 10:15 AM
    Hi Michael,
    We converted to using Fixed Assets in GP this last May, and the "by company" method worked perfectly for us. In terms of reporting, I've found the smartlists to be the best reports, and you can set those up to be multiple company.
    Let me know if you'd like to chat about tips/tricks.
    Thank you.

    Thomas Heffelfinger
    Stinker Stores, Inc.
    Boise ID


  • 4.  RE: Fixed Assets

    Posted Oct 04, 2019 10:36 AM
    We used SmartConnect and found that the eConnect procedures for fixed assets are not good.

    I would highly recommend using either integration manager OR the native integration for fixed assets that's built right into GP.

    Also, as others have mentioned, SmartList & SSRS reports are our preferred go-to for Fixed Assets. We have ~10 GP companies w/ Fixed Assets that we roll together..

    Kyle Malone, CPA
    GP Admin - CGB Enterprises, Inc.
    Lead Consultant/Blogger -
    Chapter Leader - Louisiana (New Orleans)
    Solugence | Find the software that FITS your business + integrates with GP. Find Software Smarter.


  • 5.  RE: Fixed Assets

    Posted Oct 07, 2019 03:14 PM
    I will respectfully disagree with @Kyle Malone on this one with regards to the import options. I find the out of the box macro-based import to be buggy and painful, in my experience and have used SmartConnect with the eConnect stored procs without any issues whatsoever. It's super fast, it works well and the customers I've created imports for into FA with SmartConnect love it. You can import to multiple companies at the same time with SmartConnect, which is an added bonus.

    The way you have asked your question, I would want to clarify though: when you say multiple companies, you do mean multiple different GP company databases, right? ​Above when I say multiple companies, I literally mean different GP company databases, not multiple entities in one database.

    Typically, without something like SmartConnect, you must import one company at a time - when importing to different databases.

    Reporting wise, so much of how I would answer would depend on your definition of multiple companies as it sounds like you mean something in one "database". Within what I refer to as 1 GP company, I would ensure you are utilizing a field in Fixed Assets to differentiate "company" otherwise it will be difficult to identify which is which. If it's different GP company dbs, the db itself will be the way to tell which company something is in if someone is writing multi-company reports for you, i.e. the author would have some kind of query that indicates where the data came from in theory, to help you report on them individually.

    I hope that helps!

    Jen Kuntz, CPA, CGA, Microsoft MVP (Business Applications), GPUG All-Star

    Independent Consultant
    Kuntz Consulting Inc.
    Cambridge, ON, Canada


  • 6.  RE: Fixed Assets

    Posted Oct 07, 2019 03:40 PM

    A good example of why multiple perspectives are always a good thing @Jen Kuntz !​ We had a few custom procedures given to us by Microsoft to make things work correctly & had to manipulate our source/processes to address other issues. Maybe (hopefully) they've been released to the core code or we just had very specific scenarios that were causing the issues.

    Happy to hear that eConnect/SmartConnect has worked well for others!

    Kyle Malone, CPA
    GP Admin - CGB Enterprises, Inc.
    Lead Consultant/Blogger -
    Chapter Leader - Louisiana (New Orleans)
    Solugence | Find the software that FITS your business + integrates with GP. Find Software Smarter.


If you've found this thread useful, dive deeper into User Group community content by role