Is it possible to enter a Fixed Asset with $0 Acquisition Cost and Accumulated Depreciation?

A client needed to enter an Audit Adjustment as an 'Asset' in the FA module with zero cost but including depreciation so the FA subledger would tie to the GL.  Here's how we did it:

* Click image to enlarge

Enter $0.00 in the Acquisition Cost field in the Asset General window.

* Click image to enlarge

Then, in the Asset Book window change the Depreciated to Date field to the appropriate date, change the Cost Basis equal to the amount of LTD Depreciation you need, then change the LTD Depreciation field to the amount of accumulated depreciation to match the Cost Basis.  Make sure that after you've done all this that the Remaining Years, Days is all zeroes or the asset will continue to be depreciated until the end of its life.

Convergence 2012 Early Registration Ends in 17 Days

If you plan on attending Convergence 2012 in Houston, TX this year, register now at discounted rates!  Click on the image below to register.

What are YOU interested in seeing a post on?

Typically, the blog posts I make are related to an issue that a client is currently experiencing and the resolution we arrived at.  Sometimes, it's something cool I learned along the way by reading other blogs that I follow.  However, the main reason I publish a blog is to provide YOU, the users who are kind enough to read my ramblings, insight into how to do things better, faster, easier in Dynamics GP.

To that end, I'd like to know what you would like to see a post on.  Do you have a particularly sticky issue that you haven't been able to find an answer to?  If so, leave a comment on this post and we'll see what we can do.

Thanks!  Frank

Quick and Dirty way to see Window Resources

Need to see the tables and fields related to a particular window in GP?  Here's how - open the window, select Tools>>Integrate>Table Import.  The Select a Table window opens and displays all the tables assoicated with the window (this works only in GP10 and later versions).

* click image to enlarge

* click image to enlarge

if you need to see the fields in a specific table, double click on the table name in the Select a Table window.  The Table Import Definition window opens.  Enter Test or some other value in the Definition ID field.  Note that the fields appear in the scrolling window.  Make sure you delete the definition when you close the window.

* click image to enlarge

Happy Thanksgiving and a Turkey Day Tip

Looking for a particular 3rd party product to augment Dynamics GP, CRM, or any other Dynamics product?  ISV Central provides a great searchable compilation of products for your reference and research.  Visit ISV Central by clicking on their logo below.

Wishing you all a safe and healthy Thanksgiving holiday!

Add Logical Argument Field to SmartList via SmartList Builder

I'm no SQL guru but I needed to add a column in SLB that evaluates the results in another column in the SmartList (basically an IF, THEN, ELSE statement) and ran across this great tip on Devon Southall's Dynamics GP Builders & Reporting blog.

Thought I'd share it with you . . .

http://gpbuilders.wordpress.com/2010/05/11/if-then-else-in-calculated-field-in-smartlist-builder-try-case/

Thanks Devon!

It's Year End Already???!!!

Hard to believe but it's time to start thinking about closing the year again.  In that spirit, you may find some of my previous Year End Close articles helpful.  Click on the calendar image to jump to the articles.

Good luck!