Jun 29

Just a quick post here serving as shortcut for implementing Microsoft Navision Mail.SmtpMessage in older databases. All it requires is these objects:

Tagged with:
Jun 18

ERP software knows math, or do they? Dynamics NAV can do simple arithmetic in a decimal field, eg. type “14*50+10” and the system will evaluate this to the correct result “710”. But if you start nesting your expression with parenthesis it gets a bit confused and tells you “Please specify a decimal or calculation expression”. In certain scenarios, you will require complex setups for eg. item pricing or salesperson commissions, that is defined by a formula with certain constants in it (read: other field values).

Continue reading »

Tagged with:
Jun 11

I got a Google Alert today with some interesting news from MSDN. They are doing “How do I?” videos. They are meant to show you step-by-step instructions for Microsoft Products and Technologies.

You can also subscribe to their RSS feed here:  Dynamics NAV How do I?

Continue reading »

Tagged with:
Jun 10

Over the years of working with NAV, users have always asked for ways to store their frequently used filters for reports and forms – eg. month end reports (A/R, A/P, Trial Balances), that often needs to be reported in multiple views.
Most often the users have come up with a system of storing the filterstrings in Notes in eg. Microsoft Outlook or similar. This is not a productive way, and leaves a lot of options for errors when copying the wrong filter, especially when filtering on multiple fields.

Continue reading »

Tagged with:
Jun 01

I was quoting an upgrade proposal for a client that had a lot of custom reports. Trying to identify which ones were actively being used today, the client did not have a definitive answer. So we needed an strategy to identify the reports that was being used. And at the same time we would like to know who used them, and how often – that way we could make a more qualified decision about the reports to upgrade.

Of course every report could be modified so it wrote to a report usage table (but that would require you to modify every report in the system). Fortunately there is an easier way to handle this. In codeunit 1 Application Management, the function FindPrinter():

Continue reading »

Tagged with:
preload preload preload
pornpants.com pornofri.com kilporn.com