Payment data export

[Sterio, Louis]

Submitter: Aaron LaBounty, BCS Prosoft

Business Need

Our clients who use bank services that print and mail checks to vendors require a way to export payment data for specific bank accounts in .csv format. This solution allows users to select a vendor type (individual or entity), the checking account from which the payment was made, and the payment date.

When the Preview button is clicked, the selected information is passed into an API call to retrieve the payment data. The data is then converted into the .csv format required by the bank and displayed on the screen. Since individual and entity vendors have different format requirements, there is a selector to choose the correct format.

After reviewing the data, users can click Export to CSV to save the file onto their computer.

Prerequisites

Ensure that Accounts Payable and Cash Management are fully configured with the appropriate permissions to query AP payments.

Additional Information

This tool is based on an API testing tool shared by Louis Sterio several months ago, so parts of it may look familiar. The vendor types and checking accounts are hardcoded in the script. You can either update the script to hardcode the checking accounts that apply to you or dynamically query the vendor types and checking accounts as needed. To edit the script, go to the page, click More Actions > Edit This Page, and then edit the script component.

Installation Steps

1. Download the page script here
   Password: exportAllthosePayments
2. Log in to Sage Intacct.
3. Navigate to Platform Services > Applications > Install From XML.
4. Browse for the package file (AP_Payment_Export.xml) provided above and click Install.
5. Navigate to the newly created menu: AP Payment Export.

Usage Steps

1. Log in to Sage Intacct.
2. Navigate to AP Payment Export > AP Payment Export.
3. Choose a vendor type.
4. Choose a checking account.
5. Choose a payment date.
6. Preview the data or export it to a CSV file.

[Josh Kenzer]

@Louis Sterio2 The page script link appears to be password protected.

[Sterio, Louis]

@Josh Kenzer Password: exportAllthosePayments