| Both sides previous revision
Previous revision
Next revision
|
Previous revision
|
app:app_rpt_screens [2019/06/12 06:55] dtucker [Report Options Screen] |
app:app_rpt_screens [2025/08/05 12:58] (current) dtucker [Report Maintenance Screen - Report Group Option - Delivery Preferences Tab] |
| TWBS Advanced Productivity Pack (APP) creates a screen through the SAP® Business One User Interface (UI) that allows for the administrative maintenance of reports, report groups, queries, and emails. This functionality allows the user to add, update, clone or delete definitions. The user also has the ability to add or delete categories. | TWBS Advanced Productivity Pack (APP) creates a screen through the SAP® Business One User Interface (UI) that allows for the administrative maintenance of reports, report groups, queries, and emails. This functionality allows the user to add, update, clone or delete definitions. The user also has the ability to add or delete categories. |
| |
| * 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 Setup</color>** menu groups. | * 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. |
| |
| {{:app/image88.jpeg?723x733}} | {{:app:app_report_maintenance.jpg?nolink&600|}} |
| |
| <WRAP center round info> | <WRAP center round info> |
| * **<color #00a2e8>Message ID</color> –** This is a drop down box to specify the Message selected for the delivery. The list contains all the messages defined previously. For defining new message, select <color #00a2e8>**Define New**</color> from the list. | * **<color #00a2e8>Message ID</color> –** This is a drop down box to specify the Message selected for the delivery. The list contains all the messages defined previously. For defining new message, select <color #00a2e8>**Define New**</color> from the list. |
| * **<color #00a2e8>Attachment Format</color> –** Select the desired email attachment file format for your report. Available options include... | * **<color #00a2e8>Attachment Format</color> –** Select the desired email attachment file format for your report. Available options include... |
| | * <color #00a2e8>**No Attachment**</color> |
| * <color #00a2e8>**Adobe PDF**</color> | * <color #00a2e8>**Adobe PDF**</color> |
| * <color #00a2e8>**MS Excel**</color> | * <color #00a2e8>**MS Excel**</color> |
| * <color #00a2e8>**Send**</color> | * <color #00a2e8>**Send**</color> |
| * **<color #00a2e8>Message ID</color> –** This is a drop down box to specify the Message selected for the delivery. The list contains all the messages defined previously. For defining new message, select <color #00a2e8>**Define New**</color> from the list. | * **<color #00a2e8>Message ID</color> –** This is a drop down box to specify the Message selected for the delivery. The list contains all the messages defined previously. For defining new message, select <color #00a2e8>**Define New**</color> from the list. |
| * **<color #00a2e8>Attachment Format</color> –** Select the desired email attachment file format for your report. Available options include... | * **<color #00a2e8>Attachment Format</color> –** Designate the file format type used to attach the Crystal Report results to the e-mail. |
| | * <color #00a2e8>**No Attachment**</color> |
| * <color #00a2e8>**Adobe PDF**</color> | * <color #00a2e8>**Adobe PDF**</color> |
| * <color #00a2e8>**MS Excel**</color> | * <color #00a2e8>**MS Excel**</color> |
| * <color #00a2e8>**MS Word**</color> | * <color #00a2e8>**MS Word**</color> |
| * <color #00a2e8>**SBO-XML**</color> | * <color #00a2e8>**SBO-XML**</color> |
| | |
| | <WRAP center round tip> |
| | For Report Groups, if an individual report is set to <color #00a2e8>**No Attachment**</color> for the attachment format, the report will be attached to the report group email as a <color #00a2e8>**PDF**</color>. |
| | </WRAP> |
| * **<color #00a2e8>Email From</color> –** Designate the email address which will be used as the sender's address if SMTP is specified as the e-mail provider. The field will be disabled and selected **Default Outlook User** if Outlook is specified as the e-mail provider. | * **<color #00a2e8>Email From</color> –** Designate the email address which will be used as the sender's address if SMTP is specified as the e-mail provider. The field will be disabled and selected **Default Outlook User** if Outlook is specified as the e-mail provider. |
| * **<color #00a2e8>Delivery Receipt</color> checkbox –** Specify a delivery receipt. | * **<color #00a2e8>Delivery Receipt</color> checkbox –** Specify a delivery receipt. |
| Selecting the <color #00a2e8>**Define New**</color> option at the bottom of the <color #00a2e8>**Link To**</color> drop down list on the **Report Maintenance** screen will launch the **Form Registration** screen. APP allows you to attach custom crystal reports to any SAP® Business One or add-on screen built in the SAP® Business One User Interface (i.e. you can launch a report from any SAP® Business One window by clicking the Print or Preview buttons). The first step in this process is to register the window in APP using the Form Registration screen. | Selecting the <color #00a2e8>**Define New**</color> option at the bottom of the <color #00a2e8>**Link To**</color> drop down list on the **Report Maintenance** screen will launch the **Form Registration** screen. APP allows you to attach custom crystal reports to any SAP® Business One or add-on screen built in the SAP® Business One User Interface (i.e. you can launch a report from any SAP® Business One window by clicking the Print or Preview buttons). The first step in this process is to register the window in APP using the Form Registration screen. |
| |
| The Form Registration screen is also accessible through the SAP <color #22b14c>**Form Registration**</color> menu option under the <color #22b14c>**Administration**</color> {{:app/image10.jpeg?17x16}} <color #22b14c>**Setup**</color> {{:app/image10.jpeg?17x16}} <color #22b14c>**APP Configuration**</color> menus. | The Form Registration screen is also accessible through the <color #22b14c>**Form Registration**</color> menu option under the <color #22b14c>**Administration**</color> {{:app/image10.jpeg?17x16}} <color #22b14c>**Setup**</color> {{:app/image10.jpeg?17x16}} <color #22b14c>**APP Configuration**</color> menus. |
| |
| {{:app/image121.jpeg?357x377}} | {{:app/image121.jpeg?357x377}} |
| ===== BP Properties Screen ===== | ===== BP Properties Screen ===== |
| |
| Clicking on the **Set as Default** button on the [[#page145|**Report Options**]] screen will launch the BP Properties screen. This screen is used to specify the default Business Partner settings for the selected report. | Clicking on the <color #22b14c>**Set as Default**</color> button on the **Report Options** screen will launch the **BP Properties** screen. This screen is used to specify the default Business Partner settings for the selected report. |
| |
| {{:app/image150.jpeg?723x303}} | {{:app/image150.jpeg?723x303}} |
| |
| **Note** - These settings will be valid during the Document Printing process as well. | <WRAP center round info> |
| | These settings will be valid during the Document Printing process as well. |
| | </WRAP> |
| |
| **Set as default for Current BP Only option -**Select this option if the default setting is valid only for the selected business partner. | * **<color #00a2e8>Set as default for Current BP Only</color> option -** Select this option if the default setting is valid only for the selected business partner. |
| | * **<color #00a2e8>Code</color> -** The card code of the selected business partner. This is a read only field. |
| |
| {{:app/image6.jpeg?10x10}} **Code-**The card code of the selected business partner. This is a read only field. | <WRAP center round tip> |
| | Default by BP for a single BP/ range will supersede the setting for BP Group. For example, there are 2 versions of a Sales Order – SO1 and SO2. BP code C20000 belongs to BP Group “Construction”. Let’s assume we set SO1 as the default report for BP Group “Construction” and set SO2 as the default report for BP code C20000.When the user prints a sales order with C20000 as the BP, SO2 will be printed. |
| | </WRAP> |
| |
| {{:app/image151.jpeg?723x179}} | * **<color #00a2e8>Set as default for Specified BPs</color> option -** Select this option if the default setting is valid for a range of business partners. |
| | * **<color #00a2e8>Code From</color> -** The card code range starting value. If this is missing, the first business partner will be selected as default. |
| | * **<color #00a2e8>Code To</color> -** The card code range ending value. If this is missing, the last business partner will be selected as default. |
| |
| **Note** - Default by BP for a single BP/ range will supersede the setting | * **<color #00a2e8>BP Group option</color> option -** Select this option if the default setting is valid for an entire business partner group. |
| | * **<color #00a2e8>BP Group</color> -** This is a drop down list from which the user can select the business partner group. |
| |
| for BP Group. For example, there are 2 versions of a Sales Order – | * **<color #22b14c>OK</color> button -** Perform the selected action and close the window. |
| | * **<color #22b14c>Cancel</color> button -** Cancel the action and close the window. |
| SO1 and SO2. BP code C20000 belongs to BP Group | |
| | |
| “Construction”. Let’s assume we set SO1 as the default report for BP | |
| | |
| Group “Construction” and set SO2 as the default report for BP code | |
| | |
| C20000.When the user prints a sales order with C20000 as the BP, | |
| | |
| SO2 will be printed. | |
| | |
| **Set as default for Specified Bps option -**Select this option if the default setting is valid for a range of business partners. | |
| | |
| {{:app/image6.jpeg?10x10}} **Code From -**The card code range starting value. If this is missing, the first business partner will be selected as default. | |
| | |
| {{:app/image6.jpeg?10x10}} **Code To -**The card code range ending value. If this is missing, the last business partner will be selected as default. | |
| | |
| **BP Group option -**Select this option if the default setting is valid for an entire business partner group. | |
| | |
| {{:app/image6.jpeg?10x10}} **BP Group -**This is a drop down list from which the user can select the business partner group. | |
| | |
| | |
| | |
| **OK button -** Perform the selected action and close the window. | |
| | |
| **Cancel button -**Cancel the action and close the window. | |
| |
| {{:app/image44.jpeg?786}} | {{:app/image44.jpeg?786}} |
| The Document Action screen is used to select an action to perform while doing a Document Printing from SAP® Business One. | The Document Action screen is used to select an action to perform while doing a Document Printing from SAP® Business One. |
| |
| Click the SAP menu option titled **Document Printing** under any of the SAP® Business One menus to load the Document Printing - Selection Criteria screen. | Click the SAP menu option titled <color #22b14c>**Document Printing**</color> under any of the SAP® Business One menus to load the **Document Printing - Selection Criteria** screen. |
| |
| Click the **Ok** button on the Document Printing - Selection Criteria screen to launch the APP Document Action screen. | Click the <color #22b14c>**Ok**</color> button on the **Document Printing - Selection Criteria** screen to launch the **APP Document Action** screen. |
| |
| {{:app/image152.jpeg?419x290}} | {{:app/image152.jpeg?419x290}} |
| |
| **Contact Preferences option** - Select this option to perform the actions preferred by the contacts persons/ship to addresses. More about this is explained in the How To section. | * **<color #00a2e8>Contact Preferences</color> option** - Select this option to perform the actions preferred by the contacts persons/ship to addresses. More about this is explained in the How To section. |
| | * **<color #00a2e8>Print</color> option** - Select this option to print the default reports to the preferred printers. |
| | * **<color #00a2e8>Deliver</color> option** - Select this option to deliver the default reports. |
| | * **<color #00a2e8>Fax</color> options** - Select this option to fax the default reports. |
| |
| **Print option -** Select this option to print the default reports to the preferred printers. | * **<color #22b14c>OK</color> button -** Perform the selected action |
| | * **<color #22b14c>Cancel</color> button -** Discard the changes and close the form. |
| **Deliver option -** Select this option to deliver the default reports. | |
| | |
| **Fax options -** Select this option to fax the default reports. | |
| | |
| | |
| | |
| **OK button -** Perform the selected action | |
| | |
| **Cancel button -** Discard the changes and close the form. | |
| |
| {{:app/image44.jpeg?786}} | {{:app/image44.jpeg?786}} |
| The Deliver BP Statements screen allows users to perform Print/Deliver/Fax BP Statements to Business Partners. | The Deliver BP Statements screen allows users to perform Print/Deliver/Fax BP Statements to Business Partners. |
| |
| Click the SAP menu option titled **APP - Deliver BP Statements** under the **Business Partner** menu to load the Business Partner Master Data screen. | Click the SAP menu option titled <color #22b14c>**APP - Deliver BP Statements**</color> under the <color #22b14c>**Business Partner**</color> menu to load the **Business Partner Master Data** screen. |
| |
| {{:app/image67.jpeg?11x11}}{{:app/image153.jpeg?407x257}} | {{:app:app_deliver_bp_statements.jpg?nolink&400|}} |
| |
| **Code From -** The card code range starting value. If this is missing, the first business partner will be selected as default. | **Select the Business Partners:** |
| | * <color #00a2e8>**Code From**</color> - The card code range starting value. If this is missing, the first business partner will be selected as default. |
| | * <color #00a2e8>**Code To**</color> - The card code range ending value. If this is missing, the last business partner will be selected as default. |
| |
| **Code To -** The card code range ending value. If this is missing, the last business partner will be selected as default. | <WRAP center round info> |
| | The range of card codes selected here will be processed in batch. |
| | </WRAP> |
| |
| {{:app/image154.jpeg?723x31}} | * <color #00a2e8>**BP Group**</color> - This is a drop down list from which the user can select the business partner group. |
| | * **<color #00a2e8>Include ZERO and -VE Balance Partners</color> checkbox** - Check this to include all the business partners with a zero or negative balance. |
| | * **<color #00a2e8>Select the Default Reports</color> option** - If this option is chosen APP will execute the default report (by BP, BP group) associated with each record that is part of the delivery definition. |
| | * **<color #00a2e8>Select a Specific Report</color> option** - This drop down will last all report definitions associated with the selected form that can be executed via Batch processing (i.e. all report definitions that have a query associated with it). |
| | * **Specify the Report** - If the user chooses the **Select a Specific Report** option, they need to select the report definition that they want to use. Selecting a specific report will execute that report for all records in the delivery definition. |
| |
| **Note** - The range of card codes selected here will be processed in batch. | * **<color #00a2e8>Process based on Contact Preferences</color> checkbox** - Select this option to perform the actions preferred by the contacts persons. |
| |
| **BP Group -**This is a drop down list from which the user can select the business partner group. | * **<color #22b14c>Print</color> button** - Print the reports selected in the window. |
| | * **<color #22b14c>Deliver</color> button** - Deliver the reports selected in the window. |
| {{:app/image6.jpeg?10x10}} **Include ZERO and -VE Balance Partners checkbox -**Check this to include all the business partners with a zero or negative balance. | * **<color #22b14c>Print & Deliver</color> button** - Perform both Print and Deliver actions. |
| | * **<color #22b14c>Cancel</color> button** - Cancel the action and close the window. |
| **Select the Default Reports option -**If this option is chosen APP will execute the default report (by BP, BP group) associated with each record that is part of the delivery definition. | |
| | |
| **Select a Specific Report option -**This drop down will last all report definitions associated with the selected form that can be executed via | |
| | |
| Batch processing (i.e. all report definitions that have a query associated with it). | |
| | |
| **Specify the Report -** If the user chooses the **Select a Specific Report** option, they need to select the report definition that they want to use. Selecting a specific report will execute that report for all records in the delivery definition. | |
| | |
| | |
| | |
| **Process based on Contact Preferences checkbox** -Select this option to perform the actions preferred by the contacts persons. | |
| | |
| | |
| | |
| **Print button -** Print the reports selected in the window. | |
| | |
| **Deliver button -** Deliver the reports selected in the window. | |
| | |
| **Print & Deliver button - P**erform both Print and Deliver actions. | |
| | |
| **Cancel button -** Cancel the action and close the window. | |
| |
| {{:app/image44.jpeg?786}} | {{:app/image44.jpeg?786}} |
| ===== Visual Query Builder Screen ===== | ===== Visual Query Builder Screen ===== |
| | |
| TWBS Advanced Productivity Pack (APP) incorporates a Visual Query Builder screen that allows the user to have a dynamic method to create and edit queries which can be used for reporting, query execution, or dashboards. | TWBS Advanced Productivity Pack (APP) incorporates a **Visual Query Builder** screen that allows the user to have a dynamic method to create and edit queries which can be used for reporting, query execution, or dashboards. |
| | |
| | |
| | |
| Load the Visual Query Builder window through one of the following | |
| |
| methods... | Load the **Visual Query Builder** window through one of the following methods... |
| |
| {{:app/image6.jpeg?10x10}} **[[#page200|How To Load a Blank Query into Visual Query Builder]]** {{:app/image6.jpeg?10x10}} [[#page203|**How To Load an Existing Query into Visual Query Builder**]] | * How To Load a Blank Query into Visual Query Builder |
| | * How To Load an Existing Query into Visual Query Builder |
| |
| {{:app/image155.jpeg?772x466}} | {{:app/image155.jpeg?772x466}} |
| |
| **SQL Tables List Pane -** The pane on the far right of the Visual Query Builder screen will list all of the available tables that the user can incorporate into the query. Tables can be added to the query by clicking on the table name and dragging the table into the **SQL Graphical** **Display Pane**. | * <color #00a2e8>**SQL Tables List Pane**</color> - The pane on the far right of the Visual Query Builder screen will list all of the available tables that the user can incorporate into the query. Tables can be added to the query by clicking on the table name and dragging the table into the <color #00a2e8>**SQL Graphical Display Pane**</color>. |
| |
| {{:app/image156.jpeg?723x93}} | <WRAP center round info> |
| | With focus in the <color #00a2e8>**SQL Tables List Pane**</color>, you can begin typing the table name and the tables list will locate the table. |
| | </WRAP> |
| |
| **Note** - With focus in the **SQL Tables List Pane**, you can begin typing the table name and the tables list will locate the table. | * <color #00a2e8>**SQL Graphical Display Pane**</color> - Once a table has been added to the graphical display, the fields for that table will be listed and will be available to be added to the selection part of the SQL query by clicking the check box to the left of the field name. |
| | * <color #00a2e8>**SQL Summary Pane**</color> - Fields and tables added to the query will be shown in summary form in this pane. |
| | * <color #00a2e8>**SQL Query Text Pane**</color> - Fields and tables added to the query will be shown in query form in this pane. |
| |
| {{:app/image157.jpeg}} | <WRAP center round info> |
| | The Query can be directly edited in the <color #00a2e8>**SQL Query Text Pane**</color> and those changes will be reflected in the <color #00a2e8>**SQL Graphical Display Pane**</color> once the <color #22b14c>**Save**</color> button has been clicked. |
| {{:app/image158.jpeg?723}}**SQL Graphical Display Pane -** Once a table has been added to the graphical display, the fields for that table will be listed and will be available to be added to the selection part of the SQL query by clicking the check box to the left of the field name. | </WRAP> |
| | |
| | |
| | |
| **SQL Summary Pane -** Fields and tables added to the query will be shown in summary form in this pane. | |
| | |
| | |
| | |
| **SQL Query Text Pane -** Fields and tables added to the query will be shown in query form in this pane. | |
| | |
| {{:app/image159.jpeg?723x119}} | |
| | |
| **Note** - The Query can be directly edited in the **SQL Query Text Pane** and those changes will be reflected in the **SQL Graphical Display** **Pane** once the **Save** button has been clicked. | |
| | |
| **Save & Close button -** Save the SQL Query and close the Visual Query Builder screen. | |
| | |
| **Save button -** Save the SQL Query. | |
| |
| **Cancel button -** Close the Visual Query Builder screen. | * **<color #22b14c>Save & Close</color> button** - Save the SQL Query and close the Visual Query Builder screen. |
| | * **<color #22b14c>Save</color> button** - Save the SQL Query. |
| | * **<color #22b14c>Cancel</color> button** - Close the Visual Query Builder screen. |
| |
| {{:app/image44.jpeg?786}} | {{:app/image44.jpeg?786}} |
| ===== Chart Viewer Screen ===== | ===== Chart Viewer Screen ===== |
| |
| TWBS Advanced Productivity Pack (APP) incorporates a Chart Viewer screen for the display and manipulation of charts or their associated data. | TWBS Advanced Productivity Pack (APP) incorporates a **Chart Viewer** screen for the display and manipulation of charts or their associated data. |
| |
| | * Click the SAP menu option for the query that you want to create the Chart for under the <color #22b14c>**Tools**</color> {{:app/image35.jpeg?17x16}} <color #22b14c>**Queries**</color> {{:app/image35.jpeg?17x16}} <color #22b14c>**User Queries**</color> menus to load the selected query into the SAP Query screen. |
| |
| **Chart Tab** | <WRAP center round info> |
| | This example is for the **Sales by Customer** query. |
| | </WRAP> |
| |
| Click the SAP menu option for the query that you want to create the Chart for under the **Tools** -**Queries** -**User Queries** menus to load the selected query into the SAP Query screen. | {{:app/image161.jpeg?507x357}} |
| |
| {{:app/image160.jpeg?723x69}} | The button to the immediate right of the <color #22b14c>**Close**</color> button will allow the user to view existing charts associated with the query or to create a new chart. |
| |
| **Note** - This example is for the **Sales by Customer** query. | {{:app/image162.jpeg?157x52}} |
| |
| {{:app/image161.jpeg?507x357}} | Click the <color #22b14c>**Total Sales by Customer**</color> button option to create a new chart. |
| |
| The button to the immediate right of the **Close** button will allow the user to view existing charts associated with the query or to create a new chart. | This will load the **Chart Viewer** form for the selected chart. |
| |
| {{:app/image162.jpeg?157x52}} | ==== Chart Tab ==== |
| |
| Click the **Total Sales by Customer** button option to create a new chart. | Visual display of the chart for the query data. |
| | |
| This will load the Chart Viewer form for the selected chart. | |
| |
| {{:app/image163.jpeg?774x468}} | {{:app/image163.jpeg?774x468}} |
| |
| **Data Tab** | ==== Data Tab ==== |
| |
| Clicking on the **Data** tab will give visibility to the dataset that is used for the chart. | Clicking on the <color #22b14c>**Data**</color> tab will give visibility to the data set that is used for the chart. |
| |
| {{:app/image164.jpeg?766x741}} | {{:app/image164.jpeg?766x741}} |
| |
| **Grouping the Chart Data** | ==== Grouping the Chart Data ==== |
| |
| To group any data on the chart data tab, click and drag the column title of the data that you wish to group by into the area above the column titles. | To group any data on the chart data tab, click and drag the column title of the data that you wish to group by into the area above the column titles. |
| |
| {{:app/image165.jpeg?412x257}} | {{:app/image165.jpeg?412x257}} |
| {{:app/image166.jpeg?438x379}} | {{:app/image166.jpeg?438x379}} |
| |
| Clicking on the down {{:app/image167.jpeg?12x11}} or up {{:app/image168.jpeg?12x12}} arrows will expand or contract the data group. | Clicking on the down {{:app/image167.jpeg?12x11}} or up {{:app/image168.jpeg?12x12}} arrows will expand or contract the data group. |
| |
| {{:app/image136.jpeg?723x94}} | <WRAP center round info> |
| | Information on both the **Data** and **Chart** tabs will update in real-time as columns are selected for grouping. |
| **Note** - Information on both the **Data** and **Chart** tabs will update in real-time as columns are selected for grouping. | </WRAP> |
| | |
| | |
| | |
| **Filtering the Chart Data** | |
| |
| To filter any data on the chart data tab, click the {{:app/image169.jpeg?18x17}} icon to the right of | ==== Filtering the Chart Data ==== |
| |
| the column title of the data that you wish to filter. | To filter any data on the chart data tab, click the {{:app/image169.jpeg?18x17}} icon to the right of the column title of the data that you wish to filter. |
| |
| {{:app/image170.jpeg?413x304}} | {{:app/image170.jpeg?413x304}} |
| |
| A form will be displayed which will list all values of that field in the dataset. This will allow the user to select **only** those values that will be displayed either by selecting the individual values or a range of values. The user will also be able to clear any existing filters through the **Clear** **Filter** button. | A form will be displayed which will list all values of that field in the data set. This will allow the user to select **only** those values that will be displayed either by selecting the individual values or a range of values. The user will also be able to clear any existing filters through the <color #22b14c>**Clear Filter**</color> button. |
| |
| {{:app/image171.jpeg?297x461}} | {{:app/image171.jpeg?297x461}} |
| |
| Select the data that you want to filter for the column. | Select the data that you want to filter for the column. |
| |
| {{:app/image172.jpeg?723x573}} | <WRAP center round info> |
| | Information on both the **Data** and **Chart** tabs will update in real-time as values are selected for filtering. |
| | </WRAP> |
| |
| **Note** - Information on both the **Data** and **Chart** tabs will update in real-time as values are selected for filtering. | Any columns for which the data has been filtered will display the {{:app/image173.jpeg?18x16}} icon colored to indicate filtering has been applied. |
| |
| Any columns for which the data has been filtered will display the {{:app/image173.jpeg?18x16}} icon colored to indicate filtering has been applied. | Clicking on the <color #22b14c>**Chart**</color> tab will display the updated chart. |
| | |
| Clicking on the **Chart** tab will display the updated chart. | |
| | |
| {{:app/image174.jpeg?804x491}} | |
| |
| {{:app/image44.jpeg?786}} | {{:app/image44.jpeg?786}} |
| While processing either an existing or new advanced delivery definition, the user will be prompted with the Advanced Delivery Processing screen. | While processing either an existing or new advanced delivery definition, the user will be prompted with the Advanced Delivery Processing screen. |
| |
| {{:app/image175.jpeg?782x54}} | <WRAP center round info> |
| | Refer to the **How To Execute APP Advanced Delivery Definitions** section of the user guide. |
| **Note** - Refer to the **[[#page305|How To Execute APP Advanced Delivery Definitions]]** section of the user guide. | </WRAP> |
| |
| {{:app/image176.jpeg?407x356}} | {{:app/image176.jpeg?407x356}} |
| |
| | * <color #00a2e8>**Adv. Del. Definition**</color> - The ID/name of the advanced delivery definition. |
| |
| | <WRAP center round info> |
| | The ID/name of the advanced delivery definition will only be populated if the user is executing a previously defined definition. |
| | </WRAP> |
| |
| **Adv. Del. Definition -** The ID/name of the advanced delivery definition. | * <color #00a2e8>**Select Form**</color> - The form associated with the advanced delivery definition. |
| | * **<color #00a2e8>Select Default Report</color> option** - Assign the default report for the SAP® Business One form to the advanced delivery definition. |
| | * **<color #00a2e8>Select Specific Report</color> option** - Assign a specific report to the advanced delivery definition. |
| | * **Additional Query Filters Grid** - This grid is used to define the conditions for the delivery definition. |
| | * **<color #00a2e8>Field</color> column** - The field from the object to be used in the filter. |
| | * **<color #00a2e8>Condition</color> column** - The condition option to be used in the filter. |
| | * <color #00a2e8>**Equal**</color> - Is equal to |
| | * <color #00a2e8>**Not Equal**</color> - Is not equal to |
| | * <color #00a2e8>**Greater Than**</color> - Is greater than |
| | * <color #00a2e8>**Smaller Than**</color> - Is smaller than |
| | * <color #00a2e8>**Greater or Equal**</color> - Is greater than or equal to |
| | * <color #00a2e8>**Smaller or Equal**</color> - Is smaller than or equal to |
| | * <color #00a2e8>**Between**</color> - Between |
| | * **<color #00a2e8>Value #1</color> column** - The first value to be evaluated by the condition. |
| | * **<color #00a2e8>Value #2</color> column** - The second value to be evaluated by the condition. |
| |
| **Note** - The ID/name of the advanced delivery definition will only be populated if the user is executing a previously defined definition. | <WRAP center round info> |
| | <color #00a2e8>**Value #2**</color> is not required for all conditions. |
| | </WRAP> |
| |
| {{:app/image177.jpeg?742x51}} | * **<color #00a2e8>Relationship</color> column** - |
| | * <color #00a2e8>**And**</color> - Specifies that multiple conditions must be satisfied if they exist. |
| **Select Form -** The form associated with the advanced delivery definition. | * <color #00a2e8>**Or**</color> - Specifies that one of multiple conditions must be satisfied if they exist. |
| | |
| **Select Default Report option** - Assign the default report for the SAP® Business One form to the advanced delivery definition. | |
| | |
| **Select** Specific Report option - Assign a specific report to the advanced delivery definition. | |
| | |
| | |
| | |
| **Additional Query Filters Grid -** This grid is used to define the conditions for the delivery definition. | |
| | |
| {{:app/image6.jpeg?10x10}} **Field** - The field from the object to be used in the filter. | |
| | |
| {{:app/image6.jpeg?10x10}} **Condition** - The condition option to be used in the filter. | |
| | |
| **Equal** - Is equal to | |
| | |
| | |
| | |
| **Not Equal** - Is not equal to | |
| | |
| | |
| | |
| **Greater Than** - Is greater than | |
| | |
| | |
| | |
| **Smaller Than** - Is smaller than | |
| | |
| | |
| | |
| **Greater or Equal** - Is greater than or equal to | |
| | |
| | |
| | |
| **Smaller or Equal** - Is smaller than or equal to | |
| | |
| | |
| | |
| **Between** - Between | |
| | |
| | |
| | |
| {{:app/image6.jpeg?10x10}} **Value #1** - The first value to be evaluated by the condition. | |
| | |
| {{:app/image6.jpeg?10x10}} **Value #2** - The second value to be evaluated by the condition. | |
| | |
| **Note** - **Value #2** is not required for all conditions. | |
| | |
| {{:app/image178.jpeg?667x28}} | |
| | |
| {{:app/image6.jpeg?10x10}} **Relationship** - | |
| | |
| **And** - Specifies that multiple conditions must be satisfied if they exist. | |
| | |
| | |
| | |
| **Or** - Specifies that one of multiple conditions must be satisfied if they exist. | |
| | |
| {{:app/image66.jpeg?785}} | |
| | |
| **Update/OK button -** Clicking this button will load the form that will display the definition results set. | |
| | |
| **Cancel button -** Discard the changes and close the window. | |
| | |
| **Save As Config button -** Allows the user to save the definition. | |
| | |
| {{:app/image34.jpeg?804}} | |
| | |
| {{:app/image44.jpeg?786}} | |
| | |
| ===== Batch Processing Screen ===== | |
| | |
| {{:app/image44.jpeg?786}} | |
| |
| What was called **Batch Processing** in previous versions of TWBS CrystalWave is now provided via the APP [[#page305|**Advanced Delivery**]] functionality. | * **<color #22b14c>Update/OK</color> button** - Clicking this button will load the form that will display the definition results set. |
| | * **<color #22b14c>Cancel</color> button** - Discard the changes and close the window. |
| | * **<color #22b14c>Save As Config</color> button** - Allows the user to save the definition. |
| |
| {{:app/image44.jpeg?786}} | {{:app/image44.jpeg?786}} |