Friday, December 16, 2016

Steps to Pricing Your Imported Items

Distributors and manufacturers deal with landed cost every day. The Business Dictionary defines landed cost as “the total cost of a landed shipment including purchase price, freight, insurance, and other costs up to the port of destination.” Landed cost may also include other taxes involved in the shipment such as customs duties and VAT. Landed cost is an important factor in coming up with a pricing strategy for products manufactured. It is crucial for companies who import goods for distribution or raw materials for product manufacturing to understand how much landed cost is or how it should be calculated in order to gauge profitability and pricing margins. Here are the steps to pricing your imported items with careful consideration of the landed cost:
  • Ensure you have all your costs accounted for. This pertains to all costs associated with getting your products from the supplier up until they reach your warehouse. You will be surprised with all the costs involved in your shipment. These are just few of the costs you will encounter:
    • Freight charges
    • Handling fees
    • VAT
    • Payment fees
    • Custom duties
    • Document fees
  • Determine the landed cost. As defined above, your landed cost is the value of your goods, which is the supplier price multiplied by the rate of exchange (ROE), plus all the shipping fees, duties, ancillary costs, handling costs and associated costs.
  • Make use of this formula to determine you selling price: (Cost of goods x ROE) + freight and shipping costs + duties and fees + markup + VAT = selling price
However, if you are a company that deals with numerous shipments abroad twice or thrice every few weeks, tracking of the costs manually would take ages for you to finish. You would need an ERP software to make things easier for you. ERP Consulting LLC is a company that provides an ERP software, Microsoft Dynamics GP in Pataskala Ohio. Microsoft Dynamics GP is an enterprise resource planning (ERP) software systems for SMEs or small and medium-sized enterprises. It is a solution provided by ERP Consulting LLC to help businesses manage their financial transactions, inventory and operations. If you want to make use of the Microsoft Dynamics GP in Pataskala Ohio today, call ERP Consulting LLC at 740-951-0220 or email your queries at mtaranto@erpconsultingLLC.com.

Friday, December 9, 2016

Keeping Up with Microsoft Dynamics GP

Starting a business is not a piece of cake. The same goes for ensuring the business gains traction upward as soon as it is put in place. There are so many things to worry about aside from target sales are reached – there’s all the finance aspects you need to keep track of (employees’ wages, budget, operational expenses, etc.), inventory of products and services, customer support, payroll, and so many more. In order for new businesses to grow, they need a tool that will aid them in various aspects of operations. ERP Consulting LLC recommends the use of the Microsoft Dynamics GP in Pataskala Ohio. Microsoft Dynamics GP is a software solutions that helps small and medium-sized enterprises with their financials, inventory and operations. In summary, the software empowers businesses to:
  • Manage finances and accounting

    With account-level security, it is now safer and more convenient to manage and keep track of all details of monetary transactions.

  • Manage inventory

    To know what’s going in and out of both virtual and actual shelves, the tool gives you the power to track deliveries, orders, refunds, lacking stocks and vendor details of various products.

  • Manage sales and service

    The tool helps you manage all sales transactions and all contracts made with clients, vendors and other resources.

  • Track updates and growth

    It aids you in coming up with the data for the company’s performance in terms of sales as well as various teams’ performances on the field. It is specially designed to include analytics that will provide a visual representation of the company’s performance as a whole.

  • Manage employee profiles and payroll

    You get to input all your employees’ profiles as well as encode details for their payroll. It’s a one-stop shop for HR personnel to help them manage details of all company employees.

If you want to enjoy the benefits of having to use the Microsoft Dynamics GP in Pataskala Ohio, give is a call at 740-951-0220 or email us at mtaranto@erpconsultingLLC.com.

Tuesday, November 22, 2016

Does Your Business Need ERP Software? (Part II)

Because having the need to assess the performance of our business is a must, ERP Consulting LLC, an expert of utilizing Microsoft Dynamics GP in Pataskala Ohio, wants to share with you additional warning signs if your business processes are in need of a quality and reliable ERP software. So without any further ado, here are more signs and symptoms if your business needs ERP Software.
  • Impressing the customers are now almost impossible

    A growing business is the dream of every business owner alive but when the company grows, it will be harder to reach out to the needs of each and every one of the trade’s customers.

    If you are the customer, you want things fast because you still have other things to do. Making these important clients wait in line or delivering their goods and services late is a crime. What better way to keep the production, services and even delivery fast than to go for Microsoft Dynamics GP?

  • Having an awfully complex and time-consuming IT

    One of the biggest letdowns of having loads of systems across your business is when the IT management becomes an outlandish battlefield. Having to customize a system, while integrating and maintaining them at the same time, is easier said than done.

    Rather than going for more software to use, why not utilize one that is efficient in becoming all of those software. Such is the wonder of using Microsoft Dynamics GP. It will not only save you the complexity but also the time needed to process everything.

Being in a business takes a lot of time and experience. There are times when your methods prevail and there are also moments when these procedures fail. All business owners need to stand the demands of time. But in a world lead by technology, we can now go beyond our capabilities through utilizing various devices to make our production, sales and services faster and more proficient than ever before. If you have ever experienced the troubles we listed above and on our previous blog, you need to switch to an easier and more effective system, which is the ERP System. But what is the most suitable program to use? ERP Consulting LLC recommends you to go for Microsoft Dynamics GP, a steadfast ERP System that only fails if you do not give it a chance. Speaking of giving this program a chance, you can ask us for help if you find using it difficult. We are available 24/7 if you access our website at www.erpconsultingllc.com.

Does Your Business Need ERP Software? (Part I)

Now that your business is growing and many people rely on you for employment, different kinds of problems start to emerge. Rather than being solid figures, the forecasts of your sales will be more inclined to your instincts and guesses. The order volumes coming in and items going out to be delivered seem annoyingly endless. Your warehouse looks more of like a junkyard and you do not have any clue and do not want to have an idea about the quantity of your inventory. If you have lost most of your sleep and peace of mind trying to figure out what is wrong with your system, then you should start venturing on the ERP Software. Read on down below to discover what are the different signs and symptoms your current business venture has in order to remedy it with the ERP system.
  • Having diverse software to process your transactions and productions

    If there are a variety of systems and programs that run wild in your business’s processes, you need to consolidate them in one method so that you and your employees can record transactions and go about work smoothly.

    Microsoft Dynamics GP, the ideal ERP software for your trade, has the capability to function as different kinds of systems and processes so that your business function will only rely on one database. With this, you do not have to go about hopping from one software to another.

  • Obtaining easy access to different data about your business still remains a problem

    Are there times when someone asked certain information about your business, let us say your sales margin, and you panic as you search in the vast sea of information stored in your system? And when you do find the needed info, you found out that you wasted a lot of minutes or even hours looking for it.

    With Microsoft Dynamics GP, the pace of your business will be a hundred times faster.

  • Accounting takes forever to process One technique to know if your trade needs reliable ERP software like Microsoft Dynamics GP is to check on your accounting department. Do your employees find the process difficult? Are the clients waiting in a long line? Step up your game. You do not have to keep everything manual. Get them automated!
Those are just some of the signs and symptoms you need to look out for in order to tell if you need to level up the way you do business. If you have questions on how to use Microsoft Dynamics GP in Pataskala Ohio, ERP Consulting LLC is the right mentor for you. Go to our website at www.erpconsultingllc.com.

Monday, November 14, 2016

Technical Support: Why Is It Beneficial for Businesses?

A business can’t be called a business when there’s no product/service offered to the customers. Every business should have something to offer to the customers to operate and legally call it a business. But, what if your products, particularly those technical-related products, get into trouble? Who’ll face and help your customers? Will you just leave them alone since you already got their payment? You, and all business owners, shouldn’t leave customers behind, as they’re one of the keys to your success and they can provide a big impact to your business’s reputation. This is where the importance of having a technical support team comes in. Every business requires a support team to address or help the customers on their different concerns about a certain product/s you sell. Here are some of the benefits of having a professional technical support team:
  • Improves Communication. Businesses won’t be as effective when there is no relationship built with the customers. Customers are one of the sole contributors to any business’s success. Hence, it is undeniably vital to build strong relationship with them through constant communication. With a proficient support team, you can help build a good relationship with your clients or customers.
  • Modern IT Solutions. When your products are IT or technical-related, it would be best to also have a support team that specializes in that field in order to provide better and much modernized IT solutions to your customers and even to your business.
  • Accessible Support. Anytime, a product can get into trouble. Hence, with a good technical support team, they, in your behalf, will be able to provide 24/7 services to your customers.
  • Lesser Expenses When Outsourced. IT maintenance and troubleshooting can be costly and can affect your services as well. This is why outsourcing IT support became a good decision for business owners as they can get rid of these costly expenses and still provide better services.
  • Optimization and Repairs. In a company, not all people are IT-knowledgeable. Hence, when something goes wrong in the office regarding IT stuffs, the productivity and services will surely be affected. When there is a good tech support team, help will immediately be given when something bugs down an IT stuff.
ERP Consulting LLC, a leading provider of Microsoft Dynamics GP in Pataskala Ohio, gladly offers Technical Support for businesses in need. We have highly professional and warm staff who can help your business reach its goals with less hassles on the support side, and others. Let ERP Consulting LLC help you and your customers or clients! Give us a call at 740-951-0220 today or visit www.erpconsultingllc.com to know more about the services we can offer.

Some Important Factors to Consider behind Total Landed Cost

Every business owner should know well about all the happenings in his company, from product manufacturing, purchasing, shipping, and any other processes that may complete their business. Mostly, total landed cost comes in the way and every businessman should know what factors or elements it is composed of. Let us take you a little bit closer about total landed cost and the factors linked to it. What is Total Landed Cost? Total Landed Cost or TLC is considered a vital computation that concerns every supply chain. To explain sensibly, total landed cost is the overall costs rendered from the manufacturing and product delivery up to the extent where you generate revenue from those products. Relying upon the field of industry you are in, the factors behind the total landed cost will significantly fluctuate. The main idea why total landed cost should be computed is to know both the visible and invisible expenses concerning the supply chain. When you are well knowledgeable of the accurate cost of a certain product, then you’ll be able to make wiser decisions on your future product investments. Here are some factors behind total landed cost:
  • Base Rate – this is the most fundamental cost you need to pay for the things or materials you will be or you’re sourcing. Base rates may change without prior notice due to certain reasons.
  • Delivery Expenses – the delivery expenses may cover both foreign and domestic shipping or transportation costs, including immediate line haul. You may also need to consider the variation of forex rates.
  • Administration and Overhead Costs – these expenses are usually the ones which are often neglected or missed during the computation of total landed cost. Overhead may cover stuffs like labor costs and more.
  • Compliance and Risks – satisfying all the rules and regulations with regards to trading policies may as well need you to spend. Also remember to include the risk of disruption of supply chain, particularly if you are dealing with unfamiliar or different offshore partners.
Here at ERP Consulting LLC, a topnotch provider of Microsoft Dynamics GP in Pataskala Ohio, we can help you understand more about total landed cost and everything linked to it. We can even provide better solutions for you to achieve success in the most efficient way. We can be your most proficient partner when it comes to the growth of your business. Give us a call today for a comprehensive consultation with our professional staff. Dial ,740-951-0220.

Monday, October 10, 2016

What is Microsoft Dynamics GP?



Microsoft Dynamics GP is a complete ERP package for you growing organization. With Microsoft Dynamics GP, your organization will be able to make the most out of time, money, people and other resources by streamlining your business processes and functions. For detailed consultation about this wonderful business tool, it is best to contact or visit experts such as ERP Consulting LLC, which offers consultation on Microsoft Dynamics GP in Pataskala Ohio.

Let us try to peek into some capabilities that Microsoft says about Microsoft Dynamics GP, which includes flexible and familiar tools necessary to keep your organization growing.

Financial Management and Accounting
Microsoft Dynamics GP will help you manage your organization’s cash, assets, and banking. With enhanced security features, the system allows you to do budgeting and analytical accounting without worrying of data and information leaks. Sophisticated yet easy-to-use features on cash flow management and assets management will be of great help to any organization.

Inventory Management and Operations
With this complete ERP system, it is easy to track and manage production, inventory, orders, and vendors. From receiving orders, to checking inventory, to processing those orders and managing returns, Microsoft Dynamics GP is designed to make the process smooth and painless.

Business Intelligence and Reporting
Make use of previous and current transaction data and results to get real-time visibility and analytics. This will help to track performance and will allow the organization to act with insight. No one wants to repeat the same mistake, but everyone wants to repeat the same successes. Allowing your organization to do precisely that is among the strongest points business intelligence and analytics that comes with Microsoft Dynamics GP.

How to Get Started
Consult now with ERP Consulting LLC, which offers consultation on Microsoft Dynamics GP in Pataskala Ohio. We are dedicated to offer you with the best advice and solutions for the ERP needs of your growing organization.

For more information on Microsoft Dynamics GP in Pataskala Ohio, please contact or visit us anytime at ERP Consulting LLC. We are always ready to assist.



Businesses and ERP



Businesses like ERP Consulting LLC, an expert on Dynamics GP in Pataskala Ohio, have become a great help for organizations wishing to adopt an ERP system. What is ERP and why are organizations very eager about it?

The Typical Process
In a typical business operation, when a customer calls for an order, it first goes thru the sales department, which then checks the inventory for product availability.  If no product is available, it will contact the production department, which would check the inventory for the materials and buy the unavailable materials from a third party vendor. When the product is finished, the sales department will then deliver the product to the customer. After the transaction is done, all the financial reports of the sales department and production department will then be submitted to the finance department for records of sales and expenses. It is a long and complicated process, which is also prone to errors and miscommunication between departments.

What is ERP?
ERP helps eliminated all these problems and gives your business an easy and smooth flow of operation.

ERP or Enterprise Resource Planning is a system, which manages the information of your business in a centralized manner. It integrates units of your business needed in the operation, which are product planning, manufacturing, marketing, inventory management, and shipping and payment.  Also, all the information goes through the system in a (or nearly) real-time basis thus avoiding data duplication and provides accurate information to all departments.

How does ERP work?
So, how would a business using an ERP system work?

When a customer calls for an order, sales department will just check the real-time information stored in the centralized system and can inform the customer whether the product is available or not.  And since all the departments have access to the centralized system, unavailable products can be manufactured faster which can lead to increase in sales and improved customer relations.

Here at ERP Consulting LLC, we can assist you on how to implement Dynamics GP into your business. We are an expert on Dynamics GP in Pataskala Ohio. For ore information about ERP and Dynamics GP in Pataskala Ohio, please contact of visit us at ERP Consulting LLC. Let us help you find the best

4 Benefits of Microsoft Dynamic GP’s Collection Management

Collections can be a really tedious process and, when mishandled, can cause a major financial trouble. Good thing, Microsoft Dynamics GP, a solution that we, at ERP Consulting LLC, a company that implements Dynamics GP in Pataskala Ohio, has a feature called Collections Management, a tool that will streamline collection process and reports.
 Here are some of the ways your company can benefit from the Collection Management system:

1. Decrease DSO
Days Sales Outstanding (DSO) is a necessary statistic in determining your Accounts Receivable, the money debtors owe you. DSO determines your sales and how fast you get paid for it, therefore it’s a way to know how efficient your collection process is. Microsoft Dynamic GP’s collection management feature will help you keep track of it in order to easily realize your Return of Investment.

2. Keep Payments History and Notes Centralized
Collections Management has a centralized area for tracking notes, arranging follow-ups, and setting actions on invoices. With Microsoft Dynamics GP, everything is there, from creating actions to keeping histories and notes on customer invoices. Having a centralized area for contact and collections information will boost your company’s efficiency.

3. Automate Follow-Ups and Collections A feature called “Collections Plans” will suggest all the customers you need to contact, as well as, automate all the steps in the collection process. It helps reduce your time searching for customers, creating e-mails, and manually attaching invoices. This system has a sequence of actions that are automatically suggested according a particular invoice’s due date. With this, you will significantly reduce the time to be allocated in organizing data and communicating with your clients, and be able to concentrate on other aspects of your business.

4. Simplify Reports Generation It provides a summary of Account Receivables and enables you to view information by collector, by national account, or by a group of customers. It also includes “SmartList”, a tool to dissect data, and a performance report for every collector. All these things will deal with the problems that customers have and the inefficiencies of the collectors.

The points above explain how the Collections Management feature of Dynamic GP, a business solution that we offer here, at ERP Consulting LLC, the leading source for Dynamics GP in Pataskala Ohio, enables you to enhance your cash flow and prevent financial mismanagement resulting to bad debts. Timely collection of receivables is very important in business as it promotes better cash flow. With Dynamics GP, you can be sure to have a more efficient and productive collections process. To get Dynamics GP in Pataskala Ohio, schedule an appointment with us, at ERP Consulting LLC, anytime. Call us at 614-207-1782.

Thursday, September 29, 2016

How to enter a wire transfer in Dynamics GP for Wire Transfers



Go ahead and perform the wire transfer thru your bank.  Then in GP use the manual check entry.  After entering the date and vendor id select payment method of Cash.  Enter the checkbook .  After entering the amount you can click on the apply button and apply this payment against the invoice it is paying that is already in the system.

How to correct costs on Key2Act jobs

To correct postings to jobs in Key2Act job cost you will use the GL General Journal entry. You can use this to add costs to jobs, transfer from one to another or to remove the cost from the job.

1) To add a cost to a job – When you get to the product indicator select job cost then the job and cost code. A debit will increase the cost to the job. You will then select unbilled for the second line and select the GL account that the transaction had been posted. Probably would be a cost of goods sold or subcontractor.

2) To transfer a cost from one job to another - When you get to the product indicator select job cost then the job and cost code. Enter a credit transaction to reduce from a job. Then on the second line on the product indicator select job cost then job and cost code. Then enter a debit balance. This will add the cost to this job.

3) To reduce a cost to a job - When you get to the product indicator select job cost then the job and cost code. A credit will decrease the cost to the job. You will then select unbilled for the second line and select the GL account that the transaction had been posted. Probably would be a cost of goods sold or subcontractor.





Monday, September 26, 2016

The report has a reference to a dimension called main account category using Management Reporter

I was trying to run a report for a client in management reporter. I received and error I had not come up against. The message was the report has a reference to a dimension called main account category. I then looked at the row definition and found that it referenced not only the GP categories but also had a column referring to AX.






To fix this I opened the row layout. I then went to edit - row links and deleted the reference to AX. Report ran fine. Hope this helps.

Tuesday, September 20, 2016

Highlights of Microsoft Dynamics GP

Microsoft Dynamics GP, the solution we promote here, at ERP Consulting LLC, a trusted consultancy firm that implements Microsoft Dynamics GP in Pataskala Ohio, is an accounting software and ERP solution that is designed to meet the needs of companies, especially the small and medium scales, to make their systems more efficient and help their business grow successfully. Microsoft Dynamics GP helps improve every aspect of your business, including financial management, supply chain management, reports, smart decision-making processes, and more.

Microsoft Dynamics GP is packed with features, familiar and new, that meets all the needs of your business to grow and improve and that is why we, at ERP Consulting LLC, choose to promote Microsoft Dynamics GP in Pataskala Ohio for our clients to have the best ERP solution for their businesses. The following are some of its key features:

Familiar and Easily Adaptable

Microsoft Dynamics GP provides you with robust out-of-the-box functionalities that are very easy to learn and use as they are designed similarly and works with other Microsoft applications that people, and your employees, use every day, such as Outlook, Word, and Excel.

Boosts Productivity

Microsoft Dynamics GP allows you to integrate and automate all your financial and operational processes quickly and smoothly. As a result, the ability of your employees and customers to exchange and share data will be greatly enhanced. This boost in productive is mostly because of the following reasons:

  • It is highly scalable, with a proven scalability to at least 1,000 users and provides you with robust functionality across financials, manufacturing, service, distribution, and integrated Customer Relationship Management.
  • Recent Studies conducted by Nucleus Research show that 87% of the clients implementing Microsoft Dynamics GP achieved a positive Return of Investment from their deployment.
  • The software provides users with an individualized and role-based experience so they don’t have to worry about learning more things other than the navigations and functions relevant to their tasks which would otherwise be a waste of training time and costs.
  • It provides the users with detailed and up-to-date reports, as well as notifications on what specific actions they have to perform, in order for them to make smart decisions quickly and effectively.
  • Every single record and information can be sharable to avoid miscommunications and conflicts.
Enables Better Decision-Making

Because it provides the administration and decision-makers great visibility of the business and all the processes involved, it will enable them to make smarter decisions towards improvement and efficiency of the business.

Managing and growing a company can be simpler, having an ERP solution that provides you will all the major assistance you need. To get Microsoft Dynamics GP in Pataskala Ohio, you can set an appointment with us, at ERP Consulting LLC, by calling 614-207-1782.

Advantages of Microsoft Dynamics GP vs. Other ERP Solutions

Today, there are a number of ERP software available in the market. However, to promote your business’ growth and efficiency, it is imperative that you choose the best ERP solution that will provide you and your employees with features and functionalities that altogether brings in productivity and company growth. That is the kind of business solution provided by Microsoft Dynamics GP, an ERP Solution we implement for our clients at ERP Consulting LLC, a reliable consultancy firm that implements Dynamics GP in Pataskala Ohio. Here are some of the features that makes Microsoft Dynamics GP better than most of its competitors.

Variety of Deployment Options

Unlike most ERP solutions that only offer one deployment option, which is not very appropriate for a growing or constantly changing company, Microsoft Dynamics GP will let you control your deployment options and data. You can decide between running your system in an on-demand environment or on-premise, and even a combination of the two. Furthermore, you can decide to change the deployment option of your choice any time, bringing your data with you, if your business requires it.

Comes with More Powerful Functionalities

Compared to other ERP solutions, Microsoft Dynamics GP has almost all of the applications needed by companies for them to have a great advantage. These applications include Payroll, Budgeting, Fixed Assets, Manufacturing, Project Costing, and Multi-National Accounting.

Complete with Customization Tools

Microsoft Dynamics GP gives you a wide range of customization options, beginning from end-user customization to system integration and customization, unlike other ERP solutions that will disable you from controlling neither the software nor your data.

User-Friendly

Microsoft Dynamics GP has a familiar design that is similar to and works like other Microsoft Office applications, such as Outlook, Word, and Excel. This will enable the users to be comfortable and familiar with the software, increasing the rate of their adaption to the new system and reducing training time and expenses.

Larger Number of Certified Partners

Unlike most of its competitors, Microsoft Dynamics GP has more than 2,000 implementation partners worldwide, including us, at ERP Consulting LLC, a trusted firm that implements Dynamics GP in Pataskala Ohio, so you can be sure that you will have the quick and quality support you need before, during, and after the ERP deployment.

Those are just some of the things that gives Microsoft Dynamics an edge over any other ERP solutions. If you are looking for a company that implements Dynamics GP in Pataskala Ohio, look no further than ERP Consulting LLC and we will surely give you the support you need. Call us at 614-207-1782.

Thursday, August 25, 2016

Reasons to Switch to an ERP System




Every business needs a solid and streamlined system, whether it’s a start-up business or multi-national corporation. Most businesses have acquired ERP or Enterprise Resource Planning to improve and streamline their business processes. Agencies, like ERP Consulting LLC offers ERP software such as Microsoft Dynamics  to aide businesses in changing their current management system. ERP software Microsoft Dynamics  can greatly benefit companies in driving towards a more unified system.
If you are still hesitant in upgrading your system to an ERP system, you should consider the following factors:
  1. You use various software for different tasks and processes.
The ERP system if very useful when it comes to running various front and back-end systems separately. This will ensure smooth and accurate processing. Integrating an ERP system into your business will allow you to integrate various processes so that every business function relies on a single database. With one source of information that contains accurate, real-time data, an ERP solution helps staff make better decisions more quickly.

  1. You need quick and easy access to all facets of your business.
The pace of business is quick and relentless, which means your employees need immediate access to key data. With an ERP system, executives and supervisors can get a holistic view of business operations at any time, while other staff can get the information they need to do their jobs more effectively.

  1. Accounting tasks take longer and is complicated.
The first department that indicates that your company needs ERP software will come from your accounting department. With an ERP solution in place, your employees won’t need to rely on paper-based invoices, sales orders, purchase orders, etc. Countless hours won’t be wasted manually inputting this information into various accounting and sales systems. This bodes similar to financial reporting. Consolidation and reconciliation of financial information across a wide system will be swifter and straightforward.

  1. Sales, Marketing and Customer services are compromised.
With an ERP system, employees are able to easily access updated information about services and client information which will enable business front-liners to immediately and accurately address customer needs and queries. Better yet, customers should be able to simply go online to their account and view status information.

Aside from the obvious reason of being able to run your business hassle-free and smoothly, acquiring an ERP system such as MicrosoftDynamics GP

 will greatly benefit your employees and customers. It’s a system which helps provide holistic solutions to age-old issues. We at ERP Consulting LLC want to become your trusted partner and contribute to your business growth and success.


Monday, August 22, 2016

Account Modifier and Combiner in the Professional Tools Library




I was using the GL account modifier/combiner today and was having trouble importing the changes of 83 accounts.  It would validate properly but when I clicked on modify it returned quickly and prompted to convert. The convert worked for about 2 seconds, a little too fast to combine 83 accounts. I then found in the instructions (no I didn’t read it first) I see that the changes get put in a table called TACHANGE. Nothing was there. After reading the instructions it tells me to create a text file. That was the key. Not a comma separated text file but a tab separated using the extension .txt. I didn’t try to rename a CSV to test to see if it works. Anyway, in case you hit the same issue.

ERP Consulting, LLC Upgrading To Dynamics GP 2016


Upgrading To Dynamics GP 2016
To begin the upgrade for the customer you will need to download the GP 2016 code.  Currently it can be found on Partnersource using the following link.
You may want to check back from time to time on this GP 2016 upgrade page.  It contains the upgrade paths and other materials you may find helpful.
Current upgrade paths are from 2013 and 2015
Upgrade Paths
Upgrading From
Patch Requirement for the Microsoft Dynamics GP 2016 Upgrade
Notes
12.00.1826
January Hotfix
KB 3030071
​RTM or later
Version 16.00.0371 or later
14.00.0725
R2
KB 3063038
​RTM or later
Version 16.00.0371 or later
​​Release 2013 Service Packs
Release 2015 Service Packs

Before you start make sure there is a current SQL backup.  Then go to the customization maintenance window to backup your customized reports and forms.  The following screen shot shows you the menu to go to.  It will create a package file for later import into your new GP 2016 instance.

At this point I usually go out to Partnersource to get my clients registration keys.  When you go to partnersource up in the upper right corner you will see a link called, PartnerSource Business Center.  This will take you to the following screen so you can look up the customer to get their keys.

Now it’s time to start the installation of the software.  In the directory that GP 2016 was extracted in double click on the setup.exe file.  The following window will pop up for you to continue.  Click under the Install portion “Microsoft Dynamics GP”.  Follow the prompts accepting the defaults until you get to the SQL server screen selection.
On this screen you will select the existing SQL Server.  If this was a brand new install you can provide a system database name (DYNAMICS) or another name if using the multi-tenant functionality where you may want two instances of GP on the same SQL Server. Click next and let the wizard complete the install.  You will get a windows when complete and simply press exit.

Now you will want to start up GP Utilities.  Login using the sa login and password.  This is the window you will get telling you that this is a new version and have to upgrade.
After the system updates the Dynamics database you will be presented with this screen showing all companies that need upgraded. Leave all the boxed checked and select next.  This will proceed to upgrade all the companies and may take some time depending on the number of databases and their respective size.  

After this you can launch GP 2016.  The first time you login you will use see a message in the lower left “Updating SQL Get Messages”.  This happens on the first time launching GP on this workstation.
After starting up GP you should enter the new registration keys.  This is found under the Administration window.
Enter the keys that you found on Partnersource/Customersource. Click on the validation button to make sure you entered them properly and you will see the modules you are registered for checked.  Some may be unchecked if previously unmarked as you may not want the items used.






Finally you can import your customized forms and reports. As previously shown go to the Microsoft GP button and select tools – customize-customization maintenance.  Click on the import button.  Browse out to your package file location and select.  This will import all records in that file.  There is no option to pick and choose. Make note of where your reports.dic file is so that it may be shared with all other users.  You would edit the launch file (Dynamics.set) and point to the shared file.  

That completes the GP 2016 upgrade.  You can then proceed and repeat the steps to upgrade all workstations.