Differences

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

--- app:app_how_to_dash [2019/07/25 16:15]
dtucker [How To Set Up User Defaults for an APP Dashboard]
+++ app:app_how_to_dash [2019/07/25 22:22] (current)
@@ Line 108: / Line 108: @@
 ===== Query Tips and Tricks for APP Dashboards =====
+==== SAP® Business One Link To Document Arrows ====
-**SAP® Business One Link To Document Arrows**
 One of the integration features of SAP® Business One custom queries is the ability to include a "Link To" golden arrow in the results set that allows the user to drill back to the referenced marketing document. In order to accomplish this, there are several key pieces of information that are **required** in the query to accomplish this link...
- Document Entry (DocEntry) value from the document table.
+  *  Document Entry (DocEntry) value from the document table.
+  *  Object Type (ObjType) value usually from the document table.
- Object Type (ObjType) value usually from the document table.
+<WRAP center round tip>
+The **SAP® Document Object Type Reference Guide** can be used to identify specific object type values. Refer to the **How To Add Link To Arrows for Production Order to TWBS Visual Query Results** section of the User Guide.
+</WRAP>
-{{:app/image235.jpeg?723x104}}
+<WRAP center round important>
+The Production Order database table (OWOR) does not have a specific ObjType field that contains the value for the Production Order document header record.
+</WRAP>
-**Tip** - The [[#page785|**SAP® Document Object Type Reference Guide**]] can be [[#page223|used to identify specific object type values. Refer to the **How To Add**]]
+==== Dates ====
-**[[#page223|Link To Arrows for Production Order to TWBS Visual Query]]** [[#page223|**Results** section of the User Guide.]]
-{{:app/image195.jpeg?723x81}}
-**Warning** - The Production Order database table (OWOR) does not have a specific ObjType field that contains the value for the Production Order document header record.
-**Dates**
 Assume that the current date is May 15, 2010 for the following examples.
- Current Date - **Select getdate()** will return the current system date & time.
+  *  Current Date - <color #ff7f27>**Select getdate()**</color> will return the current system date & time.
-{{:app/image160.jpeg?723x69}}
+<WRAP center round info>
+Parenthesis () are required since this is a SQL function.
+</WRAP>
-**Note** - Parenthesis () are required since this is a SQL function.
+  *  Parsing Dates - Use the SQL <color #ff7f27>**datepart**</color> function to determine the year, quarter, month, week, and day of a date. The value returned is an integer (number) and can be used in additional calculations.
+    *  <color #ff7f27>**Select datepart(//year//,getdate())**</color> returns **2010**.
+    *  <color #ff7f27>**Select datepart(//quarter//,getdate())**</color> returns **2**.
+    *  <color #ff7f27>**Select datepart(//month//,getdate())**</color> returns **5**.
+    *  <color #ff7f27>**Select datepart(//week//,getdate())**</color> returns **21.**
+    *  <color #ff7f27>**Select datepart(//day//,getdate())**</color> returns **20.**
+  *  Filtering by Date - The SQL <color #ff7f27>**datepart**</color> function can also be used to compare dates in order to automatically select a reporting period. In these examples we will use the SAP® Business One Order Header (ORDR) date and the current date of May 15, 2010.
+    *  Records where the order date is in the current week
+      *  <color #ff7f27>**Select t0.docnum, t0.docdate from ORDR where datepart(year,t0.docdate) = datepart(year,getdate()) AND datepart(week,t0.docdate) = datepart(week,getdate())**</color>
+    *  Records where the order date is in the prior week
+      *  <color #ff7f27>**Select t0.docnum, t0.docdate from ORDR where datepart(year,t0.docdate) = datepart(year,getdate()) AND datepart(week,t0.docdate) = datepart(week,getdate()) - 1**</color>
+    *  Records where the order date is in the current quarter
+      *  <color #ff7f27>**Select t0.docnum, t0.docdate from ORDR where datepart(year,t0.docdate) = datepart(year,getdate()) AND datepart(quarter,t0.docdate) = datepart(quarter,getdate())**</color>
- Parsing Dates -Use the SQL **datepart** function to determine the year, quarter, month, week, and day of a date. The value returned is an integer (number) and can be used in additional calculations.
+==== Numbers ====
-**Select datepart(//year//,getdate())** returns **2010**.
+The user interface for SAP® Business One displays decimal numeric values based on the <color #22b14c>**Display**</color> tab setup which can be accessed the SAP menu option for <color #22b14c>**Display**</color> under the **Administration** -**System Initialization** -**General Settings** -**Display** menus.
-{{:app/image6.jpeg?10x10}}
+the **<color #22b14c>Administration</color>** {{:app/image35.jpeg?17x16}} **<color #22b14c>System Initialization</color>** {{:app/image35.jpeg?17x16}} **<color #22b14c>General Settings</color>** menu groups to load the **General Settings** screen.
-**Select datepart(//quarter//,getdate())** returns **2**.
-{{:app/image6.jpeg?10x10}}
-**Select datepart(//month//,getdate())** returns **5**.
-{{:app/image6.jpeg?10x10}}
-**Select datepart(//week//,getdate())** returns **21.**
-{{:app/image6.jpeg?10x10}}
-**Select datepart(//day//,getdate())** returns **20.**
-{{:app/image6.jpeg?10x10}}
- Filtering by Date -The SQL **datepart** function can also be used to compare dates in order to automatically select a reporting period. In these examples we will use the SAP® Business One Order Header (ORDR) date and the current date of May 15, 2010.
-{{:app/image6.jpeg?10x10}} Records where the order date is in the current week
-**Select t0.docnum, t0.docdate from ORDR where datepart(year,t0.docdate) = datepart(year,getdate()) AND datepart(week,t0.docdate) = datepart(week,getdate())**
-{{:app/image6.jpeg?10x10}} Records where the order date is in the prior week
-**Select t0.docnum, t0.docdate from ORDR where datepart(year,t0.docdate) = datepart(year,getdate()) AND datepart(week,t0.docdate) = datepart(week,getdate()) - 1**
-{{:app/image6.jpeg?10x10}} Records where the order date is in the current quarter
-**Select t0.docnum, t0.docdate from ORDR where datepart(year,t0.docdate) = datepart(year,getdate()) AND datepart(quarter,t0.docdate) = datepart(quarter,getdate())**
-**Numbers**
-The user interface for SAP® Business One displays decimal numeric values based on the **Display** tab setup which can be accessed the SAP menu option for **Display** under the **Administration** -**System Initialization** -**General Settings** -**Display** menus.
 However, decimal values are stored in the database to six-decimal precision. This means that a decimal value such as US Dollars that is displayed in SAP® Business One as 100.00 will be retrieved and displayed in the APP Charts as 100.000000. The number of decimals can be controlled by the SQL statement in the query. Combinations of **cast** and **round** can be used to arrive at a reasonable display value.
- Display the database value 100.000000 for the column DocTotal with 2 decimals (100.00)
+  * Display the database value 100.000000 for the column DocTotal with 2 decimals (100.00)
+    * <color #ff7f27>**Select cast(t0.DocTotal as decimal(16,2))**</color>
-**Select cast(t0.DocTotal as decimal(16,2))**
+  * Display the database value 55.900000 for the column DocTotal rounded to a whole number (56.000000)
+    * <color #ff7f27>**Select round(t0.DocTotal,0)**</color>
- Display the database value 55.900000 for the column DocTotal rounded to a whole number (56.000000)
+  * Display the database value 55.900000 for the column DocTotal rounded to a whole number (56.000000) and without decimals
+    * <color #ff7f27>**Select cast(round(t0.DocTotal,0) as int)**</color>
-**Select round(t0.DocTotal,0)**
- Display the database value 55.900000 for the column DocTotal rounded to a whole number (56.000000) and without decimals
-**Select cast(round(t0.DocTotal,0) as int)**
+{{:app/image44.jpeg?786}}
 ===== How To Use APP Dashboards =====
 Once an APP Dashboard has been created it is available for viewing via the right-click menu from the SAP® Business One form that it has been linked to.
@@ Line 206: / Line 171: @@
 {{:app/image771.jpeg?236x130}}
-When more than one dashboard is linked to the screen, the titles of those dashboards will display in a **Dashboards** sub-menu off the regular right-click menu below any reports or charts...
+When more than one dashboard is linked to the screen, the titles of those dashboards will display in a <color #22b14c>**Dashboards**</color> sub-menu off the regular right-click menu below any reports or charts...
 {{:app/image772.jpeg?409x148}}
@@ Line 212: / Line 177: @@
 A specific chart from a dashboard can be accessed by double-clicking on the chart window. This opens the standard APP Chart window for additional use.
+{{:app/image44.jpeg?786}}

Wiki

User Tools

Site Tools

Differences

Page Tools