RKL eSolutionsBlogs

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

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).

Continue reading
Tagged With: Sage 500, SQL Server

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 .

Continue reading

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 the overall Sage 500 ERP system performance.  This change applies to the default settings for BIEs and Lookup Views .

Continue reading
Tagged With: Sage 500, How-To

Configuring Sage 500 Sales Order Entry to work with Data Porter

 

Continue reading
Tagged With: Sage 500

Questions? Need Support?
Get in Touch