Tutorial - Setup Extender to Log changes to A/R Customer Credit Limit

A company wants to log all changes to the A/R Customer Credit Limit using Orchid Extender.

Extender Setup

Requirement! This functionality is available in Extender Levels Configurator, Customizer and Developer.

Step 1: Create a "LOG" Event Type in Extender Setup / Event Types

Choose "Log Change" as the Action.

Choose "Don't Combine" so that the original and new values are logged.

 

Save the Event Type.

 

Step 2: Attach the LOG Event to the A/R Customer Credit Field in Extender Setup / View Events and Scripts.

Enter AR0024 as the View ID for A/R Customer.

Select AMTCRLIMT as the Field Name and choose LOG as the Event Code.

Note:

If you have already configured Extender for the A/R Customer View, a list of events configured will be displayed.

If you don't know the View ID, you can click F6 or the "All Views Info" icon to display a list of all Extender Views active in the database.

You can use Extender / Inquiries / View Info to view additional details on the Extender Views.

 

Step 3: Add / Save the View Event.

Viewing Log Details

In A/R Customers, Update the credit limit for Customer 1200, Mr Ronald Black.

You can view the Extender log directly from the A/R Customer Screen or from the Extender / Inquiries / Log.

Note: If you update the customer credit limit by importing into Sage 300, from Sage CRM or other Third Party applications that use the Sage 300 Views and API, Extender Logging will also take place.

From the AR Customer screen

Highlight value in a text field, and type ` (back tick) and tab - The Extender Log for the selected customer will display (filtered by default for the current month. You can change the filter on the Extender Log Screen.

Tip:

You can view the Log for a particular view in the original screen. For example if you want to view the changes made to the Customer view from the Customer entry screen, highlight any text field and enter ` (back tick) and [tab]and the Extender Log will be displayed, filtering on the appropriate View. An example of a text field on the Customer screen on the processing tab is the Credit Bureau Information Rating field or the Credit Bureau Information Number field. Other examples are the Address fields on the Address tab.

`[tab] cannot be entered on a date, a number, a check box field or a lookup field with a mask on what can be typed in the field. If the text field already has information – for example the Customer name, you need to select all the text (highlight it), then type `[tab] – the VI Log will be displayed and the original text restored to the field.

If you are using Information Manager and have licences for Workflow Users, you can configure an icon on the Sage 300 screen to view the Logs.

For details, refer to Extender LOG- Notes/DML/Extender Tray .

Extender Inquiries / Log

You can view all log entries in Extender Inquiries > Log.

Use [] in any of the columns to filter the log contents by the selected column.

The current filter is shown along the bottom of the screen, and is saved per user per screen.

Tip: You can apply a filter on multiple columns by first clicking [Ctrl] on the first column required and applying the filter, and then by clicking [Ctrl] on the second column required and applying the filter.

Tip: If the filter is not cleared prior to closing the screen, it will be remembered and re-applied the next time the same user opens the same screen.

For More Details on Setting up Extender Configurator.

Event Types.

View Events, Scripts & WF