Commonly Used Tables:
FA00100 – Asset General Information Master
FA00200 – Book Master
FA00400 – Asset Account Master
FA00500 – Lease Master
FA00600 – Insurance Master
FA00700 – Retirement Master
FA00800 – Transfer Master
FA00902 – Financial Detail Master
FA00905 – General Ledger Interface Work
FA01100 – FA-AP Posting Master – this is where Purchases from the clearing account are stored
FA01400 – Asset Purchase Master
FA01500 – FA Activity Master
FA10100 – Asset Group Header
FA10200 – Asset Group Detail
FA19900 – User Data Master
FA40200 – Book Setup
FA40201 – Asset Class Setup
FA40202 – Book Class Setup
FA40203 – Book Setup (for Depreciation)
FA41100 – Location ID Setup
FA41200 – Insurance Class Setup
FA41300 – Account Group Setup
FA41500 – Structure ID Setup
FA41600 – Lease Company Setup
FA42400 – Physical Location Setup
FA49900 – Company Setup
ASSETTYPE (Asset Type):
1 – New
2 – Used
3 – Leased
ASSETSTATUS (Asset Status):
1 – Active
2 – Deleted
3 – Partial Open
4 – Retired
PROPTYPE (Property Type):
1 – Personal
2 – Personal, Listed
3 – Real
4 – Real, Listed
5 – Real, Conservation
6 – Real, Energy
7 – Real, Farms
8 – Real, Low Income Housing
9 – Amortizable
TRANSACCTTYPE (Transaction Account Type):
1 – Reserve
2 – Depreciation
3 – Cost
4 – Proceeds
5 – Recognized Gain/Loss
6 – Non Recognized Gain/Loss
7 – Clearing
DEPRECIATIONMETHOD (Depreciation Method):
1 – Straight-Line Orig Life
2 – Straight-Line Rem Life
3 – 125% DB
4 – 150% DB
5 – 175% DB
6 – 200 DB
7 – SOY Digits
8 – Remaining Life
9 – Amortization
10 – ACRS Personal
11 – ACRS Real
12 – ACRS Real MSL
13 – ACRS LIH
14 – ACRS Foreign Real
15 – No Depreciation
16 – Declining Balance
AVERAGINGCONV (Averaging Convention):
1 – Half-Year
2 – Modified Half-Year
3 – Mid-Month (1st)
4 – Mid-Month (15th)
5 – Mid-Quarter
6 – Next Month
7 – Full Month
8 – Next Year
9 – Full Year
10 – Full Year All Year
11 – None
12 – Next Period
13 – Full period
SWITCHOVER (Switchover):
1 – No switch
2 – Straight-Line
Reporting Notes:
Most of the tables will use the Asset Index (ASSETINDEX), not the Asset ID, so link the tables on that.
SQL Code:
Fixed Assets Tips:
- Depreciation stuck? Check table FA01500.
- Projection stuck? Check table FA40203.
–
Last Updated: May 5, 2020
Victoria Yudin 
Hi Victoria, I contacted you from Chile, I hope this forum is still active… I told you that I arrived very recently at a company and among the tasks they asked me to perform is to activate, put into use the Fixed Asset module, they currently manage a Excel. I would like you to help me load the data in bulk and configure the module, I still don’t know how to start. Greetings.
LikeLike
Hi Nelson,
If you do not have experience with this, I would recommend asking your Dynamics GP partner for help with it.
-Victoria
LikeLiked by 1 person
Victoria, thank you for your prompt response. I am looking for help because the company does not want to invest in external advice and asked me to enable the Fixed Assets module by loading data from Excel. Please help (for the Inventory module they asked me the same thing).
LikeLike
Hi Victoria, I can be of help to Nelson.
Regards, James Thuo
LikeLiked by 1 person
Hi friend James, your help is well received. Regards.
LikeLike
Hi Victoria, I have followed your site for many years and it never fails to provide assistance – thank you, I certainly appreciate the time and effort that you take to do this 🙂
I have a fixed asset book question if I may.. customer is already using fixed assets successfully but wants to add another book which will hold a select number of assets to be depreciated to the GL. I have run this through in testing and all works ok apart from one issue and i am not sure if this is a system issue or not. When performing an enquiry on the GL depreciation account, i can see the depreciation for the second book of assets.
The problem i have is that if i drill back on the source code for the journal it doesn’t show me the assets that are included in that journal. If i do the same drill back for assets contained in the main book i can see this detail. Is this something that i am missing or is this standard for a “second” book please?
LikeLike
Hi Tracy,
My understanding is that you can only have one Fixed Assets Book ID in GP that is posting to the GL, all the other books are internal to the Fixed Assets module. They will calculate the depreciations, etc., but will not post to the GL. So I am not sure how you are seeing the depreciation for the second book in the GL unless that was manually posted there? In that case, that would explain why you cannot see the Fixed Assets detail for those entries.
Victoria
LikeLike
Hi Victoria.
I see you have provided a decoder for Asset Status to interpret the numbers in the table I’m querying. Are these English descriptions stored somewhere inside GP such that I could join the ASSETSTATUS value and return just the description for my users? TY!
LikeLike
Hi Jon,
Some of these have started to be added as functions in the database. For Asset Status, looks like you can use FA_FUNC_Asset_Status.
-Victoria
LikeLike
The FY is greyed out when we try to run depreciation for the new FY. Does the prior year have to be closed before we are able to run the depreciation for the month of July (the new FY)?
LikeLike
Hi Cynthia,
Yes, before you can run depreciation for one year, the prior year has to be closed in the Fixed Assets module.
-Victoria
LikeLike
Hi – I have call logged to create three reports reflect additions retirements and any change made to cost.
I’m struggling to finding with creating and additions report . Is there a table the records the additions for the period?
Thanks
LikeLike
Hi Junayd,
The FA00100 table has 2 fields that might help you:
– Date Added (DATEADDED) is the actual date an asset was created
– Acquisition Date (ACQDATE) is the sate entered as the purchase date
-Victoria
LikeLike
HI Thanks for the help
I used the Source column from FA00902
FAADD
FARET
FACHG
LikeLike
We have about 6000 assets we need to delete before the end of the year. Is there a SQL script that we can use to delete. Deleting through user interface is not practical for that large number. Thanks
LikeLike
Hi Cory,
I am not aware of a script to accomplish this. It can probably be created, but would require significant data validation and testing and may also require checking your specific environment for any add-ons or customizations that require additional changes beyond the Dynamics GP out-of-the-box tables. One thing you could do is turn on SQL profiler and delete an asset manually to see what is called by GP for deletion of an asset.
-Victoria
LikeLike
Hi Victoria,
I need to update Depreciation Method and Averaging convention on different BookID/AssetID. Do I just update the FA00200 table or are there any other tables involved?
Thanks!
LikeLike
Hi Namrita,
If you are looking to do this in order to update the depreciation for existing assets, you cannot change this in a table. It must be done in the Dynamics GP user interface.
-Victoria
LikeLike
Thank you! Is there any other options besides using macro?
LikeLike
None that I know of. And with a macro, you will need to answer a question or two on each one, so not sure how well that will work. 😦
-Victoria
LikeLike
Hi Victoria,
We use Fixed Asset module for WIP (Work in Progress) and not depreciate until it’s completed and start depreciation. Our mistake is we name the Asset ID with leading characters “WIP_” plus the real Asset ID. The Fixed Asset module do not allow to edit the Asset ID so the naming is now inconsistent. How do we update FA table by using sql query and TRIM the leading characters “WIP_”?
I used this query but gave me error.
UPDATE FA00100
SET ASSETID = REPLACE(ASSETID, ‘WIP_’, ”)
WHERE ASSETID LIKE ‘WIP_%’ AND ASSETCLASSID NOT LIKE ‘WIP’
Msg 2601, Level 14, State 1, Line 1
Cannot insert duplicate key row in object ‘dbo.FA00100’ with unique index ‘AK2FA00100’. The duplicate key value is (2210 , 1).
The statement has been terminated.
LikeLike
Hi Jina,
That error means that you already have a Fixed Asset ID that you are trying to update to, so that the update would result in a duplicate ID, which is not allowed.
That said, it’s a REALLY bad idea to do this in the database directly. I would recommend instead using the PSTL Fixed Asset Modifier tool, which will do this for you correctly.
-Victoria
LikeLike
Thank you very much for your reply. I am learning a lot from your website.
In our case (maybe?), Asset ID is not unique. But each row has a unique Asset Index .
We used Asset ID an example below:
Asset Index Asset ID Suffix
101 2114 1
102 2114 2
103 2114 3
104 2115 1
105 2115 2
However, I will explore PSTL since I have not used it before.
I thought SQL will be simpler. 🙂
Appreciate your help.
LikeLike
Dear Victoria,
Thanks for your support in advance. Just want to ask how to make undo mass retirement? Is there any way or workaround to do so?
As we have retired around 100 items in a group from mass retirement window and we want to undo the retirement.
Beast Regards
Yassir Humaid
LikeLike
Hi Yassir,
I am not aware of a way to undo a mass retirement all at once. At least you can undo the retirement one asset at a time. That’s a lot more than other modules/functions let you undo.
-Victoria
LikeLike
That’s what I thought! But I told: you may have some workaround as you are an expert in dynamics gp!
Thank you very much for fast respond. 🙂
LikeLike
Victoria,
We need to input over 3,000 assets in on of our databases. My intent is to utilize a macro to import the assets, this will be done in sub-lots which should ensure that any import errors/issues are caught early. I have already done testing in the QAS database and I was able to get the correct data on the fixed asset cards and their associated books.
The only concern I have is the creation of the Fixed Asset Calendar. The calendar must be created for any prior years that have fixed asset additions, and must also be created for any future years that depreciation will exist for based on the assets in place. Without the fixed asset calendar depreciation data will not fill in on the fixed asset card books which results in the inability to run depreciation and post that to the GL.
Per the research I completed, the fixed asset calendar should be created for the years 1901-2199. I created it in the QAS environment per the instructions I found. Once the calendar was created, the fixed asset cards auto-added the depreciation data to the fixed asset cards
Additionally, per the research I completed, it is highly suggested that a back-up be made of the database prior to creating the FA calendar. I did not find or experience any problems after creating the calendar in the QAS environment. However, I am unsure what would be impacted in order to confirm that everything worked as expected.
We need to identify what should be checked after the FA Calendar is created to avoid problems down the road.
Thanks, Tony
LikeLike
Tony,
In my experience the FA calendar is pretty straightforward and I’ve never had any errors when creating it. I’ve also never seen a backup (or restore) needed for the process. For what it’s worth.
If you want to confirm the calendar is all there, pull up the Calendar ID on the Fixed Assets Calendar Setup window and click the Print button. IMPORTANT: print the report to the screen because it will likely be over a hundred pages. 🙂 Then you can just scroll through and confirm it all looks ok.
Hope that helps.
-Victoria
LikeLike
It does! Ty for the quick reply!!
LikeLike
Hi Victoria, I wonder if you can give some advice please? We have added purchase invoices to the FA program us the PM link in GP. We have added several together into one asset. However, GP does not pass on the changed (increased) cost to the Asset Book. Do you have to manually update the Cost basis value? Am I doing it wrong or is ther a way that GP does this automatically (I’m trying to avoid human errors through manual input here)
Please advise and many thanks for this website!
LikeLiked by 1 person
Guido,
The asset book does not automatically get updated for these kinds of changes. You will need to do that manually and if the asset has already been posted to the GL or started being depreciated, you will have to recalculate the asset book information (it will prompt you to do this when you click Save).
-Victoria
LikeLike
Thanks for the prompt reply Victoria. many thanks. – Guido
LikeLike
Hi Victoria, thank you for this awesome website. Just a question: is there a way to get GP to automatically fill in the FA Book for you. Since we have only one book it seems pointless to have to select it at almost every window that requires the book. We are using GP 2010. Please advise. Thanks.
LikeLike
Good morning,
Unfortunately, this is not possible without customizing every window involved. Probably not worth the effort. 😦
-Victoria
LikeLiked by 1 person
Hi Victoria,
Hoping you could guide in in the right direction. Just started working with new company who imported their Fixed Assets last year but there was a handful of assets that did not get imported into the Fixed Asset Ledger. They went ahead and closed the year with these items being reconciling items on excel sheet. Now I’m trying to figure out if I can import these assets into the FA ledger without impacting the GL or another workaround.
GL FA Ledger Diff
719,689.06 606,815.91 112,873.15 non-imported items
LikeLike
Robert,
You can enter these assets into GP and specify the YTD and LTD depreciation that has already been booked manually in the GL. Make sure to enter the appropriate Depreciated to Date. When you run the GL posting for these, they will create a GL entry that you can then delete if all of this has already been entered directly into the GL.
-Victoria
LikeLike
Victoria, great thread with interesting topics. This is a great resource! Have you ever run into an issue with new assets being loaded, set for new, active, personal, no depreciation, but once you move to your book screen there is no “distribution” button? We are also seeing that the fully depreciated flag is set to “Y” and is greyed out so I can’t change it. I am finding very little info on how the fully depreciated flag is set… Open to suggestions. Thanks Justin
LikeLike
Hi Justin,
I am looking at an out-of-the-box Asset Book window and there is no Distribution button on it. Do you normally have a Distribution button on yours? If so, you might have a 3rd party product or customization. In general if you imported an asset and something is not working right, I would suspect something either went wrong with the import or the data in the import was incorrect. Are you able to delete and manually re-enter one of these assets? Does it behave differently?
-Victoria
LikeLike
Victoria, we are working with an out of the box FA solution. So let me see if I can provide more specifics:
Unfortunately I can’t get a screenshot to post in here…
This issue is occurring when we manually create the asset. I have now created 6 test assets to prove that this is occurring consistently. So here is the first scenario that has the expected results:
1.) Cards > Fixed Asset > General
2.) Select the class id you want to create an asset for
3.) Fill out enough information to save (acquisition date, dollar amount, descriptions, new, personal)
4.) Save
5.) Use Go-to button and select book
6.) Select the “internal” book
7.) Bottom right is a “Distribution” button and the fully depreciated flag is set to N.
This is what we expect to see the first time we go into the book window. The Distribution button allows you to see the accounts that will be affected when you save item. (clearing account vs. asset account)… After you save the newly created book class item the distribution button goes away and an ITC/Cost button appears next to where the distribution button was.
In certain class id’s where there is no-depreciation (i.e. CIP class id’s) we are not getting the distribution button to confirm the accounts (it defaults straight to the ITC/Cost button) and the fully depreciated flag is set to Y.
Does that explain the issue more clearly?
Thanks,
Justin
LikeLike
Hi Justin,
Thanks for the additional detail. I think what has happened is that someone changed the Book setup for your “Internal” book to “auto add” the book information. That automatically creates the book info and thus the Distribution button does not show up. If you change the settings on the book to not have it auto add, the distribution button will come back.
-Victoria
LikeLike
Hi Victoria,
Currently fixed assets are done manually outside of GP. Also a couple of years ago, the business was acquired and FAs were revalued. How do I go about entering all of the FAs taking into the account the revalution to have GP complete the calculation going forward?
Jelana
LikeLike
Hi Jelana,
If the assets were revalued you may be better off wiping out your FA data and starting from scratch. Another option might be to create a new FA Book and re-import all the assets with the new values into it. Otherwise you would have to manually revalue and recalculate every asset. You might want to confer with your GP Partner about the specific situation and see what their advice is…this is sometimes difficult to advise on without seeing the existing data and volume of it.
-Victoria
LikeLike
Right now we have nothing, but an excel file. We don’t use the FA section of GP at this time, but I would like to. Thanks. This gives me some things to think about.
LikeLike
Jelana,
That actually makes it a little easier. Typically the steps for implementing Fixed Assets are:
While it’s certainly not the most difficult module I’ve used in GP, if you have not done this in the past, I would recommend working with your GP Partner to implement the Fixed Assets module. Hope this helps.
-Victoria
LikeLiked by 1 person
Victoria- We are upgrading GP and we have been manually doing fixed assets in excel as we were never able to resolve issues with the fixed assets module. Unfortunately, we have some historical fixed asset information in GP prior to us handling fixed assets in Excel. Is it possible to wipe out existing fixed assets and start from scratch with the upgrade?
LikeLike
Hi Kaley,
Yes, there should be a way to wipe out all the current data from Fixed Assets. I looked around, but I do not see instructions for this, unfortunately. You may want to check with your GP Partner or with Microsoft support to get instructions for that.
-Victoria
LikeLike
Good day Victoria, I have a quick question. If I ran depreciation for a list of assets in a particular period in GP can I add another item to be depreciated for that period as well, even though it was not included in the depreciation of the initial set of items?
LikeLike
Hi Carleesha,
Yes, if you add a new asset, then re-run the depreciation for the period, it will pick up the new item that has not yet been depreciated for that period.
-Victoria
LikeLike
Thank you once again for your assistance Victoria
LikeLike
Hi Victoria 🙂
As always your site is an inspiration, thank you! I have a question regarding fixed assets depreciation if I may? We are looking at a scenario for a client where assets are depreciated quarterly. This in itself is not a problem but the issue arises because the quarter starts from the place in service date of each asset and not the quarter dates of the year. EG year is calendar Jan to Dec. Fixed asset PISD of 010114, depreciation target date would be 310314. Fixed asset PISD of 010214 depreciation target date would be 300414. This is all fine until the year end is reached and the target date cannot be a date greater than the current year, so for the asset with PISD date of 010114 everything is ok, but for the asset with the PISD of 010214 the depreciation target date would be 310115 and this is where the target date message comes up – hopefully this all makes sense (it did in my head!) Do you know of a way around this issue please?
LikeLike
Hi Tracy,
I do not think this is how the Fixed Assets module in GP is meant to work, so I am not sure you’ll be able to accomplish this. 😦
-Victoria
LikeLike
Hi Victoria
I hope you can help us. How do we get the FA module to start depreciation from the True Start Date according to calendar year?
If the Place in Service Date is 01 February, the Depreciation Start Date must be 01 February.
Currently, the system sets it one day back: Depreciation Start Date 31 January.
It only does this with some of the assets, not all of them. I can’t seem to figure out a pattern.
Thanks
Michelle
LikeLike
Hi Michelle,
The start date of the depreciation is determined by the Averaging Convention – I believe there is a description of each option and what it will do in the Fixed Assets manual.
-Victoria
LikeLike
Hi Victoria –
I have a fixed asset question I was hoping you could help me with. We just placed about 1500 assets in service on 7/1/13. We want to calculate a short year tax depreciation under a federal book using double declining and half year convention but don’t see how GP calculates a short year. We tested a few assets and noticed that GP calculates the half year convention from beginning of the year thereby calculating 6 months depreciation. However because we placed our assets in service on 7/1/13, depreciation should only be 3 months which is equivalent to a 1/2 of the half year convention. I am not sure what I need to do to make GP calculate a short year. I feel like I have tried everything.
Thank you in advance!.
LikeLike
Hi Megan,
I’ve not seen this requirement before, so unfortunately I do not have a good answer for you. The only thing I can think of is to manually change the YTD and LTD depreciation and have the asset recalculate the remaining depreciation, but that would need to be done manually for each asset, so I am not sure that you want to do this for 1500 assets.
Maybe someone else reading this will have some other ideas for you. Or you could ask Dynamics GP Support to see if they can answer this.
-Victoria
LikeLike
Victoria,
When we run Depreciation on a group we have set up to house all of our Fixed Assets, it does nothing. When we click on the ‘Progress’ button right after we run it, lists the first asset in the list, but when we hit redisplay, the asset disappears and nothing happens. Have you seen this before?
LikeLike
Hi Ben,
I have seen something similar when there was a record stuck in the FA01500 (FA Activity Master) table. I would recommend checking to see what’s in there.
-Victoria
LikeLike
Thanks for the quick reply. But sadly the FA01500 table is empty when I just checked it now.
LikeLike
I am guessing this was working previously? What has changed? Also, what if you choose Depreciate all assets instead of picking a group?
-Victoria
LikeLike
Yes, it worked in our old company. However, what changed is we had to set up a new company (for legal reasons), and we are trying to run depreciation on all assets for the first time in the new company. So technically a lot has changed, and I am sure it probably has something to do with setup/configuration, but everything matches the old company setup.
LikeLike
Aha! Very important to know that this is a new setup. What I often see is companies forgetting some of the setup steps, the Fixed Assets module is very “setup heavy”. Can you check to see if you have the right book selected under Corporate Book on the Fixed Assets Company Setup window? (GP | Tools | Setup | Fixed Assets | Company)
-Victoria
LikeLike
Yes, we only have one Book set up in this company because we didn’t use the other books in the old company. I have confirmed the book is selected in the Setup screen. I used the Fixed Assets Admin user guide to set up the new company module.
Also, the same thing happens when I just try to run depreciation on all the assets and not use a group to define it.
LikeLike
Sorry Ben, not sure what else to check without looking at your GP setup. At this point you may need to have your GP Partner or Microsoft Dynamics GP Support look at your setup together with you to get this resolved.
-Victoria
LikeLike
No worries, Victoria. Thanks for the assistance. I had already reached out to my VAR and we haven’t had any luck yet. Back to the drawing board.
LikeLike
Hi Ben,
I had experienced the same and realized there were some assets with a cost of <1 that were causing unending looping in depreciation. If you have such assets change their depreciation method to NO depreciation. Also look whether there are records stuck in FA40203
LikeLike
Victoria, have you ever had the issue of entering a fixed asset, and realizing the cost account needed to change? if we change the account group on the general tab, any future depreciation goes to the correct accounts (i think previous depreciation is corrected as well, don’t quote me though) but the cost account doesn’t change. is there a process to trigger this in the GL Posting routine? running the next month of depreciation doesn’t do it.
LikeLike
Hi Mike,
Past depreciation or cost would not get corrected by any changes to the Account Group on the Asset General Information window. You have 2 options:
-Victoria
LikeLike
Hi,
we have a very strange problem as soon as we upgraded to GP 2013 and changed the keys for one of our customers, whenever we try to add a new asset we receive the message ” adding this record will exceed your registration limit of 50 Book/Asset records”.
We sent to Microsoft and they identified that there is no issues with the keys as GP 2013 perpetual do not have such limitation.
Best Wishes & Regards
LikeLike
Hi,
Just to identify that problem solved.
While upgrading and key change , the fixed assets module under registration keys was not checked by default (activated).
Accordingly we checked it, then we had to review and save the Fixed Assets company setup.
After that every thing worked properly.
LikeLike
Hi Ismail,
Thanks for the update – I am sure this will be useful some others if they come across the same issue.
-Victoria
LikeLike
Hi, is there a table for the property type?
LikeLike
Hi Stewart,
Property Types are hard-coded, so I do not believe there is a table for them. What are you looking to do with it?
-Victoria
LikeLike
I am not sure how much system “help” this will provide, but it would have been a help to us for our consultants to understand this topic prior to our implementation.
I just wanted to chime in on the topic of negative cost. Public utilities have regulations that sometimes require them to depreciate assets beyond their original acquisition cost. They depreciate the asset at the same rate each month, even after it has been fully depreciated.
Most of us are familiar with the “normal” depreciation method for purchasing an asset (let’s say a bucket truck for $100,000 with a 5 year useful life) & depreciating it each year until it had a net book value of $0.00. However, a public utility would depreciate the asset at an “approved” rate each year the asset was in service, regardless of the net book value.
As a side note, “utility providers must prepare a rate case any time they want to increase the rates they charge to the public. They request the right to charge an amount per KWH that will allow then to earn a certain % return on their investment. Rate base is the primary component of that investment and rate base is made up primarily of PP&E. The more their “old” assets are depreciated, the less investment they have on their books and the less they can charge customers for service. This encourages utility providers to keep their equipment up to date (make more purchases) and – in turn – offer more reliable service to their customers.
I agree that negative book value seems very odd, but it does make sense once you learn the reasoning behind it. When we implemented GP, we were told that we could not have negative net book value, so we depreciate our assets as a “pool” by asset class rather than depreciating them individually. That means that the A/D only hits the GL rather than also being posted to the subsidiary ledger, but it keeps us in compliance with our regs.
LikeLike
Hi Victoria,
Hoping you can help with a FA Year End Question. We have assets that are fully depreciated and that have a depreciated to date of prior year ends (12/31/2007 for example) When we run the close we get the error “assets have not been fully depreciated through the current year” because of the assets. Can we ignore tat message and continue with the close? or do these assets need to be “depreciated” in some way before the close. These assets and their depreciated tto date were imported earlier this year (2012) with these depreciated to dates.
LikeLike
Hi Jeff,
I have not run this myself, but I have seen this question start popping up on multiple forums recently. For these assets, what is in the Fully Depreciated Flag under the book?
-Victoria
LikeLike
The flag is set to “Y”
LikeLike
Jeff,
Ok, I was hoping it was N and that was the issue. Have you tried running the Depreciation using 0000-000 in the From and 2012-012 (or whatever you last year period is) in the To? If you do not routinely use all zero’s in the From and if you have a test company, might be best to do it there first to see what will happen.
-Victoria
LikeLike
I can backup and I can try and run from 0000-000. I am not sure if that will update depreciated to date however.
LikeLike
Jeff,
I am not sure either, just something to try. I have not run into this problem before. You might need to talk to GP Support or post on the GP Community Forum to see if you can get some additional help.
-Victoria
LikeLike
Victoria,
Just wantred to close out this issue. It is a non-issue. The depreciated to date on a fully depreciated asset is the same date as the date the asset became fully depreciated.
LikeLike
Can we have an Asset with Negative Acquisition Cost?
LikeLike
Not to my knowledge.
-Victoria
LikeLike
have someone asked you this before ? do you know of a posible work around?
LikeLike
Tony,
Yes, I have seen the question before. I am not aware of any workaround. Why do you need to enter a negative cost?
-Victoria
LikeLike
I dont , my client does, it is a rec item but weird how someone really thinks an asset could have a negative cost. I know I would like to see like negative lines on Purchase Orders and perhaps other modules but not FA
Thanks Victoria
LikeLike
Tony,
Agreed – it’s a bit counter-intuitive to have a negative asset cost. If they need to make an adjustment, perhaps they can adjust the acquisition cost of the original asset and have the depreciation recalculate?
-Victoria
LikeLike
Victoria, we are getting an error on the import macro when it gets to the currency field: “Field on window is inactive or disabled. (Line#20)”. The customer is not using multicurrency, so yes, the field is disabled. We think all the setup is correct for the company. What would make the macro think it needs to enter the currency ID, and is there a way to turn that off?
LikeLike
Pam,
I checked my last import and we didn’t have currency ID and it worked just fine. Are you possibly including the currency ID in the import instead of omitting it?
-Victoria
LikeLike
We have the column, and I have tried populating it and leaving it blank. Either way, we get the same error.
LikeLike
Also, the same file imports fine to my GP, but I’m using Fabrikam.
LikeLike
Victoria, I at least figured out a workaround. When the import bombs, I edited the macro in Notepad to remove the following lines for all assets:
MoveTo field ‘Currency ID’
TypeTo field ‘Currency ID’,’Z-US$’
Then I ran the macro and everything ran fine.
I think it’s a bug in the GP2013 macro that it tries to put in the currency ID even when multicurrency is not being used. I tried it in two different companies who were not using multicurrency in GP2013 and got the same results.
LikeLike
Hi Pam,
Thanks for the update and sharing the workaround! I didn’t realize that you were using GP 2013, I have not imported assets into it yet. This will probably be something that comes up more often as we start working with customers on GP 2013.
-Victoria
LikeLike
Hello,
We are also having issues with the Fixed Assets General Import. We are getting a “Field on window is inactive or disabled. (Line#24)”. Client is using multi-currency so I don’t think I can omit the currency id column.
Any help would be appreciated.
LikeLike
Navin,
When the window opens after this error, what field is it on?
-Victoria
LikeLike
It is on the Acquisition Date field. However, when we tried Pam’s solution, it did import. The only issue with that is that it leaves the Currency ID field blank and gray’s it out.
LikeLike
Any further input would really be appreciated. Can’t seem to move forward at this point.
LikeLike
Navin,
What version of GP are you using? Pam’s issue sound like it is only going to come up in GP 2013 and only if you do not have Multicurrency enabled. I recall having to format dates in a particular way for the import to work – something like MMDDYYYY – have you checked the import documentation to make sure you have formatted it correctly?
-Victoria
LikeLike
Victoria,
We are using GP 2010 – 11.00.2044 (SP3). I do have it saved in the mmddyy format. The import documentation wanted us to save in the 0##### for Jan-Sep and ###### for Oct-Dec. Converting from date to this format was doing all kinds of modifications to the dates. So instead we created a custom mmddyy format which was also 6 digits. The funny thing is that when you tab out, it accepts and the Date Added field also populates with no problems leading us to believe that this has to do with the next field which is the currency id field.
LikeLike
Navin,
I just checked my prior imports and I have always used the 4 digit year. I would at the very least try that to see if it makes a difference. Also, I just noticed that you said that Pam’s solution works for you – why not use that? Looking through my Fixed Assets manual, I actually do not see an option for Currency ID in the import – do you? (My manual is dated April 2011.)
-Victoria
LikeLike
Hello Victoria,
We tried with a 4 digit year and it still doesn’t work. I was wondering if you could assist us by reviewing the fixed asset file and corresponding macro file that I have attached.
I did find that there is an asset id length restriction which the macro is truncating automatically.
We did leave out the currency id and date added columns and that doesn’t seem to effect. So we are back to the Acquisition Date field. We thought that Pam’s solution was working but that doesn’t seem to be the case as somehow it takes the first item but stops at the second asset on the Acquisition Date field but still somehow saves that asset as well. We keep deleting the assets before trying to re-import again.
Any assistance would be appreciated.
Thank you, Navin
LikeLike
Hi Navin,
There is no way to send me attachments on my blog. Also, I think we may be starting to get into an area that would be considered billable consulting. I would encourage you to work with your GP partner or Dynamics GP support for help on this.
-Victoria
LikeLike
Hai Victoria,
U have helped me bfore…Thnx For this Gr8 Blog..
Here i have a problem. The “depreciate” button in depreciate process information window in the routines…is disabled. It is accessible for only power users. How can I enable this for normal users.(providing FA manager privilege didn’t solved the problem)… please help…
LikeLike
Hi Victoria
Thank you for your blog, it really helps me a lot. I have one query which i can not get past at this point. A fixed asset was loaded in error and depreciation was run on it. How can I retire that asset without affecting any of our books.
Your reposnse will be highly appreciated.
Regards
Nish
LikeLike
Nish,
You should be able to retire the asset on the same date as the place in service date and have it back out any GL entries. However, you might want to test this in a test company first, sometimes retirement does not go as expected.
-Victoria
LikeLike
sorry a small change,,, its not accessible for any users…including sa. Is it any set up issue…?
LikeLike
Fazil,
This is most likely not a permissions issue. Take a look at this forum post to see if the solution suggested will help you: https://community.dynamics.com/product/gp/f/32/p/29570/49969.aspx?wa=wsignin1.0
-Victoria
LikeLike
Thanks A Lot Victoria… U rock… 😀
LikeLike
Hi Victoria,
We are now in a situation where we need to skip the depreciation of assets for the remaining 10 months of fiscal year 2011 and then depreciation again starting January 2012.
This situation is this:
Starting March 2011 to December 2011 our company ceased to operate due to a very critical situation. Last January 2012 our company started operating again. Our assets were depreciated until February 2011 and we have decided not to depreciate the assets from March 2011 to December 2011 because the company was temporary closed.
The problem is:
When we tried to depreciate our assets for January 2012 the system generated the depreciation from March 2011 which is not the way we want as explained above. Any work-around on this matter? By the way, we have already done the year-end closing procedures.
Thanks for your help.
Jack
LikeLike
Hi Jack,
I have never tried this, so it would need to be tested, but the only way I can think of to accomplish this is to change the Depreciated To Date for each asset to be 12/31/2011. That way it will start depreciating from 1/1/2012. Based on what your accountants advise, you will also possibly need to change the remaining life of the assets to add 10 months to each and/or to decide how to recalculate the depreciation. Again, best to test all of this ahead of time somewhere other than in your live data to make sure you know how it will work and to confirm it will accomplish what you need, both in the Fixed Assets module and in the GL.
-Victoria
LikeLike
Hi Victoria,
Thanks so much for the idea. If in case this will work, this would be lots of job to be done considering the number of assets that we had. What would be the better way to change each asset? I’m thinking about a macro but this would need us to prepare an excel list of assets before we can use a macro. Is it possible we can make a SQL script to perform the job? and if it’s possible, what are the FA Tables that we need to use?
Thanks so much.
Jack
LikeLike
Jack,
I don’t believe you can do this with a SQL script because this change may ask for a decision on each asset, which you will not be able to easy address with a SQL script. Macro…maybe, I am not a huge fan of macros, but in this case it might save some time. Again, I would first test out everything and make sure that it’s going to work as intended before even worrying about how to actually update the data.
Another option may be to create a new book, or even wipe out the assets and re-import them from scratch. We recently had a client that got acquired and needed to revalue all their assets, so we deleted their existing fixed assets data and re-imported all the assets with the new amounts and depreciation details. They were happy with the results, and have not run into any issues.
-Victoria
LikeLike
Hi Victoria,
When creating a new book, it means changing the cost and the original life? I mean, can we create a new book and make the net book value as the new asset cost and the remaining life as the new original life?
Jack
LikeLike
Hi Jack,
I am not sure that’s possible in a new book, you might have to create new assets to accomplish something like that. Do some testing on this outside of your production system. Is that what your accountants are advising you to do? Sounds a little strange to make the net book value the new asset cost, that’s not typically how I see assets treated.
-Victoria
LikeLike
Hi Victoria,
I’m trying to understand how an Asset’s cost basis gets adjusted after you add a purchase through AP in GP10. The acquisition cost updates fine but how do you get the cost basis to reflect this new value? I know you can manually override the value (and select the appropriate depreciation method) but with 800+ assets that’s a little hard to do.
Thanks for your help,
Thomas
LikeLike
Thomas,
I am not aware of any way to do this that’s not manual, as Fixed Assets would need to recalculate depreciation for each asset when you do this and there is no automated process for this. The only other option may be to delete existing assets and import new ones.
-Victoria
LikeLike
Fixed asset retirement question…
We have an asset that was posted 10 years ago with the suffix field left blank. We are now trying to retire it but it will not allow us to. For some reason it does not like the fact there is a zero or a blank in the suffix field. Is there any way to get around this so we can retire the asset?
LikeLike
Hi Erik,
I have not run into this before…if you suspect that this is the issue, you may need to go into the tables and add the suffix in there. I don’t believe there will be too many tables with the suffix id, you can find them all using this post.
-Victoria
LikeLike
Hi Victoria,
I have a stored proc retrieving FA data into a Crystal Report. I would like to see all assets that have been added to GP until the end of 2011. The report included new assets that I added in January 2012. When I checked the FA00902 table the FAYEAR for the assets was 2011 and FAPERIOD was 12. What exactly are FAYEAR and FAPERIOD?
Thanks.
Saras
LikeLike
Hi Saras,
FAYEAR is the Fixed Assets year and FAPERIOD is the Fixed Assets period. Is the fiscal year for this company the same as the calendar year? What exactly are you filtering on when you are checking for the date?
-Victoria
LikeLike
Hi Victoria,
Yes the fiscal year for the company is the same as the calendar year. I am filtering based on FAYEAR and FAPERIOD. I assumed that both the fields were actually Acquisition Year and Acquisition Period. If user created the asset with acquisition date DEC 2011, does the system create the asset with FAADD in table FA00902 with FAYEAR 2011 and FAPERIOD 12? If user later changes the Acquisition Date to JAN 2012, does the FAYEAR and FAPERIOD remain as before or does it change to the new acquisition date? Or does it come under FACHG? I guess I better test this scenario first before I trouble you further. Will update you soon.
Thanks,
Saras
LikeLike
Hi Saras,
I would recommend using the acquisition date (ACQDATE) from the FA00100 table or the place in service date (PLINSERVDATE) from the FA00200 table.
-Victoria
LikeLike
Can I set GP to automatically assign the Asset ID?
LikeLike
John,
Do you mean can it automatically auto-increment (ie, last one was 10052, automatically use 10053 for the next new asset created)? If so, then no, not out-of-the-box. If you mean something else, can you please elaborate?
-Victoria
LikeLike
Hi Victoria,
I am using GP 10 and have noticed something odd happening to a handful of our fixed assets. Occasionally when depreciation is ran, a FAADD transaction will show up in the clearing account related to an asset that is already in the FA Module. The transaction credits the clearing account and debits the equipment account. Do you know what would be causing this to happen?
Thank you,
Kelly
LikeLike
Hi Kelly,
I have not seen this happen before, but I would check the account numbers set up for the assets this is happening to, I would suspect they are not correct from what you are describing.
-Victoria
LikeLike
Victoria, can we use the Fixed Asset tables in SmartList Builder? I tried going to Tools – Resource Descriptions but I can’t seem to find the Fixed Asset tables?
LikeLike
Sue,
Yes, you can use any tables you have in SQL in SmartList Builder. Fixed Assets tables will be listed under the Fixed Assets product in Resource Descriptions – you are probably looking for it in the Microsoft Dynamics GP product? You might also find my Fixed Assets Tables page helpful. And I have some Fixed Assets views published – you can see the list on my GP Reports page.
-Victoria
LikeLike
Hi Victoria:
Can we change the Asset type from New to Owned, and Used to Deferred
ASSETTYPE (Asset Type):
1 – New
2 – Used
3 – Leased
LikeLike
Alan,
For what purpose?
-Victoria
LikeLike
Hello Victoria:
Currently we maintain Capital Lease and Deferred Lease into two different GL accounts, if were able to track these at the Asset Type level, then we can utilize only one GL account, and track at the Asset type level.
Alan
LikeLike
Alan,
If this is just for reporting purposes, I would recommend using one of the other fields on the asset, like structure or location or maybe one of the user defined fields. Changing a hard-coded field like asset type is something that I would typically advise against.
-Victoria
LikeLike
Many thanks for the advise.
Alan
LikeLike
Hi Victoria-
So glad I landed on your blog. I’m hoping that you can help me out with a problem I’m running into. I’ve searched and don’t think anyone has asked this yet.
We are attempting to reconcile our tax depreciation information in GP with that of our tax prep people, so that we can make use of GP for reporting tax depreciation in the future. The initial problem was that all of the tax depreciation tables (excluding our GL Book) were incorrect. These tables have since been deleted, and now I am attempting to re-import these tax books. The problem here is that this information includes special depreciation, 179 cost adjustments and misc. cost adjustments, which triggers the recalc screen.
Initially I thought that I could use the import feature to import the basic depreciation information, and then use a macro to enter the 179 and misc. cost adjustments. Unfortunately when I attempted that GP will not record the macro. Next, I tried using integration manager, which is giving me an error regarding different cost bases and not supporting depreciation recalc.
Aside from entering all of the tax information manually for the three different depreciation books, I’m at a loss for what to do next. Any input would be greatly appreciated.
Thanks – Ian
LikeLike
Ian,
I always prefer to use the Fixed Assets import over other tools for importing FA information and have not had issues with it. But I have also not done what you’re describing before. I would recommend posting your question on the GP Community Forum to see if you can get some responses from others that have run into a similar issue.
-Victoria
LikeLike
Hi Victoria,
I am trying to import FA into GP using the FA Import utility. But I understand that Setup info cannot be imported. I have a set of 220 Account Groups and 220 Asset Classes to be setup before running the import. Is there a simpler way (other than keying in) to setup Account Groups and Classes?
By the way, this site is a great help to all of us.
Regards,
Saras
LikeLike
Saras,
You could possibly import this directly into the tables or set up a macro to do this, but I have not done either, so I would not be able to give you any specific information.
-Victoria
LikeLike
dear Saras,
i just did it yesterday by Macro, i uploaded about 300 account groups and 300 asset classes, and book calss setup, all of them done by macro.
LikeLike
Hi Victoria,
May be you can help me figure out this problem. i am trying to take on assets and balance the asset cost, depreciation and accumulated depreciation figure to GL that. What is happening is that, Asset cost, depreciation and accumulated deprciation figures already exist in the GL. These figures have been posted to GL manually over the past year. We want to make use of GP FA. Let me tell you how i have approached it.
1:- I checked the figures of the asset cost, depreciation and acc depreciation in GL and balance it to an excel document that was used to maintain the fixed asset register.
2:- I then Cleared out the FA cost only into a clearing account.
3:- I took on the assets into GP. After take on, I manually caputred the LTD and YTD amounts in the Asset Book window.
4:- I then run the GL posting and posted the batch. When i check the batch,GP has calculated deprciation for one month. The deprciated to date i used was 27/02/2011.
What i want to know is that, why is GP deprciating for an extra one month? Does the take on date really matters? Because i tried testing this in March.
Thanks for your assistance in advance.
LikeLike
FEK,
Is February 27th the end of your month? Not the 28th?
-Victoria
LikeLike
Hi Victoria,
The finacial period is set up just like the retail calendar (4-5-4-4-5)weeks. So, Feb begins on 24/01/2011 and ends 27/02/2011. The 28th of Feb is the begining of March (another period). The averaging convention used is Full period and Depreciation period in the book set up window is Daily.
LikeLike
FEK,
Is that how the Fixed Assets Calendar is set up, as well? Fixed Assets has its own calendar that has to be explicitly set up, otherwise, I believe it defaults to the calendar year.
-Victoria
LikeLike
Hi Victoria:
You are such a GURU that I thought I’d run this by you. We are currently testing fixed assets in one of the training companies and would like to delete the test fixed asset records. Can I purge the fixed asset records? I see you have the commonly used FA tables listed here and that helps alot. Do you have scripts for all the tables to perform this delete if this function is possible? Thanks!
LikeLike
I should also add that we do not want to use “Clear Data” for this will only work for certain “status” types of assets e.g discontinue, inactive.. The assets we are trying to get rid of are active in the Test co. Additionally there are more that 2K of them (version GP10).
LikeLike
Teresa,
I do not have a script for something like this. You should be able to delete the data from the tables, but you do need to go through all the FA tables and determine what data they hold and whether they should be deleted.
-Victoria
LikeLike
Hi,
Victoria, I have a strange problem in Fixed Assets Module.
we uploaded all the assets and related information and once we run the Post to GL from routines nothing appears and after a while when I check it in Process Monitor I am seeing this status in the first line (missing) Fixed Assets:GL Posting(1) and second line (Missing) Fixed Assets: GL Posting Report(9)
LikeLike
Hi Arshad,
It is correct that nothing will appear when you click Continue on the Fixed Assets General Ledger Posting window. You should be able to click on the Progress button and see what is happening. There will be no message to indicate that it’s done, however the report destination window will come up when it’s ready. The Process Monitor should show 2 processes, like you mention, but I am concerned that it says “missing” in front of them. Mine say “>Fixed Assets…” I do not typically watch the Process Monitor, but the times that I have, I can’t recall seeing “missing” there, so I am not sure if it’s an issue. Does the process ever finish? If it does not finish and always says “missing” there may be an installation or setup issue and you may need to talk to your GP Partner or GP Support to get some help with this.
-Victoria
LikeLike
Hi Victoria,
We finally installed the Fixed Assets module and I am trying to figure out the import feature and am not having any luck. I never claimed to be the sharpest knife in the drawer. 🙂 However, the instruction manual seems rather vague to me.
I am not understanding how to create the macro to be able to import data from Excel. Do you have any suggestions/resources that offer more detailed instructions on how to create the macro?
Thanks in advance.
Regards,
Gordon
LikeLike
I should mention we are using version 8.00 of GPS.
LikeLike
Hi Gordon,
It’s not you, it’s not really made clear in the instructions, as least I didn’t think it was the first time I did it. The Fixed Assets Import process actually creates the macro for you and runs it, you just have to point it to your source data. What I typically do is create tab delimited text files from my Excel files, then use those as the source for the import.
-Victoria
LikeLike
OK, thanks Victoria, I will give it a shot and let you know how I make out.
Also, after I posted my question yesterday, I did a little research on the net and some people suggest that using Integration Manager is better. Any experience with that? We use IM.
LikeLike
Gordon,
I personally prefer the Import process inside GP, not IM, for Fixed Assets. I’ve used it a bunch of times with very good results. Also, IM may not be an option for you on GP 8.0….I believe that was added with the eConnect adapters which would have been version 10.0 (or 9.0 at the earliest) if I am remembering correctly.
-Victoria
LikeLike
Hi Victoria,
OK, macro has been created. When I go into the Asset Import/Export window, I set up the Import, then hit Continue, I get the message telling me that the import will be be performed and then it asks me to continue. I click on OK, then a window pops up saying that the Asset Import has been completed. There appears to be a “progress bar” that shows progress of 2/3 of the bar. I click OK. The window disappears and I am righ back to the Asset Import/Export window.
What is supposed to happen next?
Also, am I understanding this correctly when I say that two separate imports need to happen for GENERAL and BOOK, even though both tables contain the same data?
This is the most confusing thing I think I can recall in GPS in all my years.
Thanks and regards,
Gordon
LikeLike
Gordon,
How many assets are in your file? Have you checked to see if they are actually created? Yes, you will need 2 separate imports. GENERAL and BOOK. These will use two different files with subsets of your data, not the same file.
There are some pretty detailed instructions on how to prepare the files in the Fixed Assets manual. Are you following those? While not brain surgery, I would not call this an easy thing to do and if the module setup is not performed correctly, the import will not work. If the data is not formatted how the import process is expecting it to be, the import will not work. Unfortunately, if it does not work, often you do not get any messages as to why. 😦
Do you have a GP Partner that can help you with questions? Maybe you can get them to help get you to a working sample, then you should be able to take over?
-Victoria
LikeLike
Hi Victoria,
I have about 4 dozen assets.
I have followed the instructions from the manual (or at least I thought I did) and like you said, not brain surgery, but not exactly a walk in the park either.
I have contacted our GP Partner and we’ll see what they say.
Thanks.
Gordon
LikeLike
Victoria,
I’ve had a breakthrough. It almost worked. I am testing it on just one asset and I got the following message:
Field on Window is Inactive or Disabled. (Line #22)
It then brings me to the Acquisition Date field and if I try to tab out of that field it then pops up a window telling me to ‘Please check and reenter the date’. Could it be the upload .txt file date field is not formatted properly? I’ve noticed that the date changes on the upload txt file from DD/MM/YY to D/MM/YYYY.
Ever see that before?
LikeLike
Gordon,
Yes, I would check 2 things:
1. The regional settings on the computer where you are running this – the short date should be MM/DD/YYYY (or DD/MM/YYYY if that is what your GP is using).
2. Verify that the dates in your source files are all using this same format.
-Victoria
LikeLike
Hi Gordon/Victoria,
I like yourself at one point am new to using the GP fixed asset module. I have successfully uploaded a couple asset groups but am now getting the same error msg you got “Field on window is inactive or disabled (Line 24)” not 22 like yours read. How did you fix this problem and how can you figure out what line 24 is ? We are using the correct date formats and have edited our excel sheets in a custom format of ‘0#######’ which would come out as 01012010 for example. Any suggestions on how to fix this error or to find out what field is producing the error? Thank you
LikeLike
Adam,
If line 22 is the acquisition date, then line 24 is most likely the acquisition cost – check the format of your dollar amounts. If that does not help, since you have already had successful imports, compare all the fields and formatting between the ones that imported and the ones that are not importing to see what is different.
-Victoria
LikeLike
Hi victoria,
i have set up the fixed asset module and wanted to try depreciating assets. it is giving me the following error ” Error message 30900274 not in 3rd party error message master”. Do you know why i am getting the abover error?
Thanks in advance for your assistance.
LikeLike
FEK,
It looks like KB Article 939282 can help you fix this.
-Victoria
LikeLike
Victoria,
I wuld like your opinion.
I need to add a few custom fields to the Fixed Assets tables to track vehicle information such as VIN, Make, Model, License Plate, etc.
What is the best way to accomplish this?
Is it better to use the Extender Program or to do custom programing in VB or Dexterity?
I would need to run smartlists and possibly reports off these additional fields.
Thank you in advance for your thoughts
LikeLike
Hi Jeff,
Have you ruled out using the User Data fields in the Fixed Assets module? If so, I would go with Extender. Either way you will most likely need to create custom SmartLists using SmartList Builder, but I think if Extender can do the job, there is no need to re-invent the wheel.
Just to address all your questions – I would not recommend adding fields to existing tables. This is not only not supported but can get you into a big mess if you ever want to upgrade GP versions or even apply a service pack. You either use existing fields, use Extender, or add your own tables.
-Victoria
LikeLike
Hi Victoria,
I am using Fixed Assets Import/Export Utility to migrate Fixed Assets General and Book data into GP 10. Everything was working fine until I hit an error where there was a duplicate Asset ID. So I cleared the data and put in the correct Asset ID in the data file. I tried to import again. Now I hit the error “Duplicate Asset ID and Suffix”. Even if I try keyin in a new Asset ID, I get the same error message. I checked the tables, there is nothing there. Even the FAINDEX table is clear. What could the problem be?
Thanks in advance.
Saras
LikeLike
Saras,
Assuming you don’t have any customizations or modifications that are causing this, there must still be a table somewhere that has data. You can use the search method in this blog post to look for all tables with a column called ASSETID: https://victoriayudin.com/2010/04/23/how-to-find-all-sql-tables-with-a-column-name/.
-Victoria
LikeLike
Thanks a lot Victoria. I didnt realize that there were customized tables that were storing the data (done by another colleague). Once I cleared the data from these tables I was able to continue my import.
Thanks again for the very prompt reply. It saved me a lot of time and headache!!!!
LikeLike
Hi Victoria: I am a long time fan of your site, and thank you for your on-going help to those who need some assistance.
I have a basic question re: Fixed Assets. That is, when I enter a new asset directly into the Asset General Information window, the ‘Asset Account’ gets Debited and the ‘Clearing trigger Account’ gets Credited. This Credit account would not be correct, and should be changed to some other Credit account. My question is, Which account should be Credited?
Thanks for your help, as always.
LikeLike
Deesam,
Can you please clarify your question? Are you saying the Clearing Account that is automatically populated is wrong and asking where to change the default? Or something else?
Thanks,
-Victoria
LikeLike
Hi Victoria,
I’ve committed the cardinal sin of changing the ‘cost basis’ of an asset and now my FATRX journal (which includes a number of other asset additions and respective depreciation) will not post!!
I’ve now retired the asset but it still says complains about account missing when attempting GL posting.
Please help!!!
LikeLike
Kash,
An account missing on a GL transaction is not caused by changing the cost basis or retiring an asset. This is most likely looking for an account that was missing all along on the asset setup. You have not seen the issue before because the regular depreciation entry didn’t need all the same accounts that are now needed. At this point, you can open the GL transaction, fill in the missing account and post the transaction.
-Victoria
LikeLike
Hi Victoria!
Since you normally use the Macro to import new records into FA – which I do as well. I’m curious how you handle bringing in assets that have had Special Depreciation Allowance (such as the 30 or 50%) taken when placed in service. If you populate these fields it triggers the “Depreciation Sensitive” field prompt. Which in turns, stops the macro.
In the past I have just imported the Asset Value as net of the special amount , but really, this is leaving out valuable information for tax purposes.
Thanks for your insight. Website is terrific.
Catherine
LikeLike
Hi Catherine,
Thanks for the kind words!
It’s been a while since this need came up. I believe what I have done in the past is simply use the correct YTD and LTD depreciation and not use the Special Depr Allowance fields. Using the Straight-Line Rem Life Depreciation Method should then result in the correct future depreciation calculations. I would not recommend changing the Cost Basis, as that needs to match up to what is in the GL for the total asset cost.
Hope that helps,
-Victoria
LikeLike
Thanks Victoria. You’re right, I actually add the “special” amounts to the LTD depreciation rather than adjust cost. Usually this is only for the Tax books.
You bring up an interesting point though, what is the primary use of SL Remaining in regards to assets for Book or Internal use? On setups for new assets, I always use SL Orig for the Internal Book. I thought the SL Rem was used for switch in regards to Tax books, when you begin with one method such as 200DB and then towards the end of life, switch to SL Rem.
LikeLike
Catherine,
I would have to do some testing on this to double check…not sure if you already have…but here are the formulas from the documentation:
In this case, if you’re not populating the Special Depreciation Allowance, I am not sure if the Straight-line Orig Life method will result in the correct calculation… Please let me know if you have tested this and it works correctly.
-Victoria
LikeLike
Victoria,
Just wanted to update you on how this implementation/integration turned out.
I was able to import all the historic information for the asset, including the spec dpr %’s and amounts taken. I also tested the two SL methods and noticed no difference in the calculation, so I used SLO.
When I cleared all the tables and use the macro to bring in the data, no Depr Sensitive Fields warnings are triggered. If you use the macro to bring in changes to the assets – then the warning is triggered. Makes sense really.
Thanks again – you add much to the community.
Catherine
LikeLike
Hi Victoria,
I am a big fan of your Blogs.
I am having an issue with retirement of assets.
After I retire an asset the asset still has a Net Book Value.
I thought that after retirement the asset has to have a Net Book Value of 0.
Do you have any insight into what would cause this result.
LikeLike
Hi Jeff,
Thanks for being a fan!
The 2 typical things that would leave a net book value after retirement are having a Salvage Value set up for the Asset Book or not having retired 100% of the asset. Are either of those the case? If not, then you really would need to examine all the settings for this asset to see what happened. Possibly reverse the retirement and re-do it to confirm all the right options are being chosen?
-Victoria
LikeLike
Hi Victoria
GP 9 SP4
Please assist.
I recently recalculated the Life of an assets. I changed the Life from 9 years to 11 years. I selected the option to recalculate YEAR. Enquiry – Financial details reflects that depreciation was recalculated for the current year only. Except that the YTD and NBV value reflect that GP has re-calculated using Life.
For example: Cost of the Asset as 31/03/09 = 7658.00 Acc Depr = 6807.12 and NBV = 850.88 Original Life years of the asset 9 years (straight line method and daily depreciation) YTD Depr = 850.88
Cost of the Asset as 31/03/10 = 7658.00 Acc Depr = 7658.00 and NBV =0.00 Original Life years of the asset 9 years (straight line method and daily depreciation)
I then changed the life of the asset to 11 years, recalculating YEAR only. YTD = 696.18 and NBV = 154.7
I would have thought that the new YTD amount should be 283.63 (NBV @31/03/09 DIVIDED by 36 months) and that the YTD for prior years would not have changed.
Is there something that I am missing?
LikeLike
NG,
This is not something I can easily answer without additional testing. I would recommend posting your question on one of the GP forums, or, if it’s more urgent, starting a support case with GP Support.
-Victoria
LikeLike
Hi Victoria
thank you for replying.
I have found the cause. The depreciation method is set to straight line – original life instead of straight line -remaining life. I will change the depreciation method. thank you again.
LikeLike
Hi NG,
Thanks for letting me know what the resolution was!
-Victoria
LikeLike
Hi Victoria,
I was happy to finally find this site, as I am finding VERY LITTLE useful information on GP Fixed Assets. So I’m hoping maybe you can give some insite on a problem I’m having. I’m importing asset data into GP 9.0 from an old Access database application. We imported data as of Period 6 in our Fiscal Year 2010. I was able to get the depreciation amounts to match between the old system and the imported data in GP as of Period 6. In the FA00902 table, there are data records for Period 12/2009 and Period 6/2010. In Period 7, we retired assets in both systems and GP is generating depreciation in periods 1-6 for assets that are NOT Straight-Line and have an averaging convention of HY (Half-year), however this is NOT happening in the old application. (we are running parallel.) Any idea why this is happening in GP? Is it possibly because there were no Period 1-5 records in FA00902 for these assets?
Thanks for any help you can give.
LikeLike
Dawn,
Unfortunately, it very difficult to answer your question without actually seeing the data, especially with an import involved. In general I don’t recommend importing mid-year, as typically that makes monthly reporting on assets impossible. It may also be what is causing an issue here.
If you have a test company set up, I would test entering one asset in the same way that yours are set up and depreciated and another with monthly 2010 depreciation, retire them both and see if there is any difference. Also I would test retiring with different dates to see the impact that it has – the retirement date takes into consideration your averaging convention and may not always do what you think it will.
-Victoria
LikeLike
Hi
I am having trouble retiring assets, I cant seem to post to the GL.
I dont know what I am doing wrong.
I retired the assets, went to gl posting but it comes out blank…
??
LikeLike
Daniela,
Sometimes the retirement will not show up in the period you are expecting. I would try (a) seeing if there are transactions waiting to go to the GL by checking the Financial Detail Inquiry for the asset (Inquiry > Fixed Assets > Financial Detail) or (b) re-running the Fixed Assets GL Posting and choosing 0000-000 for the beginning period. Hope that helps.
-Victoria
LikeLike
Thank you!!!
Yes, it was a different period, I had tried 0000-000 and current date, the problem was it was using period 7!
I was able to see it from the financial detail window.
Thank you so much!
LikeLike
I am having the same issue as Daniela,
GP seems to insist on waiting until the half year is over. Is there a way to change this so it retires in the month intended?
Thanks
LikeLike
Hi Victoria,
I have tried to move FA data from one company to anoter.
The easiest way for this is to copy all FA SQL tables to the new company after setup was run on it.
Depreciation still works and GL interface is 100%.
This was done with no POP or PM integration.
However, when attempting the same steps when there is PM or POP integration in the company you are copying the data from, then it does not work. You cannot add any more assets.
Do you know of a solution?
Regards
Neil
LikeLike
Neil,
Without knowing all the details of what you’re copying and how you are doing it, it’s not possible to truly comment on this. My gut reaction is that copying the data in the FA tables would only work in a very specific set of circumstances, and I am not sure I would do this as a general practice.
That said, the PM and POP settings for Fixed Assets are determined by what is selected on the Fixed Asset Company Setup window (Tools > Setup > Fixed Assets > Company). I recommend taking a look at the settings there and changing them as needed. Also, when you say ‘you cannot add any more assets’, what does that mean? Are you getting an error? If purchases are simply not being recognized as assets, then you will want to check the settings for your FA clearing account – in the SQL tables the GL account will be saved as an account index – so if the account index is not the same in the companies you’re copying to and from, this will be an issue that needs to be corrected manually.
-Victoria
LikeLike
Hi, Victoria.
We are inplementing FA. Colud you help me to understand what mean’s property type selection?. In other words, what is de difference between personal and real type? Is this a classification type for depretiation purposes?. Really Do it have an important effect in FA process?
Thanks,
M.Martin
LikeLike
Hi M.Martin,
The Property Type is informational only and does not impact any functionality. So if you need to you could use it for grouping/reporting purposes, but otherwise it really does not matter what you put in there.
-Victoria
LikeLike
Hi Victoria,
I have a doubt in FA,
if i have a asset which is depreciated for 11 months (Life is 12 months), and i dont want to depreciate the last month(12th month), and avoid it in next month depreciation process….
Is it possible ?
if not then what options do i have to close this asset.
Thanks….
LikeLike
Hi Akram,
Why not retire this asset?
-Victoria
LikeLike
A user accidentially closed the year in FA for 2010, 2011, and 2012. Is there away to undo the FA year end close?
There has been no activity (additions, changes, transfers, retirements, or depreciation) for the new year 2010.
I did reset the year back to 2010 in the Book setup window – but the user is saying he cannot run depreciation now. Any thoughts?
thank you
LikeLike
Glenn,
I can tell you that there is no way to undo a year end close in the user interface. I suspect there is a way to ‘fix’ this directly in the tables, but it might be fairly involved and I have not run into this before, so to be safe and get the correct solution I would recommend starting a support incident with Dynamics GP support on this.
-Victoria
LikeLike
Victoria, I am working on some reports in SQL for Fixed Assets. I was wondering if you knew a bit about the FA00700 (Retirements) Table and how that is populated. It seems like a partial (and full) retirements get written to this table and then written back to the FA00100 Table with the same assetid and a new suffix with a ‘status’ of 4.
The FA00100 table store the ‘acquisition_cost’ of the retirement and the FA00700 stores the “PARTIALCOST.” I have some cases where the PARTIALCOST is coming up with 0.00 in the FA00700 table, and when I try to query the “Retirements” for a certain date range, I find that I then need to link back to the FA00100 Table to get that acquisition_cost, linking on FA00100.ASSETINDEX = FA00700.ASSETINDXAFTRET.
Does this sound like a bug or is this FA00700 not a trustworthy table? I don’t see any decent Checklinks or Reconcile that would compare the 2. I hope this makes sense, or at lease you can tell me why I should not be linking back to the FA00100 table for my retirement amount.
LikeLike
Kevin,
You don’t mention what version or service pack of GP you’re on, however, in general, I have not seen any issues with the FA00700 table. I have also not done a ton of reporting off the FA00700 table, but just did a little testing and looked at the data added to the tables. The PARTIALCOST field in the FA00700 table is holding what is entered in the Cost field on the Retirement Maintenance window when you partially retire an asset. Mark Polino has a great explanation of a partial retirement here: http://msdynamicsgp.blogspot.com/2009/10/weekly-review-putting-fix-in-fixed.html). I believe a partial retirement is the only time a new fixed asset will be created during the retirement process. For all other retirements, there will be no new asset and the original asset will have it’s status updated to 4.
To get the acquisition cost of any asset you should always link back to the FA00100 table, as it is not stored in the FA00700 table for anything other than partial retirements based on cost. Linking on FA00100.ASSETINDEX = FA00700.ASSETINDXAFTRET looks right to me. For non-partially retired assets the FA00700.ASSETINDEX will be the same as the FA00700.ASSETINDXAFTRET.
Hopefully this helps.
-Victoria
LikeLike
Hi Victoria,
I want to know how to import FA through import/export utility.
Can you send me a sample of the macro – as it is shown in notepad – to use in impoting?
I mean how the macro will take the data from a *.csv document and paste them into FA general information window?
I have all the data ready for importing and I know how to record amacro in other window, but I failed especially in importing FA as I do it for the 1st time!
Please help.
LikeLike
Yassir,
The macro gets created when you use the import utility and is not something I can send you. If the import is failing, it is most likely due to your import file not conforming to the specifications required. Check the documentation and your file carefully for any discrepancies.
-Victoria
LikeLike
hi Victoria Yudin,
I want to know the accounts effected in fixed assets module.To which table i need to refer.
Is there any flow in fixed assets like purchase order processing and sales orer processing..
If so can u share the link are any stuff which i can understand
LikeLike
Raghu,
The accounts set up for each asset are stored in the FA00400 table. I am not sure what you mean by the ‘flow’ question. If you mean workflow, then no, I do not believe there is a workflow for Fixed Assets currently.
-Victoria
LikeLike
Greeting Victoria,
I recently reformatted my PC and reinstalled the GP10 including the FA Module. After that, I reimported all customizations (backed up before reformatting) including FA reports customizations. And then I selected the modified windows/reports in the User Security.
I have problems on Fixed Assets Module. When I try to print the Fixed Assets Inventory List report nothing is printed (no data displayed on screen).
Is there any setting I have to set up first so I can print the fixed assets inventory report?
Everything worked well except the Fixed Assets reports printing.
Please help
Thnx
LikeLike
Ernesto,
If you switch back to the unmodified report, is it working properly? Is it working properly on other computers?
-Victoria
LikeLike
Gud day Victoria,
I switched back to the unmodified report and still not working.
It’s working on other computers.
By the way, the OS I installed after reformatting my PC is Windows 7 but I guess there’s no compatibility issue here because the GP10 and other modules are working properly.
LikeLike
Hi Ernesto,
Are all Fixed Assets reports not working on this particular computer? What about other reports from other modules? When you said you ‘re imported all customizations’ what exactly do you mean by this, what is the process for reimporting them that you went though?
The only things we have run into issues with for Windows 7 and Vista is that it is more important to install GP while logged in as the local administrator than it used to be for prior operating systems. Not sure if that is an issue in this case.
-Victoria
LikeLike
Yes Victoria, all FA reports are not working but reports on other modules are all working.
Before I reformatted my PC I exported all customizations to a package file (Microsoft Dynamics GP >> Tools >> Customize >> Customization Maintenance).
After reformatting and installing the GP10 I imported the package file (Microsoft Dynamics GP >> Tools >> Customize >> Customization Maintenance).
After that I set access to the modified windows/reports in the User Security (Microsoft Dynamics GP >> Tools >> Setup >> System >> Alternate/Modified Forms and Reports)
I’m not sure if I was logged in as administrator when I installed the GP. But if I wasn’t, the whole GP system should not be working. But in this case, on the FA reports are not working. I checked the FA records under Cards menu and the records are all there. But when I generate any FA report nothing is printed.
LikeLike
Ernesto,
So your modified Fixed Assets reports are stored in a local reports dictionary on each computer? And your dynamics.set file is pointing to a local Fixed Assets reports dictionary? (This is the line ending with R309.DIC in the dynamics.set file.)
The fact that the unmodified reports do not work either would imply that particular reports dictionary is having an issue. I would try deleting the R309.DIC file on your computer (after making a backup, of course).
So: close GP, backup R309.DIC file, delete it, open GP, make sure you’re pointing to unmodified Fixed Assets reports, run a Fixed Assets report. What happens?
Just to quickly address your last point, if GP was not installed with the right permissions, that does not mean the whole application wouldn’t work. I have absolutely seen certain functionality not work correctly, most notably exporting from SmartList.
-Victoria
LikeLike
Thanks for addressing my last point Victoria.
I tried the procedure: Closed the GP, backed up R309.dic to my Desktop and delete it from GP Data folder.
I opened the GP, set the User security and run the reports. It trigerred an error message, something like “The Dictionary is not loaded”.
Can I copy the Dynamic.set file from a computer where the FA reports are working and replace the Dynamic.set file in my PC? Of course, I have to back up the file first.
LikeLike
Ernesto,
Yes, you can certainly try copying from a working computer. Please let me know how that goes.
-Victoria
LikeLike
Hi Victoria,
I downgraded my OS back to windows xp pro sp3. I haven’t found any solution to the problem.
Anyway, tnx for the effort to help me.
Wish you all the best.
LikeLike
Hi Victoria,
I solve my problem on Fixed Assets reporting.
The culprit was on the unicode language settings.
Since we are in the middle east i just change the language to Arabic and the Fixed Assets report worked.
LikeLike
I have a situation where after importing FA Asset General and Book info into a test company and then attempting to do same against LIVE company encounter the following error:
ERROR: Microsoft.Dynamics.GP.eConnect: Number = 8692 Stored Procedure taCreateAssetID : Description = The UpdateIfExists parameter is set to 0 and you are attempting to integrate a record that already exists in the FA00100 table
A query of FA00100 retrurns only the one “dummy” asset record as required before importing additional records
The test company was created using a backup from the LIVE company with the same “dummy” record
Any ideas?
Thank you
LikeLike
Michael,
I don’t have too much experience using the eConnect adapter to import Fixed Assets. I typically use the ‘old’ macro method built into the Fixed Assets module. I would recommend posting this on the partner and/or public newsgroups to see if you can find someone that has some more experience with this.
-Victoria
LikeLike
I have a problem i deleted a batch and i need recovery batch, how can i recover a batch that i deleted?
LikeLike
Marco,
It’s typically impossible to recover a batch without restoring from a backup. Which may not be possible because you’d lose all the work done in the meantime. Depending on the type of transactions in the batch that was deleted and the volume, the methods for getting the data back may differ and there may be various options depending on the desired results and reporting detail / drill-back functionality needed. I would recommend working with your GP partner to help get back the data that was deleted.
-Victoria
LikeLike
Hi Marco,
Just to double check, was it a Fixed Assets batch that got deleted?
If the FATRX batch had been deleted in GP Frontend, there is a script that will allow you to delete the FATRX batch information from the Fixed Assets side and then you can re-run the FA GL Posting Routine once again.
You may want to check with your GP partner’s support team for assistance or even Microsoft as well for the script.
But, of course as Victoria mentioned, nothing beats a backup.
Thanks.
Eric
LikeLike
Hi Victoria,
Do you know how to run a FA report and run depreciation through a certain depreciated to date? I cannot find a filter for this anywhere in the reports!
For example, if I can’t seem to get depreciation numbers for July 2008 if I wanted to go back.
Thank you,
Daniel
LikeLike
Daniel,
I don’t think there are any reports out-of-the-box that will do that. You’d need to create your own report if you wanted to see that which will either add up all the depreciation through the date you want or take the current depreciation and back out what’s happened between your date and the ‘depreciated to’ date.
-Victoria
LikeLike
What could be the reason why some assets generate negative depreciation? These assets are not even fully depreciated. Going to their Asset Book info you can see incoherent figures. Current Depreciation expansion shows zero amount while LTD Depreciation expansion doesn’t give breakdown per period of the LTD Depreciation amount.
LikeLike
Herson,
Sounds like something has gone wrong. What was done before this happened? If this is only for some assets, what do they have in common? Does going to Inquiry > Fixed Assets > Financial Detail give you any additional information? Are there any customizations or 3rd party products that could be interacting with Fixed Assets? What you’re describing is certainly not typical, but without looking at all the details and the setup, it is very difficult to diagnose something like this. If you don’t have anyone internally with Fixed Assets experience that can look at this in depth, you might want to talk to GP Support to see if they can help you sort this out. I would also recommend posting questions like this on the Microsoft GP Newsgroup perhaps someone else has seen this kind of behavior before and can let you know what their resolution was.
LikeLike
An update on this – JB sent me some screen shots so we could get to the bottom of this. The issue was that the Account Group ID was not staying selected in the window, so it would change the GL account numbers as needed, but then would clear the Account Group ID itself. This is unique to Fixed Assets and happens pretty much everywhere you see the Account Group ID, so it was all behaving as expected.
–Victoria
LikeLike
Hi Victoria
I have attempted in Fabrikam as well.. Is there an email address were I can send you a screenprint? The G/L Account column just does not get populated with the accounts.
Expand Transfer window
——————————————————————————–
Transactions >> Fixed Assets >> Transfer >> enter or select an asset ID >> G/L Accounts expansion button
Use the Expand Transfer window to view the account numbers currently assigned to the asset being transferred. You also can change the accounts, if necessary, when an asset is being transferred.
Related item:
Transferring asset record information
LikeLike
JB,
Does the same thing happen in Fabrikam? Do you have any ISV products or customizations installed? If so, can you disable them to see if you get different behavior?
My direct e-mail is under Links over on the right side of the screen – just click on Victoria Yudin’s e-mail – or click here.
–Victoria
LikeLike
HI Victoria.
You are correct. It is the account Group. When I select the Account Group – the accounts do not get popuplated. The Account Group does exist and is setup (you can view the accounts associated with the account group as well). The only glitch is that once you select the Account Group – the accounts do not populate the Transfer Screen.. We are Using GP 10.0 and just upgraded to SP3. Please assist.
LikeLike
JB,
Can you duplicate this in the Fabrikam company? Do you see the same issue there or does it work as expected?
–Victoria
LikeLike
We are having a problem with the Fixed Asset Asset Transfer Function under Financial>Fixed Assets>Transfer. When you enter the assetID,and select the asset class, the account’s do not get populated. It stays blank. Do we know if there is a fix for this?
Thank you Victoria.
LikeLike
JB,
Just to make sure we’re on the same page…where do you fill in an Asset Class? I see an Account Group ID if I go into the Expand Transfer window (by clicking the blue arrow next to G/L Accounts). Is that what you mean? If you choose an Account Group and it doesn’t fill in any accounts, maybe that Account Group is not set up? To verify this, if you click on the hyperlink for Account Group ID to go to the Account Group Setup window and bring up that Account Group, does it show account numbers populated? Also, what GP version are you on? I am testing this with GP 10.0 SP 3 and everything looks like it’s working correctly.
–Victoria
LikeLike
Mike,
I am very glad that helped! Brrrr…NJ is freeeezing today. 🙂
LikeLike
The issue is related to the Binary Stream Multi Facility Processing product. FA Lookup by Asset ID works if the MFP Customization Status is Disabled.
Thanks so much for the thoughts!
I’ll update my post in the newsgroup as well.
Warm regards from the Wet Coast (Seattle is cloudy and gloomy today).
LikeLike
I read Mike’s posting and have similar but different issue with integrating Fixed Asset. I attempted to use Integration Manager with GP 10.0 and it gave me this error “Microsoft.Dynamics.GP.eConnect: Number = 6625 Stored Procedure taCreateAssetID : Description = Unable to obtain the next FAINDEX”
Anyone has an idea of what I’m supposed to do?
Thank you
LikeLike
Helena,
This is why Mike mentioned the required ‘dummy’ record. You need to enter one Fixet Asset manually before importing assets using the eConnect adapter. KB Article 951768 discusses this.
-Victoria
LikeLike
Thank you Victoria !!
LikeLike
PERFECT DIAGNOSIS!!
LikeLike
Mike,
I am going to take a leap here and guess that you’re asking about this to follow up on the support thread you have going on the Microsoft Newsgroups? You originally said that you imported assets using a Macro, but now cannot do a lookup correctly by the Asset ID on the Asset General Information window. Please let me know if I am on the wrong track…
If this is why you are asking about the FAINDEX table, I do not believe the issue you’re experiencing with not being able to look up the Fixed Assets by Asset ID is related to the FAINDEX table not having values. I don’t have a way for you to rebuilt it, either, but I am just saying you may not want to spend your time on that, since it may not be the fix.
I do not have a GP 10.0 SP 2 to test with right now, so I am testing this on GP 9.0 SP 3. I just checked 2 different installations where I can correctly look up assets by Asset ID and they only have a handful of entries in the FAINDEX table for many more assets. As a further test, I deleted all the values in the FAINDEX table on one of these installations and I can still successfully look up assets by Asset ID in the Asset General Information window.
Is it possible to disable all customizations and 3rd party products and see if it’s still an issue? If you have the Fabrikam company to test with on this installation, is it also experiencing the same problem? I have to think that this is not a problem in general on GP 10.0 SP 2 or we’d be hearing a lot more about it.
– Victoria
LikeLike
I recently used a Word Macro to load Fixed Assets into a system using Binary Stream’s Multi Facility Processing software.
The FAINDEX did not get updated and now the Lookup By Asset ID will not function correctly.
Any clues about how to rebuild the FAINDEX? There is no CheckLinks for FA and the FA Reconcile does not rebuild the FAINDEX.
Thanks for the post on the asset-table value definitions.
Mike Lupro
LikeLike
You just delete the FAINDEX table and it automatically rebuilds.
The following Microsoft Dynamics Knowledge Base article may of interest to you.
ArticleID: 2581263.
Error Message ‘This record has been created since your attempt to create it. Changes won’t be saved.’ when adding an Account Group ID in Fixed Assets using Microsoft Dynamics GP
https://mbs2.microsoft.com/knowledgebase/KbDisplay.aspx?WTNTZSMNWUKNTMMYOYZUVNYUNLUZTWZSNLRSUNKQZWZYWVOZ
LikeLike