Mohana's D365 Business Central & NAV Blog: February 2013

Wednesday, 27 February 2013

How to Update/Modify Data in All Companies

We have Table 2000000006 - Company
This table contains the names of all the companies that have been created in the current database.

And also we have CHANGECOMPANY Function

Redirects references to table data from one company to another.

[Ok :=] Record.CHANGECOMPANY([CompanyName])

We can create a ProcessingOnly report to update the data in all companies using above table and function.

Ex: If I have to Update "Allow Posting From" and "Allow Posting To" field of General Ledger Setup table in all companies then:

1. Create a Processing Only report with Company as dataitem

2. write below code in Company - OnAfterGetRecord() trigger

    
GLSetup.CHANGECOMPANY(Name);

GLSetup.MODIFYALL("Allow Posting From",010213D); 
GLSetup.MODIFYALL("Allow Posting To",280213D);

//You can use variables in Request Form for From Date and To Date

Where GLSetup is global variable of record type variable with General Ledger Setup table.

Saturday, 23 February 2013

One or more filters are not valid and will be ignored Message in NAV RTC

Today I tried to run (Preview) a Report with Date Filter and I got below confirmation message

Microsoft Dynamics NAV
---------------------------

One or more filters are not valid and will be ignored. Do you want to continue?
---------------------------
No Yes
---------------------------

Then I found that this is because of Wrong date format entered in Birth Date filter.
Date format in My system is set to DDMMYY and I entered as MMDDYY.

But this behavior is different in Classic Client (NAV2009R2).

I tried to enter same MMDDYY format in classic client Birth Date filed.

It immediately shown error message

---------------------------
Microsoft Dynamics NAV Classic
---------------------------
'013150' is not a valid date.

---------------------------
OK
---------------------------

Friday, 22 February 2013

Where do I Found Current Sessions in NAV2013

Till NAV2009R2 we can see Current Sessions in Classic Client under
File-->Database-->Information
Under Sessions tab

But if I look at the same path in NAV2013 Development Environment?

The information is not available at above path.
Where can I find Current sessions in NAV2013?

In Order to see current sessions, we need login into the RTC client

Navigate to
CRONUS India Ltd./Departments/Administration/IT Administration/General
Under Tasks, we have sessions

How to Save Excel File Automatically

IF NOT CREATE(XlApp) THEN
ERROR('Excel Not Found.');
xlBook := xlApp.Workbooks.Add(-4167);
xlSheet:= xlApp.ActiveSheet;
xlSheet.Name := 'Mohana'; //Sheet name

xlSheet.Range('A1').Value := 'Mohana';
xlSheet.Range('B1').Value := 'MVP-Microsoft Dynamics NAV';
xlSheet.Columns.AutoFit;
xlApp.Visible := TRUE;
xlBook.SaveAs('C:\Test\Mohana.xlsx'); // To save the excel file
xlBook.Close; //To Close the Excel