-
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.
-
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!