August 2015 – Pardaan.com

Adjust Item Costs/Prices… batch job

Just purchase one material on different rates with different vendors and consume it in manufacturing or do the negative adjustment and then run the batch job to see the effect. The batch job is in the inventory section of Finance Module. Bron : Ashwini Tripathi Lees…

31 August 2015

Dynamics NAV & BC Tips & tricks

Creating users with Powershell

We all had our fair share of database we were locked out of, because a user added himself and no other users to a database. In that case, we have 3 options to gain access to the database. One of the possibilities I’ll describe is using…

31 August 2015

Dynamics NAV & BC Tips & tricks

Client Add-in can fail with communication error (HTTP 413) in the Microsoft Dynamics NAV 2015 Web Client

Based on a very interesting development request about a drag-and-drop Client Add-In targeted for both Windows and Web clients for Dynamics NAV, we have been able to identify a communication error with Microsoft Dynamics NAV 2015 when users select and upload multiple files using a client…

31 August 2015

Dynamics NAV & BC Tips & tricks

Database function

EXPORTDATA Function (Database) Exports data from the Microsoft Dynamics NAV database to a file. The data is not deleted from the database. Syntax [Ok:=] EXPORTDATA(ShowDialog, FileName[, IncludeApplicationData][, IncludeGlobalData][, CompanyRecord]) Parameters ShowDialog Type: Boolean Specifies if you want to display a dialog box where the user can…

31 August 2015

Dynamics NAV & BC Tips & tricks

Viewing Page Data in Excel Using PowerPivot (OData)

Here I will discuss how you can use OData to expose a Microsoft Dynamics NAV 2015 page as a web service and then analyse the page data using Microsoft PowerPivot for Excel 2013. With OData and PowerPivot, you gain access to a powerful set of tools…

28 August 2015

Dynamics NAV & BC Tips & tricks

How Do I: Upload Refreshable Data to PowerBI.com?

This video demonstrates how to upload refreshable data to PowerBi.com from Microsoft Dynamics NAV 2015. Bron : Think about IT Lees meer...

28 August 2015

Dynamics NAV & BC Tips & tricks

TextEncoding Property (XMLports)

Specifies the text encoding format to use when you use an XMLport to export or import data as text. Note The TextEncoding property is only available when the Format Property (XMLports) of the XMLport is set to Fixed Text or Variable Text Bron : Ashwini Tripathi…

27 August 2015