-
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…
-
Output Journal Error
Dear All, I don't know why sometimes when i open output journal in NAV 2016 some routing line does not exist error popes up and my users are unable to enter their output in to the journal to solve this either i've create a new output journal batch or i've go to item table through dev environment and run item journal line…
-
An item with the same key has already been added.
During the synchronization to BC16 cu03 got this error.
-
How do i correct Invemtory valuation report that shows item with 0 quantity but value
Good day everyone, I currently work as an ERP Analyst and we use NAV 2017.Recently, when we run our inventory valuation report, we discovered there are some items that have 0 quantity but with value Please note: 1.Our Average Cost Calc Type in Inventory Setup is set to Item. 2.When we run the inventory valuation, we run…
-
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:…
-
Why is permissions on TableData not set, when user is SUPER?
Hi experts, I use Business Central version 13, CU 11, build 35820 on-premise. My user has the permission set "SUPER" on all companies. No users have any user groups. I have made a button that should import lines into "Bank Account Reconciliations". When I try to do that, I get the error: "You do not have the following…
-
NAV 2009 R2 Classic Client post inform by API + JSON
Hi, I am using NAV 2009 R2 classic client, would like to do an API post function to put PO Header and PO Line information to 3rd parties by using API + JSON. May I know how to do it? And how to get the response message from 3rd parties and showing success or error message to user / log into a table for user to check the…
-
Downloading a file from an URL in NAV 2009 R2
I need to download a file, from an URL, in NAV 2009 R2. I'm trying to do the following: - request a list of files from a server using a XMLRequest => DONE - list the files on a form so that users can select the desired one => DONE - download the file from the same server into the users' TEMPORARYFOLDER => TODO. How can I…
-
Simple Lot No. check
Hello, I need an idea how I could implement the following with around 15 to 20 workplaces. Every pallet to be processed has a batch sticker and when this pallet is processed, this batch should be checked or written to a table at the entrance to the production line. Now I don't want to set up 15 additional computers to do…
-
Routing by locations in regenerative planning
Our process is so that the purchases are planned and performed on one location and production - on another. Is there a standard setup to plan purchases and production this way and route the components through the transfer orders to the production location?
-
Calling Function in Form from Report
This is very not standard, but I have some calculation code in my item card that I want to run in a report. Essentially have a qty available, very complicated in the form. I'd like to get that number without having to repeat all the calculations in my report, would like to call a function, pass in my record from the…
-
Hyphen in Json vs. API PAGE BC13
Hi, I'm trying to create a webhook to recieve events. Json looks like this: API Page like this: detail-type properties: Response from postman: If I change the - (Hyphen) to _ (Underscore) in both Json and API page, it works perfectly. Does anyone know if there is a way to use Hyphen, since this is not a Json I can control?…
-
BC16 webservices / API DeepInsert
Hi, I'm working on a webservice / api which will is running on a BC16 OnPrem environment. It has been working out great so far, but I experience a lot of issues, when trying to insert data with header and lines. I have created my example code on https://github.com/kefdk/bc16-api (yes, I have been reading on this blog-post:…
-
Deep insert in API page problems
Hi, I'm having some trouble using API in my cloud BC. I have it working in my local docker container, but the syntax seems a bit different against my cloud BC. This path seems to work fine. https://api.businesscentral.dynamics.com/v1.0/{{tenant}}/{{environment}}/ODataV4/Company('{{company}}')/salesReturnOrder However, when…
-
Join the webinar👉 How to convert Classic NAV report to RDLC and AL format, success story
Join the webinar on How to convert Classic NAV report to RDLC and AL format, success story. The following topics will be explored during the online webinar: -Common problems while upgrading Classic NAV reports to Extensions -Introduction of Simplanova Tools and Report converter -Demonstration of how to convert customized…