-
Blog Series Part 7: Creating Sales Document in AL for MSDYN365BC
In this blog we will discuss about creating Auto Sales Document from the Data present in the Excel Sheet. View article...
-
Imoprt from csv file not creating a balancing line
hi guys, I am writing an import but its only creating one balancing line for my journal whereas I want it to create balancing line for each document No in the import. Here's my code. Not sure what I'm doing wrong? WITH GenJnlLine DO BEGIN SETRANGE("Journal Template Name",JournalTemplateName); SETRANGE("Journal Batch…
-
Open Image using Temp Blob codeunit
Hi I have code on a page in NAV that uses the TempBlob record to open an image. CALCFIELDS(Image); IF Image.HASVALUE THEN BEGIN FileName := AppSetup."Temp Image Path" + "Document No." + "Image Extension"; TempBlob.Blob := Image; FileName := FileManagement.BLOBExport(TempBlob,FileName,FALSE); HYPERLINK(FileName); END; I…
-
WebService consuming from a temporay table
Hi everyone, I've created a page, which its source table is temporary. The source table is one created by myself. The page is this: And the oData url is filtered, this way: http://xxxxxxxxxx:7068/DESA/ODataV4/Company('ZZZZ EUROPE S.L.U.')/AppItemPrice?$filter=Insize_User eq 'FI159' In the onOpenPage(also tried in onInit)…
-
VSC with strange error message
Hello I'm on BC16 VSC 1.45.1 Have some code in my workspace - no error And suddenly VSC finds an error on this line (that was in the workspace since a long time without error) :if ProjTrace_FolderList.RunModal() = Action::LookupOK then begin The error is : { "resource": "xxx", "owner":…
-
Modal dialo BC14 Webclient
Sometimes, even with different browsers, when I register a purchase invoice and a problem occurs it is not possible to close the error window because the one that shows the progress of the registration remains in the foreground and does not click on the Ok button of the window with error. Anyone know how to fix or work…
-
Debug web client
It's possible debug webclient also without use al extension? I migrated a database to Business Central version 14 but continued to use C / AL. However, the customer uses the web client. Is there any way to debug? Web sessions do not appear in the c / al debugger..
-
Report Generating locale Language, field formating
Hello, I'm facing a problem that reports are generated and printed out with wrong locale Language. This results, that Numbers and Dates are printed in wrong locale format. System environment: Windows Server 2012 R2 German installation Navision 2018 German My Problem is, that I generate Report Print Outs as PDF by a Job Que…
-
Option and Enum.
Hi experts, I would like to ask about the relation between Option and Enum. If my existing customized table got the option field, could I change it to enum field? May I know the existing option data will be lost? Thanks.
-
BC14 Webclient cannot open card page from list
I've a custom page list (Car list). When I move mouse cursor on field primary key (Car No.) tip show "Open record XXX1 in new window" but when I click on it nothing happens. In page list property "CardPageID" was set to correspondent card page id. What could be the problem?
-
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…