Bursting Strategic Ledger Fields

By: David Williams
Date: September 06, 2013

I was asked the other day if I could present four different fields for the one SL field currently on various forms, some in the header, some in the detail section of the form, so that the user wouldn’t have to add the values as comma separated records.

Since I love a challenge…

I deleted the one SL field and added 4 labels and 4 text fields to the form at the line level.
Each label listed what the field value should be.

When the user Inquires on the form my script retrieves the Segment Block value for each line presented
and puts that into an array (by line) and then splits the array and assigns each value into the correct text field.

When the user Adds/Changes on the form my script takes the 4 text field values (by line), puts them into one comma separated variable and then assigns that to the Segment Block value in the OnBeforeTransaction function.

The user was very happy with the ease of use that this provided to them and so, of course, asked for the ability to select Define on each of the 4 fields.

In order to add Define to a text field that you’ve added to a form, you must go into the Source tab, find the
lines for each field and add hdef=”1″ and deftkn=”SL40.6″ to each of the 4 text field references. Now when the user right clicks on your text field, they get the option to select Define.

Don’t forget that if you add a text field to the detail line section of your form then you also have to update the field so that the system knows to track it by row. In this case you would find the line in the Source and update the field number from nbr=”_f730″ to nbr=”_f730r0″.

There you go. A simple solution that makes data entry much easier for clients using the Strategic Ledger system.

David Williams, Principal Consultant

Our Headquarters

Avaap USA, LLC
510 Thornall Street, Suite 250, Edison, NJ 08837

Phone: 732.710.3425
Fax: 732.243.9550
Email: info@avaap.com

Avaap Midwest 
6 West Fifth Street, 8th Floor, St Paul, MN 55102

Avaap EHR 
70 Madison Street, Suite 2610, Chicago, IL 60602

Global Center of Excellence 
Chennai ONE, IT SEZ, Upper Stilt, Pallavarm-Thoraipakkam, 200 ft Road, Thoraipakkam, Chennai 600096. INDIA

Avaap UK
Stanmore House 64-68 Blackburn Street Radcliffe, Manchester M26 2JS. England

Avaap Spain
Antonio Machado 78, Australia Building 1-A3, Viladecans, Barcelona 08840 Spain

Avaap Amsterdam
Keizersgracht 62-64 Amsterdam, Netherlands 1015CS

Technical assistance for Avaap Managed Services and Product customers: support@avaap.com