Mark Polino's Blog, page 230
May 29, 2012
Weekly Dynamic: Checkbook Modifier
With all of the banking cosolidation that's gone in the past couple of years a lot of people now have checkbooks in Dynamics with names pointed to banks that no longer exist. So something like Wach-Payroll is no long with Wachovia. The account is probably still valid and being used but Wachovia is now Wells Fargo. So how how do fix that? It's simple with the now free Professional Service Tools Library.
Once the Library is installed, simple pick the old checkbook, give it a new name and click Convert.
The Validate and Import buttons allow you to validate and upload the old and new checkbook ID's if you have a large number of them to fix.
Once the Library is installed, simple pick the old checkbook, give it a new name and click Convert.

The Validate and Import buttons allow you to validate and upload the old and new checkbook ID's if you have a large number of them to fix.








Published on May 29, 2012 06:00
May 28, 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.








Published on May 28, 2012 05:11
May 25, 2012
Friday Fun: Presentations
Published on May 25, 2012 06:00
May 24, 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 








Published on May 24, 2012 10:00
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.
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.








Published on May 24, 2012 09:00
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








Published on May 24, 2012 08:00
Using Reporting Groups in GP 2010 | onza blog
Published on May 24, 2012 07:00
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]
Originally posted by Mark Polino
at 8/02/2010
09:00:00 AM

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]
Originally posted by Mark Polino
at 8/02/2010
09:00:00 AM








Published on May 24, 2012 06:00
May 23, 2012
Streamlined Sales Processing in Dynamics GP – Repeating Documents
Published on May 23, 2012 10:00
Performance issue with the Received/Not Invoiced report in Purchase Order Processing - Microsoft Dynamics GP Support Blog - Site Home - MSDN Blogs
From the Dynamics GP Support Blog comes details on a Performance issue with the Received/Not Invoiced report in Purchase Order Processing 








Published on May 23, 2012 09:00