Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Contact Us
  • Home
  • AP - Payment Approval Management
  • XML File Management

Defining a file format by bank

How to set up each bank account to have a different file format

Written by Jarrad Sonnenberg

Updated at September 8th, 2022

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Requisition Approval Processing Suite (RAPS)
    RAPS Setup RAPS Utilities RAPS Requisition Entry RAPS Requisition Approval RAPS Convert Approved Reqs RAPS Purchase Order Cancel RAPS Delegation Maintenance RAPS Contract Module RAPS Expediting Module RAPS Pre-Revision Quotation Module RAPS - ATC Process (Approval to Commit) RAPS Enquiry by PSA Air Department RAPS Cost Controllers RAPS Unbudgeted/Budgeted RAPS Change Order Mode
  • AP - Automated Invoice Workflow
    Validating Invoices Invoice Register - Department Invoice Register - Finance Invoice Register - Ready for Processing Invoice Register - Invoice Payment Approval Setup DOA Reports Utilities Mail Downloader
  • AP - Payment Approval Management
    Payment Approval Process Bank Details Approval/Segregation XML File Management Bank Integration Setup
  • Global Upload Program (GUP)
  • Document Register (DocReg)
  • Rotables / Component Changeout
    Component Lifecycle What's under the hood Serial Administration Component Processing Repairs Management Warehouse Processing
  • PSA Mining Report Suite
    1. Finance Reports
  • Standard Pronto Modules
    General Ledger Procurement / Inventory Management Audit Management Pronto Help Guides 1099 Forms
  • PSA HelpDesk
+ More

The first step is to evaluate the bank setup in SYS.M054 Bank Master Maintenance. Each payment method should have its own bank account. The template is set to the bank code, so it is not possible to pay checks and ACH and EFT out of the same pronto bank code, even though it may be the same actual bank account.

The recommended solution is to take the bank account that is being set up for XML bank payments to have a final character referring to the payment type;

  • A - ACH
  • E - EFT
  • W - Wire
  • C - Distributed Check

So CHAS bank above would be CHASW for wires from this account. 

Once these banks have been set up, it is possible to create a file format for the bank. It is recommended that after the bank accounts above are set up, a 1 dollar payment is made out of each account and cancelled, so that the bank account will show up in the ZUIT.M022 Bank Payment Register. The reason is that this screen only shows accounts that have had payments run through them. 

Once a payment has been made and cancelled, it is possible to select the bank that is being set up and press on the TEMPLATES mode.

This allows the user to select an element of the file, and then set up the XML structure of the file. These file formats will be documented within this wiki as they evolve in the XML Payments Management page. Each section of the XML file, can have its content set up within a word pad, containing the XML.

It is important to note that fields called %VARIABLE*% are used to automatically pull from Pronto data fields where the data is dynamic. These will also be documented in the XML Payments Management page.

After setting up a header, details and footer template, it is now possible to test the bank file format. 

 

format definition bank specific

Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • XML File Overview
  • Sample File: EFT
  • Sample File: XML Wire
  • %VARIABLE% Definitions

It’s time to transform the way you do business.

Let’s talk

Pronto Solutions Alliance Inc. (PSA) helps business clients reach and exceed their potential through implementation of Enterprise Resource Planning Software. We are the leading North American reseller of Pronto Xi ERP Business Software.

Navigation

  • Services and Support
  • Company
  • Resources
  • Blogs

Industries

  • Mining
  • Distribution
  • Pharmaceutical
  • Field Service

Resources

  • Case Studies
  • Brochures
  • Whitepapers

+ (952) 452-4301

PSA Canada Inc.

310 Centre Street South, Whitby, Ontario, L1N 4V9

PSA USA Inc.

80 S 8th St, Suite 900 Minneapolis, MN, 55402

Connect social

Proudly powered by WordPress | Theme: UnderStrap Child by understrap.com.(Version: 0.5.5)

@ALL Rights Reserved 2021 Pronto Solutions Alliance

Website Designed By Kinex Media

Expand