-
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…
-
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…
-
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…
-
Upgrade Record Links
I am having trouble finding help with upgrading Record Links from NAV 2015 to NAV 2018? Nay help would be appreciated. The client did not bring over all their old data, like customers and items. I have tried following Gunnar's suggestion found here: https://dynamics.is/?p=1193. I was able to get the data out and decoded…
-
Export virtual tables?
Hello everybody, is it possible to export virtual tables like 2000000001 2000000007 ... with all fields as a .txt file?
-
Changes in VS code not reflected in BCOnline
Hi, I am using a trial BCOnline. But for all intents and purposes, this should be similar to BC Online Production environments. I have successfully connected to the BCOnline using VSCode, and successfully downloaded symbols. When I try to run the HelloWorld.al, it does not get published to BCOnline. When I do the same…
-
Is there a way in the Classic Client to decrypt files encrypted with PGP?
Hi Forum, I received encrypted data from a financial service provider. I would like to decrypt this data and import it with a dataport and assign it to the customer. Except for the decryption of the file, everything runs automatically. It would be great if someone already had experience here. Best regards Tom
-
Nav 2016 koppeling met 3CX telefooncentrale
Ik ben bezig met een koppeling te maken van een VoIP telefonie met Nav2016. Ik heb enkele webservices gekregen waar ik bij manueel inloggen perfect de gegevens uit Navision kan halen. Nu moet dit automatisch verlopen en is de flow als volgt: Een klant belt wordt het telefoonnummer doorgegeven aan Navision, in return…
-
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
-
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…
-
BC TechTalk - a FREE virtual event for technical BC people starts tomorrow!
BC TechTalk - a virtual event for technical BC people starts tomorrow.⏰ Be prepared for: ✅17 sessions on trending and insightful topics for the BC community. ✅21 BC professionals from all over the world. ✅Q&A after each session - find answers to all of your technical questions. See you on Thursday! Claim your…
-
BC16.2 How to solve the Yellow Warning of Purchase Price
I met this problem while I was using " : Record Purchase Price" and " : CodeUnit Purch. Price Calc. Mgt.". It doesn't go wrong, but there is a yellow underscore under the Table " Purchase Price" and CodeUnit " Purch. Price Calc. Mgt." , just like the image below. And if i put my cursor on it, it will show the explanation…
-
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…