Is it possible to use wildcards in the named items for Gridview? What I would like is for the last two digits of the ledger account to equal the province. If so, what is the syntax?

Lars

Hi Lars,

I think there are two separate questions here:

1) Named items and wildcards allowed?
No. The purpose of Named items is to 'translate' a field entry from one value to another. For example, if the document type is "I" then print "Invoice". Or if "BC" then print "British Columbia". There is a one-to-one correspondance here and wildcards are not valid - ? and * are interpreted as literal text only.

2) Using the province as the last two characters of the GL account code.
If Adagio Ledger is set up for the accounts to use this structure, then GridView can use a Calculated Column to extract the last 2 characters to get the province:
Right({GL acct},2)
This calculated column can be used for filtering or summarizing/subtotaling data.

Hi Lars,

Just a note to caution against coding a location into a GL account code. You'll find it much easier to generate financial statements if you encode the location (province) into the department.