implementation

customization

reporting

upgrade

conversion

support

consulting

db design

programming

 

Internationally:

 

1-866-528-0577

1-630-961-5918

help@albaspectrum.com

 

About

Products

Cases

Clients

Solutions

Contact

Business & Technology Synergy

Microsoft Great Plains movie clip 

 

 

 

Google
 
Web www.albaspectrum.com

 

Articles 2006    Articles 2006_2    Articles 2006 3    Articles 2006 4

 

Microsoft Dexterity Customization Recovery – Alba Spectrum

If you have Microsoft Dynamics GP Great Plains as your backoffice or simply say, corporate ERP, and if you deploy modified GP business logic for multiple years, then you probably feel uncomfortable, when you hear about new technologies, affecting Great Plains and substantial changes and “improvements” in recent new GP version and even worse

Data Conversion and Migration for Microsoft Dynamics GP – Alba Spectrum

It is normal to switch over from one MRP system to another.  ERP as any other computer application has its life cycle.  When you switch from legacy system to Microsoft Dynamics GP Great Plains – one of the first questions will be this: how do I migrate my legacy accounting records into new ERP: accounts

Report Design for Microsoft Dynamics GP Great Plains – Alba Spectrum

When we are talking about reporting for your ERP/MRP application, we should mention, that you can not expect equal performance from all consultants.  The matter of fact is – each consultant specializes in her/his own set of tools and has historical level of experience and so, expertise

Upgrading Microsoft Great Plains Dynamics GP – Alba Spectrum

This article is written to warn you that you should not expect that Microsoft Dynamics GP upgrade wizard will do all you version update job, especially in the cases when you have modified or custom GP logic, or deploy ISV third party GP modules.  There is the whole spectrum of technologies

Integration: Microsoft Great Plains Dynamics GP – Alba Spectrum

Please, consider Great Plains Dynamics GP as mid-size of even large scale ERP.  This means that data sitting in SQL database if ruled by pretty complex MRP application business logic.  The above statement should help you to calm down and take conservative approach to the situation when somebody from IT

SQL Scripting: Microsoft Great Plains Dynamics GP – Alba Spectrum

If you are looking into GP data repair, we would like to introduce you to the level of comfort and complexity, we expect that you have reasonable level of Microsoft SQL Server DBA experience and certification

How to backup and restore Microsoft Great Plains Dynamics GP Company into the test database

First of all – you should be reasonably familiar with Microsoft SQL Server 2000 Enterprise manager or Ms SQL Server 2005 Management Studio – if this is the case and you know what you are doing, let’s go ahead

Data Repair: Microsoft Great Plains Dynamics GP – Alba Spectrum

When we are talking about Microsoft Great Plains Dynamics GP data fixing, you should be familiar with GP data consistency validation tools, such as Check Links.  If you have custom logic, or custom integration, than check links might not be recommended by your modification partner, please check with them

Consulting Partner: Microsoft Great Plains Dynamics GP – Alba Spectrum

ERP implementation, customization, reports design, database development, version update, initial data conversion and migration require either consulting firm or contractor selection – Microsoft Dynamics GP is relatively complex application, this is why Microsoft Business Solution requires GP to be sold and professionally implemented by certified GP reseller

Inventory Control: Microsoft Great Plains Dynamics GP tables structure – Alba Spectrum

Microsoft Dynamics GP tables structure is pretty complex and you should seek professional GP technical consultant help if you can not figure out you technical questions within your company IT department.  You should be aware that such tables as IV10200 play important role in the following SOP cost calculation process, even if you think this table is gone to history

Landed Cost: Microsoft Great Plains Dynamics GP – Alba Spectrum Chicago

Microsoft Great Plains tracks landed cost together with POP transactions: purchase receipts.  The table name is this: POP30700 and if you need to link it to your purchase receipt lines use this link

Chicago Area Microsoft Great Plains Dynamics GP Partner – Alba Spectrum

When you implement or support your new corporate ERP system, one of the criteria is find and select local or regional MRP implementation partner.  In the case or Microsoft Dynamics GP Great Plains, you should check if partner has expertise in your industry, reasonable former exposure to GP technology

Microsoft Great Plains Dynamics GP version upgrade service in Naperville, IL and Chicago suburbs – Alba Spectrum 

We often hear from our customers and prospects that version update is something they really don’t like to do very often, so it might be good idea to skip one version and it is really your decision if you accept to be a bit outdated with your ERP.  In our opinion, “being outdated” doesn’t typically apply to your MRP functionality

Microsoft Great Plains Dynamics GP implementation service in Naperville and Chicago Southwest Suburbs – Alba Spectrum

Will, Kane, Southern DuPage counties are currently experiencing population expansion time.  Businesses are relocating and finding excellent conditions in business parks along highway 55 in Romeoville, Plainfield, Joliet, Aurora, Southern Naperville.  If you are moving to this area and you historically have Microsoft Great Plains

-----------------

Microsoft Dynamics GP data migration – Alba Spectrum Illinois

Microsoft Dynamics GP Licensing – Alba Spectrum

Microsoft Dynamics GP Technical Support overview – Alba Spectrum Chicago

Microsoft Dexterity Customization Projects USA Nationwide – Alba Spectrum

Data Repair Techniques for Microsoft Dynamics GP Great Plains – Alba Spectrum

Microsoft Dynamics GP Consultant Selection Overview – Alba Spectrum

Moving Microsoft Dynamics GP from one SQL Server to another – Alba Spectrum

Microsoft Dynamics GP Implementation & Support in downstate Illinois – Alba Spectrum

Interactive Reporting (IR) for Microsoft Dynamics GP Great Plains – Alba Spectrum

-------------------

Oracle Reporting: E-Business Suite custom design & estimation – Alba Spectrum

Popular SQL Queries for Microsoft Dynamics GP – Alba Spectrum Texas

Microsoft Great Plains GP SQL Reporting: Alba Spectrum Texas

Search Engine Optimization Advises

Microsoft Great Plains Dexterity Mods: Alba Spectrum

Great Plains in North West Illinois: Microsoft Dynamics GP implementation – Alba Spectrum

Great Plains Dex Software Development for MS GP – Alba Spectrum

Microsoft Great Plains Dynamics GP Upgrade Checkpoints – Alba Spectrum

Great Plains Upgrade FAQ and Considerations

Great Plains Data Consolidation

MS Dynamics GP Enhancement Program and Reenrollment FAQ

eCommerce web development for GP - Alba Spectrum

-------------------------

Microsoft Great Plains Screenshots

Recreation 1 

 1 2 3 4 5 6 7 8 9 10 11 12 12 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50

 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 80 81 82 83 84 85 86 87 88 89 100

Recreation 2

  1 2 3 4 5 6 7 8 9 10 11 12 12 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 80 81 82 83 84 85 86 87 88 89 100

Recreation 3

  1 2 3 4 5 6 7 8 9 10 11 12 12 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 80 81 82 83 84 85 86 87 88 89 100

 

  

 

Jewelry Articles 6

 1 2 3 4 5 6 7 8 9 10 11 12 12 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50  

Jewelry 5 Articles

 1 2 3 4 5 6 7 8 9 10 11 12 12 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50  

Employment 3 Articles

 1 2 3 4 5 6 7 8 9 10 11 12 12 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50

Employment 2 Articles

 1 2 3 4 5 6 7 8 9 10 11 12 12 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50

Jewelry Articles 4

 1 2 3 4 5 6 7 8 9 10 11 12 12 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50

Jewelry Articles 3

  1 2 3 4 5 6 7 8 9 10 11 12 12 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50

Jewelry Articles 2

 1 2 3 4 5 6 7 8 9 10 11 12 12 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50

Jewelry Articles

  1 2 3 4 5 6 7 8 9 10 11 12 12 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50

Microsoft Dynamics GP Great Plains Posting Server – Alba Spectrum Texas

Microsoft Great Plains Dynamics GP Integration Manager

Microsoft Great Plains Dynamics GP Integrations – Alba Spectrum Houston

Microsoft Great Plains Dynamics GP support: Downers Grove, IL – Alba Spectrum

Microsoft Dynamics GP ERP Bolingbrook, IL – Alba Spectrum

Microsoft Dynamics GP Great Plains Support in downstate Texas – Alba Spectrum

Microsoft Dynamics GP Great Plains Support in US Countryside

ERP/MRP Articles

  1 2 3 4 5 6 7 8 9 10

CRM Articles

  1 2 3 4 5 6 7 8 9 10 11 12 12 14 15 16 17 18 19 20

Employment Articles

  1 2 3 4 5 6 7 8 9 10 11 12 12 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50

High Tech Jobs in US: Oracle, Microsoft - overview & trends

If you are in college, getting hot IT or Programming degree, you should keep your eye on high-tech job market situation

Great Plains Dynamics old-style consulting

Microsoft Dynamics GP consulting in Illinois

Reporting for Microsoft Great Plains/Dynamics/eEnterprise: RW – ReportWriter – tips for developer

Microsoft Business Solutions Great Plains is written in Great Plains Software programming tool: Great Plains Dexterity.  Dexterity in turn was built with conception of graphical cross-platform transferability (in time – 1992 – mostly Mac and MS Windows).

Manufacturing solutions for Microsoft Great Plains – overview for consultant

Manufacturing from accounting stand point is moving inventory into work in progress and then into finished goods.  And this is where we have fundamental difference between discrete and process manufacturing.

Microsoft Great Plains Food Processing – implementation & customization highlights

In Food Processing industry the manufacturing itself is so-called process manufacturing, where with variable input you have variable output.

Microsoft Great Plains Jewelry – implementation & customization overview

In this small article we’ll give you Microsoft Great Plains implementation and setup highlights, typical for Jewelry retail network.

Microsoft Great Plains Implementation: Pharmaceutical Corporation Specifics – overview for consultant

Today we’ll consider Microsoft Great Plains implementation specifics for large pharmaceutical corporation.

Microsoft Great Plains Implementation: Healthcare/Hospital example – overview for consultant

In the case of Healthcare/Hospital there is usually healthcare patient history tracking system in place and backoffice or accounting application should be integrated on the ongoing basis...

Microsoft Great Plains Implementation: Placement/Recruiting Agency example – overview for consultant

Microsoft Great Plains does wonderful ERP job for horizontal markets and clientele.  However in our opinion placement software market is underserved and needs custom modules to be developed.

Microsoft Great Plains eCommerce – stored procedures approach

assume that you are on MS SQL Server 2000/7.0, because if you are on Ctree or Pervasive SQL/Btrieve – you should use ODBC / RDO connection tools, such as MS Access and its queries or use MS SQL Server Linked Server technique with OPENROWSET statement

Microsoft Small Business Manager Customization options - overview

Microsoft Business Solutions Small Business Manager is Great Plains Dexterity based small business market niche version of Microsoft Great Plains.  Microsoft Great Plains itself has variety of customization tools: Integration Manager, VBA/Modifier

Microsoft Great Plains Integration Manager: using Continuum – overview for developer

Microsoft Business Solutions Great Plains has I’d say end user integration tool – Great Plains Integration manager.  Integration Manager itself uses OLE functionality to validate text or ODBC integration files data through Great Plains forms..

SQL Administrator skills required to support Microsoft Great Plains

Microsoft Great Plains is becoming more and more popular and we see new purchases among midsize and large corporations, where, in our opinion, Microsoft SQL Server DB administrator position is a must.

ERP Consulting 2010: future business model and alternatives

This might be attributable to the whole industry: Oracle Financials, Accpac, MAS500, PeopleSoft, SAP for mid-size business and Microsoft Navision, Axapta and Solomon.  We are talking about mid-size ERP systems implementation

Microsoft Great Plains implementation & tailoring – local versus remote support

Especially, we see tough situation for the client who is located outside of large business mega – police and who is on legacy database platform, such as Pervasive SQL or Ctree.

Microsoft Great Plains Middle East - Arabic Language Support

Microsoft Business Solutions Great Plains is marketed for mid-size companies in North America, Europe, Asia Pacific, as well as in Middle East.

Microsoft Great Plains Implementation: Verticals - Wholesale Order Entry center – overview for consultant 

Sales Order Processing improvements to work with large number of wholesale order takers

 2003/2000. 

Great Plains Dexterity Development: FAQ

Microsoft Business Solutions Great Plains is Dexterity-written application and currently we see increased interest for Great Plains customers to do in-house Dexterity development and customization.

Microsoft Great Plains in Advertising & Publishing – implementation highlights

Microsoft Great Plains, former Great Plains Dynamics is excellent fit for service oriented business and in this small article we’ll give you magazine publisher and advertiser implementation and reporting scenarios.

Microsoft Great Plains in Aerospace & Defense industries – implementation & customization highlights

Microsoft Great Plains fits horizontal markets clientele and in case of Aerospace and Defense industry we’ll talk about contractors – parts and subsystems for government contracts.

Microsoft Great Plains in Agriculture – implementation highlights

In this small article we’ll concentrate on farmers associations and non-profit state-sponsored organizations, dealing with subsidized state and federal programs distribution and management – loans to farmers and rural communities.

Microsoft Retail Management System (RMS) SQL customization – overview for programmer

Microsoft RMS is SQL Server-based application, so we will consider SQL programming – SQL queries, views and stored procedures.  Also Microsoft RMS could be integrated on the SQL level with other applications, such as Microsoft Great Plains

Microsoft Great Plains Implementation for Large Corporation – overview for VP IT

 Let’s consider the questions, you need to be placed and answered for your IT department in ERP selection, implementation, modification and customization.

Microsoft CRM Integration with Microsoft Retail Management System (RMS) – overview

Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS are both Microsoft SQL Server based applications, however historically Microsoft was purchasing industry leading applications, such as QuickSell now Microsoft RMS.

ERP Consulting – New Horizons

Every new economy recovery and boom brings new type of business paradigm.  It is true about economy in general as well as every market niche.

Microsoft Great Plains: data conversion & migration scenarios – overview for consultant
With the switch to Microsoft Great Plains you need to decide on data migration and conversion.  Let us give you highlights on your options

Microsoft Great Plains Implementation & Customization: computer parts retailer example

In this case you can base web commerce off Great Plains databases and POS automates walk-in retail store.  Inventory count might be done from both sides: Great Plains or RMS, depending on the main line

Microsoft Great Plains Accounting/ERP implementation – finance industry customization example

Bonds and Loans.  If you are issuing these documents – you probably already have production system in place.   What is often seen – this loans tracking system is not integrated with accounting application.

Microsoft CRM and Great Plains implementation: freight forwarding business automation example 

business automation example, where Microsoft CRM and Great Plains are integrated and customized to fit Freight Forwarding business processes.

Microsoft Great Plains Customization: Project Organization – international business example

Real Estate, Law Firm, Placement Agency with permanent clients, Construction or Freight Forwarding company – you probably use or plan to deploy Project management or Project accounting extension for Microsoft Great Plains.

Microsoft Great Plains implementation: restaurants supply chain management example

In this small article we would like to give you good example of customization scenarios, where client needs warehouse management, random weight purchasing and by-pond resale to end clients, barcoding.

Microsoft Great Plains international implementation – USA / Mexico – overview for consultant

Let’s consider typical case when we see international company with headquarters and distribution centers in the US and manufacturing and purchasing in Mexico

Microsoft Great Plains Technical Support : Typical Questions and Answers

Technical support offered by MBS depends on the region. For North America (NA), support is available to both partners and customers who availed of the support plan. In Asia Pacific (AP), Europe, Middle East, and Africa (EMEA)

Microsoft Great Plains Localization: Middle East – Middle Eastern Payroll

The standard Payroll module included in Great Plains is geared towards the US standards and in accordance with US regulations. While this may mean easy usage for US-based companies, this is a headache for companies situated outside North America

Microsoft Great Plains version 8.5: upgrade, customization, VBA, Crystal Reports - preliminary highlights for consultant

Microsoft Great Plains 8.5 is scheduled to be released in the second quarter of 2005.  It is usual practice when you here announcements and then you are notified about software release delays.

Microsoft Great Plains e-Commerce – additional considerations for programmer

For eCommerce developer the most important is to understand Great Plains tables structure and business processes in Sales Order Processing, Accounts Receivables, Inventory Control (inventory items allocation, backordering, etc)

Great Plains Dynamics on Pervasive/Ctree support – overview for consultant

We see large number of so-called orphan clients (who lapsed to pay annual enhancement/maintenance fee to Microsoft Business Solutions) and still sits on two legacy platforms (not supported anymore): Pervasive SQL 2000 and Ctree

ERP for Large Corporation – new selling strategy

Our opinion is based on our Microsoft Business Solutions Great Plains, Microsoft CRM sales and marketing campaign to large businesses in the following industries: Aerospace, Furniture, Beverages, Placement...

Microsoft Great Plains international implementation – USA / Mexico – overview for consultant

Let’s consider typical case when we see international company with headquarters and distribution centers in the US and manufacturing and purchasing in Mexico

Lotus Domino: reports and connectors – Crystal Reports, XML, ODBC/JDBC, OLE