DynamicAccounting.net

28 May 2012

Memorial Day

In observance of Memorial Day here in the U.S. I'm taking a day off from posting. Normal posting will resume tomorrow with an adjusted schedule.

24 May 2012

Migrating to Management Reporter 2012 - Dynamics Corporate Performance Management - Site Home - MSDN Blogs

From Dynamics Corporate Performance Management comes information on Migrating to Management Reporter 2012

Transitioning From On-Premise to Cloud ERP Solutions | 360° ERP Blog

Panormal Consulting explores some of the considerations when Transitioning From On-Premise to Cloud ERP Solutions

From point number 1, Recognize that risk will shift away from technology to the business.

"...As a result, CIOs and CFOs are forced to spend more time addressing organizational change management and training issues since the solutions can’t be easily changed to fit business needs, increasing the pressure on the organization to change its business processes and people."

hmm...this sounds a little like my thoughts at MSDynamicsWorld.

How to Engage with Microsoft Dynamics on Social Media - Microsoft Dynamics Partner Community Blog - Site Home - MSDN Blogs

While this targeted more toward partners, Kevin Machayaa explains How to Engage with Microsoft Dynamics on Social Media

Using Reporting Groups in GP 2010 | onza blog

Amanda Wong shows covers Using Reporting Groups in GP 2010 | onza blog

Weekly Review: Specific Item Costing

I ran into a situation recently where a client needed specific item costing for each product that they sell.

This is most common for serialized items where there is a single item number but specific costs need to be applied for each serialized item.

In a simple example, consider a dealership where each car model is an item number. We might have 15 MINI Cooper's on the lot in various trim models from stripped down to fully loaded but each one is a different cost with a different serial (VIN) number. You can't average the costs of the fully loaded and the stripped down models and you sure can't use FIFO or LIFO. [I'm not suggesting this is the way to run a dealership. It's an example.] You have to account for the specific cost of each car and relieve that cost when the car sells.

Dynamics GP can handle this but there are a few things that you need to know to make this work right:

The item must be using FIFO Perpetual or LIFO Perpetual valuation.
The items have to have serial numbers.
When you sell an item, the correct cost WILL NOT show on the screen or on any edit lists.
The correct cost WILL SHOW on the posting reports.

GP doesn’t finalize the cost for the item until posting so all of the edit reports show FIFO or LIFO cost but the correct cost is applied at posting. It works, you just can’t tell that it works until you post the transaction.

[Update: Lot Tracking works the same way]