[Read the rest of this article...]

[Read the rest of this article...]

[Read the rest of this article...]

[Read the rest of this article...]

Sage North America today announced Sage ERP X3, Sage SalesLogix and Sage CRM have been listed as Champions by Info-Tech Research Group in the firm’s Mid-Market ERP, Large Enterprise CRM and Small Enterprise CRM vendor evaluations respectively.

[Read the rest of this article...]

Were you not able to attend Convergence 2012 but would like to see some of their sessions? You can and it’s easy by visiting Virtual Convergence.

[Read the rest of this article...]

The Professional Services Tools Library is designed for use with Microsoft Dynamics GP. This document contains descriptions and information.....

[Read the rest of this article...]

[Read the rest of this article...]

If you are selecting software for the first time or replacing existing software, this 2012 Distribution Software Guide put together by Brown Smith Wallace Consulting Group can help you.....

[Read the rest of this article...]

[Read the rest of this article...]

Did you know you can drill down and launch a Dynamics GP window from Microsoft Excel? It’s a great feature if you need to check out transaction detail from a report or graph in Excel.

Microsoft Dynamics GP 2010 has a new feature called Drill Downs. It’s similar to the Office SmartTags.....

[Read the rest of this article...]

Round 2 Tax Update for 2012 is available for download--It’s important to note that Round 1 was originally released on 12/22/11 (Employee rate change to 6.2%) and subsequently re‐released on 12/27/11 to reflect a more recent update of Employee rate at 4.2%.

Note: Microsoft will provide a 2012 Year‐End update to all U.S. and Canadian Dynamics GP 10.0 customers along......

[Read the rest of this article...]

“NexTec is very excited to receive the Sage Spotlight Sale of the Year award, the product we used to win it – Sage ERP X3 Standard Edition, and the possibilities it opens for mid-market clients. With pre-configured templates and extensive functionality, Sage ERP X3 Standard Edition offers an opportunity for companies to achieve Tier One ERP results without the attendant budget and timeline commitments”, says Russell Harper, Vice President, NexTec Group.

[Read the rest of this article...]

If you’re attending Convergence 2012, we encourage you to visit Solver during the event trade show at Booth #201 to learn more about Solver’s BI360 v3.5. In addition to doing booth demonstrations, Solver’s team members will be presenting daily sessions to better acquaint you with the following:

[Read the rest of this article...]

In the incredibly competitive market system, businesses and companies are always looking for an edge that enables them to rise above their competitors. There are obviously many ways to do this. One method is to implement Microsoft CRM software, which has the ability to increase efficiency and effectiveness across the board regarding all business departments and divisions. Many will ask why and how this is possible.

[Read the rest of this article...]

Microsoft CRM software is customer relations software designed to improve all aspects of a business and is most effectively used in conjunction with a consulting firm. These firms have expertise in interpreting and implementing this software, to create results that may not arise without their knowledge.

[Read the rest of this article...]

We have added more talent to NexTec Group and are excited to announce that Elsa Williams has joined NexTec Group’s Helpdesk to support our Microsoft Dynamics GP practice.

[Read the rest of this article...]

[Read the rest of this article...]

Solver releases BI360 v3.5 with new features added to enhance reporting and analysis. The key features added are:

• "Drill To" - A custom drill down allowing you to dive deeper within your reports, users can drill to any module and detail in the ERP database or the BI360 Data Warehouse.

[Read the rest of this article...]

Get Your 30-Day Online Trial of MS CRM For Free! It's easy to get--there's No credit card information required and NO software installation needed. The only requirement is that you have Internet Explorer 7 or later to access your data. You can use Microsoft Office Outlook or your web browser to access your free trial.

[Read the rest of this article...]

Everyone knows that customer relationship management (CRM) can help sales, marketing, and service professionals close sales faster and serve customers better. However, Microsoft Dynamics CRM is for finance and operations too!!!

[Read the rest of this article...]

[Read the rest of this article...]

NexTec Group, a national Microsoft Dynamics and Sage ERP and CRM Partner, is proud to announce it has been selected by Progressive Media Group’s Bob Scott’s Insights (www.bobscottsinsights.com), as a winner of  its 2011 VAR Stars award. One hundred resellers are selected each year for this honor.

[Read the rest of this article...]

It’s difficult evaluating ERP solutions that best meet your organization’s needs. If you are planning to invest in a new ERP solution or in the process of evaluating systems, it doesn’t have to be difficult—we can help.

[Read the rest of this article...]

[Read the rest of this article...]

[Read the rest of this article...]

Have you heard Sage is rebranding most products in their software portfolio to be consistent with their naming conventions worldwide?

[Read the rest of this article...]

Dynamics Partner: Will Come In And Help Prep The Staff

If you are worried that your staff will not know how to use Microsoft crm software if you buy it then you probably want to make sure that dynamics partner software company comes in and does a training session and tutorial with your staff. Just because people know how to use computers doesn’t necessarily mean that they will know how to use crm without training.

[Read the rest of this article...]

Microsoft Crm Training: Do My Employees Need Microsoft Dynamics Training?

Any one that installs dynamics gp will tell you that you need Microsoft crm training if you want your software to work to its best potential for your company, your employees and your clients and customers. Dynamics is an amazing software that has improved the success of soo many businesses from the outside in.

[Read the rest of this article...]

Nucleus Research, a leading provider of investigative technology research, recently released a technology report, Technology Value Matrix 1H2011: CRM, highlighting CRM vendors and how they stack up against each other in the current CRM marketplace.

The CRM Technology Value Matrix below, based on functionality and usability and as the two core measures Nucleus Research has found to indicate an application’s ability to deliver initial ROI and, ultimately, maximum value over time, shows Microsoft Dynamics CRM, Salesforce.com and Oracle as the clear leaders.

[Read the rest of this article...]

Customer Challenge: The due date for 1099s to be issued to recipients is by January 31 and they have to be filed with the IRS by February 28. Businesses are required to provide individuals and companies who work for them with 1099s. Independent Contractors require 1099s in order to file their tax returns.

What is a 1099 form? The Form 1099 is used to report miscellaneous income for individuals and companies who have been paid $600 or more in non-employee service payments during a calendar year with the exception of royalty payments of $10 or more.

1099 vs W2: Employers classify people doing work for them as an employee receiving a W2, or an independent contractor receiving a 1099.

[Read the rest of this article...]

Recently we had a request come in from one of our X3 customers regarding their increasing need to process inventory adjustments to correct mis-keyed supplier lot data  on inventory receipts. As this field is left untouched by all of the lot maintenance and edit utilities currently available in X3, we opted to develop a simple utility of our own to do this.

[Read the rest of this article...]

As year-end approaches, questions arise about what procedures are required in Dynamics GP to insure accurate financial reporting and consistent transaction processing.  The Dynamics support team does a good job telling us what the procedures do and how to do them, but they leave out an important detail: What happens if I don’t do them at the right time, in the right order?  (Or, for that matter, what happens if I never do them?)  Following is an analysis of those questions for modules with a year-end procedure.

[Read the rest of this article...]

[Read the rest of this article...]

Did you know that with Solver's BI360 you can.......?

• Report in multiple currencies, using the exchange rate of your choice. (Daily, Monthly, Average, etc.)
• Easily create currency conversion rules through an administrative interface.

[Read the rest of this article...]

It's that time of year again and we're excited to announce that we will be hosting our Year-End Closing Process webcasts for Microsoft Dynamics GP, Microsoft Dynamics SL and Sage MAS 500.

[Read the rest of this article...]

It’s almost that time of year where we have to start thinking about Year-end processing, specifically around Payroll.

There will be a guaranteed year end update this year and below are the tentative timeline, very similar to prior years:

Updated 10/25/2011

The US Payroll Year End Update is scheduled to release 11/17/2011.  This is an update that will be required for U.S. customers to install due to the below list of changes. 

Please prepare for the update, and see below for details.  
 
Detail of the changes
•         W2 and W3 changes, EFW2 changes (magnetic media)
•         1099 R changes for Pension Payroll
•         1099 Payables Dividend changes
•         Fixed Assets Luxury Depreciation changes

[Read the rest of this article...]

[Read the rest of this article...]

In Sage ERP X3, the number of address codes by business partner is controlled by the activity code BPR.  By default it is set to 30 but can be set as high as 9999.   The activity code is managed on a folder basis so you would if you wanted to make the change in all of your folders, you will have to change them individually.

[Read the rest of this article...]

[Read the rest of this article...]

More Talent Added  to Sage ERP X3 Practice

We’ve added Chris Williamson as part of our NexTec team as an Application/Pre-Sales Consultant to help expand our national Sage ERP X3 practice.

[Read the rest of this article...]

[Read the rest of this article...]

Business Intelligence – Know Your Audience

This is the second of 5 blog posts intended to help companies figure out which business intelligence solution to buy. 

#2 Know Your Audience

Pay attention to who you are buying the BI solution for. Is it just a small group of managers? Or do you want every employee to have their own customizable dashboard that applies to their job responsibilities?  Before you start interviewing vendors and watching demos, spend time planning exactly who needs to use the system and what it is they need to be measuring and monitoring.
 

[Read the rest of this article...]

[Read the rest of this article...]

[Read the rest of this article...]

[Read the rest of this article...]

This is the first of 5 blog posts intended to help companies figure out which business intelligence (BI) solution to buy. 

#1 Ease of Use

Ease of use is one of the most important considerations in your purchase decision. Your enterprise BI solution will never be as easy as Excel, but it can’t be so complex that people won’t use it. When in doubt, keep it simple. Every BI user should know which benchmarks are most important to the company as a whole, and have smaller key performance indicators that measure how their department, division or position contributes to the overarching company goals. Advanced users may need flexibility to slice-and-dice the data.

[Read the rest of this article...]

Business Intelligence (BI) software has become a must-have solution in many businesses.  And it’s no wonder. Who would argue against making smarter decisions based on better information?

However, the myriad of choices available to you can make your decision seem overwhelming.  You may feel like you need quite a bit of business intelligence to pick a business intelligence solution.

[Read the rest of this article...]

[Read the rest of this article...]

I shouldn’t be shocked, but I still am. 

No, the surprise is not that a rabid team of reporters would hack into the phones of celebrities, politicians and victims to get a scoop.  What shocks me (and shouldn’t) is the ease in which they gained access.  There was no James Bond meets Sherlock Holmes type of code cracking.  The reporters just took advantage of the fact that people don’t change their passwords – unless they’re forced to.  Many of the people who were hacked were still using the phone’s factory default password settings. You would think that politicians and celebrities who vigilantly guard their privacy would know better.  But apparently they don’t.

[Read the rest of this article...]

We are excited to announce that NexTec Group is the first Sage Authorized Partner to implement Standard Implementation of Sage ERP X3 in North America.

A global manufacturer and distributor of custom orthotics and shoes has selected Sage ERP X3 Standard Edition to manage its complex operations. This will be the first Sage ERP X3 Standard Edition implementation in the US.

[Read the rest of this article...]

[Read the rest of this article...]

[Read the rest of this article...]

Microsoft Dynamics GP, SL and CRM Offers

NexTec is pleased to inform you that Microsoft has several great offers for New Customers and Existing Users of Microsoft Dynamics GP and Microsoft Dynamics SL. In addition to to these are a couple of great offers for Microsoft Dynamics CRM.

[Read the rest of this article...]

Microsoft has announced the general availability of Microsoft Dynamics® SL 2011!   

[Read the rest of this article...]

MRP Lite

Issue
We occasionally encounter clients running Dynamics GP’s Manufacturing module who want to identify future raw material shortages but don’t want the trouble of setting up, administering and then interpreting the results from the Manufacturing Resource Planning (MRP) tool in Dynamics GP.  What they want is MRP Lite.

Solution
For customers who want basic MRP info without the fuss of running the MRP tool, we have developed reports that identify potential shortages of raw materials based only on open sales orders for finished goods and open purchase orders for the raw materials.  No need to even run the MRP tool, much less configure it!

[Read the rest of this article...]

NexTec Develops Requisitions Module for Microsoft Dynamics SL

NexTec develops Requisitions module for Microsoft Dynamics SL allowing employees to efficiently manage the requisitions process while saving time and minimizing costs.

As a vital part of your business, employees can now manage their requisitions process independently from your Microsoft Dynamics SL system, while accessing the necessary Microsoft Dynamics SL information to do so.

[Read the rest of this article...]

For Sage ERP MAS 500 customers preparing 1099s for 2010, standalone 1099 Updates for versions 7.20 and 7.30 are now available on Sage Online.  Please note the following compatibility requirements:

[Read the rest of this article...]

NexTec Hosts Project Accounting & Job Costing Shootout Event in Houston, TX

Join NexTec Group as we battle out the Project & Job Cost Accounting strengths and differences between two of Microsoft's industry leading ERP accounting and business management solutions, Microsoft Dynamics GP and Microsoft Dynamics SL.

Whether you are currently evaluating financial ERP software or just starting the search for your project business, we'll show you some of the key differences and help clear a path for your requirements decision.

[Read the rest of this article...]

Determining How Many Sage MAS 500 and BI User Licenses Are Being Used

• Sage MAS 500 user license:
  • A standard MAS 500 user license is validated when an application task is launched from the business desktop.
    • Application tasks include all tasks in the Maintenance, Activities, and Reports folders on the Tasks tab.

[Read the rest of this article...]

OneSource Building Technologies, Inc. Launches Microsoft Dynamics GP

OneSource Building Technologies, Inc. announces financial software upgrade with Microsoft Dynamics GP to support diverse operational and financial reporting.

[Read the rest of this article...]

[Read the rest of this article...]

[Read the rest of this article...]

Financial management software is the backbone of every organization and the foundation that helps your company manage and gain insight into the most important parts of your business. If your financial management software becomes disjointed, the implications can certainly impact the success and profitability of your company.

Evaluating financial management software can be an overwhelming task as there are many factors to consider. Some of the typical questions to ask about your system may include:

[Read the rest of this article...]

Electronic Purchasing Documents

Did you know that you can send Purchasing documents electronically to a Vendor? Rather than printing and emailing these documents the old fashioned way, you can ensure a quicker and more secure delivery by sending them electronically.

[Read the rest of this article...]

Microsoft Dynamics GP 10.0 Service Pack 5 for English Installation is Available

As of 8/20/2010, the Microsoft Dynamics GP 10.0 Service Pack 5 for English Installation is Available.

[Read the rest of this article...]

PSTL 2010 - Duplicate Customer PO Numbers in SOP Entry

There are several tools that are bundled under PSTL 2010 as free tools.

The following screenshot shows the main PSTL window with this application highlighted.

[Read the rest of this article...]

Exploit Professional Services Tools Library to Consolidate and Change Critical Data

Microsoft Professional Services Tools Library for Dynamics SL and Dynamics GP provide several tools and utilities to consolidate and change critical data throughout the system, without rekeying data in multiple places.

[Read the rest of this article...]

Important Upcoming Dynamics GP (Great Plains) Version Retirement Dates by Microsoft

Microsoft usually only supports the two most recent version of Microsoft Dynamics GP. Microsoft will typically support a product for the following 24 months after the release of a subsequent version or service pack.

[Read the rest of this article...]

Microsoft Webcast - Improve Productivity & Time Management with Dynamics GP, CRM and Outlook

Bill Hoffman, Microsoft's Productivity and Time Management expert, is working with NexTec Group to deliver a series of FREE webcasts designed to help organizations get more done in less time through the tools companies may already have in place including Dynamics GP, CRM and Outlook.

[Read the rest of this article...]

MAS 500 FRx Replacement

FRx was first developed in the 1980’s and has steadily grown into the most popular report writer used in the mid-market.  It runs on multiple accounting systems and boasts over 100,000 installations.

Although it has its quirks, FRx has survived longer than most people anticipated due to the fact that it does its job of simple report writing well.  However, in recent years, the popular report writer program was acquired by Microsoft.  Ever since the acquisition, there has been talk of its retirement.  This year Microsoft released the first version of the Management Reporter suite which will eventually replace FRx.

[Read the rest of this article...]

NexTec Group Named to 2010 President's Club for Microsoft Dynamics

NexTec Group is Recognized by Microsoft for Commitment to Customers

NexTec Group, a leading provider of Microsoft Dynamics accounting and ERP solutions, has been named to the 2010 President’s Club for Microsoft Dynamics. This achievement is a direct result of NexTec Group’s outstanding dedication to customer satisfaction through the delivery of innovative business solutions.

[Read the rest of this article...]

NexTec Group Named to 2010 President’s Club for Microsoft Dynamics

NexTec Group is Recognized by Microsoft for Commitment to Customers

NexTec Group, a leading provider of Microsoft Dynamics accounting and ERP solutions, has been named to the 2010 President’s Club for Microsoft Dynamics. This achievement is a direct result of NexTec Group’s outstanding dedication to customer satisfaction through the delivery of innovative business solutions.

[Read the rest of this article...]

Dynamics GP SmartSort

Ever wanted to change the default sort method for a lookup in Dynamics GP? Ever wanted to customize a lookup for a specific user or group of users?

[Read the rest of this article...]

SQL Server Reporting Services Database Setup Issue

If you install the Reporting Services after the SQL Server is already installed, you may get the following error message when you attempt to setup the database in Reporting Services Configuration Manager.

The database version (C.0.8.40) does not match your reporting services installation. You must upgrade your reporting services database

[Read the rest of this article...]

Verifying eConnect Version When Developing eConnect Integration

When developing eConnect integration it is important to match the development environment eConnect version with the production environment.

To check the eConnect version, go to Start → Programs → Microsoft Dynamics → eConnect → eConnect Release Information.

eConnect Release Information executes the following stored procedure in the background to retrieve the eConnect business objects (stored procedures) version:

EXEC DYNAMICS..taeConnectVersionInfoDYNAMICS

[Read the rest of this article...]

Verification, Validation and Risk Management on ERP Projects

A key component of any ERP project is an adequate and thorough understanding of the client’s business and operations.  At NexTec we call this the Design Phase and include this phase on every ERP project.  To put into simple terms, this is:

Verification, Validation and Risk Management

During this phase which accounts for 10-20% of total project time, NexTec meets with key Company personnel.  Utilizing questionnaires and personal interviews, we decompose all aspects of daily operations to gain an in-depth understanding of needs and processes to determine if current processes can be continued or need to be revised for the new ERP system.

[Read the rest of this article...]

Tap Into Dynamics GP Resources

1. Go to http://reader.google.com and enter your Google account information or create a new Google account.
2. Click on the “Add a subscription” button in the upper left-hand corner.
3. Paste the following link: http://feeds.feedburner.com/dynamicsblogger/gpblogs/masterfeed.
4. You can now keep up today on all the latest information from the top Dynamics GP bloggers.

[Read the rest of this article...]

NexTec Group Now Offers Sage ERP X3

NexTec Group, a leading provider for Sage and Microsoft accounting and ERP solutions, today announced that it has reached an agreement with Sage to sell and distribute their Sage ERP X3 enterprise software suite.

[Read the rest of this article...]

Sage MAS 500 Year-End Updates

With January 31 right around the corner, now is the time to prepare for 1099s! Sage wants your 1099 season to be a successful one. To help ensure this, please take a moment to review the following valuable 1099 processing information.

[Read the rest of this article...]

How to process period-end closing or year-end closing in Sage MAS 500

I. SETTING UP GL OPTIONS

Before closing a fiscal year, configure the following options appropriately to achieve the desired results during year-end processing.

Go to the GL Maintenance menu and select GL Setup / Set Up GL Options. Verify the information on the following tabs:

[Read the rest of this article...]

PDFBlaster for MAS 500

Do you spend too much time printing invoices and mailing them to customers? Sage MAS 500 provides a document transmittal feature that allows you to submit documents electronically.  However, you can only send documents in .html and .rtf format while most customers would like to see electronic documents in .pdf format.

[Read the rest of this article...]

FRx Service Pack Issues for Microsoft Dynamics SL 7.0

As a result of many Dynamics SL 7.0 upgrades, we have had the opportunity to perform many FRx 6.7 upgrades as well.  FRx 6.7 Service Pack 9 is the first version of FRx widely distributed with Dynamics SL 7.0, and using the same code base as prior versions of FRx, the application is extremely mature and stable.

[Read the rest of this article...]

Compacting a VPC Image

[Read the rest of this article...]

Upgrading to Dynamics SL Version 7 – Feature Pack 1 or Service Pack 2?

Due to the retirement of version 6.0 and older service packs for version 6.5, several of our clients have been upgrading to version 7. 

There are two upgrade paths to 7.0

1. Feature Pack 1
2. Service Pack 2

[Read the rest of this article...]

Executing SQL Server scripts using Dynamics SL DBUpdate

Dynamics SL has a utility called DBUpdate (Database Update). Generally this utility is used to initialize some system level important tables e.g. rptcontrol, messages, pvrec, etc. The initialization of these tables is one of the post-installation steps.

[Read the rest of this article...]

Avalara - AvaTax for Microsoft Dynamics GP & SL and Sage MAS 500 ERP

Businesses are having a tough enough time in today’s recession economy just staying afloat. While paying attention to what they do best, running their businesses, the last thing they need to think about is the constantly changing rates, rules, and boundaries of sales tax jurisdictions. But if they get it wrong, charging too much or too little to customers, they’re in the kind of trouble that will take away from their bottom line.

[Read the rest of this article...]

Financial Reporting and FRx Replacement for Sage MAS 500 ERP

Scott Zandbergen (Vice President Product Management at Sage Business Solutions) recently announced a replacement strategy for FRx Financial Reporting for MAS 500 Customers. An Extract from his announcement follows:

[Read the rest of this article...]

How to Personalize Business Insights Explore in MAS 500 v7.2

[Read the rest of this article...]

Security Hints for Identifying a Task Description with the Task Name in Sage MAS 500

One of the biggest challenges in Sage MAS 500 is assigning security. The reason for this is that there are no documents that identify the task descriptions with the task names. Below is a workaround to identify the two challenges.

[Read the rest of this article...]

[Read the rest of this article...]

Increasing the Performance of Time and Expense Entry for Business Portal 3.0 in MS SL

[Read the rest of this article...]

API OptiView ECM: Seamless Document Management for MS Dynamics and Sage MAS 500

Advanced Processing & Imaging (API), developers of innovative electronic document and content management solutions, are pleased to welcome NexTec Group as an authorized platinum-level value added reseller (VAR). NexTec Group is authorized to sell and support API’s robust solutions to their existing and new clients as an added-value complement to their own products and services.

[Read the rest of this article...]

Microsoft FRx Report Writer – Most commonly overlooked features

[Read the rest of this article...]

Excel VLOOKUP Function

[Read the rest of this article...]

Exciting New Feature in MS Dynamics SL 7.0 - Quick Send

[Read the rest of this article...]

Important Version and Service Pack Support Updates for GP 10.0

[Read the rest of this article...]

Creating Custom SQL Based Sage CRM SalesLogix Groups for SalesLogix Territory Realignment

I manage our internal installation of Sage SalesLogix CRM (we still use SalesLogix for Sales and Marketing; we currently use Microsoft Dynamics CRM for Service and Support. We are in the process of migrating all of our xRM activity to Dynamics CRM as our single xRM solution). One of the things I’m frequently asked to do is re-align accounts and contacts from one rep. to another. Reasons vary for this, but most frequently it’s to accommodate some sort of ad hoc marketing activity.

[Read the rest of this article...]

Are You Taking Advantage of Microsoft CustomerSource?

I’ve had people ask me, how do I access CustomerSource and what is it?  So, I thought I would provide a little more insight for you.

CustomerSource, available for those on a current Microsoft service plan, is loaded with tools and information that can help you increase efficiency and productivity. With many self-help resources such as Knowledge Base, technical documentation and access to online training, Microsoft CustomerSource gives you the tools to efficiently use and support Microsoft Dynamics solutions.

[Read the rest of this article...]

Report Center Functionality for Microsoft Dynamics GP 10.0

The new Report Center functionality was introduced in Dynamics GP 10 and is included as a part of Business Portal, this feature is a great one for the out-of-the-box library pages that are setup for Finance, Sales, Purchasing, Inventory, Payroll, HR, Manufacturing, and Executives.

[Read the rest of this article...]

Dynamics GP on Windows 7 and Windows Server 2008 R2

[Read the rest of this article...]

Defining a Central Location to Store Report Files in MAS 500

[Read the rest of this article...]

Dynamics SL (Solomon) - Versions to Be Retired from Mainstream Microsoft Support

Below are two important announcments from Microsoft  regarding Microsoft Dynamics SL Version Retirement and Year End Tax Updates. If you have any questions or concerns regarding your Microsoft Dynamics SL install, please contact your local NexTec consultant or email marketing@nextecgroup.com.

Extracts from Microsoft Announcements regarding Version retirements and support for year end tax updates:

[Read the rest of this article...]

A Novel use for Landed Cost and an Explanation of Dynamics GP Landed Cost Postings and Options

This week I’ve been working on a deployment where one line of business sells containers of material which is purchased to order. The ultimate goal is to provide them with very accurate margin analysis on these container Sales Transactions both as a business measure and to provide feedback into their quoting process. Our client is coming from QuickBooks where they’ve been using ‘Job Cost’ to accumulate and report on these costs.

Most of these orders are coming overseas and have both import and overland freight and duty fees, etc. etc. associated with them.  Since these transactions have variable indirect and direct costs and they’re purchased to order, we needed to come up with a way to track both budgetary and actual costs against a  PO without having to go to a Project Solution (which would’ve taken too much setup and maintenance).

[Read the rest of this article...]

Why Create A Test Company in MS Dynamics GP?

There are many reasons for creating a TEST Company. These companies are typically used as a restore database point when testing new processes, procedures or proposed setup changes prior to making the changes in the production company. 

When creating a TEST company the Company Name in the test database should always be followed by the flag, <TEST>.  E.g.  Any Company, Inc.<TEST>

[Read the rest of this article...]

Cross-Database Queries & Dynamics GP Smartlist Builder

[Read the rest of this article...]

Resolving Application Errors in Integration Manager on x64 Servers 

[Read the rest of this article...]

Sage MAS 500 v7.2 64-bit Server Registration Issues

[Read the rest of this article...]

Hot Topic – Service Pack 4 for Microsoft Dynamics GP 10.0 Causes Errors in SmartList Builder and Excel Report Builder

For any of you who use Smartlist Builder and Excel Report Builder, the latest Hot Topic from Microsoft is an important bit of information.

After installing Service Pack 4 for Microsoft Dynamics GP 10.0, you will receive the error "Wrong number of arguments to 'Replace_Text'" when using areas of SmartList Builder and Excel Report Builder.  For example, the error appears completing the following:

1. Clicking Publish in Excel Report Builder.
2. Saving a calculation in SmartList Builder or Excel Report Builder.
3. Exporting the SmartList Builder or Excel Report Builder setup to a file. 

[Read the rest of this article...]

“Truth in advertising”

This morning, as I was going through my Inbox, I came across an interesting email that indicated that one of our competitors had ‘rebranded’ one of our client ‘success stories’ (see NexTec's original case study) to make it look like it was the competitors’ successful engagement (see competitor's rebranded version). I was a little taken aback by the audacity of this ‘rebranding’. The real question is, what would inspire someone to ‘push the envelope’ on something so far as to risk undermining their credibility with prospects (especially if the prospect found out that this was not their engagement)? Is this just poetic license or does this push out of the grey area of marketing?

[Read the rest of this article...]

Microsoft Dynamics CRM and Sql Server Reporting Services (SSRS)

As an ERP consulting company with offices in New Jersey, Los Angeles, Seattle, Houston and Cleveland, we have a critical need to distribute data from our accounting software via the web on a timely basis. Several years ago, we chose SSRS, or Sql Server Reporting Services as our tool of choice, this is the same great tool that Microsoft Dynamics GP uses. We chose it for 3 basic reasons: it was web facing, could schedule report delivery automatically, and it natively integrated with MSSQL.

[Read the rest of this article...]

Does your organization have good backups of your critical databases?  Are you SURE?

[Read the rest of this article...]

MS Desktop Search Tips Or when is not not "NOT"?

I find that some terms I search for occur very frequently, client or id - for instance are so common that the search results are meaningless. For instance, our Spam filter sends me emails every day with the word Sonicwall, the manufacturer of the device. Since each email also contains a line or so of text from each potential Spam item, searching for Sonicwall login or Sonicwall warranty might give me over 1,000 results.

[Read the rest of this article...]

“The Big Easy” Welcomes Convergence 2009

[Read the rest of this article...]

The Key Ingredients That Make Up Our National Helpdesk's Success

[Read the rest of this article...]

Microsoft Instant Search – Ready for Prime Time!

[Read the rest of this article...]

When Is It Time to Spend On IT?

In our Government Practice, we find that as budgets get tighter, there is an increased spend on technology and infrastructure geared toward creating efficiencies. This seems logical inasmuch as spending some money to save more money really makes sense as I write it. However, this isn’t often the case with privately owned companies. More often than not, we find that as the economy slows, IT spending decreases as the focus tends to shift to revenue generating activities.

[Read the rest of this article...]

Microsoft Dynamics GP Users Summit Briefly Previews GP version 11.0

[Read the rest of this article...]

Is your Dynamics GP Database to Large? Company Data Archive can Help!

What is Company Data Archive? 

Company Data Archive (CDA) is a 3rd party tool for Microsoft Dynamics GP by Professional Advantage that provides an easy way to move historical information from your 'live' company to another 'archive' company. Archiving your data will reduce the size of your live company database and improve system performance while posting, running reports, performing file maintenance, and day-to-day use of Dynamics GP.

[Read the rest of this article...]

Hints for Resolving 20402/20406 Errors with Customized Screens in Dynamics SL 7.0

[Read the rest of this article...]

Microsoft Dynamics GP and Trinity Myridas are a Perfect Match for Food Distributors

[Read the rest of this article...]

Why are we here?

Years ago, when we started what later became NexTec Group people used to ask us – why are you starting a company?  There were two basic answers to that question. The first is that all of us had worked for other ERP consulting firms, and felt we could do better. Few VARs at the time offered much beyond basic implementation services for Microsoft Dynamics GP (formerly Great Plains), SL (formerly Solomon) and Sage MAS 500. Our plan was to offer implementation, programming, report writing, training and more. We’ve continued that tradition by updating our offerings with CRM, Business Intelligence, and Sharepoint, and we always try to offer a compelling mix of products and services to our clients.  If you can think of something we are missing, please let us know!

[Read the rest of this article...]

Streamline your buying process with GP Requisitions Management

[Read the rest of this article...]

[Read the rest of this article...]

Get Ready for Sage MAS 500 Version 7.2 Summer 2008!

Sage Software has announced the upcoming release of Sage MAS 500 version 7.2, which continues its strong tradition as an open SQL Server and Visual Basic platform for integration and customization. Scheduled for availability Summer 2008, MAS 500 Version 7.2 strengthens its technology leadership position by providing two new Microsoft .Net solutions, support for Microsoft Vista, and overall improved workflow and the user interface. In this article, we’ll focus on a couple of significant improvements and help you determine whether an upgrade to version 7.2 would yield benefit to your business.

[Read the rest of this article...]

What is MICR?

“MICR” stands for Magnetic Ink Character Recognition. MICR encoding is a process by which checks are printed using special magnetic ink and font characters to create machine readable information for check processing. As a check travels through the banking system, a reader-sorter machine sends a magnetic charge to the check which allows it to read MICR information very quickly and accurately. Because of this required magnetic charge, the Federal Reserve and all banks require that checks be printed with a special MICR toner (for the curious-minded, the special ingredient for MICR toner is iron oxide - an excellent trivia question next time you’re hanging around the coffee machine). Laser printers with a special cartridge are typically used to print MICR-encoded checks. Using a MICR solution can transform a blank piece of security paper into a complete check with date, payee information, logos, bank identification and the MICR line, along with automated signatures, if desired.

[Read the rest of this article...]

What is Collaboration?

[Read the rest of this article...]

What is Modifier with VBA?

[Read the rest of this article...]

Harness the benefits of Microsoft SQL Server Reporting Services for Microsoft Dynamics GP

[Read the rest of this article...]