There are a few calculation methods available in for a flowfield. This is a great feature in NAV to aggregate amounts from ledger entries. I would like Microsoft to add an option to the flowfield declaration. I would like to be able to omit zeros when using methods; Average, Exist, Count, Max and Min. In a normal SQL it is possible to use NULL to archive this result but not in NAV.
When you add new Actions to a Page’s Action Pane, you have probably noticed that the default image associated with the Action is a grey circle. You probably already know HOW to associate an image with an Action (in case you didn’t: In Page Design, go to Actions, then look up that particular Action’s properties, and see the “Image” property), but are left wondering what possible values you could enter in the Image field.
In this demonstration, you’ll see how the warehouse shipment and pick processing features of Microsoft Dynamics NAV 2009 can be used to process a completed sales order.
Recently i ran into problems for pages using Temporary records.
Because i found them to be rather important, i thought to share them with you….
Did anyone ever have that situation where you need to test a mailing function, but you just don’t have an SMTP server or just too many records in the test environment to check so you wouldn’t accidentally send to a real customer/vendor/contact?
Even though this isn’t specifically pertinent to NAV, we all need to write code and queries in SQL from time to time. This little snippet of code may come in handy the next time you need to find the number of working days (i.e. excluding weekends) between two dates.
This post is merely to inform people to watch out about using CurrFieldNo. I was looking into some issues with the Job Journal Line not calculating if inventory was available when i found the problem was related to the CurrFieldNo…
Vertalen
