Category: How Tos

5 Ways to get your ERP ready for an audit

As accountants the end of the year accounting is a big deal. There are a lot of factors that go into the prep to make sure that everything gets accounted for prior to closing the books for a year. The most important step to being audit ready is to be prepared. Typically the documentation requirements for audits do not change year on year so you can use your documentation from the prior year as a guideline to get started. Here are some steps that you can take to verify that you are ready to close your year as well as prepared for auditors to come in and evaluate your books.

May 11, 2015

PAYING EMPLOYEE EXPENSES BY EFT PART 3

In part 1 – We went thru the Steps to setup the Company EFT Information. In part 2 – We went thru the Steps to setup the Employee as a Vendor and the Steps to setup the Employee EFT Information. In this Section we will go thru the Steps to Generate an EFT PreNote File and the Steps to Enter the Employee Expenses.

April 24, 2015

Converting Purchases to Fixed Assets in Acumatica Cloud ERP

Acumatica Cloud ERP is one of the many ERP (enterprise resource planning) systems that contain a fixed asset module as part of the application. Having an integrated fixed asset module automates the management of a company’s fixed assets. The automation of this allows an organization to dump their convoluted Microsoft Excel Spreadsheet or Microsoft Access Database for managing the fixed asset process. Using a spreadsheet or database to manage your fixed still leaves you with making journal entries to record monthly depreciation expense and disposal of assets when they are sold or retired. You are also subject to errors during data entry not only of the journal entry itself, but also of the initial setup of the asset in the spreadsheet or database.

April 6, 2015

Why are my General Ledger Cash Account balance and my Checkbook balance different? Part II

In my last blog from February 2015, we discussed the variety of factors that can lead to your Checkbook balance and General Ledger Balance being different and what the corresponding results will be to both balances. In this blog, I would like to address the resolution for each of these issues.

April 2, 2015

How To: Modify Dynamics GP with Modifier and Dot Net

For years I have been creating customizations for Microsoft Dynamics GP using a combination of Modifier and VBA. This has always worked well for me in the past with a few quirks and hiccups in VBA from time to time. I have created simple additional fields on screens, complex logic to enhance our customers business and many other types of projects. All of this has worked well, been easy to upgrade to the next GP version and been basically stable code for many years.

March 26, 2015

Paying Employee Expenses By EFT Part 2

In part 1 – We went thru the steps to setup the Company EFT Information. In this Section we will go thru the steps to setup the Employee as a Vendor and to setup the EFT Information for that Vendor.

Step One – Create a Vendor Class – this class will be assigned to all Employees setup for Expenses

Go To Purchasing >> Setup >> Vendor Class

March 20, 2015

Demystifying The Modification Of Word Templates For GP

Prerequisites:

Once GP has been installed – Install the Microsoft Word Add-In from the GP Installation Disk. This will install the Default Word Templates and will add Template Maintenance and Template Configuration to the Administration >> Reports Window.

March 13, 2015

Publishing Web Client Blog

We recently had a requirement where a client wanted to be able to access the web client outside of their network from the web without having to use a VPN client. Microsoft’s installation instructions direct you to implement an additional server outside of your firewall to provide windows authentication. I am going to give you the steps to publish the web client outside of your firewall without the need of an additional server and you don’t need to use a VPN.

February 11, 2015

How to Balance Your Consulting Life Without Going Crazy

A long time ago I started a family and after taking some time off work completely, I was ready to get back to into the game. However, being a mom, I did not want to have a typical 9 to 5 job because I needed to be available to take my kids to school as well as continue to be the main caregiver. I eventually took a job doing consulting work. Consulting, to me, makes me think of having some freedom within your schedule and not the typical 9 to 5 hours. (A testament to this statement is that it is currently 9pm on a Monday and I am writing this. The down side is that I left my house to go to work at 7am this morning and am still working.) But I do enjoy my job. It consists of new implementations, software upgrades, training, and support. Something new that challenges me everyday. But the question still remains (and sometimes, I still struggle with) is how does one handle the process of juggling the demand of multiple clients, multiple projects, and a family life outside of work?

November 24, 2014

3 fundamental steps to build a Top Notch Software

Creating a software is an art, and here at KTL, we take it seriously!

Building software that meets business requirements is quite a tedious process. It involves various disciplines to come together in order to gather requirements, design, code, test and deploy. The journey of a software does not end here, in fact it is just set on a long sail and is expected to do its duty and perform here on. This is when the durability of the software is tested and it is rated as mediocre or class apart. I am going to discuss a few principles that we follow to make a software that customers want to ‘Take Home’ and ‘Keep’.

November 21, 2014