Category: ERP

Applying Payments to Invoices Billed in Foreign Currencies: MS Dynamics GP

Recently we have received a lot of questions about multi-currency transactions in MS Dynamics GP. Specifically, some of these topics are related to applying payments in functional currency to the sales invoice that was billed in the foreign currency to the customer. This blog will explain a step by step process of entering invoices in the foreign currency, and then, applying a payment to such invoice in the company’s functional currency.

June 4, 2014

Using SSAS (SQL Server Analysis Services) Data Mining to Automate Marketing Analysis.

Any good analysis depends on creating a customer profile with good data. For data to be good it will need to be cleansed, meaning when you look up State in your customer database table that MD is always the entry for Maryland. The collecting and cleansing of the data is the hard part or where most of the work comes into play. The information you need to collect depends on your type of business. For example, if you sell to individual consumers, you will want to know their age, gender, location, spending habits and income. If you sell to other businesses, find out what sector they are in, how big they are, how much they spend and what other suppliers they use. Once all the hard work of data collecting and cleansing is done it’s time to analyze the data.

May 30, 2014

How Microsoft GP Easily Tailors to Your Business without Sacrifices

Microsoft Dynamics GP thrives in the distribution community and is known for its strong financial capabilities. KTL Solutions has been fortunate to work with many distribution companies and has staff of consultants that are experienced in the industry. One client of ours in particular is a frozen food distributor. Our implementation paved the way for a success story for other distributors experiencing similar growth pains.

February 17, 2014

Create or Open a New Fiscal Year in Dynamics GP

As the New Year begins, many companies are finding that they can’t post transactions to 2014. In Dynamics GP, fiscal years need to be set up prior to making transactions for that year. To start a new fiscal year in Dynamics GP, follow these instructions:

January 29, 2014

Microsoft Dynamics GP 2013, 2010, and Dynamics SL Year End Tax Update

Year-end payroll tax updates are here from Microsoft. Before you close out your year make sure you update your system for the end of the year tax changes for Microsoft Dynamics GP 2013, 2010, and Dynamics SL.

January 7, 2014

4 Tips for ERP System Maintenance

The enterprise resource planning system (ERP) is the backbone for most organizations. They invest a lot of money in software, implementation and training costs related to their ERP systems to collect, track and report on critical business data. Once the system is in production and the organization is dependent on the results provided by the ERP system, a maintenance plan must be developed and documented to ensure the system continues to operate at its best.

November 22, 2013

Management Reporter 2012 RU3 Released

On November 12, Management Reporter 2012 RU3 was released. One of the biggest additions to this update is the inclusion of a web report viewer

November 14, 2013

Revaluation and reconciliation of A/R aging report to the A/R general ledger account

It is important to perform the revaluation process every month between sales and financial modules to make sure the company’s A/R aging report balances to the A/R general ledger account.

There are two steps in such revaluation process. First, we must revalue the financial series by going to Microsoft Dynamics GP—Tools—Routines—Financial—Revaluation.

October 21, 2013

Modify the look and feel of Dynamics GP by adjusting user preferences

In order to customize the look and feel of Dynamics GP for a particular user, user should log in to Dynamics GP and select Microsoft Dynamics GP from the menu and then choose “User Preferences.” The following screen will appear.

October 18, 2013

KTL Solutions Awarded the Acumatica Gold Partner Certification

FREDERICK, Md., Oct. 16, 2013 /PRNewswire-USNewswire/ — KTL Solutions, a leading provider of ERP, CRM, and business intelligence solutions, today announced that it has been awarded the Gold Partner Certification via the Acumatica Partner Program.

This accomplishment recognizes outstanding channel partners who have achieved the highest levels of customer satisfaction utilizing Acumatica’s cloud-based Enterprise Resource Planning (ERP) technology, and who demonstrate an in-depth knowledge of Acumatica’s enterprise solutions.