Skip to main content
Question

XML file with format pain.001

  • January 16, 2023
  • 1 reply
  • 355 views
K
Hero (Employee)
Forum|alt.badge.img+9

Is it possible to get a XML file with format pain.001 from customer version of IFS? they need supplier payments information in this file to send to the bank.

1 reply

L
Sidekick (Partner)
Forum|alt.badge.img+4
  • liztrescott
  • Sidekick (Partner)
  • March 1, 2024

Sure can! 

  1. Make sure ISO 20022 is set up in Paymet Format per Company
  2. Add ISO 20022 to Cash Book > Payment Methods
  3. Go to your payment institute to add ‘Payment Methods per Institute’ to add ISO.
  4. Go to ‘Format Specific Info per Institute’
    1. You will most likely use File Template CORE.
    2. If you are making supplier payments, you are the Inititating Party and you are the Debtor.
    3. In general, this is the information that will populate your <GrpHdr> in the XML
  5. In IFS Connect, you will go to Transformers to utilize ISO CORE.  Select your output location & try a test file.  
  6. Whittle down your accuracy field by field. 

 

Working with XMLs

Here’s a trick to find out what IFS fields populate which tags on your XML.  Enter the Field Name in each IFS field.  For example, in the BIC field enter “BIC”  When you run your file, you will see where each field has mapped to your XML.  (Not always possible if it’s looking for numbers vs. text.  But a good head start)

It’s a Pain

You simply have to get a PAIN mapping from your bank to get the particulars. Especially if you are doing payments outside of your home country.  For example, Thailand has a high and low dollar value payment, no payments over 2M THB are allowed via transfer per supplier. It must be wired.  

The best resource is NACHA.  Even though NACHA is a very US-centric organization, with the new ISO compatibility, they probably have the best xml field mapping out there. 

https://www.nacha.org/content/iso-20022

 

More Details

SEPA only supports EURO currency. 

ISO is more versatile.  Get away from MT940 and BAI if you can. They are really getting outdated. 

Be careful to test how your FX rate works if your bank account is one currency and you are paying in a different currency.  

Test your addresses.  Sometimes it’s better to leave address details out of the file if your supplier masters are not well formatted. (Of course, leave it off only if optional.)

Find a good tool to compare your XML with the sample bank XML file you have.  If you find one you like, let me know!

 

Good luck!

Reach out if there’s anything else you need help with.  

 

 

Terms & ConditionsCookie settingsAccessibility statement