Knowledgebase : Translation Office 3000 > Translation Office 3000 (all versions) > Document Templates
Question:
I purchased your software and installed the English version. I am
based in Germany and need to produce invoices, etc. with the European
address format, but your program will only add the addresses in the US
format:
i.e.
Mr. ABC
12345 Diplo...
To change the name, please replace all USER_NAME (COMPANY_NAME in
Projetex) variables in templates with your name, this way your name
will be hardcoded into the templates. You can edit templates by
selecting them individually in the "Business/Corporate Se...
Numeric values may be formatted with exponent, fixed, numeric or
currency format. For this, use the functions FEXP, FFIX, FFIXR, FNUM,
FNUMR or FCUR in report templates. For example: FNUM(A:FIELD1),
FCUR(A:FIELD2,4), FEXP(A:FIELD3,10:2)
General format f...
Function FDTM uses the FORMATDATETIME Delphi function to format dates.
Syntax is FDTM(VARIABLE,FORMAT_STRING), where FORMAT_STRING is a
constant or report variable with pattern for FormatDateTime function.
For example:
VAR1='2/15/95 10:30am'
FORMAT_V...
A graphic image may be inserted from a blob, graphic field or from an
external graphic file, using function FIMG. For example:
FIMG(A:FIELD2), FIMG(A:FIELD2,1).
Function format for blobs and graphic fields is:
FIMG(FIELDNAME,[FORMATINDEX]), where FIELDN...
FBOOL(VARIABLE) or fbool(datafield)
Boolean value will be formatted according to the properties of
TrueValue and FalseValue.
Example:
Property TRUEVALUE set to "YES"
VAR1=TRUE
in a report template:
var1
formatted var1: fbool(var1)
in the result:
Tru...
Groups of services (for instance "translation") and service names
(usually a language pair) can be added to the template separately via
the following variables:
Invoice or PO template:
dtLinkJobs:GROUP_NAME - name of the group
dtLinkJobs:SERV_NAME - n...
You can translate the text part of the templates yourself, in
"Business / Corporate settings >> Templates"".
Please leave the variables in the templates as they are.
To display dates in the long format you need to edit the templates and
add the suffix LONG to static date variables. For example, DEADLINE
should be replaced with DEADLINE_LONG.
Invoice fonts size, color etc. are set in the template. To change the
font size or color, please open the template and change the size or
color of the necessary area.
Document templates can be edited in "Corporate / Business Settings >>
Templates".
To change the number of digits after the comma, please edit the fnum
command parameter in the template.
This command simply tells the parser to round up the value to the
specified number of digits after the decimal point.
For example, to display 2 digi...
The DTLINKJOBS:CCON_NAME variable is used to display the name of the
client's Project Manager for each Job in an invoice.
Alternatively, you can use the ATTENTION variable to add the name of
the Contact Person selected in the Attention field for the cur...
All you need to do is insert a space between the CURRENCY and INV_DUE
variables in the template and save it.
You can edit templates in "Business/Corporate Settings >> Templates".
There is a possibility to add PO numbers of jobs to invoices. To do it
you should use the DTLINKJOBS:CJOB_PONUMB variable in your invoice
template (it should be placed between the scanentry and scanfooter
commands)
Templates can be edited in Corporate S...
Question: I have been trying to number all invoices consecutively but
the Invoice Code still remains client-delimited (ie, invoices are
numbered 1-n per client, and not 1-n for all invoices). The global
code is correlative though. Should it be impossible ...
The style of the variable value is defined by the first character of
the variable (the first "" symbol).
For example, if this character is bold, and the rest of the variable
is not bold - its value will appear bold when you issue a document.
This error occurs when you try to generate invoice in TO3000 Version 8
with a template for Version 7. Invoice templates for Version 7 are not
compatible with TO3000 Version 8. You can download appropriate invoice
templates from sub-pages at:
http://www.to...
Question: When I save an invoice, the payment method does not include
the description (bank name, account number and SWIFT etc.), but just
one word with the name of the 'Payment method'
Answer: Please use the INVOICE_PAYMETHOD or PAYMETHOD variable for
...
You can add the name of the Client-side PM to any Client Job in your
Invoice template with the dtLinkJobs:CCON_NAME variable.
Templates can be idited in "Corporate / Business Settings >>
Templates".
If you get an error "Illegal function use:
if(DTLINK:JOBS:CJOB_FEE_stocktickerKIND='flatfee')-dataset field
CJOB_FEEstocktickerKIND not found" or similar while generating a new
invoice, please try to disable all smart tags in MS Word.
On the Tools menu,...
Please change the condition If(INVOICE_HAS_ADJUSTMENTS) to
If(ADJUSTMENTS_VALUE<>0) in your invoice template.
Templates can be edited in "Business / Corporate Settings >>
Templates".
Note: For text variables in similar circumstances, use the condition...
The сondition for the CLIENT_STREET2 variable should look like
if(CLIENT_STREET2<>'')\CLIENT_STREET2\endif
Templates can be edited in "Business / Corporate Settings >>
Templates".
Note: For numeric variables in similar circumstances, use the
condition...
The problem with saving documents seems to occur often with Windows
Vista OS (full text can be fount at:
http://support.microsoft.com/kb/931277
[http://support.microsoft.com/kb/931277]):
"This problem occurs if the hard disk drive or the flash device wa...
Please use the dtlinkjobs:CJOB_CLCODE variable for the "Client Ref."
field to be printed in an invoice.
Please be sure to place the variable in the "table" area of the
template, between the scanentry and scanfooter tags.
Templates can be edited in "Co...
TO3000 3D templates are stored in the C:Program FilesAITTranslation
Office 3000 Version 3DTemplates folder.
To edit templates from TO 3000, please do the following:
1. Go into "Business Settings >> Templates" in the Backstage View
2. Locate the folde...
In order to have the global invoice code on your printed invoices, you
will need to edit your invoice template:
1) Open the "Business/Corporate Settings >> Templates" page. Browse
the folders to find the Invoices folder.
2) Open the necessary invoice t...
TO3000/Projetex reports are based on SQL-queries. You can find a lot
of useful information on composing reports and queries in the
documentation of another software by AIT - Projetex. The following
guides describe the basic principles, which are common fo...
For example, to replace your name with the company name on the invoice
template, please do as follows:
1. In the Backstage View, navigate to "Business/Corporate Settings >>
Templates"
2. Locate Invoice templates in the following folder:
TemplatesCLIENTS...
Unfortunately, TO3000 and Projetex can work with templates only in the
RTF-format. However, you can customize the design of your templates
the same way as one made in Excel.
In Windows Vista and newer, even if you are the only user on the
computer, you can encounter problems with accessing programs, due to
lack of account rights. In rhis case, please right-click the shortcut
of MS Word and choose "Run as administrator". Then ...
Client jobs are represented in the invoice in the same order they are
shown in the New/Edit Invoice dialog. Therefore, to sort them by
Completed date/time, please click on the Completed column title. If it
is not visible in the table, click the asterisk i...
You can store your personal business details using custom variables.
In order to add the necessary variable, please, do the following:
1) Go to "Advanced Settings > Template Variables"
2) Click the New button
3) Enter your variable name (MY_ADDRESS fo...
In order to have the requested invoice code on your invoices you do
not need to make any changes in your global code settings. Simply add
the CLIENT_CODE variable before INVOICE _GLOBAL_CODE in your invoice
template, i.e. the code in the template is suppo...
In order to have the payment method in your invoices, please, add the
INVOICE_PAYMETHOD variable for the payment method name and the
INVOICE_PAYMETHOD_DESCR for the payment method description to your
invoice template.
First of all, please open the template you need to change in MS Word.
For this, go to "Corporate/Business Settings >> Templates" and choose
the template.
Mark the text you do not want to print, right-click on it and choose
Font.
In the opened window...
Documents can be saved in RTF, PDF and DOC (DOCX) file formats. Just
choose a format you need before saving a document.
You can use the following operations:
Arithmetical operations:
>, <, =, <=, >=, <> (not equal), != (not equal), +, -, *, /, %
(modulo)
Logical operations:
&& (and), || (or), ! (not)
It is possible to set a custom date format in saved documents by using
the fdtm() function and a pattern variable in the following way:
fdtm(DateTime Variable, Pattern Variable)
For example, if you have a DateTime variable DEADLINE which is January
20, ...
COMMON TEMPLATE VARIABLES
CODE TO PASTE TO TEMPLATE
INFORMATION DISPLAYED IN THE SAVED DOCUMENT
COMPANY_NAME
Name of registered company (i.e. your company name) taken from your
License Key. This name cannot be modified, however you can delete this
...
CLIENT DATA TEMPLATE VARIABLES
CODE TO PASTE TO TEMPLATE
INFORMATION DISPLAYED IN THE SAVED DOCUMENT
CLIENT_NAME
Name of client.
CLIENT_CODE
Client Code of client.
CLIENT_CURRENCY
Client's currency.
CLIENT_PAYMENT_TERMS
Payment terms of...
CODE TO PASTE TO TEMPLATE
INFORMATION DISPLAYED IN THE SAVED DOCUMENT
PROJECT_NAME
Name of project.
PROJECT_CODE
Project code.
PROJECT_CLIENT_NAME
Client project created for.
PROJECT_CLIENT_CODE
Client reference number.
PROJECT_INFO
...
CODE TO PASTE TO TEMPLATE
INFORMATION DISPLAYED IN THE SAVED DOCUMENT
SALUTATION
Salutation of contact.
Example:
Mr., Ms., Mrs.
TITLE
Contact title.
CONTACT_NAME
PM_NAME
ATTENTION
Contact name.
CONTACT_EMAIL1
Contact email addres...
COMMON QUOTE VARIABLES
CODE TO PASTE TO TEMPLATE
INFORMATION DISPLAYED IN THE SAVED DOCUMENT
QUOTE_NAME
Possible quote name.
QUOTE_CODE
CODE
Quote code.
REQUEST
Request for quote.
ANSWER
Answer to request for quote.
DATE_SENT
SENT...
CODE TO PASTE TO TEMPLATE
INFORMATION DISPLAYED IN THE SAVED DOCUMENT
JOB_NAME
Job name.
JOB_CODE
CODE
Job code.
PO_CODE
PO
Purchase order client issued for this job.
CLIENT_REF
Client reference number in accounting system of client....
DATE AND CODE
CODE TO PASTE TO TEMPLATE
INFORMATION DISPLAYED IN THE SAVED DOCUMENT
STATUS
Invoice status
Example:
Expected within 30 days, Settled 5 days earlier
DATE_DUE
SETTLEMENT_DATE
Date when invoice is due in following format:
10...
BASIC PAYMENTS TEMPLATE VARIABLES
CODE TO PASTE TO TEMPLATE
INFORMATION DISPLAYED IN THE SAVED DOCUMENT
PAYMENT_CODE
CODE
Payment code.
PAYMENT_DATE
PDATE
Date payment received in following format:
10/4/2006
PAYMENT_DATE_LONG
PLONGDAT...
Question: How can the address format be changed in saved invoices?
i.e.
Mr. ABC
12345 Diplomat Drive
Stow, New York, 55432
To:
Mr. ABC
12345 Diplomat Drive
55432, Stow
New York
Answer:
It is possible to customize the address format in your...
To change the user name in template-based documents, please open the
appropriate RTF template in the "Corporate / Business Settings >
Templates" section and replace all USER_NAME (COMPANY_NAME in
Projetex) variables in templates with your actual name. Thi...
Please add the variables DTLINKJOBS:CJOB_PONUMB and
DTLINKJOBS:CJOB_CLCODE to the appropriate invoice RTF template. These
variables should be placed between the scanentry and scanfooter
commands in the 'table' part of the invoice.
Templates can be edite...
To change the number of digits after the comma, please edit the fnum
command parameter in the template. This command simply tells the
parser to round up the value to the specified number of digits after
the decimal point.
(2 digits in the example: fnum(...
To include your CATCount notes for each client job in the invoice,
please insert the following variable in the Client Jobs section of
your invoice template: DTLINKJOBS:CJOB_COUNTNOTES
Templates are edited in "Corprate / Business Settings >> Templates"
QUESTION:
_Encoding: when I type "Hirschstraße" in the Address field, that's
what I get in the invoice: "Hirschstra" What should I do? I have MS
Windows 8_
ANSWER:
Please go to "Control Panel>Region>Administrative" and click the
"Change System Local...
For this, please open your invoice template by going to "Business /
Corporate Settings > Templates > Clients > Invoices > Invoice template
file". The file will be opened in your default RTF editor. Then enter
your "VAT number" and any required description...
You can specify the date representation for each of your clients at
"Client Profile > Locale Format". There, you can switch to Custom
Values and change your long date format to DD.MM.YY so it is displayed
as a short date format (Picture 1). Then you will ...
All information about template customization is available in our
Projetex
[http://projetex.com/download/documentation/RTFTemplatesGuide.pdf] and
TO3000
[http://to3000.com/Documentation/TO3000V10RTFTemplatesGuide.pdf]
template guides.
You can also use th...
This kind of error occurs if you have created a custom field with a
name which conflicts with a name of your Global Variable. Please
change either your custom field name or the variable name at:
For TO3000_: BACKSTAGE VIEW_ > ADVANCED SETTINGS >
TEMPLAT...
Plese do the following:
1. Specify a variable for your custom field (Picture 1) at:
a) FOR PROJETEX: PROJETEX SERVER ADMINISTRATOR > CORPORATE SETTINGS >
FIELDS > [SELECT A FIELD] > EDIT
b) FOR TO3000: BACKSTAGE VIEW > ADVANCED SETTINGS > FIELDS > [...
Please do the following:
1. Specify a variable for your custom field (Picture 1) at:
a) FOR PROJETEX: PROJETEX SERVER ADMINISTRATOR > CORPORATE SETTINGS >
FIELDS > [SELECT A FIELD] > EDIT
b) FOR TO3000: BACKSTAGE VIEW > ADVANCED SETTINGS > FIELDS > ...
In your Invoice templares, please use the following function to cut
off digits after the decimal: FNUM(VARIABLENAME,0).
Examples:
FNUM(DTLINKJOBS:CJOB_VOLUME,0)
FNUM(INVOICE_TOTAL,0)
Invoice templates can be edited in "Corporate / Business Setting...
Please remote the blank line in the template code (between SCANENTRY
and SCANFOOTER operators).
For this, please use the following code segment in your invoice
templates:
IF(CUSTOM_FIELD_VARIABLE_NAME=’YES’)
Some text.
ENDIF
Templates are edited in "Business/Corporate Settings >> Templates".
Q: I get an error when exporting my report to MS Excel. The operation
works fine in RTF.
Here is the error message:
Error while opening Excel
Class not registered ClassID:
00024500-0000-0000-c000-00000000046
A: Please repair your Office installation a...
CODE TO PASTE TO TEMPLATE
INFORMATION TO BE DISPLAYED IN THE SAVED DOCUMENT
REF_CODE
Refund code.
REF_DATE
Date refund was received, in the following format: 10/4/2006
REF_DATE_LONG
Date refund was received, in the following format: Monday...
DATE AND CODE
CODE TO PASTE TO TEMPLATE
INFORMATION TO BE DISPLAYED IN THE SAVED DOCUMENT
CN_STATUS
Credit note status
Example: Awaiting payment, Fully paid
CN_DATE
Date credit note was sent, in the following format:
10/4/2006
CN_DATE_L...
Problem: When saving an invoice (or another document) as a file, the
dropdown list in Save As dialogue only shows .rtf and .pdf options.
Neither .doc mor .docx are displayed.
Solution:
Translation Office 3000 and Projetex use some parts of the MS Wo...
Q: I want to change the invoice code format. For example, for the
company ABCD, instead of the format I-ABCD0001, I want to have the
following format:
ABCD-20-0001
(Client code)-(Year)-(Invoice number).
How do I do that?
A: Unfortunately, the format ...
That was the idea. After all, what is the point of displaying a due
date if the invoice is already settled.
Perhaps you could add such a construction instead:
if(INV_IS_PAID=0)
DATE_DUE
endif
So that the date is only displayed if the invoice is not paid...
Please make sure that the variable names you add don't have any spaces
in them.
Make sure you are adding the correct variables to the correct
templates.
INVOICE_GLOBAL_CODE can only be added to Invoice e-mail templates, for
example.
Q: I have loaded a template which works OK and invoiced a few single
jobs so far. Today, I wanted to invoice 5 jobs done in November for
the same client. I managed to create the invoice and the 5 jobs are
related to it. But when I create the Word version ...
JOBS_TOTAL includes only theactual otoals of the jobs in the invoice.
NET_JOBS_TOTAL also includes the discounts and markups.
INVOICE_TOTAL includes all ofthe above, plus taxes and adjustments.
No. The program accepts only RTF templates.
No. RTF templates are recognized by their location, not their names.
Please go into "Corporate/Business settings >> Templates" (click the
button with the program's symbol near the upper-left corner of the
window to enter the Settings menus), select the invoice template, and
add the following to it:
Payment method:
INVOICE...
This option is not supported at the moment in Translation Office 3000
3D templates.
No, there is no "Preview" function, but you can use the "save & open"
function to immediately see the created document.
What creates the the delay is most likely the fact that the attached
document is a PDF, and creating a PDF takes longer than, say an RTF.
Here is how you can change that:
1) Go into "CORPORATE/BUSINESS SETTINGS >> EMAIL TEMPLATES".
2) Double click the te...
No, edited templates are not integrated into the backup files and have
to be transferred separately.
Their location is C:UsersPublicDocumentsAITTO3000, Version 3DTemplates
There is no variable for your own e-mail and slogan.
Just insert the e-mail and slogan themselves directly into the
template.
You can go to "Advanced Settings >> Template variables" and create a
fixed CORPADDRESS variable there. Then you can add that variable to
all the required templates. and whenever you change the variable's
contents, the templates with the variable will chan...
Double-click the required invoice to open the "Edit invoice' dialog.
At the bottom of the dialog you will see a drop-down list. Simply
click it and select the required template.
Most custom RTF templates shouldstill work in mew versions of the
program.
If you run into problems with any template, please contact support and
we will help you in any way we can.
Threr is no dedicated variable for exchange rates.
But here are the variables we do have:
INVOICE_TOTAL
Invoice total in the client's currency
INVOICE_TOTAL_BASE
Invoice total in the base currency
You can use these to calculate the exchange rate like t...
You may experience issues with your existing AnyCount 2021 OCR+
application with the following symptoms:
The application requests your email and password. When you put them
in, the message appears:
Registration not successful.
Error connecting with...
© AIT Translation Management Solutions, . Awesome Software Tools for Translators and Translation Agencies.
Privacy Policy | Data Processing Agreement
Privacy Policy | Data Processing Agreement