Commonly Used Tables:
FA00100 – Asset General Information Master
FA00200 – Book Master
FA00400 – Asset Account Master
FA00500 – Lease Master
FA00600 – Insurance Master
FA00902 – Financial Detail Master
FA01100 – FA-AP Posting Master – this is where Purchases from the clearing account are stored
FA01400 – Asset Purchase Master
FA19900 – User Data Master
FA40200 – Book Setup
FA41200 – Insurance Class Setup
FA41600 – Lease Company 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
Reporting Notes:
Most of the tables will use the Asset Index (ASSETINDEX), not the Asset ID, so link the tables on that.
SQL Code:
SQL view for Fixed Assets depreciation in Dynamics GP
–
Last Updated: Apr 7, 2010
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
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
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?
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
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
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
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
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
Can I set GP to automatically assign the Asset ID?
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
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
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
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?
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
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
Alan,
For what purpose?
-Victoria
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
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
Many thanks for the advise.
Alan
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
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
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
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
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.
FEK,
Is February 27th the end of your month? Not the 28th?
-Victoria
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.
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
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!
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).
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
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)
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
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
I should mention we are using version 8.00 of GPS.
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
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.
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
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
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
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
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?
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
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
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
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.
FEK,
It looks like KB Article 939282 can help you fix this.
-Victoria
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
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
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
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: http://victoriayudin.com/2010/04/23/how-to-find-all-sql-tables-with-a-column-name/.
-Victoria
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!!!!
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.
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
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!!!
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
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
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
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.
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
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
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.
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
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?
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
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.
Hi NG,
Thanks for letting me know what the resolution was!
-Victoria
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.
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
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…
??
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
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!
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
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
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
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
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
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….
Hi Akram,
Why not retire this asset?
-Victoria
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
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
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.
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
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.
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
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
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
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
Ernesto,
If you switch back to the unmodified report, is it working properly? Is it working properly on other computers?
-Victoria
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.
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
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.
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
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.
Ernesto,
Yes, you can certainly try copying from a working computer. Please let me know how that goes.
-Victoria
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.
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.
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
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
I have a problem i deleted a batch and i need recovery batch, how can i recover a batch that i deleted?
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
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
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
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
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.
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.
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
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
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
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.
JB,
Can you duplicate this in the Fabrikam company? Do you see the same issue there or does it work as expected?
–Victoria
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.
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
Mike,
I am very glad that helped! Brrrr…NJ is freeeezing today.
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).
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
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
Thank you Victoria !!
PERFECT DIAGNOSIS!!
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
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
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