Excel Add-in (V3)
The Promenta Add-in enables a more convenient integration point for users to submit journal requests. The Add-In version 3 uses additional executables to enable browser communication.
Please note : Additional maintenance and/or license fees may be applicable – please check with your Promenta Account Manager
The Promenta Excel Add-in Version 3 offers these key features – functionality which is new for Version 3 is highlighted.
- Direct integration with Promenta Journal Solution in SAP
- Send-to-workflow button to submit a journal request straight from the excel template
- Support for Single-Sign-on to SAP systems (ECC/S4Hana) without need for RFC/SNC
- No need for SAP GUI installation
- SAP-data lookup from the excel template
- Support for Microsoft Edge (Version 2)
- Resubmit rejected request (Version 2)
- Additional template formats (Version 2)
- Support for multiple journals in the same request (Version 2)
- Full internationalization capability (Version 2)
- Sophisticated installer program (Version 3)
- Support for OneDrive and Sharepoint files (Version 3)
A short video is available here : Journal Add-in Demo
Send-to-Workflow : This button will submit the journal to the Promenta journal solution running inside your SAP system
Validate : This button will cause all the data of the journal to be validated against your SAP master data in real time.
Inbox : This button will open your Promenta Inbox to review sent and pending requests
Template Manager : This button will open the Template Manager to enable journal templates to be downloaded.
Click here to see installation guide
Download installers from here
Information for IT / BASIS teams
The excel service is the interface between the excel add-in installed on every users desktop and the SAP finance (ECC/S4Hana) system. It can be enabled for Single-sign-on with HTTP SSO technologies.
The Excel service is available in 2 versions :
Portal version – this is deployed as part of the Promenta Portal patch and must be configured. Connection to SAP is made from the portal via the SAP JCO service. As such the SAP Portal client JCO service must be configured in the portal
WAS (ABAP) version – this is deployed as part of the core delivery. No additional configuration is needed in SAP.
Information for IT teams
The Excel Addin must communicate and control the browser to enable data exchange. The only supported method for achieving this is using the WebDriver standard. With this method a intermediate program is used to receive communications from the Addin and then pass the commands to the browser. Each browser supplier (Microsoft Edge, Google Chrome etc) supplies their own version of the WebDriver.
Promenta recommends MicroSoft Edge and we include versions of the EdgeDriver with our standard installation. Google Chrome can also be used but not included in our installer.
The Add-in is configured on each users local systems via an ini file.
The ini file contains
- The allowed list of SAP systems that can be connected to.
- Determines if Portal or WAS(ABAP) is to be used
- Determines which browser and associated driver is to be used
- Setup browser screen sizing
Note : No user ids, passwords or other credentials are stored in the ini file