You cannot create an Automation object on Microsoft Dynamics NAV Server. You must create it on a client computer.

—————————
Microsoft Dynamics NAV Development Environment
—————————
You cannot create an Automation object “AutomationVariable” on Microsoft Dynamics NAV Server. You must create it on a client computer.

—————————
OK
—————————

You cannot create an Automation object {AutomationVariable} on Microsoft Dynamics NAV Server. You must create it on a client computer

Solution:
Replace

CREATE(AutomationVariable)

with

CREATE(AutomationVariable,FALSE,TRUE)

Did my solution solve your problem? Leave a reply.

Streams cannot be used with client-side invoked automation objects

Microsoft Dynamics NAV
—————————

Streams cannot be used with client-side invoked automation objects.
—————————
OK
—————————

Streams cannot be used with client-side invoked automation objects

Solution:
Use DotNET DataTypes instead of Automation.

For example:
An Automation Subtype ‘Microsoft XML, v6.0′.DOMDocument can be changed with
a DotNet Subtype System.Xml.XmlDocument

Did my solution solve your problem? Leave a reply.

HOW TO configure SMTP Mail Setup using HOTMAIL

Sometimes for testing purpose could be useful configure the SMTP Server in NAV using your HOTMAIL/LIVE account

HOW TO configure SMTP Mail Setup using HOTMAIL?

HOW TO configure SMTP Mail Setup using HOTMAIL

SMTP Server: smtp.live.com
SMTP Server Port: 25
Authentication: Basic
User ID: your full Hotmail/Live address (e.g. example@hotmail.com or example@live.com)
Password: your Hotmail/Live password
Secure Connection: Yes

Related posts:
HOW TO configure SMTP Mail Setup using GMAIL

Did my HOW TO help you? Leave a reply.

HOW TO configure SMTP Mail Setup using GMAIL

Sometimes for testing purpose could be useful configure the SMTP Server in NAV using your GMAIL account

HOW TO configure SMTP Mail Setup using GMAIL?

HOW TO configure SMTP Mail Setup using GMAIL

SMTP Server: smtp.gmail.com
SMTP Server Port: 587
Authentication: Basic
User ID: your full Gmail address (e.g. example@gmail.com)
Password: your Gmail password
Secure Connection: Yes

Related posts:
HOW TO configure SMTP Mail Setup using HOTMAIL

Did my HOW TO help you? Leave a reply.

HOW TO Copy from Excel and Paste as Picture without gridlines

The title of this post contains exactly the words I used to search on Google.
Why for this simple task I’m writing a post?
Because in this case, as happens often, the task is easy but we should know the logic behind the software and functionalities we want use.
To clarify the concept: we want

"Paste as Picture hiding gridlines"

rather then

"Copy as Picture without gridlines"

HOW TO Copy from Excel and Paste as Picture without gridlines?

The correct tile of the this post should be

HOW TO Copy as Picture without gridlines from Excel

Click Copy -> Copy as Picture…

Copy as Picture

Under Appearance section, select “As shown when printed“, then click OK

Copy Picture As shown when printed

When you’ll paste it, for example in a Word document, the image will be without gridlines.

Did my HOW TO help you? Leave a reply.

“Documents.library-ms” is no longer working

“Documents.library-ms” is no longer working.

Documents.library-ms is no longer working.

Solution 1:

  1. go to Libraries in Windows Explorer
  2. right-click whichever folder gives you an error and select Delete
  3. right-click on the Libraries folder and select Restore Default Libraries

Solution 2:
Restore your system using a previous restore point.

Did my solution solve your problem? Leave a reply.

HOW TO choose columns to show in Drop Down window in NAV

In the installation of NAV using RoleTailored Client (RTC) when you set the TableRelation field’s property in the definition of a table, automatically, in the Pages that will display this field, will show a DropDownList control.

If the user click the drop-down button it will display a windows a list of fields with the primary key columns plus a text field only if his name will be Name or Description (both case-sensitive).

An example of the Drop Down window is available opening Vendor Card for the field Payment Terms Code as in the following image:
Drop Down window in NAV

HOW TO choose columns to show in Drop Down window in NAV?

Design the table using Microsoft Dynamics NAV Development Environment then click on the menu View -> Field Groups and create a line with Name DropDown (case-sensitive) and in the Group insert the list ordered of the columns that you want display in the window linked with the DropDownList control.

Note: it’s not important the ID number, to work the system require the name will be exactly DropDown (case-sensitive), you cannot create more than one line with the same Name.

An example of the property is available in the table 3 Payment Terms as in the following image:
HOW TO choose columns to show in Drop Down window in NAV

Did my HOW TO help you? Leave a reply.

It Could Happen To You

%d bloggers like this: