-
Day rates in different countries?
Hi Guys, Does anyone know the market rate for senior consultants around the world? How much do the biggest consultancies in your market bill their end-users by hour or by day? In Denmark I know of consultancies who charge 1100DKK, 1400DKK and even 1600DKK per hour. In the UK, the dayrate is between 700-950 GBP. Does anyone…
-
How to fix New-NAVWebServerInstance is not recognized Error
I am trying to set up a new web server instance. I am using the command New-NAVWebServerInstance -blahblah -blah -etc but the PS is telling me the following
-
How to upgrade an AL Extension?
Good morning all, I am come back to Dynamics Nav 2018 after couple of years now to find that Extensions is the new way to customize Nav! I have developed a simple extension and successfully managed to publish it on my local laptop where I have installed Nav 2018. This extension is working fine. Then I changed this…
-
Access business central SaaS web service issue
Hi, I have a soap webservice in my sandbox and it's working fine. But when I deployed it in client's sandbox, I am unable to access it with userID and web service access key. What could be the possible issue?. Any help will be appreciated. Thank you.
-
BC16: Download symbols
Hello, I want to test my development in the new BC16 in a sandbox but when I get this error when I try to download the symbols: [2020-05-20 09:34:37.53] Using reference symbols cache path: c:\Users\xx\Documents\AL\ALProject1\./.alpackages [2020-05-20 09:34:37.57] Authenticating... [2020-05-20 09:34:38.10] Authenticated.…
-
NAV2018 Job Queue not retry after hit error
In Nav 2018, i have a job queue that fail sometimes The error is ok (it's because of some lockted table), so i want the job queue to retry
-
Is there a more optimal way to do this
Hi All I'm writing my first extension that we'll use in productions. basically, I need to set to clear the qty to ship on sales lines, but for a blanket sales order, I need to go and find all the sales orders linked the blanket line and sum up the Qty on sales orders. I tried with calcsums, but it complained about not…
-
How I can Push customer's information from Nav to external website.
Hi Experts, Please I need your help. I want to send the customer's information from Dynamics Nav 2016 to an external website. This should be happened in case of creation of new customer in Nav or if any modification in customer's information happend this should be operate in website. The website owner send to me this:…
-
Backup restore error in NAV2017 "No default profile set"
Trying to restore a NAV 2017 backup, it runs for about an hour and then produces the attached error. Does anyone know what that means? It's only Company Data, no Global or Application Data. Build 19421.
-
Vendor Approval Workflow issue
I have a created a Vendor Approval Workflow that is triggered on Event "A vendor record is changed". The condition is set to <Always>. I presume this workflow is triggered by the table's OnModify event. The problem is, when a user edits a Vendor, there could be multiple record saves, and thus multiple Approval Requests are…
-
How can we get download the Microsoft Dynamics 365 BC Virtual PC?
How can we get download the Microsoft Dynamics 365 Business Central Virtual PC? Pls share the link if possible.
-
Autofit column width & Wrap text
Hi guys, May I know how to autofit column width & wrap text when export to Excel file? I saw many people advise use the Autofit function in the Excel buffer table (370), but I can't find the Autofit function in my Microsoft Dynamics 365 Business Central. Anyone expert can give me some suggestions on how I can archive the…
-
OData: receiving JSON not mapping to BC Pages/Queries
Hi experts, Is there any best practice to receive and process a complex JSON Payload via http, without the need of it mapping to a BC Page/Query? Example:{ "title": "mibuso", "users": [ { "name": "Wisa123", "property1": "one", "property2": "two", "posts": [ { "title":"OData: receiving JSON not mapping to BC Pages/Queries",…
-
Upload multiple pictures from folder to BC16 webclient without dialog
Hi, I want to upload multiple pictures from a folder to the BC16 webclient (OnPrem) without a dialog. Therefore I can't use UPLOADINTOSTREAM function and using the file management codeunit is not allowed in an extension. Is there a possible workaround (SQL query, PowerShell, Webservice)?
-
Wrong language in Mail subject.
Hi When I want to send a posted sales invoice (for instance) and press "Send via mail" - the proposed mail subject (and file name) is based on the language I am using and not the language of the customer. So in my case english customers will receive an email with Danish subject (unless I change the application language to…
-
Buffer table not deleting the entries
Hi guys, I ave written some code which should delete my buffer table before filling the entries in, but its not doing it. Here's my code: TempBuffer.DELETEALL; ActualTable.SETRANGE("Type",ActualTable."Transaction Type"::"Bills"); TempBuffer.SETCURRENTKEY("Entity ID"); TempBuffer.SETRANGE("ID",Get(COMPANYNAME)) END; Any…
-
NavBC: httpclient error when get data
Hi all, I can't get data from api url. anyone can help me ? my code as below procedure StartBOTT_API(); var Client: HttpClient; HttpRespone: HttpResponseMessage; ResponseText: Text; Url: Text; begin Url := 'https://api.exchangeratesapi.io/latest'; Client.Get(Url, HttpRespone); end; ========= when run this code I'm using…
-
signing text string using certificate key and convert into base64 string to send over API.
How can I achieve this using in AL code? I have tried using encryption management codeunit but I could not find the function to get key from stored certificate. 1.Token String 1 := String 1 + String 2. 2.Generate message digest of the token string above using SHA256 hashing algorithm. 3.Sign the message digest using the…
-
pass parameter null to dotnet function
Hello, Any one can help plz. i want to pass a null parameter to dotnet function. reader : System.Data.SqlClient.SqlDataReader I already try to declare an array but i get didnt get the same result as c# When i run the same code in c# num2 = 1277 but when i run it in business central i got 0. Thanks in advance
-
Debug BC 16
Hello everybody! I'm at a loss. I need to debug our testing environment which is running BC16 on a server that can not be reached from my development environment. I have just installed VSC on the test-server and would love to be able to debug the running database - without having to publish anything new. The extension I…
-
Business Central LDAP -> LDAPS
Hi All does anybody know if this change has impact on BC 15? https://support.microsoft.com/en-us/help/4520412/2020-ldap-channel-binding-and-ldap-signing-requirements-for-windows Do we have to change something in BC? thanks
-
Data moved from one database to another database in same SQL server in C/AL ?
Hi Folk, Need your assist. I need to moved "Change Log Entries" table data from one database to another database in same SQL server in C/AL code, is this possible or not in C/AL code? Thanks in advance.
-
How to change complextype mixed=false in wsdl
Dear All I published the web service using code unit (xmlport). The WDSL has the below <complexType name="xmlPort" mixed="true"> Is possible to change mixed='false'? Thanks & Regards Nasheer.
-
Row Received Zero | RDLS Report Execution
Sir, My custom report takes some time to print the layout & during execution the Report shows Screen as given below. I want to show the custom progress-bar instead of this message. How can I do that ? Regards, Navuser1
-
How Export the file in Shared Folder
Hi All, In NAV 2018,I have created one report to export the excel file in the same server folder, it works fine. Now I am trying to save the file in another 'Shared folder' but it shows an error 'Could not find a part of the path'. How can I save the file in a shared folder? Please guide me. Thanks in advance, Jacob.A
-
SAVEASPDF on Network Drive
Can you please help me on this I am saving report as pdf on a network drive, we are on citrix with NAV 2016 when I run the code, it works fine but it is not working for other users, I made other users as super user folder is shared with 'everyone' read/write report.saveaspdf return true with no error but file is not…
-
Event session
In navision there is a table with name event session In this table record the data for log on and log off of user Can any one help me to know the about the option "close" which is under event type field Thanks
-
Business Central: Returning Max Sessions (Max Connections) in AL Online Extension
Hi folks, I have a need to return (access) the variable representing the maximum number of concurrent sessions a particular database is Licensed-for in an Online BC install. And I need to be able to access that from my own AL Extension. You used to be able to read the text-part of the License File from a System Table in…
-
Search Engine - 1 Character at a Time
Hi Mibuso.com In NAV 2009 R2 I created a search engine which could say look through customer names, addresses, etc., one character at a time. I was able to do this as a Form had a Property called AutoEnter and the Field was only a Text of one. This allowed me to type in say C and automatically I could look for all…
-
Edit a code field in BC16
Is it possible to change a (indexed) codefield from 10 length to 20 length in BC16 e.g. field1 in table 5401 I am in desperate need of 20 characters instead of 10.