Workshops

Click the workshop link of interest below to jump to the workshop details and dates. 2019 Schedule coming soon.Want a workshop specific to your company at or off your site? Complete the form below and we will get back to you.

Will you get something out of these courses?

Wow, I attended ‘Getting Under the Covers with Infor Visual ERP Using MS Excel’ and this 1 day changed my life. I have been able to save 1 day in my month-end by creating queries versus downloading reports and manipulating in Excel. And I am just getting started. It is the best money I have ever spent on training. Thanks so much for a great day and all the useful tools. Other Testimonials.

Deb Gillies, VP Finance, Assa Abloy

All open enrollment courses are held at Rattlesnake Point Golf Club in Milton, ON and include:

A comprehensive binder of course content that can also be used as a reference manual

Canada-Ontario Job Grant

One of our customers received funding for 80% of the cost of our training program (all 5 courses). We customized a 3 day on site course for a customer who also received a significant amount towards the cost of the 3 day course. Do you qualify? Take a look it is free. http://www.tcu.gov.on.ca/eng/eopg/cojg/

“Great class! Learned a lot about inventory costs, auditing and potential problems and most important how to correct the majority of these problems. Loved learning the query tools, how to look up items and in which tables. Appreciate the audit tools and month end checklist. Also picked up a lot of great tips along the way in discussions and examples from others as well.”

Have you ever wondered where the GL accounts are coming from in Visual?

Have you ever had to explain the costs in Visual but couldn’t find where they were coming from?

Have you ever had trouble reconciling your inventory accounts?

If so, then this course is for you. This is a hands-on two-day course where you use your database to learn the concepts. Actually, that’s not entirely true. You use your test database so that you can learn in a safe environment.

What will you learn?

The building blocks behind Visual’s costing

How and when costs are updated

How the journals are created

Where Visual looks in GL accounts

What exactly does costing utilities do

The costing settings and how they impact creation of the journals and subledgers

Visual’s 9 inventory audit tools:

How & when to run them

What each report is telling you

Step-by-step solutions for fixing your exceptions

General Ledger Accuracy

Ensuring the General Ledger accounts are assigned properly in Visual’s maintenance tables

Finding incorrect postings to the inventory accounts- and how to fix them without making General Journal Entries

Check the 5 different places where users sometime inadvertently use an inventory account

Running Cost Analysis Tools to find missed postings

Inventory Reports

How to ensure your inventory balance report is accurate by finding the 7 potential problems with the report

Comparison of the Inventory Valuations versus the Inventory Balance Report

Keeping Cost Layers in Sync

Using 3 different Visual tools to ensure your FIFO Layers are accurate and in balance

At least 6 sets of queries to look deeper to find potential problems

The Solutions

We will go through each of the various queries, audits, checks and balances and show you how to fix these permanently.

We will help you know what tool to use and how to use them. You might need VMFIXOHQ or maybe VMFIXWRK.

You will know when to run Recalculate Distributions and when to run FORCE FIFO.

What will you get?

Manual with over 120 pages full of instructions

Detailed procedure for updating standard costs

5 modified Visual reports to make inventory reconciliations easier

3 sets of queries for quick comparison of the General Ledger and Inventory Subledgers

Flowcharts for problem solving Visual’s audits

12 queries you can run to look for balancing problems in your database

The one-page wonder showing the various audits with the recommended fixes

After the course:

You may have questions. Do you need further clarification of a topic? Or you may have a specific business need that needs to be addressed. Each company will have a 1-hour one-on-one call. This can be used anytime for any topic. It doesn’t even have to be related to the course. Your choice. All I want to do is to help “You love Visual as much as I do”.

Who should attend?

Users of any version of Visual’s Enterprise. Specifically:

CFO’s

Controllers

Accounting Managers

Assistant Controllers

VP’s of Finance

Business owners

Anyone wanting to know more about Visual Financials

Are you intrigued? Excited? Can’t wait to learn? Then please sign up and join us for:

“Visual Hide & Seek: Inventory Reconciliation with INFOR Visual ERP”

On Wednesday, Sept. 12 and Thursday, Sept. 13

from 9 am ‘til 5 pm each day

If you are extra anxious to learn, let us know now.

If we get 5 people on our waiting list we will move the course date up.

Kim Worrall, CA, CPA is a Visual ERP Application specialist and owner of Back To Basics headquartered in the Greater Toronto Area. Kim has spent over 20 years consulting with Visual Enterprise, with an in-depth focus on all aspects financial. From costing to reporting to processing transactions as efficiently and accurately as possible. Kim is obsessed with how Visual works. She combines her healthy obsession, her thorough understanding of Visual’s functionality and tables, her puzzling skills and down-to-earth communication style to help companies get the most out of their Visual ERP.

Kim likes to share with her monthly Visual ERP Tips & Trips and monthly Blogs on all topics Visual. Her life’s objective is “To help others Love Visual as much as she does”.

Under the Covers with Visual ERP Using MS Excel Query

_________June 2018 November 2016June 2016September 2015

“Wow, I attended ‘Getting Under the Covers with Infor Visual ERP Using MS Excel’ and this 1 day changed my life. I have been able to save 1 day in my month-end by creating queries versus downloading reports and manipulating in Excel. And I am just getting started. It is the best money I have ever spent on training. Thanks so much for a great day and all the useful tools.”

This one-day hands-on course will educate you on querying your Visual database using MS Query tool. You will get to create queries linked into your database to get information quickly. Just imagine, clicking a button and the Inventory Balance Report appears. The query is refreshable. Build them once. Use them over and over again. This can be for all kinds of data in Visual.

What will you learn?

The tables that store the data from your favourite Visual windows

How to connect multiple tables to get the answers you need

The 5 most common gotchas to avoid when creating your queries & reports

Use of criteria and sorting to enhance the data pulled from Visual

How to use Excel functions (lookups, sumif and pivot tables) to take your skills with Visual data to the next level

During the course you will:

Have time to build at least 2 queries specifically for your database. You decide what you want to do.

Connect to two time-saving queries that I have already built for your use.

Month-end Inventory Balance and

Month-end WIP Balance with some extra treats to ensure the data is more reliable

Get to spend time sharing ideas with other Visual users.

What will you get?

A detailed manual with over 50 pages full of instructions

20 queries that have a proven track record of keeping your data accurate- all you need to do is connect them to your database

1-year membership to the Query of the Month Club where you will receive unique and useful queries

Electronic Data Dictionary with identification of most commonly used Visual tables

Inventory and WIP Balance queries for month-end processing

After the workshop:

You may have questions. You may have trouble with a query back in your office and just need some help tweaking it. Each company will have a 1-hour one-on-one call. This can be used anytime for any topic not just queries. Your choice. All I want to do is help “You love Visual as much as I do”.

There is nothing more satisfying then being able to get to your data more quickly so that you have better answers and understanding of your information. Put this in Excel, a tool, we know and love. Who could ask for more?

Sound like fun? (I guarantee, we will have fun). Please join us for “Under the Covers with Visual ERP & Excel” on: Wednesday, June 20

Who should attend?

Users of any version of Visual’s Enterprise. Specifically:

CFO’s

Controllers

Accounting Managers

Assistant Controllers

VP’s of Finance

Business owners

Anyone wanting to know more about Visual Financials

Kim Worrall, CA, CPA is a Visual ERP Application specialist and owner of Back To Basics headquartered in the Greater Toronto Area. Kim has spent over 20 years consulting with Visual Enterprise, with an in-depth focus on all aspects financial. From costing to reporting to processing transactions as efficiently and accurately as possible. Kim is obsessed with how Visual works. She combines her healthy obsession, her thorough understanding of Visual’s functionality and tables, her puzzling skills and down-to-earth communication style to help companies get the most out of their Visual ERP.

Kim likes to share with her monthly Visual ERP Tips & Trips and monthly Blogs on all topics Visual. Her life’s objective is “To help others Love Visual as much as she does”.

Visual ERP Controller & Beyond for Infor Visual ERP

This is a hands-on course where you get to use your database to work with the new concepts. This course will help you make better use of Visual ERP by taking advantage of functionality not commonly used and make creative use for functions you already know. We will also address aspects of Visual that can cause problems with your reporting and reconciliation. The overall objective is to save you time, provide steam-lined processes and to have you love Visual as much as I do.

What will you learn?

To create magical Product Codes to handle Capital, R&D reporting or special project reporting. No need to do general journal entries or keep external reports. Let Visual do it all for you.

Two easy ways to charge material costs to work orders without a part ID so all your costs are linked to jobs and customers. Better costs. Better profitability reporting. Better decisions.

Reliable Revaluation Entries in 30 seconds or less. Including how to ensure supporting records are in line. And how to fix them if they are not.

General Journal Entries Plus – allocating dollars to many accounts, using recurring entries monthly or on an as needed basis, using different currencies, importing general journal entries and my own secret procedure – the copy/paste.

How to prevent and correct balancing issues quickly so that you meet your month-end deadlines. And give you more time for review and analysis of financial results.

10 little used features that will enhance the information you get out of Visual. And save you time too!!

8 common mistakes that will cause balancing issues. Plus, how to find them quickly. Or prevent them from occurring at all.

How to create amazing management reports with Visual’s Financial Report Writer. From the Annual Trend for Income Statement so you can easily spot abnormalities and positive/negative trends. (No more missing those monthly expenses.) To the manager’s report than can be created in less than 5 minutes. Managers love this report, especially when you can give them the detailed transactions.

Using the Cash Management Window to forecast your cash flow based on the information (orders and invoices) in your system.

What will you get?

A detailed manual with over 100 pages full of instructions

10 improved Visual reports that will save you time, money and paper- plus gives you extra information

5 financial statements formats

Month-end procedures that show the steps to make Visual’s month-end smoother and more accurate

After the workshop:

You may have questions. Do you need further clarification of a topic? Or you may have a specific business need that needs to be addressed. Each company will have a 1-hour one-on-one call after the course to answer any lingering questions. This can be used anytime for any topic. It doesn’t even have to be related to the course. Your choice. All I want to do is help “You love Visual as much as I do”.

Who should attend?

Users of any version of Visual’s Enterprise. Specifically:

CFO’s

Controllers

Accounting Managers

Assistant Controllers

VP’s of Finance

Business owners

Anyone wanting to know more about Visual Financials

Kim Worrall, CA, CPA is a Visual ERP Application specialist and owner of Back To Basics headquartered in the Greater Toronto Area. Kim has spent over 20 years consulting with Visual Enterprise, with an in-depth focus on all aspects financial. From costing to reporting to processing transactions as efficiently and accurately as possible. Kim is obsessed with how Visual works. She combines her healthy obsession, her thorough understanding of Visual’s functionality and tables, her puzzling skills and down-to-earth communication style to help companies get the most out of their Visual ERP.

Kim likes to share with her monthly Visual ERP Tips & Trips and monthly Blogs on all topics Visual. Her life’s objective is “To help others Love Visual as much as she does”.

Visual’s Standard Costing – Validations, Valuations and Variance

This one-day hands-on workshop is for individuals whose companies use standard costing in Visual ERP. You bring your computer and link into your database so you can relate to the information. This will provide the building blocks of Visual costing set up, how to manage standard costs and inventory reporting and understanding the costing variances.

What will you will learn?

The building blocks behind Visual’s costing

How and when costs are updated

How the journals are created

Where Visual looks in GL accounts

The costing settings and how they impact creation of the journals and subledgers

3 sets of queries for quick comparison of the General Ledger and Inventory Subledgers

Detailed step by step procedure for updating standard costs

Queries to help analyze PPV and product variances

Queries to identify differences between Engineering Masters and Standard Costs

After the workshop:

You may have questions. Do you need further clarification of a topic? Or you may have a specific business need that needs to be addressed. Each company will have a 1-hour one-on-one call. This can be used anytime for any topic. It doesn’t even have to be related to the course. Your choice. All I want to do is help “You love Visual as much as I do”.

Who should attend?

Users of any version of Visual’s Enterprise. Specifically:

CFO’s

Controllers

Accounting Managers

Assistant Controllers

VP’s of Finance

Business owners

Anyone wanting to know more about Visual Financials

Kim Worrall, CA, CPA is a Visual ERP Application specialist and owner of Back To Basics headquartered in the Greater Toronto Area. Kim has spent over 20 years consulting with Visual Enterprise, with an in-depth focus on all aspects financial. From costing to reporting to processing transactions as efficiently and accurately as possible. Kim is obsessed with how Visual works. She combines her healthy obsession, her thorough understanding of Visual’s functionality and tables, her puzzling skills and down-to-earth communication style to help companies get the most out of their Visual ERP.

Kim likes to share with her monthly Visual ERP Tips & Trips and monthly Blogs on all topics Visual. Her life’s objective is “To help others Love Visual as much as she does”.

Visual Controller’s Crash Course

Are you new to Visual and need to quickly understand the accounting set up so you can do your job effectively?

Or, are you new to the Controller’s position and don’t know all the steps required for Visual’s accounting?

Or, have you been in the Controller’s position but still feel you have unanswered questions about how Visual works and what you should be doing to report in Visual effectively and accurately?

If you answered yes, then this course is for you. The 1-day crash course will be a hands-on using your database so that you can get a full understanding of your financial set up.

What will you learn?

Maintenance files that impact Visual’s Accounting Transactions

How the General Ledger is structured including how to easily set up new accounts

The places where General Ledger accounts are stored to control the difference postings

Customer and Vendors set up and how this impacts accounting transactions

Evaluate how and where sales taxes are set up and recorded and calculated

Show how & where the Terms are used and what to look out for

Review the set up for posting of inventory, sales and COGS accounts

Currency maintenance

Transaction flow within Visual

The 13 different journal types and how they impact the subledgers

The hierarchy of Visual’s postings for all 13 journal types

The General Ledger accounts that will be used for creation of the 13 journal types. (Gee do you think 13 is a lucky number?)

General Journal Entries Creation

What does native currency mean?

Allocating dollars to many accounts

Using recurring entries monthly or on an as needed basis

Importing general journal entries

Review of Month-end & Year-end Processes

We will go through the 8-page month-end process which identifies the steps required for timely and accurate month-end reporting. We will also discuss what can be done during the month so that you can get financial statements done more quickly.

The year-end requirements including setting up a new calendar year and closing profit to retained earnings.

During the course you will:

Learn specific topics which will be related back to your company

Get to spend time sharing ideas with other Visual users

Discuss your specific needs related to Visual. We will have time for your questions.

At least 2 Excel queries that you can use to speed up your month-end process

After the workshop:

You may have questions. Do you need further clarification of a topic? Or you may have a specific business need that needs to be addressed. Each company will have a 1-hour one-on-one call. This can be used anytime for any topic. It doesn’t even have to be related to the course. Your choice. All I want to do is to help “You love Visual as much as I do”.

Are you intrigued? Excited? Can’t wait to learn? Then please sign up and join us for:

“Visual Controller’s Crash Course”

On Wednesday, Nov. 14 from 9 am ‘til 5 pm.

If you are extra anxious to learn let us know now.

If we get 5 people on our waiting list, we will move the course date up.

Kim Worrall, CA, CPA is a Visual ERP Application specialist and owner of Back To Basics headquartered in the Greater Toronto Area. Kim has spent over 20 years consulting with Visual Enterprise, with an in-depth focus on all aspects financial. From costing to reporting to processing transactions as efficiently and accurately as possible. Kim is obsessed with how Visual works. She combines her healthy obsession, her thorough understanding of Visual’s functionality and tables, her puzzling skills and down-to-earth communication style to help companies get the most out of their Visual ERP.

Kim likes to share with her monthly Visual ERP Tips & Trips and monthly Blogs on all topics Visual. Her life’s objective is “To help others Love Visual as much as she does”.

Complete the form below and we will get back to you regarding your on-site workshop requirements.

Your Name (required)

Your Email (required)

Subject

Your Message

Your browser does not support JavaScript!. Please enable javascript in your browser in order to get form work properly.