Solved

Fixed Asset without Asset ID in Dynamics GP 10

Posted on 2010-11-16
4
1,432 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
  • 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Hi, I've just fixed a problem with Sage 50 Accounts 2010 crashing when creating a new Company.  I've spent nearly 4 hours on it including three calls to the Sage helpdesk (they didn't work it out in the end - I did!) ... so I thought I'd share th…
On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

685 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