Multiple G/L Accounts — One check in Dynamics NAV.
This post explains a specific problem we faced last week. The client we work with, only prints one check for multiple payments. This is a bit tricky since we use NAV 2016 W1, it simply does not allow. We tried to do code changes in codeunit 367, CheckManagement, but we ended up getting G/L Entry Table INCONSISTENT error consistently.
After some research on the internet, we knew that this kind of transactions is nothing usual in Italian localization. We opted not to try comparing W1 with Italian, so we decided to sit with functional consultants to make a viable workaround.
The solution is to create a Temporary account, debit the Temporary account, credit the relevant bank account. Also, create an adjusting credit entry for the Temporary Account using General Journals, and in the same Journals create the debit entries for the relevant G/L entries.
Check the visual representation.
The entries in Blue will produce a zero impact on the final posting. The Bank entry which is in green will be credited and the other accounts in purple will be debited.The purple entries are called as Distribution Detail Entries and “Original Document No.” reference will be passed in for every journal line.
Let’s focus on technical work now.
We called General Journals as Distribution Detail Entries and this is the checklist we followed when it comes to handling the solution in technical terms.
* Create Distribution Detail Page Action on Payment Journals Page.
* Tweak the check print to accommodate the changes in Check Ledger Entry.
* Posting the Distribution Detail Entries along with the Payment Journals.
* Void check and reprint check, before posting.
* Manual check printing.
* Void check ledger entry after posting, reverse the entries.
* Open the Distribution Detail Entries from the General Ledger Entries after posting.
* Modify Payment Voucher Reports.
I will write up specific scenarios I faced while developing, probably next week.
