Microsoft Dynamics ERP Selection: GP, AX, NAV, SL, CRM – Notes for Consultant

Microsoft recently (in September 2005) renamed its ERP product: Great Plains – Microsoft Dynamics GP, Navision – Microsoft Dynamics NAV, Axapta – Microsoft Dynamics AX, Solomon – Microsoft Dynamics SL, Microsoft CRM – Microsoft Dynamics CRM. The idea is probably nice – to unify future concordance product under Microsoft Dynamics name. There are multiple possibilities, however in getting all MRP systems merged into one Microsoft Dynamics and what should be taken as base and what should be phased out. We Read More

Zip Code Radius Calculations Using Microsoft Excel

Microsoft Excel “custom functions” can be used to carry out many tasks related to address and location-based information, such as importing demographic data, checking address accuracy, even calculating driving time and performing route optimization. Custom functions, also referred to as User Defined Functions (UDFs), perform complex calculations or tasks and are used in cell formulas just like standard Excel functions such as SUM or AVERAGE. In this article we will discuss how custom functions can also be used for identifying Read More