Extend CU 6224: Read xml node values and attributes

Xml documents can be created/processed via XmlPorts. An other opportunity is the usage of Codeunit 6224. It’s used for complex xml handling. This CU only delivers some create and find functions, but no read/get functions. Following functions extend CU 6224 with read functions. First a sample for the usage of the new functions. This sample… Continue reading Extend CU 6224: Read xml node values and attributes

Convert date string containing a month text value to a date value

Assuming you want to enter date values in the RTC client like 15-MAR-14. that won’t work. date values are only accepted with syntax like 15.03, 15.03.14, etc. But it can be that users prefer the above syntax. so then you can use a text field in your page and convert internally the value into a date… Continue reading Convert date string containing a month text value to a date value

You cannot create an Automation object ‘name of autom.’ on Microsoft Dynamics NAV Server. You must create it on a client computer.

This is an error message, when trying to create an instance of an automation on a nav server vs. >= 2013. It’s only possible to create the automation instance as client instance. Creating automation instances on nav server is allowed till nav 2009. solution: use create(<name_of_autom.>,false,true) instead of create(<name_of_autom.>). remarks: you need a installed version… Continue reading You cannot create an Automation object ‘name of autom.’ on Microsoft Dynamics NAV Server. You must create it on a client computer.

Numbers to Words

This code converts given numbers to words. For usage run (sample): InitTextVariables; numText := NumberToWords(1256,”); // numText | Text | 100 Message(numText); NumberToWords(number : Integer;appendScale : Text) : Text numString := ”; IF number < 100 THEN IF number < 20 THEN numString := OnesText[number] ELSE BEGIN numString := TensText[number DIV 10]; IF (number MOD… Continue reading Numbers to Words

Date Functions

Date functions are quite often used and needed. Here are some samples: Calculate the 1st of current month: EndDate := CALCDATE(‘-CM’); Calculate last day of current month: EndDate := CALCDATE(‘CM’); Calculate the end date of a defined period (e.g.3 months) starting with the 1st of the current month; get the last day of the end month: EndDate := CALCDATE(‘-CM+3M-1D’);… Continue reading Date Functions