It took me a while to get through the exercises again because of family vacation and Summer house projects. Hopefully I’ll be able to tackle the next exam, F110 Advanced General Ledger (V3.0), in less time.
I finally finished the data migration portion of the F100 Hands-On Financials (V4.0) course. Data migration is my least favorite portion of any implementation because:
- I think it’s boring
- It always takes much longer than you think it will
It took me a few late nights to finally get through this. There was some bad data in some of the import files that I had to cleanup in order for the import to go through successfully. When you import AP and AR open bills/invoices, the system automatically makes a journal entry which you then manually have to enter a reversing entry for. Also, the dollar amount of the imported items was $.02 different than what was in the Excel file which must have been due to rounding. I’m assuming that Acumatica put the errors in the import files intentionally so I could get some practice.
The next step is to schedule an appointment with an Acumatica instructor in order to review the setup configuration and data that I imported into the test company on my laptop. I sent an email to [email protected] requesting an appointment. We’ll see how long it takes for a response.
Tonight I went through pages 118-123 in the F100 Hands-On Financials (V4.0) course. Even though there were only a few pages, I spent quite a bit of time going through them (data import always takes a lot of time). The sample file that was created for import had some errors which made for good practice.
Overall, I like the import tool. First you create a mapping definition between your Excel file and the screen that you are importing into. Then you run the import. The errors appear next to each bad record, then you have the choice to fix the data in the screen or export it to Excel where you can make corrections and then re-import.
It’s a little bit of a pain to have to create a mapping definition between Excel and the Acumatica screen. Other import tools that I’ve seen just require Excel file to be in a certain format and then you import directly from Excel. However, the nice thing about creating a mapping definition is that you can re-use the definitions that you create. You can even schedule them to run on an interval, such as every night.
There are over 140 screens in the Finance area alone that can accept imports. That’s a lot of screens! Dynamics GP and Sage 500 ERP don’t have anywhere near that amount. I have to say though that I expected to see something like this from Acumatica because data integration is a key component of a typical web-based product philosophy.
You can also import for things other than Excel, such as another Microsoft SQL Server database, an ACH file from a bank, Salesforce, and XML. This makes the import routine very powerful as an integration tool since you always need to bring data in from multiple places when you are trying to make your ERP system the cornerstone of your business.
Next I will move on to importing other things such as Customers, a Trial Balance, etc. Hopefully I don’t get bogged down with errors as much as I did with the vendors. After I get through Data Migration, I will be finished with the F100 Hands-On Financials (V4.0) course.
Today I went through pages 69-117 in the F100 Hands-On Financials (V4.0) course. This section covered setting up the AP and AR modules. Lots of features to read through. I found myself using a couple of the keyboard shortcuts to save information and quickly transition to the next task. Here are a few things that stood out to me:
- Payment Lead Time – This is an AP feature that allows you to define the average number of days that a payment takes to reach a vendor. I assume that the Aging report will factor this when generating an aging. I haven’t seen this kind of feature before, although I’m not sure I would use it because lead times could vary greatly by vendor. We’ll see, maybe I will be able to override it at the vendor level.
- Default general ledger subaccounts – You have the ability to default GL accounts based on a combination of factors (4 bullets listed below). For example, if my subaccount structure was XX-YYY where XX is region (01 West, 02 Midwest, 03 South, 04 East) and YYY is department (000 General, 100 Sales, 200 Operations, 300 IT, 400 Finance, etc.), then I could put in a code of LL-200 to get the region from the customer/vendor and hardcode department 200 Operations. Or, I could put something like 03-EEE to hardcode region 03 South and get the department from the employee. I imagine that you could even put something like LE-LLE, although that wouldn’t make much sense. But, it’s nice that you can combine things.
- C – Expense account associated with branch
- E – Subaccount associated with employee
- I – Subaccount associated with non-stock item
- L – Subaccount associated with customer/vendor location
- Wiki help – I’m still very enthusiastic about this. In fact, it looks like the overview sections in the hands on exercises are captured directly from the Wiki help system. This is a good efficient use of the existing help. I’ve always been confused by software companies that create separate training material that walks you through each of the settings using different language than the help system. Hats off to Acumatica for not duplicating their effort here. I also tried making some modifications to the standard Wiki help and discovered (as expected) that is very easy to create custom tailored instructions. I can make slight modifications, remove entire sections, or insert blocks of customized help language. As I’ve said before, THIS IS A BIG DEAL.
I will be starting with the F100 Hands-On Financials (V4.0) course. Tonight I downloaded the material needed to complete the course. I will go through the 157 page .pdf file and setup a company from scratch. I like the from scratch approach. In the past I have worked with demo data when learning an ERP product, but it was hard to pay attention since the data was already created for me. I’m hoping that building a company from scratch will help me to stay more engaged during the learning process.
After going through the material, I am supposed to take an exam and then review the exam with an instructor. I like that I will be getting some human interaction during the process. This should be interesting…
However, before I begin the course, I need to get my hands on an installation of Acumatica. I sent an email off to the [email protected] email address to see if they can help. Maybe they will have a pre-built virtual machine?