-
XML File Signature
I need to send an XML file created with XML Port object to an external web service. Webservice verify file signature to check real file format. It expects to receive an xml file with the first 5 bytes set like this: 0x3C, 0x3F, 0x78, 0x6D, 0x6C, 0x20 but file created from BC contain file text signature: ef bb bf or ff fe…
-
Error While Using Business Chart DLL in Factbox of Item List Page!
Hi Experts , Iam getting below error when i defined Business Chart Variable in a new card page and setting ControlAddin Property of the field . When i try to recall the new page created with Business Chart as Part-Page in Item List page using Business Chart Buffer Table (485). it is throwing below error. A DotNet variable…
-
Excel Buffer How to Check Worksheet Exists
Hi All I'm importing an Excel file with multiple worksheets into BC SaaS, and I want to check if a specific worksheet exists and if not provide a user friendly error message. Say worksheet "Order" does not exist.
-
Need help: Migrating Business Central 14 to business central 22
In my version 14 fields were directly inserted into the system tables instead of making extensions. As a result, when migrating to business central 22 , when you publish the "Base Application" extension on version 22 and you want to synchronize, you get errors relating to the base tables of version 14 modified (The tables…
-
Business Central 140 CU9 - Issue with SignalR
Hi We are seeing alot of SignalR messages in relation to poor performance with BC140CU9 WebClient Anyone experiencing the same or know what the issue is ? Prod.Client.WebCoreApp.ReliableMessagingHubMiddleware SignalR. Large count of messages in the queue (50). We cannot see any direct performance issues to server…
-
Potential risks of deleting G/L entry (Archive to new table)
Hi Experts, Can somebody tell me the potential risks of deleting G/L Entry data (Archive to new table for later reference purpose) which are older than 7 years as customer don't want to keep old history coz of growing day to day data in this table. This table is already huge (over 100M records). For the deleted GL entries…
-
User Permission set issue
Dear all, When user try to post purchase receipt , he is getting following error. sorry current permission prevented the action (tabledata vat setup read : base application) error in business central. please let me know which permission set to add in BC Thanks in advance. Regards, sekar.
-
SOAP API Call returns Message: Message is closed.
Hi All, I encountered a very strange situation for a customer. We have a live VM running on azure. Which has 4vCPU's. On this VM we have 6 BC 17.0 instances. We have split up the services for the functionality so 3 of them are SOAP API services. Every time the server reboots after .net updates our 3th party receives the…
-
Warehouse register table and ADCS
We have been having issues with some of our picks not registering on NAV. Having looked at the event viewer logs, I could see that the warehouse register table had been locked. I am not entirely sure if the picks aren't registered because of this locking. Anyone here has had this before? Or is it something else that might…
-
Send PDF to Azure Function
I am trying to create azure function which will take PDF sent from BC and encrypted it with password. I try two different approach. First, to send instream from BC with content And azure function is like down there, but always got an error. Seams like I don't take stream parameter on azure function correct. I also try to…
-
CurrPage.EDITABLE together with CurrPage.UPDATE
Hello, we have made the following adjustments to the P41 for some customers; When an offer is moved from the Released status to the Open status, it should be editable. Basically, it works, BUT, you first have to leave the offer completely and then open it again so that the fields are no longer disabled. I've tried putting…
-
Problem when upgrading onprem v18 to v22
Hello all, I'm trying to upgrade a BC database from version 18 to version 22. The service is running on an Azure VM and the database is an Azure SQL database. I'm following this walkthgrough. The problem is that when I execute the step to synchronize the System Application, I'm getting the following error in Administration…
-
JSON string truncated to 240 characters
Hi everyone. I'm using the Newtonsoft JSON library in NAV2016 C/AL to format a JSON web request. The code is straightfoward: JsonTokenWriter := JsonTokenWriter.JTokenWriter;
JsonTokenWriter.WriteStartObject; //curly open {
CreateJSONAttribute('name','Shawn…
-
Convert a DotNetDictionary into a JSON string
Does anyone have any C/AL code examples of deserializing a DotNet dictionary object (System.Collections.Generic.Dictionary`2.'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089') into a JSON object?
-
PO attachment
I'm trying to get the file(Terms and conditions) from a field in a table. And then attach that field to the Purchase Order attachment. But I'm getting the following error when I get that file downloaded, please note the file size is ZERO Bites. Could anyone explain why??
-
Sales Invoice report - sales line type blank removes totals
Hi all, I am kind of a newbie in AL programming. I am working with customized sales invoice report where I run into a strange issue. Whenever the last sales line is type blank (the customer uses it to add some comments to the invoice), the totals are not showing up. I have tried to look into my rdlc layout but I am not…
-
Restrict one field in the permission sets
The goal was to restrict this one field "Last Direct Cost" in the permission sets, but I only see how to restrict all edits to the item card itself. There is no standard way to put permissions on the record to make a field non-editable for specific users. However, this could happen by adding a small enhancement so that…
-
Let me how to view Detailed Stock Ledger Report in navision?
Let me how to view Detailed Stock Ledger Report or report related to it in navision.Please
-
Page.Close() don' t work
Hi All, Can someone tell me why the CurrPage.close() don' t work in page trigger such as OnOpenPage but work in action trigger or control add-in trigger. Thks for any reply.
-
controladdin function
I need to convert a string representing a numeric expression into its corresponding result. In the same way by when in an excel cell you enter "2+2*4" and the result is 10. EVALUATE Function not work. Need for a 'numerical' string and does not calculate expressions and I cannot use DLL. Cannot find a solution. I had…
-
add email recipient during send sales invoice
Hi All. I have added new field in Customer card, which is "E-mail 2" --> text 250 how do i include this when i send Email from Posted Sales Invoice ? any idea? Thanks.
-
Fail update Odata Web Service BLOB field with return 400 Bad Request using larger file
Hi, i have create request Bussiness Central W1 19.5 OData Webservice to update BLOB field based on this Dynamics Picture Update It return successfully with 204 code for small size file (100kb) But if i try with larger file size (ex. 200kb) it return fail with 400 bad request Is there any suggestion to upload image to BC…
-
Business Central Adobe Reader API Integration
Hello, I am working on Business Central Adobe Reader API Integration. I am struggling with passing MediaType in Request via programming. I have followed Adobe Reader API Documentation and passing MediaType as per given example. But I am getting error when Request is sent via programming. The same works when I send Request…
-
Change Reference in NAV 2017 bank export (Danish BEC-Indland format)
Can't find where to change 'Own reference' when export payment to bank (fileformat BEC-INDLAND). In reference NAV exports the Voucher No. I want to export 'External Document No.' and the Vendor account instead. Where do I change that in NAV??
-
Validate on existing page... Page Extension or Event ?
Hi masters ;-) When some modification has to be done on an existing page for a Validate for exemple, I usually use the Event Subscription to perform it. I saw some of my collegues doing this operation if a Page Extension using the Modify... Both system works but I am wondering if one option is more efficient or not... Any…
-
Two instances of NAV 2018 on same RDS?
We have a NAV 2018 environment which is running on CU 2. Recently, we were asked to setup another NAV 2018 environment which is running on CU 60. How can we run both NAV 2018 CU2 & CU60 client applications from the same RDS server? Any tips on how we can configure this?
-
How to make customize dialog
Hello all, I have a function which need a dialog to display how many time past. Both of all the system providing dialog can not meet needs, Does there have a way to make a customize dialog. Thanks for any reply.
-
Chart of accounts
I have setup a new Company on Business Central. Please kindly advise how I can copy the chart of accounts from an existing company to the new company?
-
HttpResponseMessage.Headers() does not contain Content-Type and Content-Disposition?
Hi Community, it seems that the HttpResponseMessage.Headers() method does not return the http headers for "Content-Type" and "Content-Disposition". Headers traced with Fiddler: Headers List in AL-Code debugging: Does anyone know why or how to access them? I'm doing a http get for a file and want to get its mimetype and…
-
Microsoft Dynamics NAV 2015 - Start Job Queue thru terminal commands
Good day! Is it possible to Start the Job Queue in MS Dynamics NAV 2015 thru terminal commands? Microsoft Dynamics NAV 2015 Version W1 8.00 / 8.0.38798.0 Thank you!