-
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…
-
Receive a Message from Service Bus Queue via .NET DLL
Dear all, I would like to use a .NET DLL to process Azure Service Bus messages in NAV 2017. I have imagined that I receive Service Bus Messages from a queue via the DLL, then fire an event in the DLL, which is caught in NAV via an event handler. The event handler has a string as parameter, which contains the message. Here…
-
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 '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…
-
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…
-
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…
-
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,…
-
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…
-
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…
-
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…
-
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
-
Output Journal
We are operating out of Microsoft NAV Dynamics 2013R2. Hello, of our users cannot access to their output journals. She entered a line with incorrect production order by mistake, did not noticed until she tried to post and wasn't allowed. However, the this order was being finished in a 2nd user's journal about the same…
-
Automated Testing - Post routine via a page
Hi everybody, I try to create automated unit tests (in BC wave 2 version 15) but I have a problem with one test. I tried to post general journal lines via a page action but I get the following error: "Unhandled UI: Confirm Do you want to post the journal lines?" And this is my code: [Test]…
-
XmlAttributeCollection initialization in AL
Hello, I would like to use XmlAtributeCollection, but I have no idea how to initialize it. Here's my sample code: var XmlAttrCol: XmlAttributeCollection;
begin XmlAttrCol.Set('attr1', 'value1'); XmlAttrCol.Set('attr2', 'value2'); XmlAttrCol.Set('attr3', 'value3'); XmlAttrCol.Set('attr4', 'value4');
end; I am getting an…
-
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…
-
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…
-
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
-
BC17 - Creating XML Node namespace from code
Hi, I want to make an XML File from code in AL. I am using XMLDoc and its related data types. I have made a codeunit that handles almost everything what I need. I have a problem when I am setting attributes to the XmlElement. This whole thing is not working if attribute name contains ":" (colon). I know that colon means…
-
ERROUR ROUND PURCHAS INVOICE
Hello , i have a very stranger message when i posted purchase Invoice ( MSG(Amount, needs to be rounded in Gen.journal Line Journal Template Name=",Journal Batch Name=",Line No.='0') can
-
can't access web services with basic authentication - you don't have authorisation to view this page
Hi I'm having an issue with connecting to a nav service which is set up with NavUserPassword authentication. It's to be used from PHP / SOAP. To test it, I'm opening a browser page to the service url and although it prompts for my username/password it then comes up with an error that i don't have authorisation to view this…
-
Modify a Record from a RequestPage
Hello NAV experts, Is it possible to modify a Record from a RequestPage ? Here is a code example that generates an Error "ID=0" dataset
{ dataitem(CalculLoyerEntete; "Calcul Loyer Entete") { DataItemTableView = SORTING("ID"); column(Name;Name) { } column(DateMail;FORMAT("Creation Date Last Mail",0,'<Day,2> <Month Text>…
-
Codeunit based SOAP Webservice with XmlPort arguments
My function looks like this: customerprice(VAR Response : XMLport "Response Port";Request : XMLport "Request Port"). I have no idea on have to handle these XmlPorts in C# when creating a test program. Any ideas on how to get them from and to xmlDOMDocuments?
-
Incorrect Page refresh and User MetaData
I have an issue with a page refresh. I added to a list page that is related to table x with some fields from table y. In order to run the page with the correct data from table y, I added a line of code to page triggers OnAfterGetRecord and OnAfterGetCurrRecord: 'IF TableY.GET(Key) THEN; That works fine. However: when I add…
-
Run a report from a radio button selection
Hi All, I'm trying to create a simple form with two radio buttons. If radio button1 is selected then open Report X. If radio button2 is selected then option Report Y. Please keep in mind there are three buttons which are, OK, Cancel, Help. The Report should run once the radio button in the form is selected and the OK…
-
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…
-
Technical Upgrade - The file that you are importing is not based on the RDL 2010 schema.
Hi, I'm running a technical upgrade from NAV2017 database to BC14 (on premises). I've prepared the database, compiling all the objects, etc. When I finally open the NAV2017 database with the BC14 development environment, after some hours of work updating it, it shows the error: The file that you are importing is not based…
-
BC OnPrem Upgrade question
I am trying to upgrade a BC15 database to BC16 According to microsofts instructions, https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-unmodified-application-v15-to-v16 Task 2 step 4 states Unpublish all system symbols. Does this mean to unplublish ALL published extensions symbols OR…
-
Dynamics NAV 2017. How to create Excel via Excel Buffer with ASCII Characters
Hello mates! I have problem with ASCII symbol transfer from Dynamics NAV to Excel, creating by C\AL using Excel Buffer. There are Table with text type field "Export Mark DataMatrix", it is a string which include ASCII symbol (Code 29, Group Separator): When I try to generate Excel by Excel Buffer I have following result:…