Cash Flow forecast in Dynamics NAV

Microsoft Dynamics NAV gives you the advantage to know your institution's financial solvency even at some future time. Such intelligence will give you the power to make informed decisions to keep your business moving on the right track. To learn more on cash flow features of Dynamics NAV please click here

Displaying report columns only when a user chooses to view them

Hello, are you trying to create a report where a user can choose to view certain columns but things ain't working as you expect? Don't worry you are safe. Here is what you need to do.

• First create a global variable of type boolean to control when the column will appear on the report
• Add the variable to the report request page. This enables the user to check and uncheck thus choosing whether to display column or not.
• Add the variable to the report dataset so it is accessible in report layout in Visual Studio or Report Builder.
• Select a column whose visibility you want to change based on user selection. Right click the column and select "Column Visibility". 
• Change visibility based on an expression. for example =iif((Fields!ShowBilltoNo.Value=True),False,True). That expression will only display "Bill to No" column on the report when the user ticks the "showBilltoNo" field on the report request page. It's that simple, now do it and punch the air when stuff works. Good day

Dynamics NAV 2009 Classic client error "The extended stored procedure xp_ndo_enumusersids in the library file xp_ndo.dll, is not available on the server"

Do you get this error every time you try logging in via windows authentication on Dynamics NAV classic client? The reason is xp_ndo.dll is required for a successful login.
However you should not be affected by the error using database authentication.
If you need to use windows authentication, you will have to add the above library. click here for a walk through on how to add the library


Was this blog useful ? Please leave a comment

Dynamics NAV classic client Login error "The trace flag 4616 is not set on the server (local)"

Hello, you might facing the above error trying to login to Dynamics NAV classic client 2009.
That error pops up when logging in.
To stop the error you are required to set the trace flag in sql.
If you don't know how to set the trace flag click here for a walk through
Good day.

Was this blog useful? please leave a comment

Error Attaching SQL Dynamics NAV database

Hello, you might be frustrated by the above error. Relax you are safe now.
That error is often times caused by insufficient permissions to read the database files.
All you have to do is make sure you provide appropriate permissions to the mdf and ldf files.
If you don't know how to go about it, click here and here for details.
Hope this was helpful ?

Table Locking in Dynamics NAV

Hello, there could be a time where u may have to perform customization across a number of tables.
There could be processes that may require to access certain records following a specific order.
Its important for you to do your design well to avoid any possibility of a deadLock.
Often times you will need to LOCK certain tables to ensure smooth execution.  visit here for more details

Direct Posting in Dynamics NAV

Hello there, you could save yourself from the trouble and headache from imbalances between sub-ledgers and the General Ledger. A number of times this issue stems from enabling DIRECT POSTING on G/L accounts.
To avoid this trouble, disable DIRECT POSTING and make sure you make the field un-editable to system users.

Enjoy working with NAV