This is an old revision of the document!
Using APP Customizer
Item Placement - Allows the user to add objects (labels, text fields, buttons) or tabs to forms without the use of programming knowledge.
Process Rules - allows the user to add field and event based validations and procedure executions to forms without the use of programming knowledge.
Tab Order - allows the user to establish, edit, and remove custom designated tab orders for forms that will override the normal order of moving between fields on a form.
Mandatory Fields - allows the user to establish, edit, and remove custom designated mandatory fields for forms that will operate in addition to the normal required fields on a form.
Information for forms that have been customized using APP will be saved into the database as XML. These XML files are used at the time that the form is loaded in SAP® Business One.
If you are upgrading to a new version of APP from a prior version that did not store customized form data as XML, you will be required to convert or “migrate” the customization data during the upgrade process.
TWBS APP Server Configuration screen access is controlled through the SAP® Business One Authorizations function.
Click the
Report Definition menu option under the
Administration
Setup
APP Configuration menu groups to load the
APP Server Configuration screen.
This process may take a few minutes depending on the number of forms that have been customized with APP.
If any add-on applications have forms that were customized using APP, they must be connected and running at the time that the Generate XML button is clicked otherwise the user will receive an error in the conversion process.
The user should fill in the Menu UID for each form and then click the Generate XML button.
When the process is complete the user will receive a message on the SAP® B1 satus bar that the process was successful.
Item Placement
Item Placement functionality allows the user to add objects (labels, text fields, buttons, and tabs) to enhance any SAP® Business One forms or UI-based add-on application screens or edit the properties of existing SAP objects without the use of programming knowledge.
How To Auto Reference a Control During Item Placement
During the Item Placement process, it is necessary to designate a reference control on the form that will serve as an anchor point for the placement of the new item. This section will describe the process of automatically referencing an item during this process.
Automatic referencing of the control will reduce the number of item placement steps.
This example is for the Business Partner Master Data screen.
Click the SAP menu option titled Business Partner Master Data under the Business Partner menu to load the Business Partner Master Data screen.
Determine the item that you want to use as the reference control item (Currency field for this example).
Select the New Item option from the APP Customizer menu group option from the right-click menu on the form. Select the option for the type of item to be added to the form.
The right-click menu should be launched while the mouse is on top of the item being used as the reference control.
Automatically referencing the control item does not prevent the user from clicking the … button and manually selecting a different reference control. For additional information on the manual reference process, refer to the How To Manually Reference a Control During Item Placement section.
How To Manually Reference a Control During Item Placement
During the Item Placement process, it is necessary to designate a reference control on the form that will serve as an anchor point for the placement of the new item. This section will describe the process of manually referencing an item during this process.
This example is for the Business Partner Master Data screen.
Click the SAP menu option titled Business Partner Master Data under the Business Partner menu to load the Business Partner Master Data screen.
Select the New Item option from the APP Customizer menu group option from the right-click menu on the form. Select the option for the type of item to be added to the form.
This example is for the Business Partner Master Data screen and utilizes the automatic control reference process.
Click the SAP menu option titled Business Partner Master Data under the Business Partner menu to load the Business Partner Master Data screen.
Determine the item that you want to use as the reference control item (Opportunities field for this example).
Select the New Item option from the APP Customizer menu group option from the right-click menu on the form. Select the option for the type of item to be added to the form.
Current options are text box, label, tab, or button.
Edit any properties that need to be altered.
Click the Save or Save & Close button.
The new item will be displayed on the form.
This example is for the Activity screen.
The right-click menu should be launched while the mouse is on top of the tab to the left of the position where you want the new tab to be added on the form.
Edit any properties that need to be altered.
Click the Save or Save & Close button.
The new tab will be displayed on the form.
Once the tab has been added to the form, other objects can be added. Please refer to the How To Place a New Item on Form section of the user guide.
Here is an example of some labels, text boxes, and a button added to a custom tab.
This example is for the Business Partner Master Data screen and utilizes the automatic control reference process.
Click the SAP menu option titled Business Partner Master Data under the Business Partner menu to load the Business Partner Master Data screen.
Determine the item that you want to use as the reference control item (El. Doc. Export Format field for this example).
Select the user defined field option to be added to the form (rbLblUse in example) from the APP Customizer -UDF menu group option from the right-click menu on the form.
Updates to the value on either the form-placed user-defined field or the UDF tab field will be reflected in all fields on update.
This example is for the Business Partner Master Data screen.
Click the SAP menu option titled Business Partner Master Data under the Business Partner menu to load the Business Partner Master Data screen.
Select the Control Properties option from the APP Customizer menu group option from the right-click menu on the form.
The right-click from the form should be performed while the cursor is on the item on the form.
This example is for the Business Partner Master Data screen.
Click the SAP menu option titled Business Partner Master Data under the Business Partner menu to load the Business Partner Master Data screen.
Select the Item Placement Configurator option from the APP Customizer menu group option from the right-click menu on the form.
This example is for the Business Partner Master Data screen.
Click the SAP menu option titled Business Partner Master Data under the Business Partner menu to load the Business Partner Master Data screen.
Select the Control Properties option from the APP Customizer menu group option from the right-click menu on the form.
{
The right-click from the form should be performed while the cursor is on the user defined field or label on the form.
How To Change Visibility of a Standard SAP Item
This example is for the Business Partner Master Data screen.
Click the SAP menu option titled Business Partner Master Data under the Business Partner menu to load the Business Partner Master Data screen.
Select the Control Properties option from the APP Customizer menu group option from the right-click menu on the form.
The right-click from the form should be performed while the cursor is on the item on the form.
Change the visible property of the item by unchecking the Visible checkbox.
Click the Save or Save & Close button.
The item edited will be removed from the form.
The form must be closed and reopened in order for the item to reappear on the form.
How To Change Panes of a Standard SAP Item
This example is for the Business Partner Master Data screen.
Click the SAP menu option titled Business Partner Master Data under the Business Partner menu to load the Business Partner Master Data screen.
Select the Control Properties option from the APP Customizer menu group option from the right-click menu on the form.
The right-click from the form should be performed while the cursor is on the item on the form.
important boxThe form must be closed and reopened in order for the item to reappear on the form.
This example is for the Business Partner Master Data screen.
Click the SAP menu option titled Business Partner Master Data under the Business Partner menu to load the Business Partner Master Data screen.
Select the Item Placement Configurator option from the APP Customizer menu group option from the right-click menu on the form.
The properties of the newly copied item on the destination form will in most cases need to be edited for position, height, width, etc.
This example is for the Sales Order screen.
Note -
Click the SAP menu option titled Sales Order under the Sales - A/R menu to load the Sales Order screen.
Select the Item Placement Configurator option from the AP Customizer menu group option from the right-click menu on the form.
The form must be closed and reopened in order for the item removal to take effect.
Process Rules
Process Rules functionality allows the user to add field validations and procedure executions to enhance any SAP® Business One forms or UI-based add-on application screens without the use of programming knowledge.
How To Auto-Record a Macro
This example is for the Business Partner Master Data screen.
The macro editor will only support actions against screens where there are not multiple instances of that screen open in SAP® Business One when the macro is being performed. For example, a macro that performs an action against form #139 (the Sales Order form) should only be performed with one Sales Order form window open.
Click the SAP menu option titled Business Partner Master Data under the Business Partner menu to load the Business Partner Master Data screen.
Determine the item that you want to establish process rules for (Create Order button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Enter an Event Description value for the event.
Select the validation level option (No Validation option selected for this example).
Click the Define New option from the Procedure drop down. This will launch the Procedure Handler screen.
The Auto-Record function has limited support for opening forms and copying of data from field to field using the right-click menu option at this time.
The right-click menu should be launched while the mouse is on top of the field to copy.
The right-click menu should be launched while the mouse is on top of the field the value is being pasted into.
For more information on manually editing a macro, refer to the How To Manually Setup a Macro section of the user guide.
How To Manually Setup a Macro
This example is for the Business Partner Master Data screen.
The macro editor will only support actions against screens where there are not multiple instances of that screen open in SAP® Business One when the macro is being performed. For example, a macro that performs an action against form #139 (the Sales Order form) should only be performed with one Sales Order form window open.
Click the SAP menu option titled Business Partner Master Data under the Business Partner menu to load the Business Partner Master Data screen.
Determine the item that you want to establish process rules for (Create Order button for this example).
The right-click menu should be launched while the mouse is on top of the item.
This example is for the Business Partner Master Data screen.
(Insert Row option selected for this example)
Optional information for the macro row will be colored in light yellow. Required information for the macro row will be colored in light red. Fields that are not required for the action type will be colored in light grey. For more information on the fields and data that are required for each action type, refer to the Macro Editor screen section of the user guide.
How To Use Multiple Event Instances
This example is for the Item Master Data screen.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Item Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the Events tab.
Choose the Event option that you want to record the process rules macro for.
Click the Define or Edit button on the Event that you want to record the process rules macro for. This will launch the Process Rules Event Handler screen.
Enter the Event Description value to identify the Event.
Click the Define New option in the Execute Procedure drop down.
This will launch the Procedure Handler screen.
Enter a value in the Procedure Name field to identify the procedure.
Click the Load Macro Editor button on the Procedure Handler screen.
This will launch the Macro Editor screen.
Select the option from the Action Types drop down column. For this example I'll select the Messagebox option.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the Messagebox macro action type that you want to execute. Clicking in the Value column will load the Macro Editor Values Entry screen.
The value of the Sort Order field will determine the order in which the Events are executed in the case of multiple instances of the same Event. The application automatically assigns a value which can be manually altered. If two instances of the same Event are given the same Sort Order value, the Events will be executed according to the date/time the Event was added to the system.
Choose the second instance of the same Event that you want to record the process rules macro for.
Click the Define or Edit button on the Event that you want to record the process rules macro for. This will launch the Process Rules Event Handler screen.
Select the option from the Action Types drop down column. For this example I'll select the Messagebox option.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the Messagebox macro action type that you want to execute. Clicking in the Value column will load the Macro Editor Values Entry screen.
Complete the appropriate Event properties (Inner Event, Before Action, etc.)
Click the Save & Close button on the Process Rules Event Handler screen.
How To Use the Addon Loaded Event
The top area of the main menu is mostly covered by the Company and User labels.
This Event is only applicable for the successful loading of the APP application. This cannot be applied to any other add-on applications.
Select the validations and procedures to be executed when the APP application is loaded.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
Click the SAP menu option titled
Add-On Manager under the
Administration
Add-Ons menus to load the
Add-On Manager screen.
Highlight the APP application. Click the Stop button.
How To Use the Macro Action Types
The macro editor will only support actions against screens where there are not multiple instances of that screen open in SAP® Business One when the macro is being performed. For example, a macro that performs an action against form #139 (the Sales Order form) should only be performed with one Sales Order form window open.
How To Use the AddRow Action Type
This example is for the Item Master Data screen.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the AddRow option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the AddRow Macro Action Type that you want to execute.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to True.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
How To Use the CallAPPProcedure Action Type
This example is for the Item Master Data screen.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the CallAPPProcedure option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the CallAPPProcedure Macro Action Type that you want to execute.
Complete any other information and/or Action Types required to complete your Macro.
Set the Before Action value to True.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
How To Use the ComboSelect Action Type
This example is for the Item Master Data screen.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the ComboSelect option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the ComboSelect Macro Action Type that you want to execute.
The value for selection must be an existing option in the combo box.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to True.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
How To Use the ConditionExecution Action Type
This example is for the Item Master Data screen.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the ConditionExecution option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the ConditionExecution Macro Action Type that you want to execute.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to True.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
Click the Fire Macro button on the Item Master Data screen.
How To Use the DeleteRow Action Type
This example is for the Sales Order screen.
Click the SAP menu option titled Sales Order under the Sales - A/R menu to load the Sales Order screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the DeleteRow option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the DeleteRow Macro Action Type that you want to execute.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to False.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
How To Use the DisableItem Action Type
This example is for the Item Master Data screen.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the DisableItem option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the DisableItem Macro Action Type that you want to execute.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to True.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
How To Use the DoubleClick Action Type
This example is for the Item Master Data screen.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the DoubleClick option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the DoubleClick Macro Action Type that you want to execute.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to True.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
Click the Fire Macro button on the Item Master Data screen.
How To Use the EnableItem Action Type
This example is for the Item Master Data screen.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the EnableItem option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the EnableItem Macro Action Type that you want to execute.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to True.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
How To Use the EndWhile Type
This example is for the Item Master Data screen.
This example is a dual example of the While and EndWhile Action Types.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the Events tab.
Choose the Event that you want to record the process rules macro for.
Click the Define or Edit button on the Event that you want to record the process rules macro for. This will launch the Process Rules Event Handler screen.
Select the While option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the While Macro Action Type that you want to execute.
Select the End While option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the End While Macro Action Type that you want to execute.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to False.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
Click the Fire Macro button on the Item Master Data screen.
How To Use the ExecuteSQL Type
This example is for the Item Master Data screen.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the Events tab.
Choose the Event that you want to record the process rules macro for.
Click the Define or Edit button on the Event that you want to record the process rules macro for. This will launch the Process Rules Event Handler screen.
Select the ExecuteSQL option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Click in the Value column of the Macro Editor screen for the ExecuteSQL Action Type. This will load the Macro Editor Values Entry screen.
Enter the SQL statement to be executed in the Macro Editor Values Entry screen.
Click the OK button to return to the Macro Editor screen.
Complete the information needed for the ExecuteSQL Macro Action Type that you want to execute.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to False.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
Click the Fire Macro button on the Item Master Data screen to execute your SQL statement.
This example is for the Item Master Data screen.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the Events tab.
Choose the Event that you want to record the process rules macro for.
Click the Define or Edit button on the Event that you want to record the process rules macro for. This will launch the Process Rules Event Handler screen.
the **Procedure Handler** screen.
Select the FormClose option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the FormClose Macro Action Type that you want to execute.
The form to be closed must have been opened in the same macro session.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to True.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
Click the Fire Macro button on the Item Master Data screen.
How To Use the GetFieldValue Action Type - Status Bar Example
This example is for the Item Master Data screen.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the Events tab.
Choose the Event that you want to record the process rules macro for.
Click the Define or Edit button on the Event that you want to record the process rules macro for. This will launch the Process Rules Event Handler screen.
Select the GetFieldValue option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the GetFieldValue Macro Action Type that you want to execute.
This example is being combined with the SetStatusBar action to pull the Item Code and Item Name values into variables and use a variable substitution to assign those values into the text of the status bar message.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to True.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
Click the Fire Macro button on the Item Master Data screen.
How To Use the GetFieldValue Action Type - Field Example
This example is for the Item Master Data screen.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the Events tab.
Choose the Event that you want to record the process rules macro for.
Click the Define or Edit button on the Event that you want to record the process rules macro for. This will launch the Process Rules Event Handler screen.
Select the GetFieldValue option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the GetFieldValue Macro Action Type that you want to execute.
This example is being combined with the SetFieldValue action to pull the Item Code and Item Name values into variables and use a variable substitution to assign those values into the field being assigned through the macro action.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to True.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
Click the Fire Macro button on the Item Master Data screen.
How To Use the GetSQLValue Action Type
Note - This example is for the Item Master Data screen.
Click the SAP menu option titled Item Master Data under
the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire
Macro button for this example).
Note - The right-click menu should be launched while the mouse is on top of the item.
Select the Control Properties option from the APP Customizer menu group option from the right-click menu on the form to load the **Item** **Properties/Events** screen.
Select the Events tab.
Click the Define or Edit button on the Event that you want to record the process rules macro for. This will launch the **Process Rules Event** **Handler** screen.
Click the … button next to the procedure to be executed. This will launch
the **Procedure Handler** screen.
Click the Load Macro Editor button on the **Procedure Handler** screen.
This will launch the **Macro Editor** screen.
Select the GetSQLValue option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray). Complete the information needed for the GetSQLValue Macro Action Type that you want to execute.
Note - The complete SQL query used for this example is SELECT
I.ItemCode + '-' + CONVERT(nvarchar,I.ItmsGrpCod) + ': ' + I.ItemName AS [Frgn] FROM OITM I (NOLOCK) WHERE ItemCode = $[$5.0.0].
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button.
Click the OK button on the **Procedure Handler** screen.
Set the Before Action value to True.
Click the **Save & Close** button on the **Process Rules Event** **Handler** screen.

Click the Save & Close button on the **Item Properties/Events** screen.
Click the Fire Macro button on the Item Master Data screen.
The specified macro actions are executed.
How To Use the HideItem Action Type
This example is for the Item Master Data screen.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the Events tab.
Choose the Event that you want to record the process rules macro for.
Click the Define or Edit button on the Event that you want to record the process rules macro for. This will launch the Process Rules Event Handler screen.
Select the HideItem option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the HideItem Macro Action Type that you want to execute.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to True.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
How To Use the ItemClick Action Type
This example is for the Item Master Data screen.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the Events tab.
Choose the Event that you want to record the process rules macro for.
Click the Define or Edit button on the Event that you want to record the process rules macro for. This will launch the Process Rules Event Handler screen.
Select the ItemClick option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the ItemClick Macro Action Type that you want to execute.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to True.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
Click the Fire Macro button on the Item Master Data screen.
How To Use the LineEvents Action Type
This example is for the Sales Order screen.
Click the SAP menu option titled Sales Order under the Sales - A/R menu to load the Sales Order screen.
Determine the item that you want to establish process rules for (Calculate Shipping Costs button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the Events tab.
Select the Events tab.
Choose the Event that you want to record the process rules macro for.
Click the Define or Edit button on the Event that you want to record the process rules macro for. This will launch the Process Rules Event Handler screen.
Enter the Event Description value.
Select the validation type and procedure to be executed.
Click the … button next to the procedure to be executed. This will launch the Procedure Handler screen.
image580.jpeg_772x491_wrap_center_round_info_90_the_color
Select an existing Line Event and click the Load button or click the Define New button to create a new Line Event.
Designate the Name for the Line Event.
Enter the unique ID for the form on which the Line Event will operate in the Form Type field.
Enter the unique ID for the item on which the Line Event will operate in the Item UID field.
Line Events can be coded to only one form and item at a time.
For this example, the Query will determine if the Item Code <> “Shipping” and the Item Property 1 checkbox is selected. If this criteria is met, the value will be “T”, otherwise the value will be “F”.
Click the OK button.
Enter the valid return values in the Value column.
If the value returned should execute a procedure, select the procedure from the Procedure for All column.
For this example, the returned value “F” will execute a procedure to remove the line with the Item Code “Shipping”.
If the procedure needs to be modified, click the Edit button. This will launch the Procedure Handler screen.
To remove a valid return value from the screen, click the Remove button.
If the procedure to be executed returns a value to take action with, select the Operation option for the operation to be done with the value.
Enter the logic to be evaluated with the Operation in the Column field.
For this example, the returned value “T” will obtain the value from the APP Macro Ship Pct user defined field from the Item Master Data screen, divide it by 100, and multiple it by the Item Price to SUM the shipping for each item on the order as it evaluates the lines of the Sales Order.
In the Final Result Validation section, enter the valid final result return values in the Value column.
If the final result value returned should execute a procedure, select the procedure from the Procedure column.
For this example, the returned value “T” will execute a procedure to add a line with the Item Code “Shipping” to the order with the calculated total shipping cost.
If the procedure needs to be modified, click the Edit button. This will launch the Procedure Handler screen.
To remove a valid final result value from the screen, click the Remove button
Click the Save & Close button on the Macro Editor Line Events Values Entry screen.
Complete the information needed for the LineEvents Macro Action Type that you want to execute.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to False.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
Prior to the Macro execution, an item needs to be added to the Inventory with the Item Code “Shipping” for this example to complete successfully.
How To Use the LoadB1Query Action Type
This example is for the Item Master Data screen.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the Events tab.
Choose the Event that you want to record the process rules macro for.
Click the Define or Edit button on the Event that you want to record the process rules macro for. This will launch the Process Rules Event Handler screen.
Select the LoadB1Query option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the LoadB1Query Macro Action Type that you want to execute.
The value for the B1 Query is determined by the following criteria…
The first part of the B1 Query value is the form number associated with the SAP query window. This value can be determined by the associated number displayed in the system information.

The second part of the B1 Query value is the menu name (APP) associated with the SAP query.

Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to True.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
Click the Fire Macro button on the Item Master Data screen.
The SAP form will be used to display the query even if the TWBS Visual Query Editor screen is the preferred display option in the query definition.
How To Use the LoadUserTable Action Type
This example is for the Item Master Data screen.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the Events tab.
Choose the Event that you want to record the process rules macro for.
Click the Define or Edit button on the Event that you want to record the process rules macro for. This will launch the Process Rules Event Handler screen.
Select the LoadUserTable option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the LoadUserTable Macro Action Type that you want to execute.
The value for the user defined table is determined by the following criteria…
The value of the user defined table is the code associated with the user defined table.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to True.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
Click the Fire Macro button on the Item Master Data screen.
How To Use the MacroCommand Type
This example is for the Item Master Data screen.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the Events tab.
Choose the Event that you want to record the process rules macro for.
Click the Define or Edit button on the Event that you want to record the process rules macro for. This will launch the Process Rules Event Handler screen.
Select the MacroCommand option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the MacroCommand Macro Action Type that you want to execute.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to False.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
Click the Fire Macro button on the Item Master Data screen.
This example is for the Item Master Data screen.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the Events tab.
Choose the Event that you want to record the process rules macro for.
Click the Define or Edit button on the Event that you want to record the process rules macro for. This will launch the Process Rules Event Handler screen.
Select the MenuClick option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the MenuClick Macro Action Type that you want to execute.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to True.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
Click the Fire Macro button on the Item Master Data screen.
For this example, the menu click launched the Sales Order screen.
How To Use the Messagebox Action Type
This example is for the Item Master Data screen.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the Events tab.
Choose the Event that you want to record the process rules macro for.
Click the Define or Edit button on the Event that you want to record the process rules macro for. This will launch the Process Rules Event Handler screen.
Select the MessageBox option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the MessageBox Macro Action Type that you want to execute.
This example is being combined with several GetFieldValue actions to pull the Item Code and Item Name values into variables and use a variable substitution to assign those values into the text of the message box.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to True.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
Click the Fire Macro button on the Item Master Data screen.
How To Use the OpenExternalProgram Action Type
This example is for the Item Master Data screen.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the Events tab.
Choose the Event that you want to record the process rules macro for.
Click the Define or Edit button on the Event that you want to record the process rules macro for. This will launch the Process Rules Event Handler screen.
Select the OpenExternalProgram option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the OpenExternalProgram Macro Action Type that you want to execute.
APP Customizer will pass the value specified for the OpenExternalProgram action type as if the user had typed the value on the Run command window. In order for a value to work through APP Customizer, it should be able to function if manually typed on the Run command window.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to True.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
Click the Fire Macro button on the Item Master Data screen.
How To Launch a Website in Internet Explorer
This example is for the Item Master Data screen.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
For this demonstration an existing procedure is being used.
Select the OpenExternalProgram option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the OpenExternalProgram Macro Action Type that you want to execute.
Click the Value field to open the window to edit the value passed.
The value “iexplore” must be in quotations.
APP Customizer will pass the value specified for the OpenExternalProgram action type as if the user had typed the value on the Run command window. In order for a value to work through APP Customizer, it should be able to function if manually typed on
the Run command window.
Click the OK button on the Value editing screen.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button on the Macro Editor screen.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to False.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
Double click the Web Site field on the Business Partner Master Data screen.
This example is for the Business Partner Master Data screen.
The right-click menu should be launched while the mouse is on top of the item.
Select the Events tab.
Choose the Event that you want to record the process rules macro for.
Click the Define button on the Event that you want to record the process rules macro for. This will launch the Process Rules Event Handler screen.
For this demonstration an existing procedure is being used.
Select the OpenExternalProgram option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the OpenExternalProgram Macro Action Type that you want to execute.
Click the Value field to open the window to edit the value passed.
The location of the application executable must be in quotations.
APP Customizer will pass the value specified for the OpenExternalProgram action type as if the user had typed the value on the Run command window. In order for a value to work through APP Customizer, it should be able to function if manually typed on
the Run command window.
Click the OK button on the Value editing screen.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button on the Macro Editor screen.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to False.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
Double click the Web Site field on the Business Partner Master Data screen.
If not logged into a Skype account, the user will be prompted first for their login credentials.
How To Use the RightClick Action Type
This example is for the Item Master Data screen.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the Events tab.
Choose the Event that you want to record the process rules macro for.
Click the Define or Edit button on the Event that you want to record the process rules macro for. This will launch the Process Rules Event Handler screen.
Select the RightClick option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the RightClick Macro Action Type that you want to execute.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to True.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
Click the Fire Macro button on the Item Master Data screen.
How To Use the SendKeys Action Type
This example is for the Item Master Data screen.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the Events tab.
Choose the Event that you want to record the process rules macro for.
Click the Define or Edit button on the Event that you want to record the process rules macro for. This will launch the Process Rules Event Handler screen.
Select the SendKeys option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the SendKeys Macro Action Type that you want to execute.
The SendKeys Reference Guide section of the User Guide provides additional information on the SendKeys values that you can utilize.
For this example, the SendKeys value is being set up to mimic the SAP® Business One menu option keystroke shortcut for launching the Forms Settings screen.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to True.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
Click the Fire Macro button on the Item Master Data screen.
How To Use the SetBackColor Action Type
This example is for the Item Master Data screen.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the Events tab.
Choose the Event that you want to record the process rules macro for.
Click the Define or Edit button on the Event that you want to record the process rules macro for. This will launch the Process Rules Event Handler screen.
Select the SetBackColor option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the SetBackColor Macro Action Type that you want to execute.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button on the Macro Editor screen.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to True.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
Click the Fire Macro button on the Item Master Data screen.
How To Use the SetFieldValue Action Type
This example is for the Item Master Data screen.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the Events tab.
Choose the Event that you want to record the process rules macro for.
Click the Define or Edit button on the Event that you want to record the process rules macro for. This will launch the Process Rules Event Handler screen.
Select the SetFieldValue option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the SetFieldValue Macro Action Type that you want to execute.
This example is being combined with several GetFieldValue actions to pull the Item Code and Item Name values into variables and use a variable substitution to assign those values into the field being assigned through the macro action.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button on the Macro Editor screen.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to True.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
Click the Fire Macro button on the Item Master Data screen.
How To Use the SetForeColor Action Type
This example is for the Item Master Data screen.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the Events tab.
Choose the Event that you want to record the process rules macro for.
Click the Define or Edit button on the Event that you want to record the process rules macro for. This will launch the Process Rules Event Handler screen.
Select the SetForeColor option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the SetForeColor Macro Action Type that you want to execute.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button on the Macro Editor screen.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to True.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
Click the Fire Macro button on the Item Master Data screen.
This example is for the Item Master Data screen.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the Events tab.
Choose the Event that you want to record the process rules macro for.
Click the Define or Edit button on the Event that you want to record the process rules macro for. This will launch the Process Rules Event Handler screen.
Select the SetFormTitle option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the SetFormTitle Macro Action Type that you want to execute.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button on the Macro Editor screen.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to False.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
Click the Fire Macro button on the Item Master Data screen.
How To Use the SetStatusBar Action Type
This example is for the Item Master Data screen.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the Events tab.
Choose the Event that you want to record the process rules macro for.
Click the Define or Edit button on the Event that you want to record the process rules macro for. This will launch the Process Rules Event Handler screen.
This example is being combined with several GetFieldValue actions to pull the Item Code and Item Name values into variables and use a variable substitution to assign those values into the text of the status bar message.
Select the SetStatusBar option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Click in the Value column of the Macro Editor screen for the SetStatusBar Action Type. This will load the Macro Editor Values Entry screen.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button on the Macro Editor screen.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to True.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
Click the Fire Macro button on the Item Master Data screen.
How To Use the ShowItem Action Type
This example is for the Item Master Data screen.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the Events tab.
Choose the Event that you want to record the process rules macro for.
Click the Define or Edit button on the Event that you want to record the process rules macro for. This will launch the Process Rules Event Handler screen.
Select the ShowItem option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the ShowItem Macro Action Type that you want to execute.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button on the Macro Editor screen.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to True.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
How To Use the While Action Type
This example is for the Item Master Data screen.
This example is a dual example of the While and EndWhile Action Types.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Determine the item that you want to establish process rules for (Fire Macro button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the Events tab.
Choose the Event that you want to record the process rules macro for.
Click the Define or Edit button on the Event that you want to record the process rules macro for. This will launch the Process Rules Event Handler screen.
Select the While option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the While Macro Action Type that you want to execute.
Select the End While option from the Action Types drop down column.
The APP application will clear any existing parameter values. Any parameter value columns that are not optional (identified in yellow) or required (identified in red) will be deactivated (identified in gray).
Complete the information needed for the End While Macro Action Type that you want to execute.
Complete any other information and/or Action Types required to complete your Macro.
Click the Save & Close button.
Click the OK button on the Procedure Handler screen.
Set the Before Action value to False.
Click the Save & Close button on the Process Rules Event Handler screen.
Click the Save & Close button on the Item Properties/Events screen.
Click the Fire Macro button on the Item Master Data screen.
This example is for the Sales Order screen.
Click the SAP menu option titled Sales Order under the Sales - A/R menu to load the Sales Order screen.
Determine the item that you want to establish process rules for (OK/Add/Update button for this example).
The right-click menu should be launched while the mouse is on top of the item.
Select the Events tab.
Choose the Event that you want to record the process rules macro for.
Click the Define or Edit button on the Event that you want to record the process rules macro for. This will launch the Process Rules Event Handler screen.
Enter a Description for the event.
Select the validation level option (Simple Validation option selected for this example).
Click the Source Field box and a separate form will load in which the user can enter the Item UID for the field on the form that will be used as the source field for the validation.
Select the mathematical Operation to be used in the validation.
Enter the Source Value to be used in the evaluation of the mathematical Operation for the Source Field.
Click the Define New option from the Procedure drop down. This will launch the Procedure Handler screen.
Enter a Name for the procedure.
Select the Alert Type to be given to the user (Status Bar option selected for this example).
Select the Severity of the status bar message (Error option selected for this example).
Select the Duration for the status bar message (Medium option selected for this example).
Enter the Message text for the status bar message.
Click the OK button on the |Procedure Handler screen.
The new procedure will be automatically selected as the procedure to be executed for the validation.
Tab Order Sequence
Tab Order configuration functionality allows the user to establish, edit, and remove custom designated tab orders for forms that will override the normal order of moving between fields on a form.
The tab order cannot be used to set the tab order of columns in an SAP UI grid or matrix object. This is an SAP® Business One UI limitation.
How To Set Tab Order Sequence
This example is for the Business Partner Master Data screen.
The tab order cannot be used to set the tab order of columns in an SAP UI grid or matrix object. This is an SAP® Business One UI limitation.
To complete the tab order selection process, select the
Set Tab Sequence - Done option from the
APP Customizer
Tab Order menu group option from the right-click menu on the form.
The form that you are setting the new Tab Order Sequence on will need to be published and the form reloaded for the changes to be visible to the user.
How To Edit Tab Order Sequence
This example is for the Business Partner Master Data screen.
The tab order cannot be used to set the tab order of columns in an SAP UI grid or matrix object. This is an SAP® Business One UI limitation.
The form that you are editing the existing Tab Order Sequence on will need to be published and the form reloaded for the changes to be visible to the user.
How To Activate/Deactivate Tab Order Sequence
This example is for the Business Partner Master Data screen.
The form that you are altering the Tab Order Sequence on will need to be published and the form reloaded for the changes to be visible to the user.
How To Exclude Users from Tab Sequence
This example is for the Business Partner Master Data screen.
Click the

button to launch the
Customizer User List screen.
Select the users, branches, and/or departments that you want to exclude from the Tab Order Sequence.
Click the Select button to return to the Tab Order Configuration Detail screen.
How To Copy Tab Order Sequence
This example is for the Business Partner Master Data screen.
The application will perform no validation that the fields in the tab order sequence are present on the form to which the sequence is being copied. The user is responsible for verifying the fields on the new form and removing any not applicable entries from the tab order sequence.
How To Reset Tab Order Sequence
This example is for the Business Partner Master Data screen.
How To Remove Tab Order Sequence
This example is for the Business Partner Master Data screen.
Mandatory Fields
Mandatory Fields functionality allows the user to establish, edit, and remove custom designated mandatory fields for forms that will operate in addition to the normal required fields on a form.
How To Set Mandatory Fields
This example is for the Business Partner Master Data screen.
Any user-defined fields must have items placed on the regular SAP® Business One forms in order to be included in mandatory fields setting.
Items that are check boxes cannot be set as mandatory fields.
Complete the mandatory fields selection process by selecting the
Set Mandatory Fields - Done option from the the
APP Customizer
Mandatory Fields menu group option from the right-click menu on the form.
The form that you are setting the new Mandatory Fields requirements on will need to be published and the form reloaded for the changes to be visible to the user.
How To Edit Mandatory Fields
This example is for the Business Partner Master Data screen.
The form that you are editing the Mandatory Fields requirements on will need to be published and the form reloaded for the changes to be visible to the user.
How To Activate/Deactivate Mandatory Fields
This example is for the Business Partner Master Data screen.
The form that you are activating/deactivating the Mandatory Fields requirements on will need to be published and the form reloaded for the changes to be visible to the user.
How To Exclude Users from Mandatory Fields
This example is for the Business Partner Master Data screen.
Click the

button to launch the
Customizer User List screen.
Select the users, branches, and/or departments that you want to exclude from the Mandatory Fields.
Click the Select button to return to the Mandatory Fields Configuration Detail screen.
The form that you are editing the Mandatory Fields requirements on will need to be published and the form reloaded for the changes to be visible to the user.
How To Copy Mandatory Fields
This example is for the Business Partner Master Data screen.
The application will perform no validation that the fields in the mandatory fields are present on the form to which the sequence is being copied. The user is responsible for verifying the fields on the new form and removing any not applicable entries from the mandatory fields.
The form that you are copying the Mandatory Fields requirements to will need to be published and the form reloaded for the changes to be visible to the user.
How To Clone Mandatory Fields
This example is for the Business Partner Master Data screen.
How To Reset Mandatory Fields
This example is for the Business Partner Master Data screen.
How To Remove Mandatory Fields
This example is for the Business Partner Master Data screen.
The form that you are removing the Mandatory Fields requirements from will need to be published and the form reloaded for the changes to be visible to the user.
How To Delete Item Configurations
This example is for the Sales Order screen.
The right-click menu should be launched while the mouse is on top of the custom configured item.
If the control whose customizations are being removed is a custom control added through APP Customizer, the control will be removed from the form.
Click on the SAP menu option before or after the location where you want to place the custom menu option to use it as a position reference (for the purpose of this example, the Delivery menu option).
The SAP Menu Setting screen will appear and will populate the Menu ID field with the value of the menu you selected as a position reference. Select either the Menu Before or Menu After option to specifically place your custom menu option.
How To Use the Manage Control State Screen
This example is for the Item Master Data screen.
The visible/enabled properties are not being removed from the Form Properties/Events screen. Any values set for controls there in previous versions of APP will retain their values. However, any Manage Control State customized entries will override the Form Properties/Events screen settings.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Right click on the form. Select the option titled Manage Control State under the APP Customizer right click menu to load the Manage Control State screen.
When the Manage Control State screen is opened, any modified control lines will show at the top of the form, followed by unmodified control lines.
Only one entry per form control is allowed and modifiable on this screen. Therefore you cannot have one line for a control assigned to or excluding specific users and also have a second line configured differently for the same control.
The customized entry on the Manage Control State screen will be overridden by any customized properties set directly on the control itself.
The Item Master Data screen needs to be closed and reopened for the changes to take affect.
To remove a customized control line, you'll need to manually select the Visible and/or Enabled check boxes and remove assigned users in order to return the form control to the default state.
How To Select a Color Value for Properties
APP Customizer includes the ability to set values for display colors for several properties of forms and items. Several commonly used colors are referenced below for easy application of the values and the methods that can be used to determine a color are explained.
Selecting A Color Value
Click the … button next to the field that you want to specify a color for.
Select a color through one of the following means…
Select a Basic Color or a pre-defined Custom Color.
Drag the crosshairs graphic around the rainbow color chart to determine your color.
Manually enter the Red, Green, Blue (RGB) or Hue, Saturation, Luminescence values for the color.
Click the OK button.
The color selected will be returned to the property field.
Commonly Used Color Values
Red (255)
Pink (12615935)
Orange (33023)
Yellow (65535)
Lt. Green (8454016)
Green (65280)
Lt. Blue (16777088)
Blue (16744448)
Purple (8388736)
White (16777215)
Gray (12632256)
Brown (4210816)
How To Export/Import Objects and Properties
How To Export/Import Item Properties and Events
APP Customizer includes the ability to export and import Item Properties and Events
Note - This example is for the Item Master screen.
Exporting
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen. Load the information for an Item into the screen.
Note - For this example, the Unit Price field and label have been given a customized position on the screen.
Note - The right-click menu should be launched while the mouse is on top of the item.
Select the Item Placement Configurator option from the APP Customizer menu group option from the right-click menu on the form to load the **Item Configurator** screen.
There are two entries on the **Item Configurator** screen, one for the Unit Price entry field and one for the accompanying label. Select the configuration items that you want to export.


Note - At least one item configuration must be selected in order to utilize the export function.
Click the down arrowhead on the Export button at the bottom of the screen and select the appropriate option.
A window will open to allow you to specify the directory and file name under which the exported XML file will be saved.
Enter a file name.
Click the Save button.
Navigating and opening the exported XML file shows the data that has been exported and can be imported into either the same SAP database or any other SAP database utilizing APP Customizer.
Importing
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.

Note - For this example, I am reusing the same SAP database. The Unit Price field and label customizations have been removed following the export of the data to the XML file.
Click the SAP menu option titled Import XML under the Administration -Setup -APP Setup menus .
A window will open to allow you to specify the directory and file name for the XML file to be imported.
Double click the file name or select the file and click the Open button. The XML file will be imported into APP Customizer
Stop and restart the APP application.
Warning – After importing any objects into APP, the application must be stopped and restarted for the imported modifications to take effect.
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
The Item Master screen now reflects the customizations to the Unit Price entry field and accompanying label imported from the XML file.
How To Export/Import Charts
APP Customizer includes the ability to export and import Charts
Exporting
Click the SAP menu option titled Report Definitions under the Administration -Setup -APP Setup menus to load the Reports Maintenance screen.
Click on the object with the associated Chart that you want to export.
Click the Manage Charts button (
). The Chart Definition form is displayed.
Click the Export button.
A window will open to allow you to specify the directory and file name under which the exported XML file will be saved.
Enter a file name.
Click the Save button.
Navigating and opening the exported XML file shows the data that has been exported and can be imported into either the same SAP database or any other SAP database utilizing APP Customizer.
Note - The Query for the Chart is also included in the exported XML file information.
Importing
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Click the SAP menu option titled Import XML under the Administration -Setup -APP Setup menus.
A window will open to allow you to specify the directory and file name for
the XML file to be imported.
Double click the file name or select the file and click the Open button. The XML file will be imported into APP Customizer
Stop and restart the APP application.
Warning – After importing any objects into APP, the application must be stopped and restarted for the imported modifications to take effect.
How To Export/Import Dashboards
APP Customizer includes the ability to export and import Dashboards
Exporting
Click the SAP menu option titled Dashboard Setup under the Administration -Setup -APP Setup menus to load the Dashboards setup screen.
Load the Dashboard that you want to export.
Click the Export button.
A window will open to allow you to specify the directory and file name under which the exported XML file will be saved.
Enter a file name.
Click the Save button.
Navigating and opening the exported XML file shows the data that has been exported and can be imported into either the same SAP database or any other SAP database utilizing APP Customizer.
Note - The Query for the Dashboard panes are also included in the exported XML file information.
Importing
Click the SAP menu option titled Item Master Data under the Inventory menu to load the Inventory Master Data screen.
Click the SAP menu option titled Import XML under the Administration -Setup -APP Setup menus.
A window will open to allow you to specify the directory and file name for the XML file to be imported.
Double click the file name or select the file and click the Open button. The XML file will be imported into APP Customizer
Stop and restart the APP application.
Warning – After importing any objects into APP, the application must be stopped and restarted for the imported modifications to take effect.
A Guide to Dynamic Syntax
Dynamic syntax is based upon the SAP® Business One formatted search capabilities and is a way for the user to dynamically substitute information from the system into SQL queries that can be launched from the current form within Business One. Dynamic syntax can be broken down into two types…
Item Syntax – Allows the user the ability to execute SQL queries that automatically substitute information values from an active SAP Business One® form.
**String Data Type**
**Integer Data Type**
**Decimal Data Type**
**Date Data Type**
**Line Level Data**
User Table Syntax – Allows the user to obtain information from SAP Business One® user-defined fields
Item Syntax
Item syntax is the most commonly used form of dynamic syntax. It allows the user the ability to execute SQL queries that automatically substitute information values from an active SAP Business One® form.
General Item Syntax Form
$[$<Item UID>.<Column UID>.<Data Type>]
Item Syntax Components
Item UID – The unique ID value for the item from the SAP Business One® form that you wish to reference.
Column UID – The unique ID value for the column from the SAP Business One® form that you wish to reference (if applicable).
Data Type – The designation for the type of data in the field from the SAP Business One® form that you wish to reference.
STRING or 0 – For string (text) data type fields.
NUMBER – For numerical Integer or Decimal data type fields.
DATE – For date data type fields.
CURRENCY – For numerical Decimal data type fields to obtain currency code.
Examples
$[$5.0.0] or $[$5.0.STRING]
$[$33.0.STRING]
$[$8.0.NUMBER]
$[$29.0.CURRENCY]
$[$46.0.DATE]
**String Data Type**
**Integer Data Type**
**Decimal Data Type**
**Date Data Type**
**Line Level Data**
String Data Type
The String data type form of Item Syntax can be used to substitute the value from any string (text) data field on an SAP Business One® form.
In this example, we will represent the Business Partner Card Code in dynamic syntax for a SQL query.
The Item UID for the BP Code field is “5” from “Item=5” in the system information from the status bar.
The Column UID for the BP Code field is “0”. The property is not applicable because the field is not on a details line.
The Data Type for the BP Code is either “STRING” or “0”.
Warning - The “STRING” syntax cannot be used in designation of the Source Field value when setting up process rules events on the **Process Rules Event Handler** screen. “0” must be used as the data type.
Setting up the dynamic syntax in a SQL query will look like this…
Execution of the Query while the Business Partner Master Data screen is active and populated with a specific Business Partner will result in the following dynamic syntax substitution from the BP Code field…
Integer Data Type
The Integer data type form of Item Syntax can be used to substitute the value from any integer(whole #) data field on an SAP Business One® form.
In this example, we will represent the Sales Order Document Number in dynamic syntax for a SQL query.
The Item UID for the Document # field is “8” from “Item=8” in the system information from the status bar.
The Column UID for the Document # field is “0”. The property is not applicable because the field is not on a details line.
The Data Type for the Document # is “NUMBER”.
Setting up the dynamic syntax in a SQL query will look like this…
Execution of the Query while the Sales Order screen is active and populated with a specific document will result in the following dynamic syntax substitution from the Document # field…
Decimal Data Type
The Decimal data type form of Item Syntax can be used to substitute the value or currency code from any decimal (numeric with decimal places) data field on an SAP Business One® form.
Numeric Value
In this example, we will represent the Business Partner Credit Limit in dynamic syntax for a SQL query.
The Item UID for the Credit Limit field is “85” from “Item=85” in the system information from the status bar.
The Column UID for the Credit Limit field is “0”. The property is not applicable because the field is not on a details line.
The Data Type for the Credit Limit is “NUMBER”.
Setting up the dynamic syntax in a SQL query will look like this…
Execution of the Query while the Business Partner Master Data screen is active and populated with a specific Business Partner will result in the following dynamic syntax substitution from the Credit Limit field…
Currency Code Value
In this example, we will represent the Sales Order Document Total currency code in dynamic syntax for a SQL query.
The Item UID for the Document Total field is “29” from “Item=29” in the system information from the status bar.
The Column UID for the Document Total field is “0”. The property is not applicable because the field is not on a details line.
The Data Type for the Document Total currency code is “CURRENCY”.
Setting up the dynamic syntax in a SQL query will look like this…
Execution of the Query while the Sales Order screen is active and populated with a specific document will result in the following dynamic syntax substitution from the Document Total field…
Date Data Type
The Date data type form of Item Syntax can be used to substitute the value from any date data field on an SAP Business One® form.
In this example, we will represent the Sales Order Document Date in dynamic syntax for a SQL query.
The Item UID for the Document Date field is “46” from “Item=46” in the system information from the status bar.
The Column UID for the Document Date field is “0”. The property is not applicable because the field is not on a details line.
The Data Type for the Document Date is “DATE”.
Setting up the dynamic syntax in a SQL query will look like this…
Execution of the Query while the Sales Order screen is active and populated with a specific document will result in the following dynamic syntax substitution from the Document Date field…
Line Level Data
Obtaining information from the line level details of SAP Business One® objects follows the same general dynamic syntax format as the previous examples, however additionally we need to specify a value for the Column UID of the column the data is being obtained from on the form.
String Data Type Column Example
In this example, we will represent the Item Code from a Sales Order line in dynamic syntax for a SQL query.
The Item UID for the Item Code field is “38” from “Item=38” in the system information from the status bar.
The Column UID for the Item Code field is “1” from “Column=1” in the system information from the status bar.
The Data Type for the Item Code is either “STRING” or “0”.
Setting up the dynamic syntax in a SQL query will look like this…
Execution of the Query while the Sales Order screen is active and populated with a specific document will result in the following dynamic syntax substitution from the Item Code field…
Decimal Data Type Column Numeric Example
In this example, we will represent the Quantity from a Sales Order line in dynamic syntax for a SQL query.
The Item UID for the Quantity field is “38” from “Item=38” in the system information from the status bar.
The Column UID for the Quantity field is “11” from “Column=11” in the system information from the status bar.
The Data Type for the Quantity is “NUMBER”.
Setting up the dynamic syntax in a SQL query will look like this…
Execution of the Query while the Sales Order screen is active and populated with a specific document will result in the following dynamic syntax substitution from the Quantity field…
Integer Data Type Column Example
In this example, we will represent the Warehouse Code from a Sales Order line in dynamic syntax for a SQL query.
The Item UID for the Warehouse Code field is “38” from “Item=38” in the
system information from the status bar.
The Column UID for the Warehouse Code field is “24” from “Column=24” in the system information from the status bar.
The Data Type for the Warehouse Code is “NUMBER”.
Setting up the dynamic syntax in a SQL query will look like this…
Execution of the Query while the Sales Order screen is active and populated with a specific document will result in the following dynamic syntax substitution from the Warehouse Code field…

User Table Syntax
Table syntax is the form of dynamic syntax that can be used to obtain information from SAP Business One® user-defined fields and from forms. It allows the user the ability to execute SQL queries that automatically substitute information values from an active SAP Business One® form.
General User Table Syntax Form
$[<Table Name>.<Field ID>.<Data Type>]
User Table Syntax Components
Table Name – The name of the database table that you wish to reference.
Field ID – The name of the field on the database table that you wish to reference.
Data Type – The designation for the type of data in the field on the database table that you wish to reference.
STRING or 0 – For string (text) data type fields.
NUMBER – For numerical Integer or Decimal data type fields.
DATE – For date data type fields.
CURRENCY – For numerical Decimal data type fields to obtain currency code.
Examples
$[OCRD.CardCode.STRING]
$[ORDR.DocDate.DATE]
$[OINV.DocTotal.CURRENCY]
$[OCRD.U_rLblUse.STRING]
In this example, we will represent the Customer Label user-defined field value from the Business Partner screen in dynamic syntax for a SQL query.
The Table Name for the Customer Label field is “OCRD”.
The Field ID for the Customer Label field is “rbLblUse”.
The Data Type for the Customer Label is “STRING” or “0”.
Setting up the dynamic syntax in a SQL query will look like this…
Execution of the Query while the Business Partner screen is active and populated with a specific partner will result in the following dynamic syntax substitution from the Customer Label field…