You’re offline. This is a read only version of the page.
Announcements
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.
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.
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.
Talk to your boss about your requirements and let me know if you already have a Microsoft Dynamics GP partner who can help.
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.
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?
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.
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.
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?
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?
#1
André Arnaud de Cal...
293,442
Super User 2025 Season 1
#2
Martin Dráb
232,582
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (