Skip to main content

Posts

Note’s in Navision 2009 RTC

Hi all, While trying to figure out new features in Navision 2009 RTC I figured out a new feature called Notes/Links. In Navision 2009 RTC, you will find a system part called as Notes. Let’s see how we can use this. Below is the image which shows a list of Sales order in Role Tailored Client and you can see a note window in the right hand side. As soon as user opens an existing order or creates a new order, he/she can put his comments about the same and notify the user whose windows login is synchronized in the database. As I opened a sales order, I can see a link for creating a new note in the right hand panel (Fact Box). As soon as user clicks on the link to create a new note, he get a window opened which ask for certain information. 1) Your message/ comments. 2) User Id whose you want to send the notification. 3) A Boolean for Notify. User select one of the user from the list and click on the notify Boolean and then save the note. When t

Show only Date not Date and Time in RTC Reports?

Hi all, Most of the time client requires only date to be printed in the report, say for the shipment date. But when we create the report in RTC and set the dataset field for the shipment date we get data and time. The date in RTC Report shows date and time and that is the standard format. If you want to show only date then we need to use the Format Property. Example Then in Page body click on the expression of the text box which says  “=SalesLine_ShipmentDate” and convert it to =FORMAT(SalesLine_ShipmentDate,"Short Date"). This will only show date. Regards, Saurav Dhyani www.sauravdhyani.com

How to Start Navision Application Server?

Hi all, We always face issues while using NAS. Lets discuss how we can install, configure and use Navision Application Server (NAS). Go to Server Folder in the installation disk of the Navison version for which you want to start the Navision Application server. Install the server on the disk. This will create a service, go to services.msc to change the startup parameter of the service and use an administrative account to start the service.

RTC Report Development 3.

Hi all, If you haven't read part1 and part2 then click here for Part1 and Part2. Now lets see what can be done to create Page Header without any issues. Lets check what Microsoft do to create Page Header for the same report. Here is what it see the Layout of standard Report.

ERROR The trasaction log for database is full.

Hi all, Sometime we face an error in SQL Server while performing transaction in Navision. ERROR - (Error 9002) The following SQL Server Error or errors occured when accessing the "Table Name" table: 9002,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server] The trasaction log for  database 'Database name' is full. To find out why space in the log cannot be reused, see the log_reuse_Wait_desc column in sys.database. SQL: Update "database name"."dbo"."Table Name" with (RepeatTableRead) set something where  query. Reason For Error- The error is due to space avilability in the disk where Log file reside. Resoultion - There are multiple options for the resoultion of the same, choose one that best suite you- 1) Backing up the Log. 2) Freeing Disk Space. 3) Moving the Log File to a Different Disk 4) Increasing the size of a log file. 5) Adding a log file on a different disk. 6) Completing or killing a long-