Using Browses

It is possible to list some Sage data directly from Excel using Excelerator.

For example, in the standard template for NL Journal Excelerator, if user select a cell in the nominal_code range, right click user will see:

If user select Browse Records then the following will be displayed:

As shown, if user start entering a number, then the browse auto-completes the entry, and jumps to that data.

User can select a posting code, click OK, and the posting code will be displayed in the cell.

In the browse, clicking on the description column header reorders the list in description order:

The auto-complete then works on the description instead. This allows quick look ups based on data like descriptions.

This feature is available on all browse columns.

Some browses have Advanced Browses available.