Akhilesh E Kartha Business Central

Business Central Create New Extension and Push to GitHub Repository

Git is a distributed version-control system for tracking changes in source code during software development, following video explain how to create new business central extension project  and push extension to git repository Steps Create new Project in visual studio code Create new Repository in GitHub Check visual studio code and confirm the git enabled Initialize … Continue reading Business Central Create New Extension and Push to GitHub Repository

Akhilesh E Kartha Business Central, Powershell

Business Central Install Multiple Extensions using powershell script

One of our customer having 20 + extensions ,while setting up new environment  it's  very difficult to publish and install all extensions one by one , so I created one powershell script to install multiple extensions . Please check the video for more details ,thanks https://youtu.be/vClW26IeLmA Script folder Business Business Central Administration Shell  

Akhilesh E Kartha Visual Studio Code

Modern Development Environment Issues

While confuguring the visual studio codes hit few errors Could not open the specified startup page. Please check that the server configuration key PublicWebBaseUrl has been properly set we need to update the public URL from powershell or administor  tool and restart the service Debug app hit following error  After publish the app ,its working … Continue reading Modern Development Environment Issues

Akhilesh E Kartha Nav 2016, Navision, Report

Nav 2016 Preview Report without Request Page

REPORT.EXECUTE Runs a report in preview or processing only mode without running the request page. The function gets the request page parameter values as an input parameter string. This is the new reporting function added on 2015 version Requirement : preview Sales invoice report without the request page  Create New codeunit to generate the XML … Continue reading Nav 2016 Preview Report without Request Page

Akhilesh E Kartha Nav 2016

Dynamics Nav 2016 Enable NavUserPassword authentication in simple steps

This post describes the simple steps to enable the NavUserPassword authentication   Download the poweshell script form Dropbox Link  Run Script as administrator Run mmc.exe to open management console File -> Add/Remove Snap-in Select Certificate -> Add -> Select Computer account finish New Certificate created on Personal Certificate folder with 10 year validity Copy Certificate … Continue reading Dynamics Nav 2016 Enable NavUserPassword authentication in simple steps

Akhilesh E Kartha Nav 2016, Report

Navision Schedule Report warning There is no running job queue for scheduled reports.

Scheduled reports are entered in the job queue and processed at the scheduled time, similar to other jobs. If we choose to save the report to a file, then the processed report will sent to the Report Inbox, While Scheduling the report, the scheduler page hitting warning message There is no running job queue for … Continue reading Navision Schedule Report warning There is no running job queue for scheduled reports.

Akhilesh E Kartha Nav 2013, Nav 2016, Report

Schedule Adjust Cost report on navision 2013 and higher versions

Job queues enables users to schedule and run specific reports and codeunits. You can set jobs to run one time, or recurring basis Previous versions we have to install  NAS to process job Queue  , 2013 and higher versions default service will start process this job queue entries . Create New Job Queue Category ADJUSTCOST … Continue reading Schedule Adjust Cost report on navision 2013 and higher versions

Akhilesh E Kartha Nav 2016, Workflow

Implementing Nav 2016 Workflow Events and Response for Sales Invoice auto send email

In this post we will create a new Workflow Event . The event  tied to the Dynamics NAV  Sales post functionality, While posting the sales invoice based on the workflow conditions program will auto send email and update the pdf report  on report inbox You may download the object and workflow file from Dropbox Link  … Continue reading Implementing Nav 2016 Workflow Events and Response for Sales Invoice auto send email

Akhilesh E Kartha Excel, Navision

Error when exporting budget to Excel – The call to member Add failed. Microsoft Office Excel returned the following message: That name is not valid.

While exporting budget from nav 5.1 version system hit following error message The call to member Add failed. Microsoft Office Excel returned the following message: That name is not valid.   Error hitting on  report 82 Export Budget to Excel Line ExcelBuf.CreateRange(ColumnDimCode[i]) Line This is the standard Nav 5.1  report  bug and Microsoft has already … Continue reading Error when exporting budget to Excel – The call to member Add failed. Microsoft Office Excel returned the following message: That name is not valid.

Akhilesh E Kartha Navision, Outlook

How to save outlook attachments files from Navision ?

we have one new requirement to read outlook from Navision Details User will send one text file. The text file will be on specific format, then program should read new mails from outlook and  download the file to a pacific place . Read the text file and creates item journals and posts it. The main … Continue reading How to save outlook attachments files from Navision ?

Akhilesh E Kartha Navision

How Create Excel Pivot table report from Navision?

A pivot table is a data processing tool used to query, organize and summarize data or information between spreadsheets, tables or databases. Dragging and dropping fields into a pivot table facilitates rotational, or pivotal, structural changes. Using excel automation we can create the excel  Pivot table report from  Navision This is one example to analyze … Continue reading How Create Excel Pivot table report from Navision?