Mark Polino's Blog, page 355

Microsoft Forecaster – Using Overrides to present relevant data to users - Dynamics Corporate Performance Management

Digging into Microsoft Forecaster, Dynamics Corporate Performance Management looks at Using Overrides to present relevant data to users.

Of course, if you had the new DynAcctNet Android app you'd be able to follow Dynamics Corporate Performance Management on your phone.

Weekly Review: Turning a Project into a Fixed Asset

A common request is to turn a Project from the Project Accounting module, into a Fixed Asset in the Fixed Asset module. There is no native functionality to do this and based on my conversations with the Dynamics GP team, it's not going to happen so you might as well understand the workaround and it looks like this:

1) Create a Miscellaneous Log Cost Category for Fixed Assets pointing the Contra Account to the FA Clearing account and the Cost/Expense account to wherever you are collecting the project costs (a WIP account, a project FA WIP account, etc.). You'll be doing a negative misc log so the cost collection location will be credited and contra (FA Clearing) will be debited. 2) Once the project is ready to become a Fixed Asset, process a negative Misc Log transaction using the Fixed Asset Cost Category to remove an amount equal to the total cost of the project. a. This setup makes it easy to exclude the FA Cost Category when analyzing project costs while still leaving the project at zero b. This process provides a transactional audit trail to show that the project was closed out and moved to Fixed Assets 3) Create a Fixed Asset. The GL Transfer mechanism will move the costs from the FA clearing account to the appropriate Fixed Asset account.

The reality is that the number of fields that would actually transfer from a project is really small, single digits small. The complexities of creating a Fixed Asset from a project become large very fast. For instance, how do you deal with multiple assets from a single project, complete assets but incomplete projects, partial capitalization of a project, combining Cost Categories for capitalization, etc. The benefits of creating something to manage this are far outweighed by pain of dealing with all of the possible scenarios. Realistically, this is best handled through a process like the one described here.

Posted by Mark at 6/01/2009 02:23:00 PM

Microsoft Excel - Where to begin: PowerPivot for Excel

I've blogged and spoken about how cool PowerPivot is. Well, if you've been wanted to play with it, check out Inside Microsoft Office's Where to begin: PowerPivot for Excel.

Dynamics Confessor Blogspot: Notable settings on the Account Maintenance Window

New from Leslie Vail is a look at Notable settings on the Account Maintenance Window.

New DynamicAccounting.net Android App!

The DynamicAccounting.net Android app has been updated and is completely new.

Now you can get the latest news from DynamicAccounting.net on the go and you have access to all of the Dynamics GP product blogs (like Inside Microsoft Dynamics GP or Developing for Dynamics GP). Plus you get access to all of the GP MVP blogs from folks like Mariano Gomez and Frank Hamelly along with a bunch of other Dynamics GP sites from influencers like Dwight Specht. Additionally, access to  MyGPSearch has been rolled in as a feature as well.

The DynamicAccounting.net Android App is 99 cents in the Android Market or you can use the bar code below to get it directly on your phone.

The app has be rebuilt from the ground up. Unfortunately, that means that there isn't an upgrade path for existing users. Sometimes you have to break things to move forward.

For now, I have a list of all of the users who have purchased the old version. If you want a refund on the old application to purchase the new one, email me with this link or at the email address on the blog and I'll refund your Google account.The old version will continue to work just fine but you won't be able to update or re-download it.

Rebuilding the app gave me the opportunity to easily create iPhone or Windows Phone 7 versions but I'm not sure that the demand is there to cover the much higher developer fees from Apple and Microsoft. If you are interested in an iPhone or Windows Phone 7 version email me so that I can gauge demand.

Mapping Functions: What are they and where can I find out more about them? - Connector -- Integrating Dynamics ERP with Dynamics CRM

 

Char Gust has a great look at Mapping Functions: What are they and where can I find out more about them? - Connector -- Integrating Dynamics ERP with Dynamics CRM .

She doesn't mean driving maps. This is about mapping Dynamics GP to CRM using the Connector.

The Dynamics GP Blogster: Microsoft Dynamics GP "12" Multi-tenant Architecture

Mariano looking into Microsoft Dynamics GP "12" Multi-tenant Architecture. This essentially allows multiple Dynamics databases making managing different installs on a single instance much easier.

Getting the name of a month from the month number in SQL Server | Victoria Yudin

Victoria shows us how to

How to add Item Category Long Descriptions to reports using the Support Debugging Tool - Developing for Dynamics GP

David Musgrave shows How to add Item Category Long Descriptions to reports using the Support Debugging Tool over at Developing for Dynamics GP

Mohammad R. Daoud: SOP Master Numbers not being assigned properly

Mohammad Daoud looks at how to deal with SOP Master Numbers not being assigned properly