Microsoft Dynamics NAV - Navision - Payment Journals Line

Dynamics NAV (Navision) – export vendor payments to the bank

Dynamics NAV (Navision) – export vendor payments to the bank

Microsoft Dynamics NAV (Navision) provides for the companies functionalities which allow an optimum management of financial flows. One of them makes possible to create automatic payments of the vendors, payments which can be transmitted electronically to the company’s bank.

For this purpose, it is used a special journal named “Payment Journal”. It can be accessed in  Dynamics NAV using the following path: Departments->Financial Management->Cash Management->Payment Journals

Microsoft Dynamics NAV - Navision -Payment Journals

At first sight, payment journal looks as any other general ledger journal in Dynamics NAV (Navision). The difference is made by a special function, named ”Suggest Vendor Payments”. This function opens a window (see picture bellow) which allows us to fill in journal lines with payments we want to made for vendors:

Microsoft Dynamics NAV - Navision - Suggest Vendor Payments

First, in this window we establish the due date for vendor payments. Also, we can have an amount available for payments, and the application will generate payments  until the amount available is fulfilled. We have an option to select vendors according to a priority rank – the priority may be settled on the vendor’s card.

In the same window, we can choose if a payment line will be generated for each vendors’ invoice, or one line for all the invoices of the vendor, and we can setup our bank account the payments will be made from. After all options are  selected and the “Ok” button is pushed, payment lines will be created.

Microsoft Dynamics NAV - Navision - Payment Journals Line

Payment lines contain all the necessary information to be transmitted to the bank. The file for the bank will be generated by clicking on the button “Export Payments to File”.

Microsoft Dynamics NAV - Navision - Export Payment File

Next, the file is sent to the bank. When bank statements arrive, an additional check is made and then payment journal lines are posted, as any general ledger journal line

Payments export is traceable in the system. When each payment export file is generated, payment journal lines are marked as exported and a register is created, and when a new payment file is exported, the lines already export may be omitte  in order to avoid doubled payments. Yet, if necessary, lines can be re-exported.

Microsoft Dynamics NAV - Navision - Credit Transfer Registers

 

Some mentions to be made: what we have presented till now is a standard Dynamics NAV functionality. To implement it for your company, some customization is needed, because each bank has its own  payment file format to import.

Moreover, the payment export will not work unless the information into the system is correct and complete. For example, each vendor must have the proper setup of its bank account where the payment will be made. The functionality has checks regarding payment file generation, as the sent file to be without missing information or errors.

Kepler Management Systems has already implemented for his customers this functionality. If you are interested, please contact us.

If you want to read future articles and also be in touch with other many functionalities of Dynamics NAV (Navision), you can subscribe to the newsletter (in Romanian only!) provided monthly by Kepler Management Systems – see the link bellow!

Link Abonare Newsletter

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply