Share |

Tuesday, October 30, 2007

Change Caption in execution time

Thanks to nilsm for post in the Tips dBits forum.

Exist a way to change the value of the Caption property in a dynamic way, even for different languages. The trick is to use the control's property CaptionClass control customize the functionality CaptionClassTranslate in CodeUnit 1.

You have a document with detailed explanation in Tips dBits.

Error traceflag 4616 at start NAV in SQL 2005

Thanks to nilsm for post in the Tips dBits forum.

To try execute Dynamics NAV (Navision) in SQL 2005 show the next error:
"The indicator 4616 is not established on the server. This indicator must establish and restart the server before connecting using Microsoft Dynamics NAV."

To correct this situation, proceed as follows:
01.) Open the Start Menu
02.) Go to Microsoft SQL Server 2005 Group
03.) Go to Configuration Tools Group
04.) Click on SQL Server Configuration Manager
05.) Click on SQL Server 2005 Services
06.) Right-click on SQL Server ($INSTANCENAME) and click on Properties
07.) Click on the Advanced tab
08.) Go to Startup Parameters
09.) Enter the string so that it looks as follows (notice the end is the only change):
-dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf;-T 4616
10.) Click OK
11.) Restart the SQL Server service

Wednesday, June 13, 2007

Correction entries

A field denominated “Correction” exists in journals that can be used to correct, not only the balance of an account, but also the sum of "Debit" and "Credit", since it inserts a entry with a charge or debit (according to it comes) in negative. That is, if it is desired to correct an erroneous movement that it has written 500€ in Debit of an account, by means of this option we will be able to write a movement of correction of -500€ in Debit of the same account, instead of 500€ to the Credit.

This field also exists in the sale and purchase heads, to be able to use it when registering credit memos that in fact are corrections of erroneous invoices.