Russ Griffith
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 readingSage 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 readingAvaTax 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 readingAvaTax 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 readingDisable 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 readingHow 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 readingSage 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 readingAutomate 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