RKL eSolutionsBlogs

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

RKL eSolutions Updates and Enhances O2 Mobile Warehousing

If you use Sage 500’s O2 Process Manufacturing module, then you know RKL acquired O2 from EVS in early 2020. With a smooth transition completed, RKL is happy to be supporting customers and making minor modifications for ad-hoc requests. What you may .

Continue reading
Tagged With: Sage 500, O2

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, Avalara, 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, Avalara, Sage 500

Sage Enterprise Intelligence Universal Data Model

  The latest version of Sage Enterprise Intelligence (SEI), 9.2.6791 UDM template has prebuilt reporting and dashboards for Finance, Sales, CRM and Inventory.  Today we will focus on the Universal Finance Data Model. Universal Finance Data Model The .

Continue reading

WEBINAR: Maximize the profitability of your warehouse in Sage ERP

 

Continue reading
Tagged With: Events, Sage 500, Sage X3, Webinar

Sage 500 - tciDBActivityLOG - Cleanup Routine

  Introduction The RKL performance team regularly reviews large tables in the Sage 500 database to find ways to improve performance. One table that can be very large is tciDBActivityLog. This table is filled with a database trigger that records data .

Continue reading
Tagged With: Sage 500, How-To

The SQL Command Override

Business Insights Explorer (BIE) tasks can quickly compile data using a SQL query from data existing in one or more Sage 500 tables. The user can personalize a BIE task by filtering, grouping, and subtotaling the data as needed.

Continue reading
Tagged With: Sage 500, SQL Server

Questions? Need Support?
Get in Touch