-
"No active message processors listening on the message queue." Troubleshooting
This is a prompt that my clients get from time to time and restarting the service tier fixes it, but I don't know how to find the cause of the message. Especially when the service is running. Does anyone know of any tips for looking into this particular prompt further? I have a client asking and I'm not sure what to tell…
-
How to create and send an email message in Business Central 20 using replaced
As you probably have noticed, the SMTP module was replaced by “Email – SMTP Connector” and “Email – SMTP API” apps in the Business Central 20 version and will cause an error if you use the standard SMTP module. Read the latest post on the Simplanova blog, where you will find possible SMTP mailing usages and learn how you…
-
Link with external database / float Field
Hi Guys, I am currently working on an interfacetable and am stuck on a problem where there seems to be no search results. I have already succeeded in linking and can see the data from the external table in a NAV page. Also the advertiser works up to a point. This starts to jam when it comes to the data type "float". I…
-
General Journal Post via Job Queue?
I have been researching a bit but really haven't found anything definitive. I am really new to Nav, we are using Dynamics Nav 2018, especially on the backend/development side of things, but essentially we have users going into General Journal, picking their employee Batch name, then putting a bunch of entries in here, then…
-
Importing Excel File From C/AL Side.
Hello guys, I want to import excel file from C/AL side in NAV 2009 version. Windows window should appear and let me choose the excel file I want. In newer version, it's easy using Codeunit File Management, but here in this NAV version there is not one. I searched for other ways but zero progress. Can you guys give me a…
-
Introducing Simplanova Chatbot for BC Customer Support
Simplanova invites Dynamics partners to join the free webinar "Introducing Simplanova Chatbot for BC Customer Support". This webinar will demonstrate the main QnA, issue logging, and knowledge base building features of Simplanova's Teams bot. We will demonstrate a provisioned example, and attendees will be invited for a…
-
Copy Files to BC Docker images
Hi, I have created BC docker and it all works. How do I copy files from local host to docker? In this blog --> https://simplanova.com/blog/how-to-start-using-dynamics-365-business-central-docker/ there are detailed steps on how to do this. It says that I have to stop the container to copy files using "Docker CP" command.…
-
How to Access OneDrive using Graph API in Business Central
One of the significant limitations we face when upgrading to Business Central’s SaaS environment is our local or server’s file system usage. Various NAV or BC solutions often use the file system to save files for archiving purposes or to be processed later by an automated job. There are multiple methods of refactoring…
-
How can I concatenate two fields into one?
How can I concatenate two fields into one? I have to concatenate Item No. and Variant Code into one field with underscore. Ex: Item No._Variant Code. 2000_Onesize. Regards, Perizat.
-
Is there a way to see when a user last logged in to BC?
I have a client asking how to do this, and I've never seen/heard/been able to find anything about this. Any help would be appreciated. Thank you!
-
Accessing OneDrive using Graph API in Business Central
Simplanova invites Dynamics partners to join the free webinar "Accessing OneDrive using Graph API in Business Central". Webinar Date and Time: Tuesday, 31st of May, 2022, 04:00 PM CEST (Central European Summer Time). Register for the webinar HERE:…
-
Account Schedules D365 Business Central totaling question
Hi, Account Schedules overview values with formula totaling type in old versions can be opened to check if amounts are matching, now it seems only Total Accounts and Posting Accounts can be used for balance sheet etc. Are there any options to open values similarly as Formula totaling type?
-
after creating a field in customer record how to Flow the value of same field on Sales Header & Line
After creating a field in customer record how to Flow the value of same field on Sales Header and Sales Line.How to do this?
-
Adding Excel option to report
In report 10019 GLRegister report, when you go to print it has the option to Print to Microsoft Excel. We have a custom report that we built and when we select Print, we do NOT have that option... its missing. Was using that report as reference as it shows the button... Where or how do we add that button?
-
RapoidStart create duplicate entries
Hello, I have googled far and wide and can't find an answer to this problem ... I use file FORECASTUpload4Test(2bleentries).xlsx to upload some forecast data in that table 1 row gets uploaded but 2 get applied (And inserted) - see resulting data (I extracted the data using RapidStart) files available here:…
-
How to capture (Only) the print button event of a Report Page Requeste, to run an table modification
Hi everyone, I am on a task that concerns NAV version 11.0.19394.0, and I am trying to do a task on the RequestePage of a Report. I am trying to figure out how can I know if the user click on the PRINT button choice or another button choice (PREVIEW, PDF, WORD, EXCEL), so I can run a modification on the DataItem of the…
-
Vendor Ledger Entry Does not have an application entry.
-
NAV 2016/2017 with ADFS (SSO)
Hi, Please let me know the document to follow for integrating Nav 2016/2017 with ADFS 4.0? we want to log users with UPN (User principle name), which is possible with sso configuration.
-
Database size
Our clients are using Nav 2015. Our database size is around 600 – 700 gb and system is running slow. What can we do to improve the performance of the database? What do you recommend?
-
Automate C/AL to AL upgrades
Simplanova invites Dynamics Partners to join our webinar introducing a unique proposition for NAV to BC code upgrade automation – SALT (Simplanova AL Tools). Webinar Date and Time: Wednesday, 11th of May, 2022, 04:00 PM CEST (Central European Summer Time). Register now:…
-
Dynamics NAV 2016/2017 + problem to login UPN (Email ID) with ADFS integrated setup
Hi, I am testing Dynamics NAV 2016/2017 to integrate with ADFS (4.0 on Windows server 2019) to login users with UPN (Email ID). I followed this article: https://docs.microsoft.com/en-us/dynamics-nav/authenticating-users-with-active-directory-federation-service-2017 1. Created SAML 1.0 & JWT tokens in Claim Issuance Policy.…
-
Text Constant
Hello, I have to search a wording beetween TEXT CONSTANT in all object. can you suggest me how to do that? tnx
-
What’s new in Dynamics 365 BC version 2022 Wave 1 (April)
As the new version of Dynamics 365 Business Central is coming, Simplanova is organizing the webinar with Microsoft MVP for Business Applications – Stefano Demiliani, and encourage you to attend. During the webinar, you will hear detailed information, about What’s new in Dynamics 365 Business Central version 2022 Wave 1.…
-
FULL VAT in Tax Posting setup doesnt work for Items
Hello :smile: I'm trying to capture a purchase line with a Tax Prod. Posting Group , which has VAT CALCULATION TYPE := "FULL VAT" and doesn't work for ITEMS but only for G/L Accounts , when I change "Vat calculation type" to "Normal" it works , but has a wrong VAT calculation. Is there a setup I have to change?
-
What is the best way of exporting BLOB?
Kicking and screaming we are now entering BC! Therefor I am facing a big upgradeproject which includes going from TempBlob Record to "Temp Blob" Codeunit. Therefor I am looking for some information on how to best use/transfer the old pieces of code into the new one? For intance I have a lot of places where various files…
-
File Management limitations in SaaS using BlobStorages
One of the major limitations we face when upgrading to Business Central’s SaaS environment is the usage of our local or server’s file system. Quite often, various NAV or BC solutions use the file system to save files for archiving purposes or to be processed later by an automated job. There are multiple methods of…
-
Issue in passing a String from NAV to a DotNet Method
I was trying to pass a text variable txtStartDate from NAV2017 to a DotNet Method: SomeMethod(String StartDate) I found that when I pass a value directly to the DotNet Method like this (1) SomeMethod('2022-02-25T13:30:00') it behaves differently than when I pass (2) SomeMethod(txtStartDate) [although I have assigned…
-
Do we have a solution to read the CSV file through XMLport even if the data is having comma(,) ?
Hi, I am facing issues while reading the CSV file through XMLport. Example: I am reading the Vendor's data from CSV file, "Address" field has value 10 North, Lake Avenue as there is a comma(,) after 10 North, CSV file treating it as a field separator and the Address field just holds the value till comma and the remaining…
-
Secure life in a Dynamics 365 Business Central tenant by Stefano Demiliani
New hot and really important topic – secure life in a Dynamics 365 Business Central tenant. Read Microsoft MVP for Business Applications Stefano Demiliani article on Simplanova blog: https://simplanova.com/blog/secure-life-in-a-dynamics-365-business-central-tenant/
-
SMTP Basic Authentication in Dynamics NAV 2018
Our software is built on the 2018 version of Dynamics NAV and it uses Microsoft Exchange and Office365's SMTP in order to send emails to customers. The issue that I've recently become aware of is that the only authentication option that we have for our Azure clients is Basic Authentication which will be discontinued later…