Did you know it is possible to create standard format messages when using electronic banking in Microsoft Dynamics-NAV?

The EB Payment Journal is used to export the payments to file, which can be used to import into Isabel. The suggested Payment Message contains the Vendor Invoice No or External Document No. However, at this point the EB Payment Journal only contains Payment Suggestions, which means this Payment Message can still be modified.

In case of domestic payments you can use the Payment Message field to create standard format messages. You can simply type the standard format message; with or without +++ and /. When the entered number passes the MOD97 test, Microsoft Dynamics-Nav will convert this message into a Standard Format Message. (CTRL+F8: Standard Format Message = Yes)

How are the Payment Journal Lines exported to file?

Under normal circumstances all Payment Journal Lines for one vendor are put together into one payment transaction.

However, following circumstances will result into more payment transactions:

• the Payment Journal Line contains a Standard Format Message; per standard format message a new payment transaction will be created (CTRL+F8: Standard Format Message = Yes; Separate Line = Yes)
• the Payment Journal Line contains a partial payment; per partial payment a new payment transaction will be created (CTRL+F8: Partial Payment = Yes; Separate Line = Yes)
• Electronic Banking Setup: Cut off Payment Message Texts is not activated; Normally all Payment Messages of all Payment Journal Lines from one vendor are put together into one payment message for the payment transaction. However this can only contain a certain amount of characters (106 for domestic payments, 140 for international payments). Two or more payment transactions will then be created to make sure all payment messages are taken into account.