Workshops

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

 

Visual ERP Inventory Reconciliation

 

Under the Covers with Visual ERP Using Excel Query Course

 

Visual ERP Controller & Beyond

 

Visual Controller’s Crash Course

 

Visual’s Standard Costing – Validations, Valuations and Variances

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:

  1. A comprehensive binder of course content that can also be used as a reference manual
  2. Coffee throughout the day
  3. Snacks mid morning and mid afternoon
  4. Lunch – click to checkout a typical menu
  5. A complimentary one hour consulting call per company attending
  6. Meet other Visual Users and see how they use Visual ERP

Coming from a long distance?  Check out TripAdvisor for lodging near the venue.

Canada-Ontario Job Grant

Are you looking for education and would like financial assistance?  Check out the 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/

Visual ERP Inventory Reconciliation – Visual Hide & Seek, Infor Visual ERP

“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.”

Karin Krukoski, Senior Staff Accountant, Sun Nuclear 

(2 day workshop) – TBD or Upon Request at Rattlesnake Point, Milton, ON             

20161116_164024

20160427_161734

 

 

 

 

v                                                                               November 2016                                                        April 2016                                                  September 2018

Visual Hide & Seek: Inventory Reconciliation with Infor Visual ERP

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?

  1. 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
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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

20161110_16170420160622_13210620150922_144900

_________June 2018                                November 2016                                      June 2016                                                    September 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.”

Deb Gillies, VP Finance, Assa Abloy

One Day Course – Date: TBD or Upon Request at Rattlesnake Point, Milton, ON –               

Workshop Outline

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

  CcourseAug16CCPicture11111520150715_144115

(2 da      June 2018                                     August 2016                                             November 2015                                          July 2015

(2 day Workshop) Workshop

Date: TBD 0r Upon Request at Rattlesnake Point, Milton, ON  –   

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?

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 10 little used features that will enhance the information you get out of Visual. And save you time too!!
  7. 8 common mistakes that will cause balancing issues. Plus, how to find them quickly. Or prevent them from occurring at all.
  8. 5 little-known ways to copy information from Visual into Excel to eliminate boring typing time.
  9. 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.
  10. 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


 

 

 

 

 

                 September 2018                                            March 2017

Date: TBD or Upon Request at at Rattlesnake Point, Milton, ON.             

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?

  1. 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
  2. Managing Visual ERP’s standard costs
    • Detailed procedure for updating costs for purchased & fabricated parts and the resource costs
    • Capturing the impact of the change on the Inventory Valuation
  3. Valuations – How to manage the inventory valuation reporting
    • How to ensure your inventory report is accurate by finding cost changes
    • How to obtain your inventory balances at any time
    • The 5 second quick method for comparing your General Ledger & Valuation
  4. Variances – Reporting
    • Understanding the production variances by reviewing existing Visual reports
    • Purchase Price Variance Reports and GL accounts
  5. Validate – Reconciliation Process
    • The 10 things that can happen to your General Ledger to cause an imbalance
    • Working with Costing Tools including how to eliminate the exceptions
    • How to identify cost changes that you didn’t know about & quantify their impact
    • How to run mini-costing utilities to process specific fixes

But wait, there’s more!  As part of the course, this is what you will get:

  • A detailed manual with over 50 pages full of instructions
  • 5 modified Visual reports to make inventory reconciliations and costing analysis easier
  • 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

New One Day Course – Date November 14, 2018 or Upon Request at at Rattlesnake Point, Milton, ON.        

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?

  1. 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
  2. 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?)
  1. 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
  1. 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.

What will you get?

  • Detailed manual with over 50 pages of detail instructions
  • 6 modified Visual reports that will makes Visual reports easier to read and provide additional information
  • 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

How Can We Help You?

: