Method

This article will show you how to add a column to the item line grid in a transaction print template using the Web Report Designer.

___________________________________________________________

In the following example, we are going to add another column containing the unit of measure field, to the invoice print template.

The first step is to find out which print template you are using. You can find this in the preferences screen of the transaction app itself.

Click the vertical ellipses [<code> ⋮ </code>] on the Invoices App and then click Preferences.

In the below example, you can see the template we are using is called Printable Invoice. Armed with that knowledge, we can open it in the web report designer.

Click the preferences icon in the upper-right corner and select Account Settings.

Scroll down and select Reports and Print Templates.

In our example, we will search for "Printable Invoice".

Since you are making changes to the template, it would be better if you created a duplicate of the template. Click the vertical ellipses [<code> ⋮ </code>] beside your selected print template and click Duplicate.

Change the name and description so you know not to confuse it with the other print template. When you are ready, click Launch Builder to start editing!

1. Click the vertical ellipses [<code> ⋮ </code>] on the Invoices App and then click Preferences.

2. In the below example, you can see the template we are using is called Printable Invoice. Armed with that knowledge, we can open it in the web report designer.

3. Click the preferences icon in the upper-right corner and select Account Settings.

4. Scroll down and select Reports and Print Templates.
5. In our example, we will search for "Printable Invoice".
6. Since you are making changes to the template, it would be better if you created a duplicate of the template. Click the vertical ellipses [<code> ⋮ </code>] beside your selected print template and click Duplicate.

7. Change the name and description so you know not to confuse it with the other print template. When you are ready, click Launch Builder to start editing!

The first thing you will need to do in the template is alter the size of the other fields on screen. The list of items is using a table object to display itself. You will need to insert cells into the table object to display the UOM field.

On the right, the DESCRIPTION object's properties appear. Under action, find the small icon and hover over it. It will show that it is the "Insert Column To the Right" action. Click this icon to insert a column.

Double-click this table cell and rename it "<code>UOM</code>".

On either side of this new cell, you will see two little squares. By clicking and dragging these squares, you can resize the cell. Make it roughly the same size as the QTY cell.

Select the [Item] line and insert a column to the right again.

Resize them to match the size of the UOM, and also clear their text.

Now you're ready to drag in your new field, but you need to find it first.

- Select the database icon in the right menu.
- Expand the line with your Method account name [▾].
- Expand the Invoice [▾] line.
- Expand InvoiceLine.Invoice [▾].

Scroll down and find the UnitOfMeasure field. Click and drag that...

... into the cell you added earlier in the [Desc] row of the table.

Finally, at the top, Save and then Close the report.

1. Click the DESCRIPTION object.

2. On the right, the DESCRIPTION object's properties appear. Under action, find the small icon and hover over it. It will show that it is the "Insert Column To the Right" action. Click this icon to insert a column.

3. A new tableCell## will appear.

4. Double-click this table cell and rename it "<code>UOM</code>".

5. On either side of this new cell, you will see two little squares. By clicking and dragging these squares, you can resize the cell. Make it roughly the same size as the QTY cell.

6. Select the [Item] line and insert a column to the right again.

7. Resize them to match the size of the UOM, and also clear their text.
8. Now you're ready to drag in your new field, but you need to find it first.
 - Select the database icon in the right menu.
 - Expand the line with your Method account name [▾].
 - Expand the Invoice [▾] line.
 - Expand InvoiceLine.Invoice [▾].

9. Scroll down and find the UnitOfMeasure field. Click and drag that...

10. ... into the cell you added earlier in the [Desc] row of the table.

11. Finally, at the top, Save and then Close the report.

Set the Transaction Template as Default Print Template

Now that you have created your new transaction template, you will need to go into your preferences again and set it as the print template.

Click the vertical ellipses [<code> ⋮ </code>] on the Invoices App and then click Preferences.

For the Print Template, select your custom template you created.

Click Save &amp; Back and you're done!

1. Navigate to your Method Dashboard.
2. Click the vertical ellipses [<code> ⋮ </code>] on the Invoices App and then click Preferences.
3. For the Print Template, select your custom template you created.

4. Click Save &amp; Back and you're done!

One final thing, aligning of text is a bit tricky when it comes to the web report designer. You may wish to view some example templates to ensure the text is in the place you want, and aligned properly.

How to add another column in invoices, estimates, sales orders, sales receipts, print template.

Find the Transaction Template To Edit

Customize the Transaction Template

Set the Transaction Template as Default Print Template