dynamicsblog.wordpress.com

noisyvan.wordpress.com

Make Exporting Excel Formulas Fully Multilanguage Aware | Noisy Van

https://noisyvan.wordpress.com/2008/10/09/make-exporting-excel-formulas-fully-multilanguage-aware

Make Exporting Excel Formulas Fully Multilanguage Aware. October 9, 2008 at 4:18 pm. I have been struggling with exporting data from Dynamics NAV to Excel Spreadsheets including formulas lately. I had the problem with a custom developed export to excel so I checked the code in the Excel Buffer table to see how standard Navision solved the problem only to see that the problem also existed in standard NAV too. English NAV Client and Spanish Office, wrong formula. Standard Dynamics NAV uses multilanguage te...

noisyvan.wordpress.com

Storing Password in SSIS Packages | Noisy Van

https://noisyvan.wordpress.com/2008/07/01/storing-password-in-ssis-packages

Storing Password in SSIS Packages. July 1, 2008 at 8:26 pm. Recently I had to make an SSIS package where data was loaded from an external database (Oracle in my case) to a SQL Server 2005 database. All went well except one thing. How to save the Oracle and SQL 2005 connection credentials encrypted in the package? I wanted to store the credentials in a way that a user with rights to execute the package, could do this without seeing the credentials of the databases the package connects to. I tried all kind.

noisyvan.wordpress.com

Perfect source for Postal Codes Info and Downloads | Noisy Van

https://noisyvan.wordpress.com/2008/10/16/perfect-source-for-postal-codes-info-and-downloads

Perfect source for Postal Codes Info and Downloads. October 16, 2008 at 9:46 am. Not all localized versions of Dynamics NAV contain the list of postal codes and often you want to add postal codes of different countries to one database of company. I searched more than once for good lists or import files but they are hard to find and almost never free. Until I found the following site which has daily dumps of postal codes for most countries and for free on top of that. The Data is provided “as is&#82...

noisyvan.wordpress.com

Show Shipment Information on Sales Invoices | Noisy Van

https://noisyvan.wordpress.com/2008/10/08/show-shipment-information-on-sales-invoices

Show Shipment Information on Sales Invoices. October 8, 2008 at 7:08 am. When using combined shipments or when using the “Get Shipment Lines…” function on the invoice form, a line with shipment information is shown for all shipments linked to the invoice lines. Sales Invoice with shipment information. With the following adjustment to codeunit 80, the extra line is also added when you post “Ship and Invoice” an order. Codeunit 80 – Sales-Post. Entry filed under: Dynamics NAV. Leave a Reply Cancel reply.

noisyvan.wordpress.com

Conventions, Or Should I Say Conversions | Noisy Van

https://noisyvan.wordpress.com/2008/10/20/conventions-or-should-i-say-conversions

Conventions, Or Should I Say Conversions. October 20, 2008 at 7:39 am. Often you have to convert objects from one type to another e.g. from Integer to Text, from Boolean to Text, etc. Up to version 4.0 there was a codeunit, Codeunit 6201 – Conventions. So have a look at the code or download the attached codeunit Conventions of which I never understood where the name came from. CodeToText(VarCode : Code[250];MaxLength : Integer) : Text[250]. IF Setup.RECORDLEVELLOCKING THEN. EXIT(FORMAT(VarOption,0,2) ;.

noisyvan.wordpress.com

Too Many Invoice Copies | Noisy Van

https://noisyvan.wordpress.com/2008/06/30/too-many-invoice-copies

Too Many Invoice Copies. June 30, 2008 at 9:47 pm. Ever had the “Too many copies are printed! Your customer wants to prints an invoice copy when posting invoices. So you set the. Field on the Invocing tab of the Customer Card to 1. Problem is, now the program will always print an invoice copy even when you manually reprint a posted invoice. Even though the option tab of the report shows. 0 , a copy will be printed. If you change the. To 1, the system prints 2 copies, it doesn’t make sense! Is only run wh...

noisyvan.wordpress.com

Avoid “not a valid time unit” Errors with Multilanguage Calcdates | Noisy Van

https://noisyvan.wordpress.com/2008/10/05/avoid-not-a-valid-time-unit-errors-with-multilanguage-calcdates

Avoid “not a valid time unit” Errors with Multilanguage Calcdates. October 5, 2008 at 1:14 pm. I had some problems with a German report giving errors when I tried to run it. The people that programmed it put not only the comments in German, but also all calcdates. As all calcdates where entered in German when I ran the report in an English client, I got an error that ‘-1T’ was not a valid time unit. This is because in English you need to write D for day not T for Tage. Entry filed under: Dynamics NAV.

gaspodethewonderdog.blogspot.com

Gaspode's Brain Dump: December 2008

http://gaspodethewonderdog.blogspot.com/2008_12_01_archive.html

Some useful stuff on Dynamics NAV and some useless junk. Monday, 29 December 2008. NAV 2009 Book - more details on PACKT site. If you are interested in our book Implementing Microsoft Dynamics NAV 2009, you can find a couple of things of interest on the PACKT web site. First of all, there is the table of contents. Then there is an article based upon some of the examples in Chapter 7 called Extending the Application using Microsoft Dynamics NAV 2009. Links to this post. Wednesday, 24 December 2008. Vjeko ...