> Microsoft Word Printing

Microsoft Word Printing

As an alternative to printing your documents on pre-printed stationery, you can configure SYSPRO to allow you to print your stationery documents using Microsoft Word.

Sample templates for the various formats are provided as standard, however you can optionally design your own templates, indicating which fields you want to print and at which position on the document.

Aside from being able to use the extensive design features that are available with Microsoft Word, an added advantage of using this option is that you do not need to purchase pre-printed stationery.

Prerequisites

The following prerequisites are required before selecting to print your stationery documents using Microsoft Word:

  • An installation of Microsoft Word 97 or later version

  • The Office Automation & Messaging module installed as part of your SYSPRO license agreement

  • The Windows Printing option enabled (SYSPRO ribbon bar->Setup->Windows Printing)

  • A default Windows printer that is available for use within the system (SYSPRO ribbon bar->Setup->Print Setup)

  • A working knowledge of Microsoft Word and Microsoft Word templates

Implementation

You activate the MS Word Print option separately from within each stationery format program that caters for the facility.

Once you have indicated that you want to print using MS Word, you can then select the MS Word Options format option to configure the various settings as required.

The stationery format programs that cater for MS Word include the following:

Stationery format program Considerations
AP Check Format You can only activate Word printing for this format if you select to print checks and remittances separately.
AR Statement Format

Document types available for formatting:

  • Customer statements

Multiple statement formats can also be defined, enabling you to customize your statements to meet your various customers' needs.

AR Permanent Entries Format Document types available for formatting:
  • Permanent entry invoices

Inventory Document Format Document types available for formatting:
  • Stock receipts

  • Issues

  • Transfers out

  • Purchase order receipts

Purchase Order Format Document types available for formatting:
  • Local

  • Foreign

  • Requisitions

  • Blanket contract

You can also print graphical multimedia items associated with a purchase order or contract number.

If you select to print multimedia items on your documents then you will be required to specify the multimedia category to which the item belongs. This category is then appended to the bookmark name.

Inspection Document Format Document types available for formatting:
  • Inspections

  • Scrap

  • Reject

These document formats only contain Detail sections.

SO Document Formats Document types available for formatting:
  • Invoice

  • Delivery note

  • Order acknowledgement

  • Dispatch note

In order to cater for multiple sales tax lines, sales tax fields are inserted as part of the Detail section (instead of the totals section).

Quotation Document Format The Offer print method that is configured against quotations will determine whether additional fields are available to print on your quotations.

Ensure that the Offer print method you select corresponds to the template layout (i.e. do not try to print a Multiple lines format on a template that was designed as One per document).

Similarly, if you select Multiple columns at the Offer print method field, ensure that the entry against the Number of offers across page option correlates with the template design.

Factory Documentation Format Because this format does not have a total section, you are only required to define one continuous section break.

This format does however, cater for a second (optional) continuous section break, in which you can insert any of the heading fields.

You can also print graphical multimedia items associated with a job number and stock code when printing factory documents.

MS Word Options

The following areas of format configuration are available within the MS Word Options screen:

Field Description
Template Options These options are available for all stationery formats.
Template location Indicate where the template must be saved.
OptionDescription
ClientStore the template on the client machine.

In a client/server environment, templates are created on the client and copied back to the server during the analysis phase.

ServerStore the template on the server (only available in Client/Server or mapped-drive environments).

If the template is stored on the server, then when it is required by the client workstation, it is first copied to a temporary folder on the client. This reduces unnecessary network traffic.

If the template already exists on the client then an attempt is made to delete and replace it.

If the file cannot be deleted then you will not be allowed to continue with the design process.

Template name Indicate the name of the MS Word template that you want to use for the stationery document.

If you select to store the template on the client, then you must specify the full path to the template document.

If you select to store the template on the server, then only the name of the template must be entered.

Header section Indicate how you want to configure fields from the header section of the stationery format.
OptionDescription
Print on first page onlyAll heading fields configured for the format must be printed on the first page of the document only.
Print on all pagesAll heading fields configured for the format must be printed on each page of the document.
Header section break not requiredSelect this if you do not require heading fields to be printed or if you want all heading fields configured for the format to be printed in the document header section of MS Word.
Detail section Indicate how you want to configure fields within the Detail section of the stationery format.
OptionDescription
Print using a line countThis indicates that you want to specify the number of detail lines that must be printed on each page.
Use the entire pageThis indicates that you want the system to calculate the number of detail lines that can be printed on a page.
[Note]

This option is significantly slower.

Maximum number of detail lines per page If you select the Print using a line count option, you would then use this field to specify the maximum number of detail lines to print on each page.
Totals section/Optional third section Indicate how you want to configure fields from any non-detail section of the stationery format.
OptionDescription
Print on first page onlyIndicate that any non-detail fields assigned to the template must be printed on the first page of the report only.
Print on all pagesIndicate that any non-detail fields assigned to the template must be printed on each page of the report.
Print on last page onlyIndicate that any non-detail fields assigned to the template must be printed on the last page of the report only.
Total section break not requiredIndicate that you do not require fields to be assigned to the optional third section, or that any non-detail fields configured must be printed in the document footer section of MS Word.
Attachment Options This section is optional and may not be available for all stationery formats.
Attach document Enable this option if you want to append a file attachment to the end of each document produced from this format.
Attachment location Indicate whether the file attachment resides on the Client or Server workstation.
Attachment name Indicate the file that you want to attach to each document produced from this format.
Template status A template must be analyzed before it can be used for printing a document, therefore these fields enable you to see if the template is ready for use.

If the date and time on which a template was last saved differs from the date and time it was last analyzed, then this indicates that the template was modified after it was last used. The template must therefore be analyzed (in order to recognise the changes made) before it can be used.

These options are available for all stationery formats.

Details of when the Template was last saved Indicates the date and time that the current template was last saved.
Details of the Template when it was last analyzed This indicates the date and time that the saved version of this template was last analyzed.
General options This section is optional and may not be available for all stationery formats.
Suppress leading spaces for all numeric fields Enable this to remove all leading spaces for numeric fields, in order to reduce the likelihood of numeric fields wrapping within a table.
[Note]

If selecting this option results in the misalignment of fields containing decimal points, you can use decimal tab stops in Microsoft Word to correct this.

Print operations before materials

This option only applies to the Factory Documentation format and enables you to indicate if you want to print operations before materials.

[Note]

You will be unable to select this option if you have enabled the option to sequence materials by operation number.

Split detail notes, narrations and text This option only applies to the Factory Documentation format and is used if your operations or materials narrations are too long to fit into the Detail section of a single page.
[Note]

This option is only available if you select the option Use the entire page under the Detail section.

However it can also be applied if you define your Detail section to be a set number of lines, and the number of narration lines exceeds the number of detail lines available.

Perform word wrap for notes, narrations and text This option currently only applies to the Factory Documentation format and is used if you want to print all notes in a single cell.

This then enables you to design a template which uses up all the available horizontal 'white space' taken up by individual cells, in order to print the notes in as few lines as possible.

If you select this option, then the system attempts to join the separate lines of 60 characters into ordered sentences and paragraphs.

Design Template This function enables you to design the required template.
[Note]

In order to use this function, you must first make an entry at the Template name field.

Template design

Once you have configured the MS Word Options for the applicable stationery format program, you then select the Design Template function to open the applicable MS Word template and insert the fields that you require printed on your stationery.

If the selected template does not exist, then you are prompted by the Create Template dialog to create the template. If the template already exists, then the template is opened and the template design dialog is displayed.

The steps to follow in sequence are as follows:

  1. Create the template

  2. Design the template

  3. Validate the template

  4. Analyse the template

  5. Convert the template (optional)

Create the template

This screen is displayed if, at the Template name field of the MS Word Options screen, you entered the name of a template which does not yet exist (i.e. you are creating a new template).

Field Description
New template options  
Create blank template Create a blank document template that contains no sections.

Any of the MS Word layout views can then be used when designing the template.

Create default layout Create a new document template that is formatted according to the basic requirements of the stationery format you are configuring.

The system will then attempt to assign the correct number of sections and provide guidelines on the placement of fields and tables.

Based on sample template Create a new document template based on an existing sample which you then specify in the field provided.
Based on existing template This creates a new document template based on an existing template that you have created.
[Note]

The existing template must reside in the Samples folder of the SYSPRO Base folder, however in a client/server environment the template must exist in the Samples folder on the server.

Browse on client This option is only available if you are operating in a client/server environment and enables you to locate templates on the client machine.
Create Select this to create the new template according to your selections and open the new template in MS Word.
[Note]

In a client/server environment, the template is created on the client machine and copied back to the server during the analysis process.

Cancel Select this to ignore your selections and to return to the previous screen.

Design the template

The title bar of the window displayed includes the format type of the template you are maintaining as well as the current field group in use.

You can select the fields to view using the View menu and once you have indicated the section you want to configure, you can then (from the Bookmark drop down menu) select the relevant fields to insert.

Field Description
File  
Convert Update older style templates (i.e. templates that made use of form fields) to the new style template that uses bookmarks.
List Bookmarks View a list of the bookmarks used in the template.

The listview displayed shall include the following information:

  • Bookmark name

  • Section that contains the bookmark

  • Index number of the bookmark within the section of the template

View  
Non Detail View either the heading or the total fields from the Non Detail option sub menu.
Detail View the available Detail line types that are relevant to each document format.
Offer Number

This option enables you to select the required offer number for which to insert fields.

If you are maintaining a template for a multiple offer quote, then the available offer numbers are displayed as sub menu choices.

[Note]

This option is only available for Quotation document formats.

Options  
Stay On Top Force the template design dialog to remain in the foreground when the focus is within Microsoft Word.
Insert Default Text Select whether or not to insert default text at the bookmark's location.
[Note]

Deselecting this option makes it more difficult to see where a bookmark is positioned.

Show Default Text Select to show or hide the default text against all of the bookmarks in the template.
Bookmark Indicates the name of the field you want to insert into the template.
[Note]

You will be unable to insert the same field more than 10 times on a format.

Hide List If you selected the List Bookmarks option, you can then use this function to hide the list of bookmarks.
Show List If you selected the List Bookmarks option, followed by the Hide List function, you can then use this function to redisplay the list of bookmarks.
Insert Insert the field into the template.
Validate Identify any significant errors in the template's design (i.e. verify that you have defined the correct number of sections and that bookmarks are correctly placed).

Any warnings or critical error notifications that are found will then be displayed in a listview pane.

Analyze & Exit Validate and analyze a template in one operation, rather than performing these tasks individually.
Remove Bookmark This function removes the highlighted bookmark from the template.
[Note]

This button only becomes available if you select the List Bookmarks option.

Validate the template

The validation process attempts to locate all the known errors within the template and any errors found are then displayed in a listview below the design window.

The listview includes the following information:

Field Description
Error type
Error type Description
Warning Errors that can affect how the template is produced are listed as warning messages and are depicted by a black exclamation mark on a yellow background.
Critical All errors that could cause the print process to end abnormally are listed as critical errors and are depicted by a white cross on a red background.
Error description This message provides some indication as to the nature of the error.
Section This helps to narrow down the cause of the problem as it lists the section that contains the error.
Index number If the object that caused the error is part of a collection of objects in Microsoft Word, then this value points to its position within the collection.
Additional information If a bookmark caused an error, then this column indicates the bookmark name and may assist you in locating the error.

When you select an error in the listview, SYSPRO attempts to highlight the area of the template that caused the problem.

Analyze the template

Before a template is analyzed it is automatically validated. If errors are encountered, the analysis phase is then halted for you to correct those error(s).

The two possible scenarios are:

Scenario Options available
One or more Warning type error messages are found
  • Continue with the analysis phase.
  • Exit without performing the analysis.

    [Note]

    If you select this option any changes that you made since the last time you saved the template may be lost.

  • Cancel the analysis and return to design mode.
One or more Critical type errors messages are found
  • Exit without performing the analysis.

    [Note]

    If you select this option any changes that you made since the last time you saved the template may be lost.

  • Cancel and return to design mode.

After the validation phase is complete, and assuming that the analysis phase has not been cancelled, the default text is removed from all bookmarks.

[Note]

This is done to save time during the print phase therefore you will always be prompted to save the template, even if you have not made any changes.

Convert the template

The Convert option enables you to update older style templates (i.e. ones that made use of form fields) to the new style template that uses bookmarks.

[Note]

These older style templates must be converted before they can be used.

Every time a template is validated, a check is performed to determine if it contains any form fields that have a name matching any of the valid bookmarks for the format. If any of these form fields are found you are prompted to convert the template.

Form fields can still be used in your template, but you must ensure that the name you use for the form field does not match any of the bookmark names for the format.

The conversion process attempts to convert all form fields found in the template into bookmarks.

If form fields are found that do not have a name, then a bookmark is created with the name "noname" together with a numeric suffix. This suffix starts at 1 and is incremented for each nameless form field found in the template.

If the form field did not have default text associated with it, then the bookmark is created with it's own name as the default text.

Configuring sections

Within each of SYSPRO's stationery format programs, you can assign fields from the template design window. These fields are grouped accordingly as Non Detail or Detail areas of the format.

Section Description
Non Detail This area typically comprises of a heading section and a total section.
Header section The header section of a SYSPRO format refers to that area of the document that occurs before the first continuous section break.

Although you do not have to insert fields into tables for the header section, we recommend that you use tables to assist in aligning fields and formatting text.

The alternative is to use tabs and tab stops. While this alternative is an effective method of aligning fields and formatting text, problems are more likely to arise when using these methods.

One reason for this is that at run time SYSPRO replaces the bookmarks with data and this data can inherit the formatting style of the previous field.

To avoid this you can use multi-column tables, where the fields are separated into different cells. In this way the formatting of each field is preserved.

Total section The total section usually refers to the area of the document after the second continuous section break.
[Note]

The guidelines applicable to the heading section apply equally to the total section.

If the Header section break not required option is selected, then the total section is the section after the first section break.

You can optionally insert some or all of the total section into the footer of the document.

However if the entire total section is placed into the footer then the Total section break not required option must be selected from the MS Word Options menu.

Detail This area comprises sections that vary according to the specific format that is being maintained.

The Detail section of a SYSPRO format refers to that area of the document that is located after the first continuous section break.

Unlike the header section (where the use of tables is optional), all fields in the Detail section must be inserted into tables.

Depending on the number of fields used in the header and total sections, a maximum of 20 tables can be included in the Detail section of a SYSPRO format.

You must insert a continuous section break between each section of a format, as this enables SYSPRO to identify the different sections.

You also need to ensure that there is at least one space break between:

  • the information in MS Word's header and the heading section of the document
  • the heading section and the first section break
  • the first section break and the table in the Detail section
  • the Detail section and the second section break
  • the second section break and the total section

Continuation message

If you are using a continuation message, then you should position this on its own line to ensure that it appears correctly on the document.

When the document is being printed and the system detects that a new page must be inserted, it places only the line containing the continuation message before the page break. Any other bookmark placed on the same line is not populated with data.

Table locking

Table locking is an MS Word feature that allows you to specify where you want to place a table in a document and to lock the table to that position. SYSPRO Word printing also caters for table locking, but only for a single table and only in the total section.

You would typically use table locking to ensure that the total section is always printed at the bottom of the page, regardless of the number of detail lines printed on the page.

[Note]

If a table is locked, then you can only have one table in the total section and all bookmarks (except the continuation message) must be located in the table.

Table layout options

There are a number of ways in which you can configure tables in the Detail section of the format. These methods include using a single table or multiple tables.

Different detail line types placed into different rows of a single table

This method makes for a template that is easy to read and produces a document without a lot of whitespace. Additionally, you can apply different formatting options to the rows, which means you can make clear distinctions between specific rows.

Example:

Detail line Stock code Warehouse
Stock description Stock code long description  
Lot Lot quantity Lot expiry date
Different detail line types placed into the same row of a single table

You would use this method to save space, however you must ensure that at least one character is placed between each bookmark in a cell.

Example:

Detail line Stock code Warehouse
Stock description Stock code long description  
Lot Serial number Lot quantity Serial description Lot expiry date Serial expiry date
Each type of detail line placed into its own table

This method is recommended when you require an obvious distinction between the different detail line types.

Example:

Detail line Stock code Warehouse
Stock description Stock code long description  
Lot Lot quantity Lot expiry date

Lot Lot quantity Lot expiry date
One detail line type placed into multiple tables

In this example, the General detail line is split across two tables, however this method can waste space.

Example:

Detail line Stock code Warehouse

Stock description Stock code long description

Populating the data

SYSPRO uses one of two methods to populate data in the Detail section of the document:

Print using the entire page

When you select this option, SYSPRO calculates the number of detail lines that can fit on each page, regardless of the options you have specified in the heading and total sections.

You must ensure that the top and bottom margins are large enough to completely accommodate any information you place into the header and footer areas of MS Word. The reason for this is that SYSPRO uses the top and bottom margins to calculate the amount of printing space available.

[Note]

This option is slower because SYSPRO has to perform calculations to determine the height of each area that is placed on the document.

Print using line count

When you design a template based on the line count, the value specified at the Maximum number of detail lines per page field represents the total number of printed lines and not the total number of lines extracted to print. Thus, although a merchandise detail line is one line on an invoice, it can result in several lines being printed on the document.

[Note]

Blank lines between tables increase the line count.

Within the Detail section of a format, each table is broken down into several portions, each of which is then analyzed separately. These portions can be referred to as the table heading and table data portions.

Field Description
Table heading portion Begins after the first continuous section break, until the end of the last row of the table that does not contain a bookmark.

If you have configured more than one table in the Detail section, then table headings for subsequent tables apply from the end of the previous table, to the paragraph before the next table.

[Note]

Each table must have at least one paragraph before and after it.

Table data portion The table data refers to the individual rows of the table into which you have inserted fields that will be populated with data when printing the document.

The table data portion applies to everything after the table heading until the end of the last row of the table.

[Note]

SYSPRO does not detect carriage returns within a cell. This can result in inaccurate line counts.

Each time a new table with a column heading is inserted, an additional 2 lines are consumed (i.e. the paragraph after the previous table and the column heading row).

To best use the space available (where multiple tables are configured), we recommend that you structure these tables logically (i.e. repeating a sub group in different tables on the format consumes additional lines).

Column headings

There are a number of ways in which you can configure columns in the Detail section of the format. The method you choose depends on individual preference as well as the type of data being presented. A mixture of all methods can also be used.

Column headings placed at the end of the header section, before the first continuous section break:

Heading table:

Detail line Stock code Warehouse

Detail line table:

Detail line Stock code Warehouse
Stock description Stock code long description  
Column headings included as part of the table, after the continuous section break:

Heading and Detail lines in one table:

Detail line Stock code Warehouse
Detail line Stock code Warehouse
Stock description Stock code long description  
Column headings within cells alongside the bookmarks:

Heading and Detail lines in one table:

Detail line Stock code Warehouse
Detail line Stock code Warehouse
Stock Description Stock description -- Stock code long description  

Bookmarks

Bookmarks are used to insert SYSPRO fields into the various areas of a template document.

Using bookmarks also enables you to use Microsoft Word's header and footer areas, among others (e.g. Text box).

When you insert a Non-Detail bookmark, SYSPRO checks to ensure that it is not being inserted into the Detail section of the template. Similarly, when you insert a Detail bookmark, SYSPRO checks to ensure that it is being inserted into the Detail section and that it is being inserted into a table.

Bookmark warning messages

When you insert any bookmark, SYSPRO checks to see if any other bookmarks have already been created for the same field. If SYSPRO finds that the field already exists, then SYSPRO attempts to create a new bookmark for the same field, but with a numeric suffix attached. Up to ten instances of the same field can be inserted into the template.

Once ten bookmarks for the same field have been inserted the message Cannot insert the bookmark. The maximum number of entries has been exceeded is displayed.

If the original bookmark name is 40 characters long, then the message Cannot insert a duplicate bookmark. The field's name is already 40 characters long is displayed. This is because MS Word limits the length of a bookmark name to 40 characters.

General guidelines on inserting bookmarks

  • To insert a custom bookmark, first insert a single character (e.g. a space) then select the character and select Bookmark from the Insert menu.

    If you want the bookmark to be available after the document has been rendered during the print phase, then the bookmark must be prefixed with "ub_" and the bookmark must contain at least one character.

  • Always ensure that there is at least one character between bookmarks. If not, there is a high probability that data will not be printed in the document.

  • When inserting a bookmark into a cell of a table, ensure that the cursor is placed inside the cell and that the entire contents of the cell are not selected. Selecting the entire contents of the cell can cause problems when SYSPRO populates the document with data.

  • A bookmark cannot be inserted into the template when MS Word is minimized.

  • A bookmark cannot be inserted when you have more than one document open and the template is not the active document.

Printing Word documents

When documents are printed, use is made of the foreground printing option which means that each document must be completely spooled onto the printer before the next document can be created. If the printer's spooler becomes full (possibly due to the printer having run out of paper), then the system cannot create the next document until the spooler is cleared. The resulting delay may cause the system to terminate abnormally.

Therefore, when you print batch documents, try to ensure that the printer's spooler does not fill up by ensuring that the printer has enough paper and ink before you begin the print process.

If you select to print a range of documents and you use the Preview facility, then only the first document in the range is displayed in the Preview window due to limitations in MS Word.

The MS Word session is automatically opened and closed for each batch print, or in the case of online printing, for each document printed. However, if you use the Preview facility, you will need to close the MS Word session manually when printing is complete.

The following windows are displayed during the print process:

Window Description
Standard tickover window displayed by SYSPRO while the data to be printed is extracted If you select the Cancel function during this process, then no further data is extracted for printing. Data already extracted will be sent to the printer.
MS Word tickover window that displays the current printing status of MS Word documents If you select the Cancel function during this process, the printing of all remaining documents is cancelled.
Window displayed by the MS Word program during the print process of each document If you select the Cancel function from this screen, then only the current document being printed is cancelled.

The remaining batch of documents to print is not cancelled.

General information for Word printing

SYSPRO reformats the data extracted to print before it is sent to the print routine. When SYSPRO extracts the data to print, the header section data is extracted first, followed by the Detail section data and lastly the total section data.

Word printing, however, requires access to the total section data before the Detail section data so that it can place a total section on the first page of a document if required.

The print phase reads the information stored during the analysis phase and removes the data that is not required by the template. The template file, and attachment file if required, are copied to the temporary folder on the client machine before the print process starts. This reduces network traffic.

The print phase creates a temporary document, based on the template, to act as the source document. When faxing or emailing a document, the files are created in the temporary folder. These files are then deleted when emailing the document, but not if the document is being faxed. This is because the fax software, specifically WinFax PRO requires access to the document after SYSPRO performs the clean up process.

Diagnostic codes

SYSPRO enables you to enter diagnostic codes which create log files during the design phase and these files can then be used to locate errors.

The following diagnostic codes can be used for Word printing:

Diagnostic code Description
WORD01 Keeps the data files created by the print process which are usually deleted once the print process is complete.

The following files are saved:

  • The template file that was copied to the temporary folder on the client (only applicable in a client/server environment).

  • The attachment file that was copied to the temporary folder on the client (only applicable in a client/server environment).

  • The temporary file that contains the data extracted to print. This file resides in SYSPRO's temporary folder or in the temporary folder on the server in a client/server environment.

    [Note]

    The Windows Environment Variable TEMP defines the location of this file. A typical file name for this file could be _T053004.DAT.

WORD02 Creates a log file of the program execution that occurred on the client machine during the design process

This can be useful when attempting to find the location of an error during the print, design, analysis or validation phase.

[Note]

The log file is saved as WordPlog.txt in the temporary folder on the client machine.

WORD03 Creates a log file that traces the server side program execution.

This can be useful when attempting to find the location of an error during the print, design, analysis or validation phase.

[Note]

These files are saved on the server in the Base\Settings directory on a Windows server and in the Base directory on a Unix/Linux server.

The name of the file that is created is Oper.txt, where Oper is your operator code.

WORD99 Combines the functionality of WORD01, WORD02 and WORD03, if you want to create both log files as well as retain the data files created during the print phase.

Notes and warnings

MS Word Options considerations

  • Templates can be stored on a non-Windows server.

  • Templates residing on the server are stored in the Base\Template folder of your SYSPRO installation.

  • The Template name cannot contain spaces if it is stored on the server. If a template exists on the server with the same name then a numerical suffix is added to the template name to ensure that any existing file is not overwritten.

  • If your template layout requires a certain section to be defined (i.e. header, detail or total), then you must configure it in order to complete the design phase.

  • The Attachment Options are ignored if a file attachment is not found at the time of printing the document (i.e. the document is produced without the attachment).

Template design considerations

  • The template must not exceed one page in length.

  • When you open a template in design mode, SYSPRO has to change the template to insert the default text against the bookmarks. This text is then removed when the template is closed. Therefore you are prompted to save the template even if you have made no changes to it.

    At this point, a resource conflict can occur.

  • Resource conflicts can also occur when opening a document that is not based on the template, because all Microsoft Word documents are ultimately based on the normal .dot file.

    Using Microsoft Word as the email editor in MS Outlook can also cause this type of resource conflict.

  • To reduce the chance of document resource conflicts, it is recommended that no other documents are opened (or already open) with Microsoft Word when using MS Word printing, or when designing a template.

Section considerations

  • A continuation message must not be placed inside a table. If you place the continuation message in a table, then the line containing the continuation message is not printed when the total section is printed on the last page.

  • No bookmarks must be placed on the same line as the continuation message.

Header sections
  • There is no limit to the number of tables that can be included in the header section of a SYSPRO format.

  • The table position cannot be locked in the header section of the document.

  • The use of tables within the header section is optional. However if you use tables, then you must insert a carriage return before the first table and after the last table to avoid possible formatting problems.

  • The header section in SYSPRO is not the same as the header section in MS Word. If you choose to assign some (or all) of the SYSPRO header section into the MS Word header area, then you must select the MS Word option: header section break not required.

  • The MS Word header and footer option Different first page can be used in a template.

Detail sections
  • Multiple bookmarks can be assigned to a single cell (or column) providing they are separated by at least one character (e.g. a space, full stop, carriage return, etc).

  • When the template is analyzed or validated, a warning message is displayed if more than one bookmark appears in a single cell.

    Although you can ignore the warning and save the template, if these bookmarks are adjacent to one another (i.e. not separated by at least one character) then some (or all) of the data in the field will not be printed.

  • Cells in the Detail section cannot be vertically merged.

    This is because MS Word printing analyzes the Detail section on a row-by-row basis and MS Word does not allow single row selection in a table when cells are merged across two or more rows.

  • The table position cannot be locked in the Detail section of the document.

  • It is possible, but not advisable, to place fields from two or more detail line types on the same row of a table.

  • In general, the more tables you use in the layout of the Detail section, the more space is wasted when changing between tables.

  • You must enter a carriage return between tables, as well as between a section break and a table.

Hints and tips

General Design Advice

The following are some guidelines to assist you in creating a template:

  • Try to keep the template design as simple as possible.

  • Make sure that at least one carriage return is placed before and after each section break.

    To reduce the amount of space that is taken up by these blank lines, you can reduce the font size for these lines. This font size can be set to 1 or 2, even if the lowest available size in the font size list is 7. You can reduce the amount of space taken up by the section break line in the same way.

    You can also enter standard text in the blank lines.

  • You can only enable text wrapping inside a table in the total section.

  • The use of multimedia objects affects how data is formatted on the page. Consider the amount of space an image will occupy, as too large an image will restrict the amount of detail that is printed on the page.

    Up to 40 multimedia objects can be used in a document.

  • The document's formatting marks can be viewed by selecting Options from the Tools menu in Microsoft Word and then selecting the required options from the View tab.

    Displaying the document formatting marks can assist you in designing the template.

  • Defining a border around tables can assist you in designing the layout of the template.

    You can also remove these borders once you have completed the design if you do not want them to be printed around the tables on your document.

    Alternatively, you can use the Show/Hide Gridlines option from the Table menu to view the table outlines, as these outlines are not printed on the final document.

  • Save the design using the Save option from the File menu in Microsoft Word before you exit the design phase. This ensures that the design is saved even if critical errors are encountered during the analysis phase.

  • Use tables to make formatting easier. For example, if you require different formatting for static and variable text, it is easier to do this using tables.

    [Note]

    Static text is text you enter into the template.

    Variable text is the text that SYSPRO inserts in the place of bookmarks.

    When using tables, alignment rules can be applied on a cell-by-cell basis, border lines and background color can be applied, all of which can be used to highlight the data.

    Bookmarks that require different styles can be placed into different cells, without leading or trailing text.

    In some cases, both tables and tab stops might be required to achieve the desired result.

  • Enable diagnostics to assist you in troubleshooting.

Print your company logo on the stationery

One of the advantages of using MS Word to format and print your stationery is that you do not need to purchase pre-printed stationery. This is made possible by the facility to insert a graphic representation of your company logo (e.g. into the MS Word header).

[Note]

Do not confuse the MS Word header with the SYSPRO heading section.

  1. Select the header and footer option from the MS WordView toolbar.

  2. Insert the required graphic into the header section of the template.

    You can also use the Watermark feature of MS Word to print your company logo on your stationery.

Enable diagnostics

SYSPRO enables you to enter diagnostic codes which create log files during the design phase. These files can be used to attempt to locate errors.

  1. Navigate to the General tab of the System Setup program.

  2. At the Diagnostics field, enter one of the diagnostic codes required.

  3. Select Save to enable the diagnostic option you entered.