Bursting Strategic Ledger Fields

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

Subscribe

* indicates required

Expert Insights

Trending resources

What you need to know about Workday's new accounting center functionality

Workday’s accounting center is bringing new functionality. Get an introduction to the accounting center, learn how these changes impact your…

Change Fatigue is Real  

This year has been one for the books. Social distancing, wearing masks, new hand washing routines all against a backdrop of…

Remote Implementations: Improving Operations Amid Pandemic Uncertainty

As countries experience second or third waves of the coronavirus pandemic, many including the United…

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