Fixed Assets Tables


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
FA01100 – FA-AP Posting Master  – this is where Purchases from the clearing account are stored
FA01400 – Asset Purchase Master
FA01500 – FA Activity Master
FA19900 – User Data Master
FA40200 – Book Setup
FA40201 – Asset Class Setup
FA40203 – Book Setup (for Depreciation)
FA41100 – Location ID Setup
FA41200 – Insurance Class 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: June 25, 2014

186 Responses to “Fixed Assets Tables”

  1. 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?

    Like

  2. 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

    Like

    • 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

      Like

  3. 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!.

    Like

    • 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

      Like

  4. 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?

    Like

    • 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

      Like

      • Thanks for the quick reply. But sadly the FA01500 table is empty when I just checked it now.

        Like

        • I am guessing this was working previously? What has changed? Also, what if you choose Depreciate all assets instead of picking a group?

          -Victoria

          Like

          • 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.

            Like

            • 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

              Like

              • 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.

                Like

                • 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

                  Like

                  • 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.

                    Like

  5. 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.

    Like

    • 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:

      1. Make the change directly in the General Ledger for both the cost and the past depreciation. Since the accounts are now correct, future depreciation will be using the correct accounts.
      2. Use the transfer functionality (Transactions | Fixed Assets | Transfer). You may want to test this first in a test company to make sure this will accomplish what you want. Also, I am not sure how this will work if you have already changed the accounts on the Asset General Information window, so you may need to manually adjust these in the GL and wait to use this method for the future.

      -Victoria

      Like

  6. 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

    Like

    • 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.

      Like

  7. Hi, is there a table for the property type?

    Like

  8. 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.

    Like

  9. 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.

    Like

    • 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

      Like

      • The flag is set to “Y”

        Like

        • 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

          Like

          • I can backup and I can try and run from 0000-000. I am not sure if that will update depreciated to date however.

            Like

            • 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

              Like

              • 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.

                Like

  10. Can we have an Asset with Negative Acquisition Cost?

    Like

  11. 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?

    Like

    • 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

      Like

      • We have the column, and I have tried populating it and leaving it blank. Either way, we get the same error.

        Like

      • Also, the same file imports fine to my GP, but I’m using Fabrikam.

        Like

      • 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.

        Like

        • 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

          Like

          • 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.

            Like

            • Navin,

              When the window opens after this error, what field is it on?

              -Victoria

              Like

              • 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.

                Like

                • Any further input would really be appreciated. Can’t seem to move forward at this point.

                  Like

                • 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

                  Like

                  • 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.

                    Like

                    • 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

                      Like

                    • 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

                      Like

                    • 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

                      Like

  12. 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…

    Like

  13. 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

    Like

  14. 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

    Like

    • 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

      Like

      • 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

        Like

        • 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

          Like

          • 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

            Like

            • 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

              Like

  15. 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

    Like

    • 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

      Like

  16. 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?

    Like

    • 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

      Like

  17. 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

    Like

    • 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

      Like

      • 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

        Like

  18. Can I set GP to automatically assign the Asset ID?

    Like

    • 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

      Like

  19. 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

    Like

    • 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

      Like

  20. 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?

    Like

    • 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

      Like

  21. 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

    Like

  22. 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

    Like

    • 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

      Like

  23. 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

    Like

    • 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

      Like

    • 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.

      Like

  24. 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.

    Like

    • FEK,

      Is February 27th the end of your month? Not the 28th?

      -Victoria

      Like

      • 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.

        Like

        • 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

          Like

  25. 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!

    Like

    • 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).

      Like

      • 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

        Like

  26. 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)

    Like

    • 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

      Like

  27. 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

    Like

    • I should mention we are using version 8.00 of GPS.

      Like

      • 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

        Like

        • 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.

          Like

          • 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

            Like

            • 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

              Like

              • 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

                Like

                • 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

                  Like

                  • 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?

                    Like

                    • 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

                      Like

                    • 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

                      Like

                    • 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

                      Like

  28. 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.

    Like

  29. 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

    Like

    • 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

      Like

  30. 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

    Like

  31. 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.

    Like

    • 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

      Like

  32. 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!!!

    Like

    • 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

      Like

  33. 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

    Like

    • 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

      Like

      • 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.

        Like

        • 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:

          • Straight-line Orig Life: (Cost – Salvage Value – Special Depreciation Allowance) ÷ Original Life in Years
          • Straight-line Rem Life: (Cost – Salvage Value – (LTD Depreciation Amount – YTD Depreciation Amount)) ÷ Remaining Life in Days

          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

          Like

          • 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

            Like

    • 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.

      Like

      • 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

        Like

  34. 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?

    Like

    • 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

      Like

  35. 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.

    Like

    • 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

      Like

  36. 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…
    ??

    Like

    • 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

      Like

      • 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!

        Like

        • 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

          Like

  37. 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

    Like

    • 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

      Like

  38. 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

    Like

    • 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

      Like

  39. 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….

    Like

  40. 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

    Like

    • 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

      Like

  41. 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.

    Like

    • 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

      Like

  42. 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.

    Like

    • 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

      Like

  43. 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

    Like

    • 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

      Like

      • 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

        Like

        • Ernesto,

          If you switch back to the unmodified report, is it working properly? Is it working properly on other computers?

          -Victoria

          Like

          • 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.

            Like

            • 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

              Like

              • 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.

                Like

                • 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

                  Like

                  • 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.

                    Like

                    • Ernesto,

                      Yes, you can certainly try copying from a working computer. Please let me know how that goes.

                      -Victoria

                      Like

                    • 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.

                      Like

                    • 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.

                      Like

  44. 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

    Like

    • 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

      Like

  45. Marco Villanueva Reply June 1, 2009 at 4:12 pm

    I have a problem i deleted a batch and i need recovery batch, how can i recover a batch that i deleted?

    Like

    • 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

      Like

      • 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

        Like

  46. 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

    Like

    • 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

      Like

  47. 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.

    Like

    • 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.

      Like

  48. 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

    Like

  49. 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

    Like

    • 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

      Like

  50. 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.

    Like

  51. 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.

    Like

    • 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

      Like

  52. Mike,

    I am very glad that helped! Brrrr…NJ is freeeezing today. :-)

    Like

  53. 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).

    Like

    • 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

      Like

  54. PERFECT DIAGNOSIS!!

    Like

  55. 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

    Like

  56. 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

    Like

Trackbacks/Pingbacks

  1. SQL view for Fixed Assets depreciation in Dynamics GP - Victoria Yudin - April 7, 2010

    [...] depreciation amounts in Dynamics GP. For more detail on the Fixed Assets module, please visit my Fixed Assets Tables page. If you’re looking for more SQL code, you can find it on my GP Reports [...]

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 1,477 other followers

%d bloggers like this: