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

Get the latest thought leadership from Avaap delivered to your inbox weekly!

* indicates required

Expert Insights

Trending resources

The Complete Guide to ACA Setup and Configuration (PDF)

This presentation takes a deep dive into setup and configuration for the Affordable Care Act (ACA) inside Infor Benefits Administration.…
Leveraging Change Management When Moving to the Cloud

Leveraging Change Management When Moving to the Cloud

Start with the end in mind: Optimize your future state by leveraging the current state…
Spilling the Tea: Three Things You Should Know Before an ERP Implementation

Spilling the Tea: Three Things You Should Know Before an ERP Implementation

Have you implemented ERP in the cloud? There are many people who are first-timers to…

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