RKL eSolutions Blog Trends and Insights

Russ Griffith

Russ Griffith
Russ assists companies who need to improve their business processes and evaluate how to make their business systems work for them. By working with the key resources at each company he is able to understand the needs and challenges that are present in each unique environment.

Recent Posts

AvaTax for Sage 500 ERP – Required Update to Support TLS 1.2

Overview Avalara has announced that it will be deprecating support for Transport Layer Security (“TLS”) 1.0 and 1.1 during the course of 2022.  You may have seen one or more messages from Avalara regarding this topic.  A sample message can be found ...

Continue reading
Tagged With: Sales Tax, Sage 500, What's New

Sage 500 ERP 1099s for Tax Year 2020

   There's a new form for tax year 2020 filing  As of this year, the 1099-MISC Box 7 Nonemployee compensation has been moved to the new 1099-NEC Box 1. With recent changes, the IRS required that these amounts be filed with the IRS by January 31st, ...

Continue reading
Tagged With: Sage 500

AvaTax for Sage 500 ERP: What Data is Used in this Interface?

When working with AvaTax for Sage 500 ERP we are often asked what data is exchanged between the two solutions. In order to help provide a better understanding of this, below is an outline of many of the data elements that are passed between Sage 500 ...

Continue reading
Tagged With: Sales Tax, Sage 500

AvaTax for Sage 500 ERP:  Mapping Items to Product Tax Codes

When implementing AvaTax for Sage 500 ERP, one area that we often receive questions about is the mapping of items to the proper Product Tax Codes. These codes exist to allow anyone who uses them to designate the specific classification of each ...

Continue reading
Tagged With: Sales Tax, Sage 500

Disable Auto Load of Business Insights Explorers and Lookup Views in Sage 500 ERP

  Many customers experience issues with performance and often times they do not take advantage of a simple change that would benefit overall Sage 500 ERP system performance.  This change applies to the default settings for BIEs and Lookup Views to ...

Continue reading
Tagged With: Sage 500, How-To

How to Set up ACH Processing in Sage 500 Accounts Payable

This article is intended as a guide to walk you through the steps of setting up ACH (Automated Clearing House) Payment Processing within Sage 500 ERP. In some of the steps you will need to provide information that would be supplied by your bank.  If ...

Continue reading
Tagged With: AP Solutions, Sage 500, How-To

Sage 500 ERP Surrogate Keys and Checking for Inconsistency

How to check for inconsistencies in the Sage 500 ERP surrogate key values If you are familiar with the database schema of Sage 500 ERP you have likely come across the need to understand the use of surrogate keys in the database.  Most tables within ...

Continue reading
Tagged With: SQL Server

Automate the Sage 500 ERP Daily Aging Recalculation

Sage 500 ERP Aging Recalculation Within Sage 500 ERP, there are tasks that allow you to age all of your Open Receivables and Open Payables to ensure that they are current when viewing this information on reports and explorer views throughout Sage ...

Continue reading
Tagged With: Sage 500, SQL Server