Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Set up a Parse rule for Reconciliation Referenece

edited Aug 24, 2021 11:49AM in Payables, Payments & Cash Management 1 comment

Summary

How to Set up a Parse rule for Reconciliation Referenece MT940

Content

Hi

Could anyone help me with a parse rule to populate the reconciliation reference field in Cash Management staement lines for an MT940 file?

Example of the data source is :

:61: 310720xxxxxxxx,NMSCGBS BACS G3 JOURNA

:86: GBS BACS G3 JOURNA

I added parse rule:

Transaction Code = NMSC

Source Field = Customer Reference

Target Field = Reconciliation Reference

Rule = (X~)

However this did not populate the Reconciliation Reference when importing the file to cash management.

Thanks

Sarah

 

Version

21B (11.13.21.04.0)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!