-
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.
-
Installation of Two versions of same NAV 2016 in one Computer?
Hi Experts, Is it possible to install two version od nav 2016 on same computer i have install nav 2016 version 9.00.49.146 and i want to install nav 2016 9.00.51175 and want to access it independently. also please tell me any online space where i can install nav 2016 .is it possible from azure for free. thanks in advance
-
iPad dragging the view
I have a simple page with the Sales Header, and Sales Lines.. The sales lines is at the bottom of the screen, and the iPad doesn't seem capable of dragging it up to show more Sales Lines.. Anyone have a solution?
-
iPad printing receipt
I'd like to install a receipt printer in our forklifts so our loaders can give the drivers a receipt of what is on the truck. Anyone printed to a Bluetooth printer from an Ipad in NAV? Using NAV2016 right now, but in the middle of upgrading to NAV2019
-
How to load data from excel file to the Nav
How to load data from excel file? For example I have the table in which I have to fill some fields. I have to load it from excel file. In this file I have id of each field. I have to load this fields by id
-
Data Compression in NAV 2016 - Report Performance
Does using data compression on a regular basis speed up the time to run reports which rely on a culmination of ledger entries, like the Inventory Valuation report? This is an environment that is very high transactions (Item Ledger Entries) and very high number of Items, as well as quite a few locations. Thanks in advance!
-
Cannot send e-mail new SMTP provider
We want to use a SMTP server from a new provider. When I tried to send a test e-mail I get the error message "Unable to read data from the transport connection: net_io_connectionclosed..". The provider told me that they use explicit SSL and that probably Business Central (.NET) use implicit SSL. How do I change this, I…
-
PingPong On BC14
Good Morning on a particular page I can't make pingpong work..the data is not updated in any way :( LOCAL OnTimer() CALCFIELDS("Anime per Getto"); VALIDATE("Peso Totale Anime"); NOT EDITABLE PingPong::AddInReady() //OnTimer; CurrPage.PingPong.Ping(1000); PingPong::Pong() OnTimer; CurrPage.PingPong.Ping(1000); On another…
-
multiline transfer from one table to another
Hi all, I have created custom table and page to store comments.later i have created action sales and purchase order page .on click of action custom page opens and multiple comments selected. then it move to in standard table ie: purchase comment. what code on action so that it move multiple line only which selected in…
-
Codeunit with CREATE - Error: Either the caller does not have the required permission ...
Hey Guys, i built a xmlport to export table data to a .csv / .txt. This works. Now I'm trying to make a codeunit, which creates the file to a specific folder. This is the code i am using in the codeunit: varXmlFile.CREATE('C:\Program Files (x86)\Microsoft Dynamics NAV'); varXmlFile.CREATEOUTSTREAM(varOutputStream);…
-
NavApplicationProfiler & NAV 2018
Has anyone managed to run this successfully in NAV 2018 (CU29) If i dont enable function tracing i can capture the database access, but when i enable tracing i get an error when stopping the trace. Th e error is along the line of invalid typecast when calling the stopfunction in the dll. Alternatively i could use a hint on…
-
JSON file type missing
Hello guys, Please help me. JSON file type missing???