Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Fixed Asset without Asset ID in Dynamics GP 10

Posted on 2010-11-16
4
Medium Priority
?
1,480 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 1000 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 Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part I
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses

877 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