This alert is for clients that use the PosiPay service with their bank, which requires them to upload a XLS or CSV file with the appropriate information. This alert will run each day and attach the file to be submitted to the bank to register the checks/amounts with the bank.
Jump to: Overview | Samples | Variables | Alert Functionality | OnDemand Report Filters | Best Practices & Tips | Related Alerts
Overview:
Overview:
This alert will create the XLS or CSV file with the appropriate information included for your bank, from the AP checks created each day. When we install this for you we will request the bank requirements for data needed in the file (i.e. ck#, amount, etc). Please provide a sample as this will be customized for you.
Run Schedule: Weekday Evenings
Type of Output: Email / On Demand Report
* * *
Sample
Sample
This screenshot shows a sample of the .xls file that would be included in the email:
* * *
Variables
Variables
This alert has no variables but requires cooperation from your bank to get set up.
* * *
Alert Functionality
Alert Functionality
1. The alert pulls daily Accounts Payable check details as required by your bank and provides to you in either XLS or CSV file. File format will depend on your SQL Server version.
2. Also provides an On Demand SSRS Report so you can run as needed for time period needed.
* * *
On Demand Report Filters
On Demand Report Filters
Use the disc ikon to export to excel:
* * *
Best Practices & Tips
Best Practices & Tips
None at this time.
* * *
Related Alerts
Related Alerts
None at this time.
* * *
0 Comments