Register For Our Live Webinar WorkshopRegister Now

Multiple Values Input Box in Dynamics NAV

In Microsoft Dynamics NAV, there are many functions that help you enter data in a quick and easy way. Sometimes clients have a requirement of inputting one or more values at run-time and based on that result perform some actions. Keeping this requirement in mind, we have implemented an input box that takes multiple values as input at run-time. Here are the steps for the to create multiple values input box in Dynamics NAV:
1 – ActionEnter Rows and Columns

1_Action

2 – Multiple values Input Box

2_Input

3 – Result

3_Result

4-Code

X_Table

4_RunOnClient

 

For all this variables “RunOnCilent” property must be set. To set this up, following are the steps:
1 – Create Input Box as Form

5_Create Form

2 – Add Labels

6_Lables

3 – Add Text boxes

7_Textboxes

4 – Add Buttons

8_Buttons

5 – Get Results

9_Result

And its done.
This can reduce the unnecessary use of objects.
If you need any help, feel free to reach us.

Integrate Dynamics NAV with Telegram

As we all know that BOTs are the most buzz topic now-a-days and Telegram messaging application has a good hold
on it as a platform. Recently we  received a couple of feedback from our customers to integrate some messaging
application with Dynamics NAV because that’s where they work-in the whole day and they don’t like to switch the screen to connect with their co-workers. We had been searching a good BOT to integrate with our ERP until we ended up crafting it on Telegram. It’s very easy and fun work.
Easiest Steps to Integrate Telegram with Microsoft Dynamics NAV

  1. Connect to @BotFather account of Telegram by searching like thisbotfather account telegram

2. Create new bot by sending /newBot command

create new bot command

3. It will ask for your Bot name that you want to create.

Your Bot name

4. Give Suitable name that ends with for Ex: NAV_bot.

bot name

5. Each bot is given a unique authentication token when it is created. The token looks something like 326076132:AAEufsce4s2sg5b6mdbmW_KLTcbmS-HeVXY.

  • To generate token, just go into botFather account.
  • Send /token

 

unique authentication token

  • It will ask you that, for which bot you want to generate token.

 

bot token

  • Just Tap on our newly created bot name @Navision_bot.

 

newly created Bot name

  • That’s it, just copy this token for your reference.

6. Now, I have created this bot to Integrate with NAVISION, so for that you require to generate Chat IDs of users to send chat messages to any Telegram User.

  • First of all, users will have to send test message to the BOT that you created.
  • For that, search your bot account in Telegram starts with @ Sign followed by your Bot Name.

 

Search your bot account

  • Just enter into your bot, and type /Start to send test message to generate your Chat ID.

 

Generate Chat ID

  • Now, your Chat ID generated and you will get it by calling getUpdates method of Telegram API, for this you have to call getUpdates method in web browser as follows.
  • https://api.telegram.org/bot<Your Bot Name>/getUpdates
  • For Ex: https://api.telegram.org/324480200:AAGxuzqskveyV-ZBTM81P0CCI2qartfWPfo/getUpdates
  • You will see the response of telegram in JSON format as follows.

 

response of telegram-JSON format

  • From here you can get the Chat IDs.

7. All set, now you can send message to any user. And it will have sent from your newly created

  • To Integrate Telegram with NAV, we have focused to send requests via CURL tool, that silently run HTTP requests from
  • For Ex:
  • Open CMD.
  • Go to the path where your CURL tool is there.
  • Run the command to send Http Post request like this: Curl -X POST “https://api.telegram.org/bot326076132:AAEufscs4s2sg5b6mEbmW_KLTcbmS-HeVXY/sendMessage” -d “chat_id=163898670&text=my sample text”

 

send HTTP Post request

 

All Above Steps are to test sample message sending from HTTP request.
8. Now to Integrate Telegram with NAV, you will have to send HTTP requests from NAV code, For that, I have used CURL tool that run silently from your PC and sends HTTP request.
9. Create One Automation variable of ‘Windows Script Host Object Model’.WshShell to open CMD and run CURL command.
10. Here are some sample commands to send messages and send attachments from NAV.

  • curl -X POST “https://api.telegram.org/bot326076132:AAEufccs4s2kg5b6mfbmW_KLTcbmS-HeVXY/sendMessage” -d “chat_id=-189801512&text=my sample text”
  • curl -F chat_id=”35065383″ -F document=@”//intechserver/Shared/FTP/Attachments/Temp.pdf” -F caption=”PFA” https://api.telegram.org/bot326076132:AAEufscs4s2sg5b6mEbmW_KLTcbmS-HeVXY/sendDocument
  • just run above commands from NAV with the use of Automation variable.

11. Just create Two tables, one is for chat IDs for individual NAV users and another is to create telegram message queue.

  1. Chat IDs table will contain user ID and Chat ID fields.
  2. Message queue table will contain User ID of receiver, attachment, Message body fields.
  3. Now do code for send message Action with the use of above automation variable and CMD command as above.

12. Final NAV will look like this,

Final NAV look

This page contains Chat IDs of Individual Users in NAV.

Chat ID in NAV
Chat ID

This Page will send Message to particular User that was added in Chat IDs table.
Just place sendMessage code on this Send Message Action

send message

You can keep Sent Message Entries by creating another page like this.

If you need any help, feel free to reach us.

Microsoft Dynamics AX client has stopped working

There could be any reason for the error ‘AX  client has stopped working’. Most of the time it’s due to bad code and data. In this article, we will see how can we troubleshoot and fix the same.
Finding the logs:
During the crash, you will see the following messages

AX crash errors

 

  • On the client crash: Microsoft Dynamics AX client has stopped working.

 

AX Client crash message

 

  • On the Application object server (AOS): The Server is unavailable. Check your configuration and network connection and try again.

 

AX AOS Crash message

 

Check if AX Service is stopped.

 

AX service status

 

Check the event viewer on AOS server, probably you will see following error Faulting application name: ax32Serv.exe, version: xxx, time stamp: xxx

 

event viewer on AOS Server

 

Service control manager also reports about this issue.

 

Service control manager

 

Fixing the issue:
First, identify if the crash is due to buggy Dynamics AX code or not. To identify it, check the said logs as mentioned above. Ensure that event viewer has not reported any error related to Network on AOS server or Domain on AOS server.
Follow the below steps, if you find that the culprit is buggy code or some bad data.

  1. Use any of the following tools to collect memory dump.
    1. WER (Window error reporting) is a built-in tool that collects information about errors, can be used to capture memory dump for AX crashing application.
    2. Debug Diagnostic is a free Microsoft Tool. It is advanced as compared to WER and more configurable.
  1. To conclude the reason for the crash, one needs to analyze the collected memory dump. It is in machine language and not in readable format, so we can use the following options.
    1. Analyze it with Crash Dump Analysis tool on LCS – this will generate a report can be useful to conclude.
    2. Raise a support incidence with Microsoft, they will provide workspace to upload dump and after analyzing MS Support engineer will help to resolve the issue.

If you need help, please feel free to reach us.

Data Analytics: Power to transform your business

When you think of business data, an image of huge servers and chunks of wires come in front of your eyes. It is estimated that every day at least 2.5 quintillion bytes of data is produced. This is rightly an era of technology and data.
With this ever increasing data, it is important for companies to find a way to analyze the data increasing in their business environment and take it into meaningful consideration. Companies can either make a good use of technology to mine this mountain of data or get submerged in its burden. Big Data analytics help organizations of all sizes to mine the tons of data, analyse them, discover trends, apply analytical model and optimize the performance of
business processes. This in turn helps them to bring out the best from their resources and make smarter decisions.
For example, immense amounts of shipping delivery data, continuous traffic and weather data, details of various vendors and their past performances, geographic regions, etc. can all be analyzed simultaneously to devise a model to select the most suitable shipping subcontractors. This will ensure timely delivery, less damaged goods and the optimum service.
So how is Data Analytics useful to your organization?

data-analysis-idea

  • Smarter and faster decisions: With the availability of varied data analytics software, it has become easier to identify trends and other analysis immediately. Making decisions based the output of the analysis becomes easier.
  • Reduction in costs: Not only storing huge piles of data but also analyzing them to your advantage has become a piece of cake nowadays. The challenge is just to know the process right. You don’t need bulky servers or big rooms to store your data. Cloud-based analytics or in-memory analytics do this work for you with much less cost.
  • Customer satisfaction: The end result of all the analytics is that it helps you gauge what your customers want from you. When you give them what they want, they are content too. So, all in all, this is a win-win situation for both of you. More and more companies are innovating and evolving so as to meet customers’ needs just because of Data Analytics.

Have a look at how we help you in managing your huge data.

If you need help, please feel free to reach us.

Leverage IoT in your business to achieve more

As a businessman, you might be having many questions. Where is your business going? Is it thriving, static or deteriorating? How can you make it at par with modern technology breakthroughs to ensure your business is set up for the long term? How can you make your employees more efficient and reduce costs at the same time? What can you do to make your customers satisfied? How can you make the optimum use of the resources you have? The answers to these and many such questions already exist in your business. You just need ideas, inspiration, and technology partners to help you, not in surviving in the market but to make your business prosper.

Everyday new trends and technology takeover the market; many of which you are still unaware of. The Internet of Things, also known as IoT, is one such trend. IoT basically means each thing in the world has capability to connect, produce and transfer the data. Thus, it erases the line between digital and physical world. IoT in business is the first step in making your business go Digital.

IoT is much hyped as billions of devices and systems connected but think of it as Internet of Your Things. It is a good time to look beyond the hype. Create a strategy to unlock the potential of the Internet of Your Things to generate ROI and drive efficiencies and insights for your organization. Moreover, IoT in business helps you realize real, transformative results in your organization.

Simply put, these connected “things” are producing large amounts of information. Tap into those data streams and connect them to the cloud and back-end systems. You can thus optimize business processes and decision making, identify new revenue opportunities, and better understand customer and partner behaviours.

before-and-after-iot

Robots on a factory floor send production and maintenance information directly to those who need it, for unparalleled reliability and uptime. Sensors installed inside an equipment will check if any part is not at par with its designed thresholds and will automatically send reports to owners and manufacturers if they have. In each case, new insights are generated that drive the organization’s objectives forward on many levels.

Internet of things will find its way into manufacturing, smart cities and more; here’s why

IoT starts with identifying the one process, product line or location that matters most and then making small changes with a big impact. Find few key areas of your business that provide the quickest return and aim to optimize them by connecting your people and infrastructure together. The power of IoT in business and your existing assets enables you to:

  • Connect your already existing data and systems with new data sources to gain new insights into business which are futuristic and efficient
  • Scale your IoT project to your business needs and get started quickly
  • Capture, analyze, and mine disparate data to create new insights and predict future outcomes.

If you need help, please feel free to reach us.

    Join our mailing list for news updates, invitations, and more