Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Fixed Asset issue
Finance | Project Operations, Human Resources, ...
Unanswered

Fixed Asset issue

(0) ShareShare
ReportReport
Posted on by Romryan

Dear All,


I have an issue whereby assets were uploaded in my Client's GP but unfortunately they missed accountgroupid field. This field is important since each asset needs to be attached to an accounting group depending on the branch it's located to i.e. account groups are named Furniture-Branch A,Furniture-Branch B,Computers-Branch E, Motor vehicles Branch K etc so there are many account groups guided by number of Asset classes times the number of branches.


My client ran the depreciation and when building the GL batch on GL posting window, he got the messages on account not found. I wanted to to do an update query i.e. I update FA00100 from a custom table where my client had populated AssetIDs and Account Groups but I didn't find Account Group Id field in table FA00100. I don't know whether this is the best and quality solution besides re-importing them again. Can Econnect help in updating this field (without distorting the rest of assets information) or re-uploading is the best option?.

Kindly assist.

Categories:
Microsoft Dynamics GP
  • Leng Papio Profile Picture
    Leng Papio 855 on at
    RE: Fixed Asset issue

    The GLINTBTCHNUM is populated if the entry had already been picked up for the GL Posting (interfaced to GL already).

    There's really a lot of things that need to be discussed on integrations, regardless of what you use. For example, when you integrate to the Asset General window, is the auto add to book option marked (don't remember the exact option as I don't have GP opened right now).

    Once you save the asset , the 'account group id' becomes irrelevant as the specific GL accounts will be attached to the asset record itself.

    And those accounts can be changed anytime..  if the account group id is saved or attached to the asset, but the specific GL accounts are 'allowed' to be changed over time - the account id may be a source of confusion if the said changes actually happened.

    For example, if you have a group of assets you consider as 'Equipment', you assign the asset group id 'equipment' with specific GL accounts signifying equipment accounts, say for clearing, for cost, etc... over time, one of those accounts may need to be changed for some reason (like the business needs to inactivate it or change it for reporting purposes)- then identifying the asset by the asset group id will no longer be reliable.

    I really cannot give a specific set of recommendations on re-uploading unless I see the data.

    I am just saying, instead of identifying the assets with issues one by one and fixing the issues within GP - I think it will be easier to fix the issues/missing or incorrect info in an Excel sheet, validate it etc..  then remove the current data in GP, and reupload...

    Again, you can communicate with me directly as it may be easier...

  • Romryan Profile Picture
    Romryan on at
    RE: Fixed Asset issue

    Thank you Elena,

    I have checked FA00902 and unfortunately the GLINTBTCHNUM is empty and the GLINTACCTINDX is not empty.

    And again I have created e-connect test integration for Asset General Information (without book information) in Fabrikam and all the fields are getting in besides Account Group Id which is empty on the Fixed Asset General information card window. What could be the cause??.

    Also, what did you mean by this statement "When an asset is saved in the Asset Book window, where the account group is assigned, the account group itself is not saved with the asset.. only the accounts under that assigned group."  Does it mean that the Account Group Id cannot be saved if I have added only the General information without the book information?

    Lastly, If I was to re-upload the assets again, what do I need to do in order to remove all existing assets without affecting the setups?

  • Leng Papio Profile Picture
    Leng Papio 855 on at
    RE: Fixed Asset issue

    Hi,

    The cleanest way to do this is:

    clear out the uploaded assets, and re-upload.. then do depreciation and gl posting, etc.

    You can use the Select Assets, and create a group that you will remove.. and you can just re-integrate.

    Updating in the backend is never recommended... but if you must know, all transactions in FA is found in the FA00902.

    Also, there is a report in FA, under Reports, Activity... I think it is FA to GL reconciliation report.. using that report, you can sort it by account and see exactly which transactions do not have a GL account assigned on it.

    The FA00100 is the records in the Asset General window.

    The FA00200 is the Asset Book records.

    When an asset is saved in the Asset Book window, where the account group is assigned, the account group itself is not saved with the asset.. only the accounts under that assigned group.

    I am not sure why this is designed this way, but it is this way.

    You can contact me directly if you need more info.

    Elena

  • Romryan Profile Picture
    Romryan on at
    RE: Fixed Asset issue

    Any suggestion?

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans