RSS

Category Archives: Okategoriserade

Dynamics NAV Reports (RDLC): SetData, GetData And Line Numbers

In Dynamics NAV reports we use SetData and GetData functions to retrieve data certain data in page headers and footers due to different scopes. In this blog post I’m not going to explain why and how but I’m going to give links to some good posts that does it at the bottom this post. Instead I’m going to give you a tip on how to make the process of adding/finding which data that has a certain index in the SetData function call by using line numbers.

Read the rest of this entry »

 
1 Comment

Posted by on 2015-10-11 in Okategoriserade

 

Tags: , , , , ,

Dynamics NAV 2009 R2: DotNet System.String

If you are having the need to use DotNet in an older client such as Dynamics NAV 2009 R2 you will problably run into troubles which they have fixed for later versions of Dynamics NAV.  I had the problem that I tried to downgrade code using the DotNet type System.String. I didn’t get very far until the compiler started to complain…

Read the rest of this entry »

 
Leave a comment

Posted by on 2015-09-21 in Okategoriserade

 

Tags: , , , ,

Dynamics NAV: How To Run Tables From RTC (Role Tailored Client)

In the classic version we could run tables straight from the object designer and the object designer was always included in the client. In the Role Tailored Client (RTC) however we don’t have an object designer. Instead it is located in the developement environment. But sometimes you need to run a table but you don’t have access to the development environment (end user computer, ClickOnce and so on..).

So what to do then?

Read the rest of this entry »

 
Leave a comment

Posted by on 2015-08-29 in Okategoriserade

 

Tags: , ,

Dynamics NAV: How To Run Objects From RTC (Role Tailored Client)

In the pre RTC versions of Dynamics NAV it was really simple to run/view objects from the client. Nowadays when we are using RTC it is not quite that simple since by standard we don’t have object designer in RTC (Role Tailored Client). At least yet 🙂

But there is a trick that you can use to achieve this. You need to create a page on the table object. After that add a button that runs the current record. Microsoft described this a couple of years ago in a blog post (How to start any object in Role Tailored Client)

But how about tables and querys?

Read the rest of this entry »

 
2 Comments

Posted by on 2015-08-29 in Okategoriserade

 

Tags: , , ,

Dynamics NAV: Field List

The last couple of years I have started to use an new trick to make my everyday life with Dynamics NAV easier.

Usually I have the problems like this:

  • How do I easy see all the locations of a certain field name in the database?
  • How can I quick look up a datatype for a certain field?
  • How can I quick see if a field is a flowfield?
  • How can I search on database fields using captions?

For me the solution became to make a page on the virtual table field (How to: Create a Page to View a Virtual Table).This is real handy when you have an addon table with 355 fields were the captions don’t really match the field names.

Read the rest of this entry »

 
Leave a comment

Posted by on 2015-08-29 in Okategoriserade

 

Tags: , ,

XMLPort: Import Into Temporary Table

Earlier today I wrote a blog post XMLPort: Export from temporary tables. The principle is the same when you want to import to a temporary table. Instead of calling a function in XMLPort before you call the export that inserts values into the temporary table you do the opposite, call a function after the import has completed that copies all the temporary data to your temporary record parameter.   Read the rest of this entry »

 
1 Comment

Posted by on 2015-08-08 in Okategoriserade

 

Tags: , , ,

XMLPort: Export from temporary tables

You can export data from tables to XML by using XMLPorts. But you can also use XMLPorts to export data from temporary tables.
The principle is to set the Temporary property on the table line and then create a function in XMLPort that inserts all the data into the temporary record.

Read the rest of this entry »

 
1 Comment

Posted by on 2015-08-08 in Okategoriserade

 

Tags: , ,

 
Dynamics 365 Business Central for Partners

Reflections from the ERP field

Freddys blog

Learn something new... - then Teach someone!

Stefano Demiliani Technical Blog

Reflections from the ERP field

David Worthington's NAV Performance Blog

Micosoft Dynamics NAV Performance Testing & Optimization

Freddys Blog

Reflections from the ERP field

Mark Brummel Blog | Microsoft Dynamics NAV

Master Classes Design Patterns and more...

Vjeko.com

ideas in the cloud

Goprowe AB

Reflections from the ERP field

ArcherPoint Developer Blog

Reflections from the ERP field

The NAV Viking´s Blog

- Sharing my experience in the Dynamics NAV world

Comments for waldo's blog

Reflections from the ERP field

Nav Can Be Fun

Its Really Fun to Work with Microsoft Dynamics Nav / D365 Business Central

Navision-Girl.Com

Reflections from the ERP field

Kine's Info

Reflections from the ERP field

blog.wibeck.org/

Just another WordPress.com site

NAV/SQL Performance - My Two Cents

Reflections from the ERP field

Hougaard.com – Applied Hacking

Reflections from the ERP field

Kauffmann @ Dynamics 365 Business Central

Reflections from the ERP field