Recurring Journals Tip – Microsoft Dynamics Nav Tip

In Recurring Journals if you have a line set up where there is no value to post this month and you attempt to post you will receive the following error:

Amount must not be 0 in Gen. Journal Line Journal Template Name = ‘RECURRING’, Journal Batch Name = (name of your journal batch), Line No = (Line No. where you have the zero amount)

To get round this you do not need to delete the line you can filter out the zero line as follows:

Under the Amount column apply a Field Filter (F7), enter a filter saying not equal to Zero <>0 then OK

This will allow you to post the journal, when posted the Posting Date of the line that was zero (that was filtered out) will not have moved onto the next month.  Just amend this manually.

Leave a Reply