Differences

This shows you the differences between two versions of the page.

--- app:app_how_to_cust [2019/07/31 23:43]
dtucker [How To Select a Color Value for Properties]
+++ app:app_how_to_cust [2019/08/02 00:07] (current)
dtucker [How To Publish APP Customizer Changes to All Users]
@@ Line 8: / Line 8: @@
 {{:app/image44.jpeg?786}}
-===== How To Convert APP Form Customized Data to XML =====
+===== How To Convert APP Form Customized Data to XML During APP Upgrade =====
 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.
@@ Line 40: / Line 40: @@
   * The user should fill in the Menu UID for each form and then click the <color #22b14c>**Generate XML**</color> button.
   * When the process is complete the user will receive a message on the SAP® B1 satus bar that the process was successful.
+{{:app/image44.jpeg?786}}
+===== How To Publish APP Customizer Changes to All Users =====
+The APP Customizer **Publish Forms** screen lists all SAP® Business One forms or other APP registered forms that have been modified through APP Customizer (Item Placement, Tab Order, and Mandatory Fields).
+Click the SAP menu option titled <color #22b14c>**Publish Forms**</color> under the <color #22b14c>**Administration**</color> {{:app/image10.jpeg?17x16}} <color #22b14c>**Setup**</color> {{:app/image10.jpeg?17x16}} <color #22b14c>**APP Configuration**</color> {{:app/image10.jpeg?17x16}} <color #22b14c>**Customizer**</color> menu to load the APP Customizer **Publish Forms** screen.
+{{:app:app_customizer_publish_forms.jpg?nolink&400|}}
+  * Click the <color #00a2e8>**Select**</color> column checkbox at the right of each form listing that you wish to publish APP Customizer modifications to all users.
+  * Click the <color #22b14c>**Publish**</color> button.
+  * Close the APP Customizer **Publish Forms** screen.
+<WRAP center round info 90%>
+Once APP Customizer form modifications have been published for all users, the changes will be reflected once any open instances of the form(s) published have been closed and reopened.
+</WRAP>
 {{:app/image44.jpeg?786}}
@@ Line 431: / Line 450: @@
 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.
+{{:app/image44.jpeg?786}}
@@ Line 2958: / Line 2976: @@
 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.
 </WRAP>
+{{:app/image44.jpeg?786}}
 ===== How To Set Tab Order Sequence =====
@@ Line 3149: / Line 3168: @@
 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.
+{{:app/image44.jpeg?786}}
 ===== How To Set Mandatory Fields =====
@@ Line 3515: / Line 3534: @@
   *  {{:app/image423.jpeg?310x25}} **Brown (4210816)**
-===== How To Export/Import Objects and Properties =====
+{{:app/image44.jpeg?786}}
+====== Exporting/Importing APP Objects and Properties ======
 APP Customizer includes the ability to export and import a number of objects, including...
- Item Properties and Events
+  *  Item Properties and Events
+  *  Charts
+  *  Dashboards
- Charts
+<WRAP center round important 90%>
+After importing **any** objects into APP, the application **must** be stopped and restarted for the imported modifications to take effect.
+</WRAP>
- Dashboards
+{{:app/image44.jpeg?786}}
+====== How To Export Item Properties and Events ======
+<WRAP center round info 90%>
+This example is for the **Item Master Data** screen.
+</WRAP>
-**[[#page731|How To Export/Import Item Properties and Events]] [[#page739|How To Export/Import Charts]] [[#page743|How To Export/Import Dashboards]]**
+  *  Click the SAP menu option titled <color #22b14c>**Item Master Data**</color> under the <color #22b14c>**Inventory**</color> menu to load the **Inventory Master Data** screen.  Load the information for an **Item** into the screen.
-{{:app/image704.jpeg?742x56}}{{:app/image67.jpeg?11x11}}{{:app/image67.jpeg?11x11}}{{:app/image67.jpeg?11x11}}
+<WRAP center round info 90%>
+For this example, the <color #00a2e8>**Unit Price**</color> field and label have been given a customized position on the screen.
-**Warning –** After importing **any** objects into APP, the application **must** be stopped and restarted for the imported modifications to take effect.
+</WRAP>
-{{:app/image34.jpeg?804}}
-===== How To Export/Import Item Properties and Events =====
-APP Customizer includes the ability to export and import Item Properties and Events
-{{:app/image160.jpeg?723x69}}
-**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.
-{{:app/image136.jpeg?723x94}}
-**Note** - For this example, the **Unit Price** field and label have been given a customized position on the screen.
-{{:app/image705.jpeg?723x640}}
-**Note** - The right-click menu should be launched while the mouse is on top of the item.
 {{:app/image706.jpeg?443x241}}
- Select the **Item Placement Configurator** option from the **APP** **Customizer** menu group option from the right-click menu on the form to load the [[#page320|**Item Configurator**]] screen.
+  *  Select the <color #22b14c>**Item Placement Configurator**</color> option from the <color #22b14c>**APP Customizer**</color> menu group option from the right-click menu on the form to load the **Item Configurator** screen.
 {{:app/image707.jpeg?772x411}}
-There are two entries on the [[#page320|**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.
+  *  There are two entries on the **Item Configurator** screen, one for the <color #00a2e8>**Unit Price**</color> entry field and one for the accompanying label. Select the configuration items that you want to export.
-{{:app/image136.jpeg?723x94}}{{:app/image67.jpeg?11x11}}{{:app/image67.jpeg?11x11}}
+<WRAP center round info 90%>
+At least one item configuration **must** be selected in order to utilize the export function.
-**Note** - At least one item configuration **must** be selected in order to utilize the export function.
+</WRAP>
 {{:app/image708.jpeg?792x148}}
- Click the down arrowhead on the **Export** button at the bottom of the screen and select the appropriate option.
+  *  Click the down arrowhead on the <color #22b14c>**Export**</color> button at the bottom of the screen and select the appropriate option.
 {{:app/image709.jpeg?352x83}}
- A window will open to allow you to specify the directory and file name under which the exported XML file will be saved.
+  *  A window will open to allow you to specify the directory and file name under which the exported XML file will be saved.
 {{:app/image710.jpeg?639x480}}
- Enter a file name.
+  *  Enter a file name.
+  *  Click the <color #22b14c>**Save**</color> button.
- 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.
- 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.
 {{:app/image711.jpeg?766x561}}
-**Importing**
+====== How To Import Item Properties and Events ======
-Click the SAP menu option titled **Item Master Data** under the **Inventory** menu to load the Inventory Master Data screen.
+<WRAP center round info 90%>
+This example is for the **Item Master Data** screen.
+</WRAP>
-{{:app/image159.jpeg?723x119}}{{:app/image67.jpeg?11x11}}
+  *  Click the SAP menu option titled <color #22b14c>**Item Master Data**</color> under the <color #22b14c>**Inventory**</color> 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.
+<WRAP center round info 90%>
+For this example, I am reusing the same SAP database. The <color #00a2e8>**Unit Price**</color> field and label customization has been removed following the export of the data to the XML file.
+</WRAP>
 {{:app/image712.jpeg?621x526}}
-Click the SAP menu option titled **Import XML** under the **Administration** -**Setup** -**APP Setup** menus .
+  * Click the <color #22b14c>**Import XML**</color> menu option under the **<color #22b14c>Administration</color>** {{:app/image35.jpeg?17x16}} **<color #22b14c>Setup</color>** {{:app/image35.jpeg?17x16}} **<color #22b14c>APP Configuration</color>** menu groups.
+  * A window will open to allow you to specify the directory and file name for the XML file to be imported.
-{{:app/image67.jpeg?11x11}}
-A window will open to allow you to specify the directory and file name for the XML file to be imported.
-{{:app/image67.jpeg?11x11}}
 {{:app/image713.jpeg?638x480}}
- Double click the file name or select the file and click the **Open** button.  The XML file will be imported into APP Customizer
+  * Double click the file name or select the file and click the <color #22b14c>**Open**</color> button.  The XML file will be imported into APP Customizer.
 {{:app/image714.jpeg?488x138}}
- Stop and restart the APP application.
+  * Stop and restart the APP application.
-{{:app/image715.jpeg?728x101}}
+<WRAP center round important 90%>
+After importing **any** objects into APP, the application **must** be stopped and restarted for the imported modifications to take effect.
+</WRAP>
-**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 <color #22b14c>**Item Master Data**</color> under the <color #22b14c>**Inventory**</color> menu to load the **Item Master Data** screen.
-{{:app/image22.jpeg}}
-Click the SAP menu option titled **Item Master Data** under the **Inventory** menu to load the Inventory Master Data screen.
 {{:app/image716.jpeg?621x526}}
- The Item Master screen now reflects the customizations to the **Unit Price** entry field and accompanying label imported from the XML file.
+  *  The **Item Master Data** screen now reflects the customization to the <color #00a2e8>**Unit Price**</color> entry field and accompanying label imported from the XML file.
-{{:app/image34.jpeg?804}}
+{{:app/image44.jpeg?786}}
-===== How To Export/Import Charts =====
+====== How To Export Charts ======
+  * Click the **<color #22b14c>Report Definition</color>** menu option under the **<color #22b14c>Administration</color>** {{:app/image35.jpeg?17x16}} **<color #22b14c>Setup</color>** {{:app/image35.jpeg?17x16}} **<color #22b14c>APP Configuration</color>** menu groups.
+  * Click on the object with the associated Chart that you want to export.
-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.
 {{:app/image717.jpeg?542x577}}
- Click the **Manage Charts** button ({{:app/image718.jpeg?18x18}}). The Chart Definition form is displayed.
+  * Click the <color #22b14c>**Manage Charts**</color> button {{:app/image718.jpeg?18x18}}. The **Chart Definition** screen is displayed.
 {{:app/image719.jpeg?527x419}}
- Click the **Export** button.
+  * Click the <color #22b14c>**Export**</color> button.
+  * A window will open to allow you to specify the directory and file name under which the exported XML file will be saved.
- A window will open to allow you to specify the directory and file name under which the exported XML file will be saved.
 {{:app/image720.jpeg?638x479}}
+  * Enter a file name.
+  * Click the <color #22b14c>**Save**</color> 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.
+<WRAP center round info 90%>
- Enter a file name.
+The Query for the Chart is also included in the exported XML file information.
+</WRAP>
- 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.
-{{:app/image136.jpeg?723x94}}
-**Note** - The Query for the Chart is also included in the exported XML file information.
 {{:app/image721.jpeg?784x581}}
-**Importing**
+====== How To Import Charts ======
- 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.
+  *  Click the SAP menu option titled <color #22b14c>**Import XML**</color> under the **<color #22b14c>Administration</color>** {{:app/image35.jpeg?17x16}} **<color #22b14c>Setup</color>** {{:app/image35.jpeg?17x16}} **<color #22b14c>APP Configuration</color>** menu groups.
+  *  A window will open to allow you to specify the directory and file name for the XML file to be imported.
 {{:app/image722.jpeg?639x480}}
- Double click the file name or select the file and click the **Open** button.  The XML file will be imported into APP Customizer
+  *  Double click the file name or select the file and click the <color #22b14c>**Open**</color> button.
+  *  The XML file will be imported into APP Customizer
 {{:app/image714.jpeg?488x138}}
- Stop and restart the APP application.
+  *  Stop and restart the APP application.
-{{:app/image109.jpeg?723x56}}
+<WRAP center round important 90%>
+After importing **any** objects into APP, the application **must** be stopped and restarted for the imported modifications to take effect.
+</WRAP>
-**Warning –** After importing **any** objects into APP, the application **must** be stopped and restarted for the imported modifications to take effect.
+====== How To Export Dashboards ======
-===== How To Export/Import Dashboards =====
+  *  Click the SAP menu option titled <color #22b14c>**Dashboard Setup**</color> under the **<color #22b14c>Administration</color>** {{:app/image35.jpeg?17x16}} **<color #22b14c>Setup</color>** {{:app/image35.jpeg?17x16}} **<color #22b14c>APP Configuration</color>** menu groups to load the **Dashboards** setup screen.
+  *  Load the Dashboard that you want to export.
-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.
 {{:app/image723.jpeg?385x328}}
- Click the **Export** button.
+  *  Click the <color #22b14c>**Export**</color> button.
+  *  A window will open to allow you to specify the directory and file name under which the exported XML file will be saved.
- A window will open to allow you to specify the directory and file name under which the exported XML file will be saved.
 {{:app/image724.jpeg?639x481}}
- Enter a file name.
+  *  Enter a file name.
+  *  Click the <color #22b14c>**Save**</color> 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.
- Click the **Save** button.
+<WRAP center round info 90%>
+The Query for the Dashboard panes are also included in the exported XML file information.
- 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.
+</WRAP>
-{{:app/image136.jpeg?723x94}}
-**Note** - The Query for the Dashboard panes are also included in the exported XML file information.
 {{:app/image725.jpeg?784x586}}
-**Importing**
+====== How To Import Dashboards ======
- 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 <color #22b14c>**Import XML**</color> under the **<color #22b14c>Administration</color>** {{:app/image35.jpeg?17x16}} **<color #22b14c>Setup</color>** {{:app/image35.jpeg?17x16}} **<color #22b14c>APP Configuration</color>** menu groups.
+  * A window will open to allow you to specify the directory and file name for the XML file to be imported.
- 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.
 {{:app/image726.jpeg?638x479}}
- Double click the file name or select the file and click the **Open** button.  The XML file will be imported into APP Customizer
+  * Double click the file name or select the file and click the <color #22b14c>**Open**</color> button.  The XML file will be imported into APP Customizer
 {{:app/image714.jpeg?488x138}}
- Stop and restart the APP application.
+  * Stop and restart the APP application.
-{{:app/image109.jpeg?723x56}}
-**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...
- **[[#page748|Item Syntax]] –  **Allows the user the ability to execute SQL queries that   automatically substitute information values from an active SAP Business One® form.
-{{:app/image6.jpeg?10x10}} [[#page750|**String Data Type**]]
-{{:app/image6.jpeg?10x10}} [[#page752|**Integer Data Type**]]
-{{:app/image6.jpeg?10x10}} [[#page754|**Decimal Data Type**]]
-{{:app/image6.jpeg?10x10}} [[#page758|**Date Data Type**]]
-{{:app/image6.jpeg?10x10}} [[#page760|**Line Level Data**]]
- **[[#page765|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.
-{{:app/image6.jpeg?10x10}} **STRING** or **0 –** For string (text) data type fields.
-{{:app/image6.jpeg?10x10}} **NUMBER –** For numerical Integer or Decimal data type fields.
-{{:app/image6.jpeg?10x10}} **DATE –** For date data type fields.
-{{:app/image6.jpeg?10x10}} **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]
- [[#page750|**String Data Type**]]
- [[#page752|**Integer Data Type**]]
- [[#page754|**Decimal Data Type**]]
- [[#page758|**Date Data Type**]]
- [[#page760|**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.
-{{:app/image727.jpeg?658x616}}
- 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**".
-{{:app/image728.jpeg?685x104}}**Warning** - The **"STRING"** syntax cannot be used in designation of the **Source Field** value when setting up process rules events on the [[#page328|**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...
-{{:app/image729.jpeg?357x27}}
-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...
-{{:app/image730.jpeg?786x374}}
-**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.
-{{:app/image731.jpeg?715x563}}
- 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...
-{{:app/image732.jpeg?450x48}}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...
-{{:app/image733.jpeg?786x375}}
-**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.
-{{:app/image734.jpeg?658x617}}
- 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...
-{{:app/image735.jpeg?443x41}}
-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...
-{{:app/image736.jpeg?507x148}}
-**Currency Code Value**
-In this example, we will represent the Sales Order Document Total currency code in dynamic syntax for a SQL query.
-{{:app/image737.jpeg?715x563}}
- 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...
-{{:app/image738.jpeg?442x39}}
-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...
-{{:app/image739.jpeg?505x145}}
-**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.
-{{:app/image740.jpeg?715x563}}
- 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...
-{{:app/image741.jpeg?400x23}}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...
-{{:app/image742.jpeg?507x148}}
-**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.
-{{:app/image743.jpeg?716x562}}
- 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...
-{{:app/image744.jpeg?422x24}}
-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...
-{{:app/image745.jpeg?507x144}}
-**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.
-{{:app/image746.jpeg?716x563}}
- 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.
-{{:app/image65.jpeg?0x10}} The **Data Type** for the Quantity is "**NUMBER**".
-Setting up the dynamic syntax in a SQL query will look like this...
-{{:app/image747.jpeg?365x26}}
-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...
-{{:app/image748.jpeg?785x295}}
-**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.
-{{:app/image749.jpeg?715x563}}
-The **Item UID** for the Warehouse Code field is "**38**" from "Item=38" in the
-{{:app/image67.jpeg?11x11}}
-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.
-{{:app/image67.jpeg?11x11}}
-The **Data Type** for the Warehouse Code is "**NUMBER**".
-{{:app/image67.jpeg?11x11}}
-Setting up the dynamic syntax in a SQL query will look like this...
-{{:app/image750.jpeg?435x23}}
-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...
-{{:app/image34.jpeg?804}}{{:app/image751.jpeg?508x157}}
-**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.
-{{:app/image6.jpeg?10x10}} **STRING** or **0 –** For string (text) data type fields.
-{{:app/image6.jpeg?10x10}} **NUMBER –** For numerical Integer or Decimal data type fields.
-{{:app/image6.jpeg?10x10}} **DATE –** For date data type fields.
-{{:app/image6.jpeg?10x10}} **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.
-{{:app/image752.jpeg?772x554}}
- 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...
-{{:app/image753.jpeg?341x43}}
-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...
-{{:app/image754.jpeg?507x144}}
+<WRAP center round important 90%>
+After importing **any** objects into APP, the application **must** be stopped and restarted for the imported modifications to take effect.
+</WRAP>

Wiki

User Tools

Site Tools

Differences

Page Tools