Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Unanswered

Tracking items through the FA Clearing Account

(0) ShareShare
ReportReport
Posted on by 5

I am having an issue tracking items that go through the fixed asset clearing account and perhaps I don't have enough experience using GP to come up with a solution to this issue.  

We have invoices that get coded to the FA clearing account (which uses our standard location code, 100).  From the FA clearing account, we setup the assets and move the costs from the FA clearing to the specific asset.  When crediting the FA clearing and debiting the Fixed Asset, the true location code of the asset is included in the Fixed Asset account string.  One issue that I am having is trying to pull all of the FA GL detail relating to one of our locations but it appears that when things go into the FA Clearing, they sometimes come out with slightly different descriptions and/or amounts (along with other bits of information like vendor name and invoice numbers) that have been combined making it impossible to historically tie these assets to the invoices they are made up of.

Is there any unique identifying characteristic to the entry that can be used to trace a specific fixed asset back to the entries that it is made up of?

Also, from my very short time using GP, I find it hard to believe this is the only way to account for fixed assets.  Is there a way to bypass the 'blackhole' of the fixed asset clearing and directly code these invoices to their respective fixed assets and FA GL? 

Please feel free to offer any other suggestions or how your company handles these issues because I have to believe there is a more optimal way to go about this.

Categories:
  • RobertShap Profile Picture
    RobertShap 125 on at
    RE: Tracking items through the FA Clearing Account

    It's best to create a  report specification in excel with the required columns. That way a consultant/developer can evaluate the requirements and propose a solution.

  • fireice113 Profile Picture
    fireice113 5 on at
    RE: Tracking items through the FA Clearing Account

    I was actually able to learn how to link the two tables with the exact fields you mentioned above but I'm not sure it is getting me to the desired outcome.  The new smartlist I created with the linked tables looks like a Fixed Asset register although it is under the financial smartlist instead of fixed assets but still does not list the GL details.

  • RobertShap Profile Picture
    RobertShap 125 on at
    RE: Tracking items through the FA Clearing Account

    Talk to your boss about your requirements and let me know if you already have a Microsoft Dynamics GP partner who can help.

  • fireice113 Profile Picture
    fireice113 5 on at
    RE: Tracking items through the FA Clearing Account

    I do have access to SmartList Builder but have never used it before.  Also I am not sure if we have a resource to help assist with these tools.  Sorry I am fairly new to using GP.

  • RobertShap Profile Picture
    RobertShap 125 on at
    RE: Tracking items through the FA Clearing Account

    Quite often the Standard SmartList Views do not meet all of the business requirements. That is why there are tools to create a new SmartList. Two of the tools that can be used are SmartList Designer which is free or SmartList Builder which is an add-on product from eOne Solutions.Do you have a resource or Microsoft partner that is familiar with these tools?

  • fireice113 Profile Picture
    fireice113 5 on at
    RE: Tracking items through the FA Clearing Account

    I have two different smartlist sub-folders under Fixed Assets for 'Fixed Assets' and 'Fixed Assets Purchase,' is that what you mean?  They both appear to show just a fixed asset register with different columns but neither show any GL info.  I think I understand your solution to my issue, I am just not sure how to get there.

  • RobertShap Profile Picture
    RobertShap 125 on at
    RE: Tracking items through the FA Clearing Account

    I recommend creating a SmartList. You will need to use either SLD or SLB to create a new SmartList depending on your software licensing.

    Start with the FA01400  Asset Purchase Master linking to the  FA00100 Asset General Master Table. 

    Use the Asset Index to link both tables.

  • fireice113 Profile Picture
    fireice113 5 on at
    RE: Tracking items through the FA Clearing Account

    I am adding the asset in the FA card using the purchase button and selecting the invoice.  Is there a report I can run that shows all of the invoices attached to each fixed asset card?

  • RobertShap Profile Picture
    RobertShap 125 on at
    RE: Tracking items through the FA Clearing Account

    Are you creating manual journal entries to move costs or adding the asset in the Fixed Asset General Card by selecting the Purchases button in the toolbar?

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans