Solved

Fixed Asset without Asset ID in Dynamics GP 10

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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

A frequent question here in the MAS90 Zone is, How do you get data out of MAS90 for analysis, reporting or using the data on your web pages?   This is an introductory level tutorial to getting data out of MAS90 using ODBC. Data can be accessed by…
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…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

747 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now