How do I determine what ODBC Options to use for the DSN?
Description

Field descriptions associated with Miscellaneous fields that can be customized in Setup windows (as opposed to in Custom Descriptions) do not store a standard description field names.

Queries and/or custom reports using a DSNs set to use Standard Descriptions that include Miscellaneous fields may need to be customized to be data folder specific.

See the attached Sage 300 CRE Miscellaneous Fields List. docx document for a list of the types of Miscellaneous fields.

See Error: "This field name is not known...{JCM_MASTER__JOB.Project_Manager}" for information on errors that may be returned on reports and/or queries that include fields with Miscellaneous fields.

Cause

Resolution

[BCB:5:Third-party support:ECB]

 

 

  1. From the Windows Start menu, select Settings, Control Panel, ODBC Data Sources (32-bit).
  2. Select the data source the click Configure.
  3. Click Options.

Table and Field Naming

The Table and Field Naming tells ODBC how to display the table and field names when accessing data via ODBC. The selection determines how portable your report is from one database to another. The options are:

  • Custom descriptions
    You use this when you design reports for a specific database. When you select this option, the descriptive name for tables and fields displays via ODBC. The custom description names on the report are from the database that is selected for the DSN used to create the report. The report is only portable to databases that use the same custom descriptions as the original database used when creating the report. (e.g. table name format = MASTER_JCM_Job)
  • Standard descriptions
    You use this when you design reports for multiple databases that have different custom descriptions. When you select this option, the descriptive name for tables and fields displays via ODBC. The default custom descriptions display on the report design, but the users custom descriptions display when printing the report. The report is portable to all databases, regardless of the use of custom descriptions. (e.g. table name format = JCM_MASTER_Job)
  • Dictionary names
    You use this when you modify Billing invoice reports and reports designed in Crystal Reports for Timberline Accounting CD versions prior to 8.0. Dictionary names are the internal table and field names. They are less descriptive than the standard description but they provide the same functionality. If you select this option, the report is portable to all databases. (e.g. table name format = MASTER_JCM_Record_x)

Use maximum table segment size

The Use maximum table segment size determines how many columns you can include in a table before the table is split into two tables when accessed via ODBC.

  • When you clear the check box, a table that exceeds 255 columns is split into two tables. For example, the Job Cost Master.jcm file Job record is split into two tables, the JCM_Master_Job_1 and JCM_Master_Job_2.
  • When you select the check box to use maximum table segment size, the table is not split. For example, the Master.jcm file Job record does not split and is one table, JCM_Master_Job.
    Note: Some programs, including Microsoft Access, do not support the use of maximum table segment size. Clear the check box when you use DSNs associated with those programs.

Shorten field and table names:
Before ODBC 8.00.3, the ODBC driver shortened table names longer than 36 characters and shortened field names longer than 25 characters. Select the Shorten field and table names check box to create a DSN compatible with reports you designed for versions of the software prior to Accounting and Management 8.0 and Estimating 6.5. Clear the check box to create a DSN compatible with reports you designed for Accounting and Management 8.0 and later or Estimating 6.5 and later.

For more information, see ODBC Help topic Setting up Driver Options . You can find this topic by going to Start, Programs, Timberline Office, Accounting, ODBC Help. On the index tab, type Setting up Driver Options.

Attachment: Sage 300 CRE Miscellaneous Fields List.docx

[BCB:156:Chat 300 CRE US:ECB]

Steps to duplicate
Related Solutions