TASBooks & Microsoft Word templates - How to edit an invoice or credit note template
Description

You can make basic changes such as adding your company logo and bank details, or create a completely bespoke design.

Cause
Resolution
To open the invoice or credit note templates
  1. Click Sales Orders, then click Print and Post, then click Print Sales Invoices / Credit Notes.
  2. Click the Print Options tab, then select to Use Microsoft Word Template.
  3. To select a new template, click Change, then select the required template.
  4. Click Edit.
To add an invoice or credit note template
  1. Click Sales Orders, then click Print and Post, then click Print Sales Invoices / Credit Notes.
  2. Click the Print Options tab, then select to Use Microsoft Word Template.
  3. To add a new template, click Change, then click Add New.
  4. Click the folder icon and browse to your template, then click Open.

    TASBooks has the following standard templaes alread available in C:\ProgramData\Sage\TAS\TASBooks\Company001\Accounts

TWINVBLK If you want to create your own invoice or credit note template, select this option.
TWINVPHT If you want to add your company logo to the standard invoice or credit note template, select this option.
TWINV Select this option if you want to use the standard invoice or credit note template.
TWINVE Select this option if you want to print an extra column to display amounts in a second currency, for example, Euro.

Editing your template
  1. Click Sales Orders, then click Print and Post, then click Print Sales Invoices / Credit Notes.
  2. Click the Print Options tab, then select to Use Microsoft Word Template.
  3. To select a new template, click Change, then click Edit.
Save your template and add to TASBooks
  1. Click File, then click Save As.
  2. Save the document with a custom filename. The file type must be Word 97-2003 Docuement (*.doc).
  3. In TASBooks, click Sales Orders, then click Print and Post, then click Print Sales Invoices / Credit Notes.
  4. Click the Print Options tab, then select to Use Microsoft Word Template.
  5. To add your new template, click Change, then click Add New.
  6. Browse to and add your template.
Add rows and columns to your template table
  1. Highlight the last row of the existing table.
  2. Right-click the highlight, then click Insert, then click Insert rows below
  3. To insert a column, highlight the column, then click Insert, then click Insert Column to the Right/Left.
  4. You can delete the highlighted row or column by highlighting it, then selecting Delete Cells.

 

Insert fields and text

To insert text

To add text to all invoices simply type the text required in the required position. Every document printed will then display this text.

To insert fields

You can add fields to the Header, Body and Footer of the document.

Add a field to the Header or Footer
  1. Click where you want the field to appear.
  2. From the menu bar, select TAS, then click Header or Footer..
  3. Select the relevant field, then click OK.
Add a field to the body of the document,
  1. Click into the first empty cell in the description column.
  2. Click TAS Menu, then click Body.
  3. From the TAS Invoice Fields window, select the relevant field.
  4. Select the number of the row you're adding the macro to.
  5. Click OK.
  6. Repeat the above steps for all the rows in the body of the document.

To change the number of lines parameter

Each template is set-up to display a certain number of lines as a default and to fit to A4 size. The invoice template for example displays 33 lines as default. If you change the template you may need to delete some rows to allow you template to fit on one page. If you change the number of lines on the invoice you need to change the Number of Lines parameters in accordance with this.

  1. Click File, then click Properties.
  2. Choose Advanced Properties then select the custom tab.
  3. From the Properties pane at the bottom of the window, click NumOfLines.
  4. Change the Value field to show the number of lines on your document.
  5. Click OK.
Re-use fields

if you need to duplicate a field, you must insert it as a cross-reference.

  1. Click once in the area you want the field to appear.
  2. Click Insert, then click Cross-reference.
  3. Select Bookmark from the Reference type drop-down list.
  4. Select the relevant macro, then click Insert.
To save the template
  1. Click File, then click Save As.
  2. Enter file name, if required, leaving the file extension as .DOT.
  3. Click File, then click Close.
[BCB:19:UK - Sales message :ECB]
Steps to duplicate
Related Solutions