Tag: KTL Solutions

Uploading Journal Transactions in Acumatica Cloud ERP

Most of us have experienced the pain and agony of having to hand-key a very large, multiple line journal entry. You add G/L account number after G/L account number, debit after debit, and credit after credit. You get to the end of the very long journal entry press the save button only to find that your very long, multiple line journal entry is out of balance. So you start your quest. You go line by line comparing the numbers you keyed against your source documentation to ensure that all of the numbers have been entered correctly. If you’re lucky, you’ll find the data entry error in time so that the last thing left to eat in the cafeteria for lunch isn’t a cold grilled cheese sandwich.

Read More »
November 6, 2015

Real Time Data Warehouse ETL (Part 1)

Part 1 – Implementing Service Broker as a Real Time ETL Tool

The cheapest and easiest way to solve the real-time ETL problem is to not even attempt it in the first place, but we live in the real world and businesses are saying that:

·      Viewing yesterday’s data is no longer sufficient.

·      They need a faster reaction time to respond to threats and opportunities. 

Read More »
November 5, 2015

How are the Parature and Marketing Pilot Purchases for Microsoft Dynamics CRM Coming Along?

Last year, Microsoft unveiled a comprehensive set of new Microsoft Dynamics CRM capabilities by purchasing a social listening tool, a social engagement tool, a marketing tool, and a customer service tool.  This customer service tool, or “Customer Care” tool, Parature, and the marketing tool, Marketing Pilot, has been integrating into CRM for the last year and are now ready to help organizations match their customers to the right products and services, engage with them in the right way at the right time, and nurture their relationships.  

Read More »
November 2, 2015

Pumpkin Spice Lattes, Ugg Boots, Thick Sweaters, and … Falling Lead Numbers?

September marks the first month of Fall and man, do I love Fall. Pumpkin Spice Lattes, also known as PSLs, are available at the local coffee shops, Ugg Boots are acceptable to start wearing as the chilly weather comes in, and thick sweaters are being stocked in all the trendy clothing shops. We’ve made it through summer and the thick humidity and are now settled back in our offices from our last fling of summer vacations. Many marketing and sales representatives start to think that since summer and vacations are over, their lead generation will soon rise and the end of the year deal closings will be back at it. This isn’t the case though. Logically thinking, summer is the start to what I would consider a downward trend in the market.  

Read More »
October 26, 2015

WOW! A Dynamics GP multi-company Financial Dashboard

Dynamics GP can deploy some great Excel dashboard’s in GP2015 and Jared Hall created a awesome Financial Dashboard that you can download here.  The problem with all of these solutions is that most Dynamics GP environments are multi-company setups making these dashboards not very functional without navigating and opening multiple Excel spreadsheets to view each company’s dashboard.  So I took it upon myself to modify the one provided by Jared Hall to work in a multi-company Dynamics GP setup. 

Read More »
October 21, 2015

The Importance of Requirements Gathering for Software Projects

Requirements are an essential part of any software project and the foundation on which all projects should be built. The gathering of and compiling of requirements for a software project is very much a partnership between the user of the software and the developer. Obviously the customer or software user needs to communicate to the developer what they need, but at the same time the developer needs to be able to anticipate needs and ask the right questions during the requirements gathering phase of a project. 

Read More »
October 14, 2015

Why Did We Miss Those Requirements?

How does your end-user derive true value from the product/service you provide? The end-user doesn’t care too much if the product/server was delivered within budget or on-time. They are most concerned and get the best benefit as long as their requirements have been met in its entirety. 

 

Read More »
October 9, 2015

Whitaker Brothers Become Automated

Organization: Whitaker Brothers Business Machines, Inc.

Users: 20

Current Solutions: MSFT Dynamics-GP and MSFT Dynamics-CRM

Modules: Core Financials; Inventory; Purchase Order Processing; Sales Order Processing (POP/SOP)

ISV Products Used: K-eCommerce; Avalara; FieldConnect

Read More »
October 9, 2015