List Window

On most programs that add or edit records in a table, the first window display is a list of records. Here is the main list for the Customer master in Accounts Receivable:

01 RAG 7-20-2012

There are four parts to the list window:

  • Start Prompt (top)
  • List display (middle)
  • Buttons and Status Bar (bottom)

 

   Page 1 — list window
   Page 2 — start prompt
   Page 3 — list display
   Page 4 — mouse and keyboard
   Page 5 — buttons and status bar

Next — Start Prompt >

Finding Stuff — Zoom

In the Finding Stuff series, there are a number of ways to find and filter data: wildcard, zoom, find, select and Quiz Select.

This article is on ZOOM.

Zoom is a filter on a Telios list. The filter is set from the column value of the highlighted column. Clear?

Okay, here is an example. We go into the Customer Master in Telios:

0007 RAG 7-11-2012

The status bar displays ZOOM if the list supports zoom.

Continue reading…

Finding Stuff — Find

This series on finding stuff has wildcard, zoom, find, select and Quiz select.

So what’s more basic that Find itself?

This function is standard on virtually every Telios list. Okay, probably not on all the popups, but just about everywhere else.

So, how does it work? We look at the main Sales Order list for an example:

0009 RAG 7-17-2012

For the sake of documentation, the Find options are located on the context menu (right-click or press M, or CTRL + SHIFT + F10). On most of these menus they are buried in the “Other” category – primarily because CTRL-F and CTRL-G are pretty much the standard for the find and find next functions.

More…

Edit Window

The Edit window is used to add, change and delete individual records. In most cases the Edit window is associated with a List window.

The Edit window may have line items and sub-sections like the Inventory Master Edit window:

00 RAG 7-27-2012

Or, it can simply have fields from the corresponding table:

02 RAG 7-27-2012

In both cases, the button at the lower right hand corner will return to the main List window.

   Page 1 — edit window
   Page 2 — the buttons
   Page 3 — find field
   Page 4 — field TAG
   Page 5 — the edit field

Next – The Buttons >

Print — Repeat

SQL returns every field on every row selected on a query. You often don’t want every field to print on every row. So… we have this reserved word.

Where count and summarize keep track of unique values, repeat deals entirely with consecutive values.  If the values of the records are like this:

A B B C B A A C C B B A  — the printing would be like this:
A B    C B A     C     B     A

There are two forms.

  1. norepeat — skips print of duplicate value
  2. repeat on — accepts modifiers. Whenever the target field or any one of the modifiers change, the field prints.

 

   Page 1 — repeat
   Page 2 — norepeat
   Page 3 — repeat on
   Page 4 — repeat on page

Next – norepeat >

Print — Summarize

summarize is used in two ways:

  1. For numeric fields, summarize will calculate a running total of the field. The on arguments then determine when the accumulated value prints. When the field prints, the running total is reset to zero.
    Where break will print totals under an existing column, summarize prints its values in a separate column.
  2. For date and text fields, summarize acts as a filter rather than an accumulator. The on arguments determine when the date or text field prints.

All summarize statements require at least one following ‘on’ reserved word.

   Page 1 — summarize
   Page 2 — summarize syntax
   Page 3 — numeric summarize
   Page 4 — date summarize
   Page 5 — expression summarize
   Page 6 — text summarize

Next – summarize syntax >