Let’s clean up NAV #12 – Next Counting Period

My good friend Luc van Vugt started a little miniseries on his blog with things we can do to clean up NAV. What a great idea, so here is something I have noticed.

In NAV 2015 the Next Counting Period was replaced by 2 date fields after I reported it. The field was used to store the date filter for the next counting period, but if you used counting cycles and had users with different date setting in their regional settings you quickly got quite the mess to figure out. You should of course never store Date filters in text fields unless they are used with in the same transaction ensuring that the user have not changed regional settings in the meantime.

After this was done the Field “Next Counting Period” Text(250) which exist in Table 7380 Field 8, Table 5700 Field 7382 & Table 27 Field 7382 was never removed in 2015. It is not used in the code or in the UI to my knowledge, so maybe it is time to clear it up and get rid of it permanently.

Should there be a need to display the date filter we can always display it based on the 2 new date fields by calculating it on the fly which would ensure it is consistent with the uses current regional settings.

It is a low impact issue as the field has no use today and it is easy to fix not to mention it reduces record length of a tables considerable.

One thought on “Let’s clean up NAV #12 – Next Counting Period

  1. Pingback: Next Counting Period Removed | Thinking NAV – Thinking Differently

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s