How do I set up an ODBC TS Billing Field Names DSN to modify or create Billing invoice formats?
Description
Cause
Resolution
[BCB:5:Third-party support:ECB]

A TS Billing Field Names DSN is not required to print customized invoices in Billing. For information on how to use an ODBC DSN in crystal reports, please refer to Article ID 21011: DocLink: How do I use an ODBC data source name (DSN) for my Sage 300 Construction and Real Estate data in a Crystal report?

Set up a TS Billing Field Names DSN to modify billing invoices in Crystal Reports as follows:

  1. From the Windows taskbar, click Start and select All Programs, ODBC, 32bit ODBC Administrator or if this is a 64-bit machine, browse to C:Windows\sysWOW64\odbcad32.exe.
  2. From the User DSN tab, click Add.
  3. In the Create New Data Source window, select Timberline Data, and then click Finish.
  4. Type the Data Source Name as TS Billing Field Names and then specify the Database Type as an Accounting Data Folder.
  5. Click Select Folder and then select the folder that contains the data you want to use.
  6. Click OK.
  7. Click Options >>.
  8. Specify the Table and Field Naming as Dictionary names.
  9. Select the Use maximum table segment size check box.
  10. Clear the Shorten field and table names check box.
  11. Click OK twice.
DocLink: How do I use an ODBC data source name (DSN) for my Sage 300 Construction and Real Estate data in a Crystal report?

[BCB:156:Chat 300 CRE US:ECB]
Defect ID
Steps to duplicate
Related Articles