When the new “Refresh a dataset” action for Power Automate (formerly Flow) was released last year I couldn’t help thinking there must be something really cool you could do with it – I just didn’t know what.
Dynamics NAV provides a very time efficient tool to generate financial reports on the fly. The functionality is called: “Account Schedules”. A very NAV specific term (so I understand if you don’t know what it is).
I can tell you this, it takes about 30 seconds to generate a P&L and a Balance Sheet via Account Schedules and maybe a few more minutes if you want to format the columns to make it look nicer.
In Microsoft Dynamics NAV, the Column Layout screen allows you to determine how you want to see the columns on your account schedules. You may define columns that are visible on the financial reports or columns that are strictly used for calculations. This blog will illustrate how to create custom layouts for account schedules in Dynamics NAV.
If you have a relative large number of items to plan it could take a while to run the MRP calculations in Microsoft Dynamics NAV, an hour to do a full calculation is not uncommon, especially if you have been using the system for a while. In order to not have the MRP calculations to interrupt with the daily operations (such as posting orders) you typically want the calculations to take place during the night.
SQL Server Express editions do not offer a way to schedule either jobs or maintenance plans because the SQL Server Agent component is not included in these editions. Therefore, you have to take a different approach to back up your databases when you use these editions.
Currently SQL Server Express users can back up their databases by using one of the following methods: