Wiki

Scale Your Enterprise

User Tools

Site Tools


app:advanced_productivity_pack_app

Advanced Productivity Pack (APP)

APP Installation

The current version of the application requires that any servers/client machines running the SAP B1 client and the application be using a minimum of version 4.8 of the Microsoft .Net Framework.

TWBS Advanced Productivity Pack (APP) installation consists of the following steps.

  • MS .Net Framework Version Verification – The latest versions of Third Wave SAP® Business One add-ons require that any servers/client machines running the SAP B1 client and the application are using a minimum of version 4.8 of the Microsoft .Net Framework.
  • SAP® Business One Extensions Path for APP Data Logging – Third Wave SAP® Business One add-ons have been updated with a new application data logging mechanism. It will no longer place files in the users local MY DOCUMENTS directory. The application will now use the SAP® Business One defined Extensions file path.
  • SAP® Business One APP Client – The TWBS APP add-on will only be available for installation through the SAP® Business One Server management of extensions for lightweight deployment method. Use of this method requires that the SAP® Business One System Landscape Directory be installed on the SAP® B1 Server.
  • Licensing Advanced Productivity Pack (APP) – TWBS SAP® Business One add-ons have been updated with an automatic licensing procedure based on the system SAP® Business One installation number.
  • APP License Allocation to Specific SAP® Business One Users – Individual assignment of APP licenses to specific SAP® Business One users is no longer required.
  • APP/EFT Server Configuration – Server configuration will allow you to verify the database connection credentials, enabled individual functionality modules within APP, create required database objects for installations/upgrades, and migrate APP Customizer or report data from older versions of APP if required during an upgrade.
    • Advanced Productivity Pack (APP)
      • Creation of APP Database Objects – How to create the required database objects for the APP application.
      • Setup Dashboards/Advanced Delivery Definitions – How to set up default dashboards and advanced delivery definitions.
      • Standard APP Reports – The TWBS APP application provides 16 standard Crystal Report layouts for SAP® Business One marketing documents.
    • Electronic Funds Transfer (EFT)
      • Creation of EFT Database Objects – How to create the required database objects for the EFT application.
  • Setting SAP® Business One Authorizations for APP Admin Access – Third Wave SAP® Business One add-ons have been updated to restrict access to application screens used for setup and/or configuration. Each user that you want to provide access to these screens will need to be manually provided authorization to access the specific screen through this process.

SAP® Business One Extensions Path for APP Data Logging

Third Wave SAP® Business One add-ons have been updated with a new application data logging mechanism. It will no longer place files in the users local MY DOCUMENTS directory. The application will now use the SAP® Business One defined Extensions file path.

The specified Extensions Folder path should be a network location directory that is accessible to all SAP® B1 users starting the application.

Launch the General Settings screen by selecting the General Settings menu option under the Administration image10.jpeg System Initialization menu groups.

Click the Path tab along the top of the form .

image11.jpeg

Verify that a directory that is accessible to all SAP® B1 users starting the application is specified on the Extensions Folder line.

If you wish to change the Extensions Folder location, please be sure that all users are logged out of all TWBS add-on applications before the new directory is selected.

SAP® Business One APP Client

The TWBS APP add-on will only be available for installation through the SAP® Business One Server management of extensions for lightweight deployment method. Use of this method requires that the SAP® Business One System Landscape Directory be installed on the SAP® B1 Server.

Installing SAP® Business One Applications through the SLD

Licensing APP Modules

Third Wave Business System SAP® Business One add-ons have been updated with an automatic licensing procedure. In order to obtain a permanent license key, the production environment SAP® Business One installation number must first be provided to TWBS Support so that the information can be entered into our systems. The SAP® Business One installation number is a critical component to the new TWBS application license keys. Without this information you will only be able to obtain a 30-day application trial license.

On start up, the application client will verify that a valid license exists for the application having been purchased based on your SAP® Business One installation number. If the license is verified, the application will start. If the application has not been purchased, a 30-day trial license will be issued to allow for limited use of the application. If your trial license has expired and you would like to purchase the application to obtain a full license key, please contact Third Wave Business Systems @ (201) 703-2100.

APP License Allocation to Specific SAP® Business One Users

The TWBS APP Processing application has been updated so that the manual allocation of user licenses to specific SAP® Business One users is no longer required. The application will automatically track when the application is connected/disconnected how many individual user licenses are currently in use.

APP/EFT Server Configuration

TWBS APP Server Configuration screen access is controlled through the SAP® Business One Authorizations function.

  • Launch the APP Server Configuration screen by selecting the Server Configuration menu option under the Administration image35.jpeg Setup image35.jpeg APP Configuration menu groups.

  • The Server Name, Database, and SQL/Hana Provider values will be determined automatically based on the SAP® Business One company database the user is logged into.
  • Enter the database user credentials in the fields provided.
  • Enter the SMTP Server information in the fields provided, if using SMTP rather than MS Outlook.
    • The SMTP Server for email delivery either by server name or by IP address.
    • The Port # for the SMTP Server .
    • The Enable SSL check box will enable Secure Socket Layer (SSL) for the SMTP Server.
  • Set the desired value for the APP Menu Refresh drop down.
    • Always Refresh on Menu Load
    • Never Refresh on Menu Load
  • Check the Suppress Menu Items for Doc Specific Reports on Main Menu checkbox if you do not wish for document specific reports to be displayed on the main SAP menu structure.
  • Select the SMTP Authentication option if using SMTP for report delivery.
    • Basic Authentication - The existing user/password SMTP authentication method.
    • oAuth Authentication - New oAuth authentication method that will require the generation of new security credentials that will be entered into the fields that display on the selection of this option.
      • Tenant ID
      • Client ID
      • Client Secret

Support for oAuth SMTP authentication is limited to Microsoft Exchange Online servers at this time. Additional SMTP support will be added later.

For instructions on how to generate oAuth account credentials for Microsoft Exchange Online servers, please use the following link:

  • Click the Test Connection button to test the data interface connection.
  • If the credentials entered allow a successful connection, the user will receive a confirmation message box.
  • Click the Update button.

If you are upgrading to a new version of APP from a prior version that did not store all APP information in the SAP® Business One company database, you will be required to convert or “migrate” the APP data during the upgrade process. Please refer to the How To Migrate TWBS_SBO-Common Data During APP Ugrade section of the guide.

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. Please refer to the How To Convert APP Form Customized Data to XML section of the guide.

APP - Database Object Creation

If you are any of the APP modules of the TWBS APP application, you must create the associated database objects required for the APP application.

  • Launch the APP Server Configuration screen by selecting the Server Configuration menu option under the Administration image35.jpeg Setup image35.jpeg APP Configuration menu groups.

  • Click the Recreate APP SQL Objects button to initiate the SAP® B1 company database object creation.
  • The user will be notified once the process is complete.
  • Click the Create APP Objects button to initiate the SAP® B1 company database object creation.

This process will initiate a prompt by SAP® Business One that new database objects have been created and they will need to close open windows.

  • Once the process is complete and successful, and the form is reloaded, the indicators next to the Recreate APP SQL Objects and Recreate APP SQL Objects buttons will display image43.jpeg.

APP - Dashboards/Adv. Delivery Definition Setup

  • Launch the APP Server Configuration screen by selecting the Server Configuration menu option under the Administration image35.jpeg Setup image35.jpeg APP Configuration menu groups.

  • Click the Setup Dashboards/ADD Definitions button to initiate the dashboards and advanced delivery definitions setup.
  • Once the process is complete and successful, the indicator next to the Setup Dashboards/ADD Definitions button will display image43.jpeg.

APP - Standard Reports Included

TWBS Advanced Productivity Pack (APP) provides a variety of standard Crystal Reports layouts for SAP® Business One marketing documents included with the product installation. While these reports are installed, they come disabled and would need to be edited through the Report Maintenance form to activate them.

Included Reports: Quote, Sales Order, Pack List, A/R Invoice, Goods Return, Purchase Order, A/P Invoice, Credit Memo, Sales Return, Goods Receipt PO, Customer Statements, Service Calls, Check Printing, A/R Down Payment, A/P Down Payment, Incoming Payments, Outgoing Payments

EFT - Database Object Creation

If you are utilizing the EFT module of the TWBS APP application, you must create the associated database objects required for the EFT application.

  • Launch the APP Server Configuration screen by selecting the Server Configuration menu option under the Administration image35.jpeg Setup image35.jpeg APP Configuration menu groups

  • Click the Create EFT Objects button to initiate the SAP® B1 company database object creation.

This process will initiate a prompt by SAP® Business One that new database objects have been created and they will need to close open windows.

  • Once the process is complete and successful, and the form is reloaded, the indicator next to the Create EFT Objects buttons will display image43.jpeg.

EFT - Standard Reports Included

Installtions of TWBS EFT that are not using the basic TWBS APP application will have the ability to configure and execute 2 of the standard TWBS APP crystal reports files that are specific to TWBS EFT functionality.While these reports are installed, they come disabled and would need to be edited through the Report Maintenance form to activate them.

Included Reports: Incoming Payments & Outgoing Payments

Setting SAP® Business One Authorizations for APP Configuration Access

Third Wave SAP® Business One add-ons have been updated to restrict access to application screens used for setup and/or configuration. Each user that you want to provide access to these screens will need to be manually provided authorization to access the specific screen through this process.

  • Launch the General Authorizations screen by selecting the General Authorizations menu option under the Administration image10.jpeg System Initialization image35.jpeg Authorizations menu groups. Select the user or group from the left list for whom you want to set authorizations.

image36.jpeg

  • Expand the User Authorization section on the right side of the form by clicking on the arrow head next to it so that it is pointing down.
  • Inside the User Authorization section you will find entries for each of the following options.

The TWBS Server Settings authorization setting is common to all TWBS applications. Disabling access will affect all installed add-ons using this mechanism.

  • TWBS Server Settings – Provides authorization to access the APP Server Configuration form.
  • TWBS APP Report Maintenance – Provides authorization to access the Report Maintenance form.
  • TWBS APP Define Roles – Provides authorization to access the User Roles Properties Screen form.
  • TWBS APP Module Manager – Provides authorization to access the APP Modules form.
  • TWBS APP Admin Access – Provides authorization to access the APP Admin Access Screen form.
  • TWBS APP Form Registration – Provides authorization to access the Form Registration Screen form.

APP SAP® Business One Add-On Client Uninstall Process

The TWBS APP add-on will only be available for installation through the SAP® Business One Server management of extensions for lightweight deployment method. Use of this method requires that the SAP® Business One System Landscape Directory be installed on the SAP® B1 Server.

The SAP® Business One System Landscape Directory must be installed on the SAP® B1 Server to access this option. All installations and removals of APP versions 92.2.0 and above must be performed on the SAP® B1 Server through the System Landscape Directory.

If your previous version of TWBS APP is a version that still utilizes the Database Server.

  • Open the Database Service Manager Screen select the Uninstall Service option.

image6.jpegimage47.jpeg

  • Open the operating system option for administering programs through the Control Panel.
  • Uninstall the option for Third Wave APP Database Server.

If your previous version of TWBS APP is a version installed through the Add-On Administrator.

  • Launch the SAP® Business One Add-On Administration screen selecting the option from the Administration image35.jpeg Add-Ons menu.
  • Move the entry with Third Wave APP in the Add-On Name column to the left by highlighting the row and clicking the button.
  • Click the Remove Add-On button on the Add-On Administration screen.
  • Click the Update button on the Add-On Administration screen.
  • Log back into SAP® Business One to initiate the SAP® Business One client uninstall.

If your previous version of TWBS APP is a version installed through Lightweight Deployment.

As of the release of Version 92.2.0 of the TWBS Advanced Productivity Pack (APP) application, the add-on will only be available for installation through the SAP® Business One Server management of extensions for lightweight deployment method. Use of this method requires that the SAP® Business One System Landscape Directory be installed on the SAP® B1 Server.

The screenshots in this section are for a different application for process only.

  • Launch the SAP® Business One Add-On Administration screen selecting the menu option.
  • Click the Manage Extensions for Lightweight Deployment link in the bottom right corner of the form.

The SAP® Business One System Landscape Directory must installed on the SAP® B1 Server to access this option.

image50.jpeg

  • Selection of the link will open an instance of your default web browser to navigate to the Extension Manager.

If you receive the following notification about the website's security certificate, you can click the Continue to this website option.

  • Log into the System Landscape Directory using the correct credentials.

image17.jpeg

  • Click on the Company Assignment tab of the SAP® Business One Extension Manager screen and select the SAP® B1 Company database name from the Company List that you want to remove the application from.

image52.jpeg

  • Click on the line for the name of the application that you want to remove.
  • Click the Unassign button on the form.

image53.jpeg

  • A confirmation message box will appear for the un-assignment of the extension from the company database. Click the Yes button.

image54.jpeg

If you need to remove the application from more than one SAP® B1 Company database, repeat these last few steps for each of the databases in the Company List which have the application assigned to them.

  • Click on the Extensions tab of the SAP® Business One Extension Manager screen and select the line for the name of the application that you want to remove.

image56.jpeg

  • Click the Remove button.

image57.jpeg

  • A confirmation message box will appear for the removal of the extension from the company database. Click the Yes button.

Applying APP Updates

The TWBS APP add-on will only be available for installation through the SAP® Business One Server management of extensions for lightweight deployment method. Use of this method requires that the SAP® Business One System Landscape Directory be installed on the SAP® B1 Server.

The SAP® Business One System Landscape Directory must installed on the SAP® B1 Server to access this option. All installations and removals must be performed on the SAP® B1 Server through the System Landscape Directory.

  • If your previous version of the TWBS APP application is a non-SLD installed version, you should refer to the APP SAP® Business One Add-On Client Uninstall Process section of the User Guide and follow all appropriate instructions for the complete removal of the previous version of TWBS APP.
    • Once the previous version of TWBS APP has been uninstalled, you can follow the steps in the SAP® Business One Add-On Client Installation section of the User Guide to install the latest version.
  • If your previous version of the TWBS APP application is an earlier release of TWBS APP, you have the option to install the new patch without removing the previous patch and the System Landscape Directory will upgrade to the new patch.
  • If you would rather remove the previous version prior to upgrading to the new patch release, you should refer to the APP SAP® Business One Add-On Client Uninstall Process section of the User Guide and follow all appropriate instructions for the complete removal of the previous version of TWBS APP.
    • Once the previous version of TWBS APP has been uninstalled, you can follow the steps in the SAP® Business One Add-On Client Installation section of the User Guide to install the latest version.

APP Module Management

TWBS APP application functionality is divided into separate modules. Only enable the modules for the aspects of APP that you want to use. These components are administered through the TWBS Module Manager screen.

  • Advanced Productivity Pack (APP)
    • Report Maintenance and Delivery
    • Customizer
    • Dashboards
  • Electronic Funds Transfer (EFT)
  • Journal Voucher Import

The TWBS Electronic Funds Transfer (EFT) application is sold and licensed separately from the TWBS Advanced Productivity Pack (APP) application.

Activating Modules

  • Select the Module Manager menu option under the Administration image10.jpeg Setup image10.jpeg APP Configuration menus to load the APP Module Manager screen.
  • Click the Active checkbox next to the module(s) that you wish to enable.

Activating a module will enable this functionality for all users in the SAP Business One® company database, not just for an individual user.

  • Click the Update button.

Activation and deactivation of modules will require the restarting of the APP SAP® Business One Client for the changes to be applied.

APP Modules

For information on new features, functionality enhancements, or fixes in releases of APP/EFT please refer to the Release Notes document available in the application documentation download or full APP application package.

APP - Report Maintenance and Delivery

Report maintenance and document delivery provides the user with a suite of tools to execute and deliver reports and documents, either individually or in mass processing, via delivery methods including fax, print, email, or a combination - performed in a single process.

APP - Customizer

TWBS Advanced Productivity Pack (APP) Customizer provides users with a customization toolkit and process rules to facilitate the enhancement of any SAP® Business One forms or UI-based add-on application screens without the use of programming knowledge. The APP Customizer toolkit consists of the following areas:

  • Item Placement - Item Placement capabilities allow the user to add objects (labels, text fields, buttons, and tabs) to forms or edit the properties of existing SAP objects.
  • Process Rules - Process Rules capabilities allow the user to add field and event based validations and procedure executions to forms.
  • Tab Order Sequence - Tab Order sequence capabilities allow 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 - Mandatory Fields configuration capabilities allow 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.

Any APP Customizer functionality will be limited by the restrictions of the SAP® Business One object. All Customizer functionality has been tested and verified on UI-based add-on forms.

APP - Dashboards

Interactive dashboards and charts to speed decision making. Automatic refreshing dashboards and charts.

EFT - Electronic Funds Transfer

Journal Voucher Import

SAP® Document Object Type Reference Guide

Each SAP® Business One marketing document has a unique object type (ObjType) value associated with it in the respective database table that identifies the type of marketing document that the record represents.

ObjType ValueAssociated SAP® Business One Object
13 A/R Invoice
14 A/R Credit Memo
15 Delivery Note
16 Return
17 Sales Order
18 A/P Invoice
19 A/P Credit Memo
20 Goods Receipt Purchase Order
21 Goods Return
22 Purchase Order
23 Sales Quotation
59 Goods Receipt
60 Goods Issue
67 Inventory Transfers
132 Correction Invoice
163 A/P Correction Invoice
164 A/P Correction Invoice
165 A/R Correction Invoice
166 A/R Correction Invoice
202 Production Order
203 A/R Down Payment Invoice
204 A/P Down Payment Invoice
540000006 Purchase Quotation

The Production Order database table (OWOR) does not have a specific ObjType field that contains the value for the Production Order document header record. Please refer to the How To Add Link To Arrows for Production Order to TWBS Visual Query Results section of the User Guide.

TWBS Application Technical Support

Support is provided for Third Wave’s APP application and all included modules. Please direct your inquiries regarding APP functional and technical capabilities to your SAP® Business One Partner or Third Wave Business Systems (TWBS).

Visit the TWBS Support Portal (login credentials required)

  • Add/manage support tickets for product issues and inquiries.
  • Review and download product software releases for upgrades.

Visit the TWBS YouTube Channel

  • Product overview videos for all TWBS applications.
  • Product training video series and demos for select products.
app/advanced_productivity_pack_app.txt · Last modified: 2025/06/12 09:38 by dtucker