Convert Payables Trial Balance Report into Excel from PDF
This bot will fetch payable report in PDF format from Oracle ERP, convert it to Excel and send it to the user via mail.
Top Benefits
- Excel version of Payables Trial Balance helps users in reconciliation of AP to GL.
- Helps in easy identification of differences during reconciliation.
- Perform Pivots in Excel.
- If users have Excel version, then as per their need they can easily put filters.
Bot Reads and fetches data from PDF to Excel Format and from Excel will key in information into Oracle
The bot downloads information from Oracle Payables Trial Balance report output is in PDF. As excel version of Payable Trial Balance helps users in reconciliation of AP to GL. Pivots can be created
Free
- Bot Security Program
-
Level 1 - Applications
-
- Business Process
- Finance and Accounting
- Category
- Productivity
- Downloads
- 164
- Vendor
-
- Automation Type
- Bot
- Last Updated
- March 21, 2019
- First Published
- August 9, 2018
See the Bot in Action
Setup Process
Install
Download the Bot and follow the instructions to install it in your AAE Control Room.
Configure
Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)
Run
That's it - now the Bot is ready to get going!
Requirements and Inputs
- AAE v10.5 or higher
Inputs:- vInfo_Login_ID
- vInfo_Pswd
- vEmailTo
- vEmailFrom
- ExcelFile
- ExcelFilePath
- TextFile
- PDFFile
- OutputFolderPath
- InputExcelFile