RKL eSolutionsBlogs

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 .

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 .

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 .

WEBINAR: Maximize the profitability of your warehouse in Sage ERP

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 .

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.

Create a Custom Task in Sage 500 ERP

You created a custom Business Insights View (BIE) but now you need to grant access to users so they can start using it from their menu. In order to add the view to the menu, you must add it in the Task Editor (System Manager > Tools > Task Editor).

From Sage 500 to the Cloud

Current Sage 500 Situation Your Sage 500 ERP was released in 1998. Its programming language is based on VB6. Sage 500 was probably the first ERP system that you ever implemented. Letting go of old things can be hard, especially when you have relied .