OLE or Automation Error: "F9043C85-F6F2-101A-A3C9-08002B2F49FB" not found

How to Resolve OLE or Automation Error

How many times do you got an error when we are trying to do a Data Migration here's the message below:

Could not create an instance of the OLE control or Automation server identified by 

GUID-{F9043C85-F6F2-101A-A3C9-08002B2F49FB}. 

Check that the OLE control or Automation server is correctly installed and registered.

What this message is trying to tell you is that something has not been installed correctly on this client

That something is a file which is not Register with the Client i.e. "comdlg32.ocx".

The error you have {F9043C85-F6F2-101A-A3C9-08002B2F49FB} refers to the GUID for 

Microsoft Common Dialog Control, v6.0. It is typically placed here in the below given folders : 

'C:\WINDOWS\System32\comdlg32.ocx' and C:\Windows\SysWOW64\comdlg32.ocx'


Solution :

Step 1 :- Download the OCX file from the given link below 

Download Comdlg32.ocx File from here

Step 2 :- Copy File to both Folders :-
               C:\Windows\System32
               C:\Windows\SysWOW64 

Step 3 :- Go to Start and type in CMD in the search space.
               [IMPORTANT] Right click CMD and click "Run as administrator".

Step 4 :- Copy and Paste the below given command on CMD & press Enter to Run it
               (the following depending on sysWOW 64 or System32).

First Command :
               regsvr32 c:\Windows\system32\comdlg32.ocx

After pressing Enter you will get below Confirmation Message.  
        



Now Second Command :
                regsvr32 c:\Windows\SysWOW64\comdlg32.ocx



After pressing Enter you will get below Confirmation Message.  




Hopefully Error will be Resolved after Registering above OCX file.

Note :- Usually you will also get an error if you try to compile Codeunit 412...

Hope it helps :-)

Save as Word and Excel Dynamics NAV 2016 Configurable

Yes you read the title correct, now you can disable,
1. Save as word
2. Save as Excel.

Both before print and after print from preview window.

This feature is available in Dynamics NAV administrator tool.

Yes a new Tab has been provided to allow or disallow this feature.

Now check the Report

 

 

 

Well that's it.

How to Calculate Week No. Month Wise from a Date NAV RDLC (Starting Weekday "SUNDAY")

In Navision RDLC if we want Week No. Month Wise i.e. if a invoice is posted on 15/04/2016 then Week no. should come 3.

Note : Initially week starts from Monday but what if we want week no. of a month where week starts from Sunday.

When you are developing a Report in NAV with a Requirement that with Posting Date you also have to provide Week No. in which that particular Posting Date comes. (Month Wise with starting week day "Sunday").


As per the above requirement given below are the required Variables & Code for the same.


##C/AL Globals (Variables) :

Name               DataType         Subtype
DateRec           Record                   Date
WeekNo           Integer
StartDate          Date
EndDate           Date
Ctr                    Integer
PDStartDate     Date
PDEndDate      Date
PDStartBLN    Boolean
DStartDate       Date
DEndDate        Date


##Code on Trigger (On After Get Record) :

Method 'PageXXXX.a60Action1102601028a62_a45_OnAction' not found

How many of you have faced this issue when 

you click on statistics or Release button ?

Method 'Page9304.a60Action1102601028a62_a45_OnAction' not found

##On sales return order page when you click on Statistics button system will give you below error.

STEPS TO ORIGINATE ISSUE :

Steps to Follow are given below

•    <Step #1: > Open Navision RTC 2013 R2

•    <Step #2: > Open Sales Return Order

•    <Step #3: > Generate New Sales Return Order by filling all the required Fields in header and line.

•    <Step #4: > Click on  Statistics Action Button, you get the error

RESOLUTION :

This happens because action button and method is not linked properly.

To fix this issue design the “Page ID – 6630” and then go to page actions.

Change Old Action Name “Statistics” to “<Action1102601028>”.

Important Note: - Now to know in which Page ID What Action Name is to be given to a particular Action Button.

Read the Error Message Carefully : - (See the Yellow color highlighted first  is Page ID & Second is Action Name)

[Method '    Page9304     .a60     Action1102601028    a62_a45_OnAction' not found.]

Well rename the Name to the action with <Action> and the issue is solved.

Method 'PageXXXX.a60Action1102601028a62_a45_OnAction' not found

How many of you have faced this issue when you click on statistics or Release button ?

 

Method 'Page9304.a60Action1102601028a62_a45_OnAction' not found

 

Ø  On sales return order page when you click on Statistics button system will give you below error.

STEPS TO ORIGINATE ISSUE

Steps to Follow are given below

·    <Step #1: > Open Navision RTC 2013 R2

·    <Step #2: > Open Sales Return Order

·    <Step #3: > Generate New Sales Return Order by filling all the required Fields in header and line.

·    <Step #4: > Click on  Statistics Action Button, you get the error,

RESOLUTION

<List 1> This happens because action button and method is not linked properly.

To fix this issue design the “Page ID – 6630” and then go to page actions.

Change Old Action Name “Statistics” to “<Action1102601028>”.

Important Note: - Now to know in which Page ID What Action Name is to be given to a particular Action Button.

Read the Error Message Carefully : - (See the Yellow color highlighted first  is Page ID & Second is Action Name)

[Method '    Page9304     .a60     Action1102601028     a62_a45_OnAction' not found.]

Well rename the Name to the action with <Action> and the issue is solved.



How to Convert Every First letter of a Field into Uppercase by Default

If a Name is entered  into Name Field in Customer Card like for example "prateek gupta" it should automatically convert into "Prateek Gupta"

Global Variables :

Name              Data Type          Length

Indx                 Integer                            

NewValue         Text                     20

Cap                  Boolean

##Code on Trigger : OnValidate (on a Table Field that you wish to apply this code on)