Which SQL Table tracks the best method information?
The best method information for items is stored in the ForecastResultBestMethods_ID
Related Articles
Best Method is not showing when run as a job?
The reason Best Method is not showing when run by a Job is because of the service account. Give the service account full access to all data in security, then try running the job again.
Best Method is not picking the best method?
All of the combinations in the fact table must be consistent with time, otherwise discrepancies will occur.
Cannot trigger actions in SQL when a user creates a recurrent event?
The setup for extracting the next date from the table (SQL Triggers) has the potential to produce negative effects when used by multiple users. Our recommendation is to setup alerts for calendar events for non secured items. By setting up an alert a ...
SQL Tools fail during installation of Arkieva?
The SQL tools part of the installation is related to two programs: Microsoft ODBC Driver 11 for SQL Server' (msodbcsql.msi) and 'Microsoft Command Line Utilities 11 for SQL Server' (MsSqlCmdLnUtils.ms) There are most likely higher versions of these ...
Cannot access the same attributes in Quick and Table editor?
When having roles in the system model, you can access the role’s attributes in a Quick report but not in the Table Editor. Since the Table Editor only queries directly on a table, it is not possible to access the attributes of a role in table editor.