Return Code 17 Fixed Assets
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 We are currently testing fixed assets in one of the training companies and would like to delete the test fixed asset records. Reply Joseph Guyton Works For Elior North America in Jackson, MS My Badges Joseph Guyton responded on 4 Nov 2015 10:06 AM Hi Nathan, I'm getting the same error as the 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 contact form
LikeLike Navin Mirpuri Reply February 25, 2013 at 2:13 pm Any further input would really be appreciated. Just started working with new company who imported their Fixed Assets last year but there was a handful of assets that did not get imported into the Fixed Asset Ledger. 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. It happened that I had a problem with FA Calendar. https://support.microsoft.com/en-us/kb/2827044
LikeLike Victoria Yudin Reply January 10, 2013 at 5:44 am Fazil, This is most likely not a permissions issue. My educated guess it was the assets dates set to 2013.........no year end process and the book set to 2014 caused the issue. LikeLike Victoria Yudin Reply October 1, 2010 at 9:27 am Gordon, I personally prefer the Import process inside GP, not IM, for Fixed Assets. 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.
The acquisition cost updates fine but how do you get the cost basis to reflect this new value? LikeLike Victoria Yudin October 6, 2010 at 12:30 pm Gordon, Yes, I would check 2 things: 1. These figures have been posted to GL manually over the past year. Maybe someone else reading this will have some other ideas for you.
We selected the Build Quarters tab. Either way, we get the same error. I tried doing a recompile and update statistics and still no success. I didnt realize that there were customized tables that were storing the data (done by another colleague).
LikeLike Tony Reply March 6, 2013 at 12:16 pm Can we have an Asset with Negative Acquisition Cost? Once the calendar was rebuilt ( I let GP do every available year) the error 'return code 2 on FA_RETIRE_ASSET' did not reappear. This will probably be something that comes up more often as we start working with customers on GP 2013. -Victoria LikeLike Navin Mirpuri Reply February 22, 2013 at 9:46 am Hello, We noticed that the Quarter dates were empty - for the current year, and for other years - in Fixed Assets Calendar Setup -> Quarters.
- Is it possible we can make a SQL script to perform the job?
- Or you could ask Dynamics GP Support to see if they can answer this. -Victoria LikeLike Ben Reply December 24, 2013 at 10:58 am Victoria, When we run Depreciation on a
- After I retire an asset the asset still has a Net Book Value.
- You should backup the company database, and then try and rebuild the FA calendar.
- 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
- Please run the following script against the company database to check the record for the asset in the Asset Retirement Master (FA00700) and Asset Retirement Event Master (FA41700) tables.
- Please update me with your results.
Thank you, Kelly LikeLike Victoria Yudin Reply February 3, 2012 at 3:54 pm Hi Kelly, I have not seen this happen before, but I would check the account numbers set up Next, I tried using integration manager, which is giving me an error regarding different cost bases and not supporting depreciation recalc. LikeLike Pam Robertson Reply February 21, 2013 at 3:47 pm Also, the same file imports fine to my GP, but I'm using Fabrikam. Take a look at this forum post to see if the solution suggested will help you: https://community.dynamics.com/product/gp/f/32/p/29570/49969.aspx?wa=wsignin1.0 -Victoria LikeLike Fazil tk Reply January 10, 2013 at 6:12 am Thanks A Lot
At this point, you can open the GL transaction, fill in the missing account and post the transaction. -Victoria LikeLike Catherine Reply July 11, 2010 at 5:01 pm Hi Victoria! weblink LikeLike Victoria Yudin Reply December 28, 2016 at 7:12 am Good morning, Unfortunately, this is not possible without customizing every window involved. 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 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
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. Also, I think we may be starting to get into an area that would be considered billable consulting. Any input would be greatly appreciated. http://supportcanonprinter.com/return-code/eza1735i-std-return-code-27550-error-code-00002.html They are on GP2013 so the book can't be changed.
They depreciate the asset at the same rate each month, even after it has been fully depreciated. The deprciated to date i used was 27/02/2011. I really don't know how to resolve this.
As a side note, "utility providers must prepare a rate case any time they want to increase the rates they charge to the public.
I am not sure why FA is trying to use this date. 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. When she hit retire, she was asked for the code for the prior year adjustment - I am unsure whether she provided the code. 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. Because i tried testing this in March. Reply Nathan MacPherson Suggested Answer Nathan MacPherson responded on 4 Sep 2012 5:49 AM TRY THIS: This is most often cause by unsynchronized retire events. his comment is here I have contacted our GP Partner and we'll see what they say.
Regards, Gordon LikeLike Gordon Reply September 30, 2010 at 5:15 pm I should mention we are using version 8.00 of GPS. THEN: Thank you for those results! GENERAL and BOOK. Thank you LikeLike Victoria Yudin August 29, 2011 at 9:17 am Adam, If line 22 is the acquisition date, then line 24 is most likely the acquisition cost - check the
My question is, Which account should be Credited? Accordingly we checked it, then we had to review and save the Fixed Assets company setup. Are you able to delete and manually re-enter one of these assets? 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.
I have found the cause. How can I enable this for normal users.(providing FA manager privilege didn't solved the problem)… please help… LikeLike Nish Reply November 9, 2012 at 2:31 am Hi Victoria Thank you for 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 If you have such assets change their depreciation method to NO depreciation.
Is there any preventive measure that we can take? I just wanted to chime in on the topic of negative cost. Since the accounts are now correct, future depreciation will be using the correct accounts. I've used it a bunch of times with very good results.
I can see that there is a mismatch between the FA00700 (Asset Retirement Master) and the FA41700 (Asset Retirement Event Master) tables: MAX(RETIREEVENT) for FA00700 is 837 MAX(RETIREEVENT) for FA41700 is Last January 2012 our company started operating again.