January 2015 – Page 10

Decode Base64 BigText

With this code you can decode a BigText variable with a Base64 coded string (in this case a PDF document).... abpBigPDFText -> BigText abpAutConvertBase64 -> DotNet 'mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Convert abpAutBytes -> DotNet 'mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Array abpAutMemoryStream -> DotNet 'mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.IO.MemoryStream abpOutStream ->…

7 January 2015

Dynamics NAV & BC Tips & tricks

Rolling Up Standard Costs in Microsoft Dynamics NAV with the Standard Cost Worksheet

There are times when you may want to establish or reestablish Standard Cost for Items: • For all new items • When you find a significant mistake in the purchased item cost, the Production BOM, and/or the Routing and want to make a correction • When…

7 January 2015

Dynamics NAV & BC Tips & tricks

Passing JSON from JavaScript to C/AL

If you read my last postabout how to pass objects from C/AL to JavaScript, you must have wondered if it’s possible to also pass objects from JavaScript back to C/AL. Wonder no more. It is. And here’s how. Again, a bit of theory. JavaScript uses JSON…

7 January 2015

Dynamics NAV & BC Tips & tricks

Adding notes to G/L Journal Lines

One of the nice features introduced with the RTC client is GUI notes. These are tied to the page and do not work as is with worksheet lines like journals. Also, if you add a note, it stays behind and is not attached to the ledger…

6 January 2015

Dynamics NAV & BC Tips & tricks

Passing strongly typed data to a JavaScript control add-in

Many cool things often go undocumented. I’ve just stumbled upon one of those, and it comes in handy to close this year of blogging. Imagine this situation: you have a server-side .NET object, that you want to pass on to the client. With the .NET System.Windows.Forms-based…

6 January 2015

Dynamics NAV & BC Tips & tricks

Microsoft Dynamics NAV: Download with FTP using dotNET Interop

Having an extensive C# development background, as I had mentioned in a previous post, I was thrilled with the ability to access the .NET framework through the dotNET Interoperability introduced with the Microsoft Dynamics NAV Roletailored client. When interfacing data with other systems it is often…

6 January 2015