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.

 •  0 comments  •  flag
Share on Twitter
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.

 •  0 comments  •  flag
Share on Twitter
Published on May 28, 2012 05:11

May 25, 2012

May 24, 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.

 •  0 comments  •  flag
Share on Twitter
Published on May 24, 2012 09: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



 •  0 comments  •  flag
Share on Twitter
Published on May 24, 2012 06:00

May 23, 2012