#### Retiring Asset with Non-Zero Net Book Value

```Hi,
I have recently started handling Fixed Assets and I have some doubts

in GP, When an asset is retired and has not been fully depreciated,
the net book value is calculated as cost basis less LTD depreciation.
Can anybody explain the underlying accounting concept for keeping the
net book value. When an asset is retired, it means this asset has no
value for the company. Isn=92t it so ?

Is there any way in GP to make net value zero when it is retired ?
Thanks.

```
 -1
rubal_pal (3)
1/21/2009 9:22:17 AM
greatplains 29623 articles. 6 followers.

0 Replies
1644 Views

Similar Articles

[PageSpeed] 30

Similar Artilces:

I need a formula to calculate 2-3 columns but skip a column if it has a zero
I'm building a Golf League spreadsheet and we want to calculate handicaps starting with the second week (calculates 2 weeks) and then after the 3rd week calculates every 3 weeks. Columns B-S are the individual weeks scores for each golfer (golfers listed by row 4-33), each column (b-s) has a formula which pulls the golfers score from the input worksheet(weekly input) to this worksheet(scorecard). Starting with Column V we are trying to have the running handicap for the year which changes each week. Column W is the first week handicap =AVERAGE(B4-36)*0.8 (this ones easy) Column X is the se...

Using Access form to assign values of variables in an Excel VBA program
I have created a VBA program for Ms Excel.But,to get desired results, every time, I go into the code to change the values of variables.Is there a way to get the values of variables stored in an Access table? YOu need to do a search for ADO method (ActiveX Data Object). There are plenty of example of code on the web. You need to add two references in your VBA to use the method. from VBA menu tools - References 1) Microsoft Access XX.X object library 2) Microsfot ActiveX Data Objects X.X library Use the latest versio of the two libraries on your PC. You will make a conn...

non vba way to print non continuous ranges
Hi, Is there a non vba way to print non continous ranges on the one shee using excel? Specifically, lets say I want to print data from columns A, B, C, G an K down to row 35 in each column. Is there a way I can do that withou manually making them continuous by cutting and pasting each range ont a new sheet? Regards, David Obei -- DavidObei ----------------------------------------------------------------------- DavidObeid's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=223 View this thread: http://www.excelforum.com/showthread.php?threadid=27196 You can h...

Selecting top five values from Pivot
Hi, I have a Pivot shows the supplier name and the qty supplied by them. Now in another sheet, I have to show only the top 5 suppliers, who have supplied highest qty. Supplier Qty AAAA 12 BBBB 2 CCCC 65 DDDD 987 EEEE 75 FFFF 1 GGGG 123 Above data is displayed in Pivot. In another sheet, I require, only top 5 suppliers with highest qty supplied. Please help. Thanks, Navin ...

HELP!!! How do you create a query crieria for multi values??
Hello all, please hyelp, its an emergency!!! Need to create a query where one of the searches is male or female, how do I allow user to enter both as the search options?? Also how do I convert tix boxes into a query criteria (e.g. serach for all ticked) Thanks so much for your help ...

Disable/Enable all controls on a form based on value of another control
What is the best to way to exclude a specific control (or controls) from the following condition? (e.g., I would like to exclude SubjectID and MRN from being Enabled or Disabled): ### Dim Ctl As Control On Error Resume Next If IsNull(Me.SubjectID) OR IsNull(Me.MRN) Then For Each Ctl In Me.Controls Ctl.Enabled = False Next Ctl Else For Each Ctl In Me.Controls Ctl.Enabled = True Next Ctl End If ### I'm using this to ensure that the user enters the SubjectID and MRN *before* entering more data for the subject. By disabling all the...

When I right click on an item as select sent to mail receipient it uses my windows address book, vice my Outlook address book. Since I don't want to update both how do I make it default to the Outlook book and contacts? -- Jeff Mu�iz Work is victory. - Ralph Waldo Emerson Open Internet Explorer and select Tools | Internet Options | Programs tab. Set the contact list dropdown to Microsoft Outlook. "Jeff Mu�iz" <jmuniz6@cox.net> wrote in message news:wEUId.20390\$B95.3864@lakeread02... > When I right click on an item as select sent to mail receipient it uses my ...

Cell Number Format includeing other Cell Value
Hello, I needed to create some conditional number format - to say so... My goal: Cell A1 content is "m2" as I Enter in cell A2: "10" -> the output to cell A2 should be "10 m2". Cell A1: "Dollars" -> A2: 200 -> shown "200 Dollars"... and so on.... Is that possible in Excel? (don't know VBA - yet :DD) Any help is appreciated! BR, Daniel How about just use a third cell: =a2 & " " & a1 daniel_of_vienna wrote: > > Hello, > > I needed to create some conditional number format - to say so... > M...

Exchange 2003 Books
Dear All, Hello. I have extensive Exchange 2000 experience. Are there any books on Ex2003 worth getting? Thanks to All! Angel Microsoft Exchange 2003 Unleashed (Sams) is the only book I found useful. "Angel" wrote: > Dear All, > > Hello. I have extensive Exchange 2000 experience. > > Are there any books on Ex2003 worth getting? > > Thanks to All! > > Angel > > replied in microsoft.public.certification -- Mark Fugatt Exchange MVP http://www.exchangetrainer.com http://www.msexchange.org "Angel" <anonymous@discussions.micr...

Visual Studio .NET 2003
I have two projects in a solution. I want to create a dependency of one project on the other. I know to do this in vc++6.0 but unsure in .NET 2003. One is a library and I would like the library to be linked with the program in the other project(to whom the library is dependant) Thanks got it , Project->dependencies is there. "mfc" <mfc@nospam.com> wrote in message news:uE4vrmEnFHA.2080@TK2MSFTNGP14.phx.gbl... > I have two projects in a solution. I want to create a dependency of one > project on the other. I know to do this in vc++6.0 but unsure in .NET 2003. > ...

Check value range, then return spesific number?
Hi. I want to implement a function in my spreadsheet, that gives me this: When I enter a number into a cell, another number shows in another cell, based upon the number first entered. A bit more spesific: The idea is to calculate the number of instructors needed for a week end seminar. 1 participant requires 1 instructor. Same for 2 participants, and 3. 4, 5 and 6 participants requires 2 instructors. 7, 8 and 9 participants requires 3 instructors. And so on. For every 3 participant, we apply 1 instructor. So, i.e. if I enter the number 5, i want the number 2 in the cell below. I trie...

Fixed Assets import using Integration Manager
Hello, I am having an issue whemn importing Fixed Assets. I have a simple file that I was able to import in one environment, but not successful at another environment. The issue that I am running into is I receive this error when importing the asset using Integration Manager for version GP 10: 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 I tried manually creating one asset and then running the import ...

Visual Basic.net
I currently work in Finance and have been told that VB.net is a useful tool for financial modeling which I want to learn. Any opinions on this? Thanks -- Mark "Mark" <Mark@discussions.microsoft.com> wrote in message news:14FAA95A-4D62-452F-A21D-24D2CB4F0396@microsoft.com... >I currently work in Finance and have been told that VB.net is a useful tool > for financial modeling which I want to learn. Any opinions on this? This group is for VB 6 and earlier; VB.Net is a substantially different language. You need to ask in a group with "dotnet" i...

Assigning a default value to a lookup.
I have a client that only has one unit of measure (Each) and would like to have this value set at default when creating new quote and opportunity products. I spent some time looking into this and have not determined how to control lookups at all except clearing them. Any suggestions would be appreciated. Thanks, Wayne. Hi Wayne, It's documented in the CRM SDK: http://msdn2.microsoft.com/en-us/library/aa681853.aspx -- Michael H�hne, Microsoft Dynamics CRM MVP Web: http://www.stunnware.com/crm2 Feed: http://www.stunnware.com/crm2/atom.aspx Custom Lookup Dialog: http://www.stunnw...

eliminate future zeroes
How can I show only valid data to date and not future data not yet entered and considered by Excel as zeroes Hi, Future data cells should be empty. If they contain formula then the result for empty data should be NA() rather than "". Charts treat text values, which "" is, as zero. NA() will only stop the data marker being plotted. The line will be interpolated between valid data points. But as your future points will not contain any valid points the line will stop. Cheers Andy Bryan wrote: > How can I show only valid data to date and not future data not yet enter...

w98 to wxp (DD32101@Comcast.net)
I just set up my new version on WXP pro..I had w98 2nd edition I am not able to find my old Outlook Express files.. How do I find, and get all of my old emails and notes to the new OE. The adress book did migrate, but all of the files are empty!? Thanx JoAnne dd32101@Comcast.net JOANNE wrote: > I just set up my new version on WXP pro..I had w98 2nd > edition > I am not able to find my old Outlook Express files.. > How do I find, and get all of my old emails and notes to > the new OE. The adress book did migrate, but all of the > files are empty!? > Thanx JoAnne > ...

Check Book Formula
I'm a real green horn when it comes to excel, I've searched the data base and am pretty baffled by some of the questions...Wow....anyways, I feel kind of silly asking as this is probably very simple. I just don't know how i would go about setting up a check book style spreadsheet. The last three colums would be Income, Expense, Balance. I understand how to add or subtract, what I don't know is how to I tell the spreadsheet to SUBTRACT the expense to get the Balance or and ADD the income to get the balance in each row. Do I have to type a formula in each row to do ...

Format a whole row based on value of one cell
I want to use conditional formatting to colour a whole row of cell based on the value in column C. I understand how conditional formatting works on the single cell yo select, but I don't know how to change the format for multiple cell based on the value of a single cell. Any suggestions? g -- Message posted from http://www.ExcelForum.com Hi try the following as an example: - select row 1 - goto 'format - Conditional Format' - choose 'formula' and enter the following formula =\$C1=your_value - choose a format -- Regards Frank Kabel Frankfurt, Germany > I want to u...

I have a number field (double) where it would be nice if Access didn't show a leading zero. Decimal Places is set to "Auto", and that is good, except for the leading zero. Format is currently blank. Access 2002. Thanks, croy On Tue, 23 Mar 2010 06:36:01 -0700, croy <croy@invalid.net> wrote: >I have a number field (double) where it would be nice if >Access didn't show a leading zero. Decimal Places is set to >"Auto", and that is good, except for the leading zero. >Format is currently blank. Access 2002. > >Thanks, >cro...

How to remove comma and decimals from a value
How can I remove comma's and decimal's from a value using a formula in a query? i.e. 4,325.00 Result: 432500 Assuming Excel recognizes the data as numeric, just reformat it. Edit > Cells, select the Number tab, choose 0 decimals and uncheck the separator box. If there not recognized as numbers, you'd first want to convert them: type a 0 in some random cell, copy it, select your data set and Edit > Paste Special, select Values and Add, then click OK. "Send Object Command - Two attachments" wrote: > How can I remove comma's and decimal's from a valu...

Sort order when using Contacts as Address Book?
When using Contacts as an Address Book, is there a way to change the sort order without changing the Default Full Name order? Currently when I select "To..." while composing a new message, Contacts are sorted by first name. I'd like to sort them by last name. Thanks. -- Lew One of the most frequently asked questions (probably becuase it's one of the most carefully hidden options): Go to Tools > E-mail accounts > View or change existing directories or address books > Outlook Address Book > Change. > Set your sort order there -- Russ Valentine [MVP-Out...

In stock non movement report?
I need a report that i can define dates and looks at on hand and when the last time it was sold. What I am trying to do is rid my inventory of items that are not moving. So i dont just need to know what is sold but how many i have in stock right now. I hope this makes sense. There's a canned report that can do just that. Go to Reports | Items | Item Quantity List. Put in the date range for Last Sold as a filter. Make sure you select On-Hand quantity and Last Sold in your column list. ...

Line chart zero values
I am trying to do a automated line chart that updates as users input over the next 12 weeks... the chart is consisting of 12 weeks on the x axis and % on the y. The problem im having is the values in the table that the chart is picking up from are formulas... but if the formula result is zero or ""(blank) I want the line chart to ignore it... rather than plot zero values making the line drop when a nil value or blank... for rest of the whole 12 weeks...? eg week 1 = 10% week 2 = 11% week 3 = I want the line to stop at week 2...? but because to work out the % is a formula...

Enable Combo box based on value in check box and list box....
I am working in Excel 2003 As a part of my worksheet titled "Worksheet" I am trying to enable Combo boxes based on the value of a check box and the value in a list box. There will be a total of 6 combo boxes on the Worksheet. The first combo box that deals with the body of a book will by default enabled. The second combo box will be set to appear disabled unless a forms control check box is checked to indicate there will be a cover on the book. The 3rd through 6th combo box will each be disabled by default and will be enabled when the list box which indicates the additional sect...

Anybody have a suggestion on a good beginner on asp.net
I have been working with win forms C# for 1.5 years and xml. I have not been using any kind of web development or html so I'm totaly new to asp.net. I want a suggestion for a good book on asp.net for a newbie like me //Tony I would strongly suggest the following: ASP.NET 3.5 Unleashed by Stephen Walther When I first started learning ASP.NET, I had almost no experience in .NET, web or desktop, other than an extremely basic college course on ASP.NET 1.1, but they did very little in that. But I wanted to learn more about ASP.NET, and my professor recommended ASP.NE...