Solved

Fixed Asset without Asset ID in Dynamics GP 10

Posted on 2010-11-16
4
1,438 Views
Last Modified: 2013-12-11
Hello,  
We have an old asset that we are not able to retire because it doesn't have an Asset Number.  Any suggestions on how we can get rid of it?
Thanks
0
Comment
Question by:steve_gp
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 18

Expert Comment

by:Steve Endow
ID: 34158571
Hi,

Unfortunately I don't have a GP test server with FA installed to test, but I would recommend trying Reconcile and/or Check Links on your Fixed Asset master.

Just make sure to perform a full backup of your Dynamics and company database(s) before running either.

One of the routines should either assign an asset number to the problem asset, or delete the record.  Make sure to save the error log to a file and review it to see what changes it made.  If it found other issues that resulted in changes, verify that those won't cause issues for you.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional
0
 

Author Comment

by:steve_gp
ID: 34168786
Hi Steve,
Thanks for the response.  I tested Reconcile in my Test Instance and it didn't resolve the issue for that asset.  And the Check Links doesn't have "Fixed Asset Master" listed.  Should I be able to see Fixed Asset Master under the Financial Series?

Is it possible to do a backend update on the Asset Number field so that I can retire the asset?

Thanks,
Steve
0
 
LVL 18

Accepted Solution

by:
Steve Endow earned 250 total points
ID: 34169486
Hi,

Sorry about that, I finally found a server where I had fixed assets installed, and unfortunately I confirmed that there is no Check Links for Fixed Assets.

Here's one last thing to check before you perform your update.

It looks like the ASSETID field is used in 10 different tables:

FA00100
FA00700
FA00701
FA00800
FA00801
FA01002
FA01100
FA01300
FA10200
FACNVDTL

So, first query the FA00100 table and find the asset with no ID:

SELECT * FROM FA00100 WHERE ASSETID = ''

Note the ASSETINDEX value for the asset.

Then query the remaining 9 tables for that asset index, like so:

SELECT ASSETID, * FROM FA00700 WHERE ASSETINDEX = 100
SELECT ASSETID, * FROM FA00701 WHERE ASSETINDEX = 100
SELECT ASSETID, * FROM FA00800 WHERE ASSETINDEX = 100
SELECT ASSETID, * FROM FA00801 WHERE ASSETINDEX = 100
...
...

See if any of those tables have a record for the asset that tells you what the asset ID was or should be.  

If so, great, go ahead and update your asset record with that ID.

If not, then it would seem that there are no other references to the asset's ID, so you can go ahead and assign one.


Before updating your live database, I would recommend trying this in a test copy of your database.  In that test company, try performing the update, and then try the retirement.  It looks like it should be okay, but there could be something that I'm missing that might cause an error.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional
0
 

Author Closing Comment

by:steve_gp
ID: 34190709
Helped to have each of the tables so that I could confirm the update was accurate and complete.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is a walkthrough guide I wrote whilst upgrading my on-premise MS Dynamics CRM 3.0 deployment to 4.0. This covers the actual installation of the product to a working level for my system, I ran into a lot of issues that the steps below fixed so h…
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part II
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question