Browse By Tags

  • How to create a new index that supports the "Include" option on an X3 table?

    How to create a new index that supports the "Include" option on an X3 table?

    It's always the way isn't it? You don't see any articles about creating indexes then several come all at once! Chris Hann recently wrote the article " How to use the Database Optimization function " but what if you want to create a new index which uses…

  • SAGE X3 TABLE INDEX dimensional field, example GACCENTRYA field CCE_1

    When we try to create an index in table GACCENTRYA including field CCE_1, SAGE X3 gives error. For now solution is to add the index manually directly in the SQL Server, any solution to make this solution permanent? Thanks.
  • Four T-SQL commands for your toolbox

    Four T-SQL commands for your toolbox

    I have used the following T-SQL commands quite often when working on the SQL Server side. There are other ways to find some of this information, but you should have these commands in your toolbox. Using the SQL Server Management Studio(SSMS) interface…

  • Configurator Filtering Range on Response Table by Index

    Hi folks. Configuring a script for the configurator module, I'd like to filter a response table, based on a range of indexes, instead of specific indexes. I.E: I've tried '8...19', '8..19', etc, but still haven't succeded. Is there any way…

  • Search of a line item using the kDISPLAY index fails

    Hello, Our Sage 100 integration fails with some customers, when it searches for a shipping entry item by kDISPLAY index (InvoiceNo:LineSeqNo:LineKey). I have put together a simple VBscript replicating the problem. It works without any problem with…

  • Accessing Sage 100 Contractor 2016 Database with Microsoft Access 2010

    How can the Sage 100 Contractor 2016 (version 20.4.51.0 or greater) databases be accessed using Microsoft Access 2010? I would like to link to the data source by creating a linked table. To do this I have created a Machine Data Source using ODBC in…

  • Search Index

    I would like to schedule a search index task (using Scheduler) but find no way to assign the task. I think the task I need is ASRINDBAS.

*Community Hub is the new name for Sage City