BMI Microsoft Dynamics NAV Blog

Microsoft Dynamics NAV / Navision "Out-Of-Balance" AP Check Error

Posted by Amy Valenzano on Jan 30, 2014 10:31:00 AM

I have come across a few different situations where a user has printed computer checks out of Navision where the check printed fine, but when the user goes to post the payment journal an “out of balance” message appears and the journal cannot be posted.  

Here is an example of a Payment Journal where the checks have been printed correctly and the Total Balance is zero.

Payment Journal view after checks have printed correctly.


When going to post this error message appears.

"Out of Balance" error posting Payment Journal
 

The reason for the error is because the data is not listed in order of Vendor No so
that when Navision goes through the posting process the balancing credit amount
line is not directly after the debit lines.  To resolve this error without voiding the checks and rearranging the data, you can simply re-sort the journal by changing the sort option from the
default “Journal Template Name,Journal Batch Name,Line No.” key to the “Journal Template Name,Journal Batch Name,Posting Date,Document No.”

Topics: Navision, Dynamics NAV, Microsoft, Microsoft Dynamics NAV 2013, Dynamics NAV 2013, Navision Training, Microsoft Dynamics NAV, NAV Training, Microsoft Dynamics Training