Dec 09

Every time you copy/paste data from NAV to Excel, you always run into the “intelligent” way Excel handles data. Excel’s default number format is “General”. Unfortunately this has some drawbacks, especially when you paste in data from another application.

Lets do this example, enter in a new cell with Number Format General, the value “001010”, and you will see Excel stores this as 1010, since it determined your value to be a Number. Of course we wanted it to be the equivalent of a NAV Code field, and expected Excel to keep it like “001010”. In order to do this you can for the field tell it is text by adding a ‘ in front. So far so good….

But when doing a copy/paste you dont have that option, so what to do?

Continue reading »

Tagged with:
Dec 03

While most children are watching the days to christmas, most NAV people are looking forward to December 15th, when the R2 release of Dynamics NAV 2009 is going to be released.

A quick blog scan will give you loads of information about the new features, the hype and what not. But Microsoft also released these hot topic videos covering some of the new features. For some reason i had not seen them until today where they caught my eye on the frontpage of MIBUSO. Thought i would share them with you as a little advent calendar present.

The topics covered are:

.NET Interop, Online Payments Service, What’s new for developers and a general overview.

Continue reading »

Tagged with:
Dec 02

As “Dinosaur”-tech as it might seem these days with most blogs posting about RTC, dataports is still one of the easiest ways to import data into NAVision. Having to search my old databases for a quick way to handle headers in datafiles, i thought i would share this with you. Hopefully Google will answer you with this post next time you have to do it :).

If you appreciate these beginners tips, let me know and i will dig into my archives before everyone leaves on the Dynamics Ark….

This small piece of code will handle writing headers when exporting, and also skip the first datarow when importing.

Continue reading »

Tagged with:
preload preload preload