-
Not allow to modify a record in some conditions
trigger OnValidate() var StatusLbl: Label 'The status of the policy has changed to: %1', Comment = '"ESP = "El estado de la póliza ha cambiado a: %1"'; begin Rec.Reset(); // --- IF para comprobar si el estado de la póliza es Aceptada o Rechazada --- if (("Policy Status" = "Policy Status"::Approved) OR ("Policy Status" =…
-
BC 17 - cannot enter table ID in field mapping from a data exchange definition
Hi. I think this is something simple that I have missed but I am banging my head against a wall! I am setting up a simple payment export. I have created the new data exchange definition, set the details (variable text and all code units etc), entered the line, entered the columns and then I go to field mapping and I try to…
-
Set-NAVServerUser to add profile to user failing, after New-BcContainer for BC 17.0.16993.0
Hi, I am trying to add a profile (role) to a user. I have created a docker image/container using New-BcContainer and then using Set-NAVServerUser as below. However, I am getting an error. I have tried various profiles ACCOUNTANT, BOOKKEEPER etc. Regards & Thanks Roddy
-
NAV 2016 cu1 client does not run on terminal server
Hi, Strange problem here. I've installed NAV 2016 cumulative update 1 on a navision-server. Installed the client too on that server. It opens fine. Now when I install the client on the terminal server the installation seems succesfull, but when I start the client it crashes. In event viewer there's a ".NET runtime"-error.…
-
NAV 2009 R2 Classic Client and Shopify API + JSON
Hello I need to integrated with our new Shopify shop, so NAV 2009, can get orders, update orders, products etc by some sort of automation. Ive created a shop i Shopify, greated a private App, got the API key and the password, and when i enter the url:…
-
Network share as URL/Hyperlink in field
Hello! We are facing the following problem: In Business Central web client, we would like to use network share as clickable links. It's working for HTTP and https protocols but for file:// protocol it redirects us to about:blank#blocked, and the field trims the \\'s from the url \\machinename\share\file.ext to it's parsed…
-
VS Code compile errors for dotnet in BC17
Hi, I'm preparing a baseapp for BC17, it is all going well but I've had an issue after installing and then uninstalling NAV 2015 on my machine for an emergency. I'm now getting a handful of .dotnet compilation issues for BC17. Note, I have repaired/uninstalled/reinstalled BC17. I'm wondering in anyone has come accross this…
-
BC Task Scheduler Retry Flow
Hello all together. Our company is in the process of upgrading from NAV 2009 R2 to Business Central. I was looking into the Task Scheduler and came across the following. Under certain conditions (e.g. table lock) a task is restarted ("Retry Flow" or "Retry Process"). The first time after two minutes, then after four…
-
Can we capture mobile device ID in Dynamics 365 BC
Hi All, We are using MS Dynamics 365 business central on premises. User is accessing application from mobile. Can we capture his mobile device ID? If any user fill the data through mobile we have to capture his mobile device ID also. Please help how can we capture this? Thanks in advance. Regards, Kishore
-
Data migration from BC 14 to BC Online
Hi, I'm a bit lost and wonder if someone can give me some tips. I'm in a process of migrating data from BC 14 to BC Online After upgrading the data, I have many tables with "warning : The table does not exist in the local instance". Some of them are coming from extensions that are not in by BC 14 on prem but others are…
-
could not find a debug adapter descriptor for debug type 'al' (extension might have failed to activa
Hello I have been using vscode yesterdag, but todag i am getting the message: could not find a debug adapter descriptor for debug type 'al' (extension might have failed to activate) I couldnt finde something on google. thanks for the help. Kinde regards Firsa
-
Publish of Extension Error
Hello, I'm trying to re-publish a perfectly running extension but suddenly I'm getting this error "Couldn't find a debug adapter descriptor for debug type 'al' (extension might have failed to activate)" using AL Extension v0.13.195601 any help is highly appreciated thanks
-
OData Connected Service throwing exception with NAV2017
Hi Everyone, Im attempting to send data to Dynamics NAV 2017 from a C# Application via a ODataV4 Connected Service. However when saving the changes tracked by the connected service extension in Visual Studio i am getting the following error. The context URI '[i]ODataV4 Endpoint Redacted[/i]' is not valid for the expected…
-
ODATA 'company' name issue (..."O'Reilly Corp"?)
For a NAV 2016 CU48 instance we have published pages as web services, to be consumed by ODATA. We consider them stable. However we have a company called for example "O'Reilly Corp" and the apostrophe is causing us some headache. This is an issue that should be resolved by reading the ODATA specification documentation. For…
-
Purchase Variance with Items of type Service - NAV 2018 (ver 11)
Hi everyone, We are selling services to our customers that are handled by our partner (using the Purchase Order and Items of type Service), then, when the service was actually provided, we're receiving back the invoices from the partner. Sometimes the amount in the partner Invoice is equal to the original Purchase Order,…
-
A logical problem i don't know how to resolve (code comments in spanish)
I have to import orders from an XML that contains:* Customer No && Order Date (Header) * Line Type && Item No && Quantity (Line) The point is that some headers has the same customerNo and Order Date combination so I have to put in that case the lines into the same order. This is my xmlport code: The filter doesn't seems to…
-
3CX phone system NTLM auth with Nav2016
I am in the process of linking a 3CX VoIP telephony with Nav2016. I got some web services where I can get the data out of Navision perfectly when logging in manually. Now this has to be done automatically and the flow is as follows: -> A customer calls the phone number is passed on to Navision, in return we get a Queue…
-
Converting Text to Date
Hi, can anyone say to me if it's possible to convert Text Data to a Date Data? I'm importing a CSV text file to headers and lines and I want to pass one information to the Order Date date field. Thanks!
-
Get user input
Hi All Using business central 2020 (so 100% AL). I have a codeunit that gets called from the sales line functions menu. I need to get a percentage from the user. How do I prompt the user for a value? Thanks mark
-
Export XML and Save To Local Directory
Hi, i am running BC16 on prem on a local docker and want to be able to export an xmlport file to my local machine. My code is as follows below, but rather than saving it automatically to a specified folder it is saving to my downloads. OutputFileDirectory is set to 'c:\TestExport\' and OutputFileName is set to…
-
customize standard C/AL report as AL
I'm trying to make a customized version of report 4 i BC ver. 14, so I've ExportToNewSyntax and Text2Al, this gives me 4 files *.al, *.rdlc and 2 xlf, I have added the al and rdlc to my vsc project, here I have added possibility for Dimension filter and corrected the RDLC path in the al file, this all went smooth, but when…
-
How do I add a pdf/base64 to a cloud api?
Is it possible in the Cloud to generate a pdf document and transfer that to an API? I am trying to create an API for the "Purch. Inv. Header" that includes a printed version of the Invoice as Base64. I have been trying to use the Report.SaveAs funtionality, but keep getting an error stating that unknown language has been…
-
How to handle manual consumption WITHOUT picking.
Hi Guys, I have a customer that produces beer. The location is set up for picking so they can pick based on FEFO. On every production order they need to record how many liters of beer was used to produce, say 5000 bottles of beer and then register this on the production order. Sometimes they use 2045 liters, sometimes…
-
Web service Azure authentication with OnPrem NAV installations
Hi, I am using NAV2017 OnPrem with Azure Authentication. Managed to get Azure authentication working with the Windows and Webclient. But, could not get it to work with Web services. How does one configure Web services to work with Azure Authentication? Jordi
-
BC 2020 - how to select records (like select more) in AL
Hi All Trying to write an extension that will give users a function on sales lines. When they run it, it will select certain records in the lines (based on an internal calculation, so that they can then hit Ctrl-C and have the selected records copied to clipboard. In the UI, you would click "Select More" and then select…
-
Unittesting and mocking?
Hi everyone this is my first post here so please be gentle. I was recently granted the honor of my company to start getting to know the inner workings of NAV and now BC14 on-prem in order to be a better orderer for our dynamics partner. Being a C#-developer I soon became interested in getting to know how to code in C/AL…
-
How to change unit price in Jobs?
I am a very new Junior NAV Consultant, and I'm hoping someone here can help with what is probably an easy question. My client doesn't use standard unit pricing for Jobs. The cost is static, but they change the item prices based on the job. I have created a sample/test Job for them, but now I can't figure out how to edit…
-
Insert through API - OnClosePage trigger?
Hi, I have created an API (BC16.5 version), where I have header and lines in my definition. After the retrieval of the last line I want to do some processing-code. But how do I trigger this? On a normal page I would use the OnClosePage()-trigger, but that is not possible on an API Page. Is there another way? Just to sum up…
-
Edit in Outlook + Citrix
Hi Experts, What needs to be done in order to enable editing emails in local Outlook when NAV/BC is Citrix hosted? Or is this possible? I just have a feeling that one customer where able to do that in NAV2017, but not sure which Citrix setup (file association?) was behind of this. -mikhael
-
Can I suppress the question regarding communicating with external service?
I have created a codeunit that uses he buildin HttpClient to GET a URL. How can I structure my code so that it supresses the question to allow the session to communicate with the external resource? I understand that the user can press "Always allow", but I also need the job queue to be able to handle it, so I can't have…