Contents

Download Templates

Caroline Buckland Updated by Caroline Buckland

Did you know you can download to a template? Have a look at the below.

To setup the template, follow the instructions below.

The balances template can be used in the following screens.

Profit and Loss

Balance Sheet

It can be used on the Account Details screen, but not recommend due to the flexibility of the enquiry.

The excel sheet must have the first tab name of E5_CTRLD_CMDS

The second sheet is where the data will be applied E5_CTRLD_OUTPUT

 

Each cell you require to download needs to be individually coded.

The format is as follows.

e5.cell(2,4)         where 2,4 represents Row and Column

In this instance the value returned would be -38001.70

To action the download, access the enquiry screen.

General Ledger>GL Enquiries>Profit and Loss

Make and entry in the selection window and click on OK., select the download icon.

Select Open using Excel Spreadsheet option and then use the browse button to locate the template.

Click on OK once the template is loaded, the zip file can be found in your download directory.

Was this article useful?

Why has my transaction not appeared on the AP Payment run?

Useful information to include when raising Financials cases

Contact