Create BottomLine ACH/Check Output

Owned by Kathleen Avery (Deactivated)
Last updated: Aug 31, 2017
2 min read

Create BottomLine ACH/Check Output: 

To create an XML file, with data to be transmitted to BottomLine:

  1. Create a Disbursement Voucher.  This can be done by using the GUI (Main Menu Tab, Transactions Column, Financial Processing section, Disbursement Voucher) or by creating a formatted .csv file and uploading the file to the staging directory.  Uploading the file can be done using the GUI (Adminstration Tab, Batch Column, Financial Processing section, DisbursementVoucherCSVUpload).  If the Upload approach is taken, LoadDisbursementVoucherJob must be run (Administration Tab, Batch column, System section, Schedule Jobs, namespace=fp).  Verify that the Due date is the current date (Payment InformationTab, right-hand column).
  2. The Disbursement Vouchers must be approved.  Backdoor in as the approver, go to the action list, select the Disbursement Voucher and approve the document.  The document must be in FINAL status, before a check or ACH payment can be created.
  3. Run the DisbursementVoucherPreDisbursementExtractJob (Administration Tab, Batch column, System section, Schedule Jobs, namespace=fp).  Verify that the job ran successfully by looking at the log.
  4. Format the payment.  (Maintenance Tab, first column, Pre-Disbursement Processor Section, Format Checks/ACH).  Capture the Process ID
  5. Review the Format Summary report.  (Maintenance Tab, first column, Pre-Disbursement Processor Section, Format Summary).  Enter process id, then search.  Select the process id from the results window.  The report must be complete before the next step.  The report will summarize the payment types and number of payments.
  6. Run the pdpExtractBottomLineAchPaymentsJob and/or the pdpExtractBottomlineCheckPaymentsJob (Administration Tab, Batch column, System section, Schedule Jobs, namespace=pdp).
  7. Review the XML output. (Administration Tab, Batch column, System section, Batch File, staging/pdp/payment extract).
  8. If need to verify file through BottomLine, contact Finance Systems to coordinate a test of the file.  The file needs an actual (real) Company Id and Account Number.  Performing this test in the SUP environment will give the real values for the Company ID and Account Numbers.

Â