-
setCurrentKey no longer crashes if missing
Hi all, I just want to confirm something. I would say in old nav versions if they key didnt exist it simply used to fail. It seems like, now it searches for best ocurrence of index fields for the given setcurrentkey:…
-
External application to access Dynamics 365 SQL database
Hello everybody! In our organization we have an "on premise - Dynamics 365 Business Central" server that runs our main business database. It runs version 14, that is, Dynamics 365 Business Central Spring Release v14.00 I believe is also called Wave 1 2019. We now use the "web" client (after many, many years of using the…
-
Rest Call to Cognitive Service Computer vision in AL, Header Issue
Hi I'm trying to do a POST Rest call to the computer vision service of the Azure Cognitive services in the new development environment in AL using the HTTPClient as seen in the example of this blog post http://www.kauffmann.nl/2017/06/24/al-support-for-rest-web-services/. When using the code underneath I'm having the issue…
-
Issue in PO Workflow - Status is not getting changed.
Hi All, [NAV Version: 2018] I have created a new workflow for Purchase Order from the template. There are 2 approvers need to approve a PO. Even after the final approver approves, the Status is not getting changed to RELEASED and still showing as PENDING APPROVAL. When I checked in Restricted Records table, it is showing…
-
Better way to insert dimension set ID from AL Code (BC SaaS)
Hi Guys I'm inserting sales invoice lines from code and couldn't find an elegant way of creating and inserting dimension set IDs.
-
Set body for POST request
Hello mibuso community, I am trying to send a post request (no authorization required, not even simple user name and password). I need to send JSON data in the body, so I am trying to put the JSON content into a Text variable and trying to pass it to the HTTPClient.POST method (in its 2nd parameter). When in AL (Visual…
-
Printing Blob Field
I have pasted this text from Word Document to a NAV Blob Field: ~!@#$%^&*() ‘something’ “something more” end And printed this blob fields through a NAV report as pdf, it looks like this: It could not decode the Left Single Quotation, Right Single Quotation, Left Double Quotation, Right Double Quotation when printing. This…
-
Layout of side by side subpages
Hello guys I have a question about page layout. In my company we use Navision 2015 and we have a page that consists of several subpages. Two of the subpages, one contains a list view and the other a cardview, are side by side. Navision automatically sizes the subpages that way, that the card sub page always gets 2/3 of the…
-
NST Services are using different amount of Memory
Hi, got a new Job in the Developmend Field and have to look for the Dev-Server regarding Performance etc. On the Dev Serrver there are different NST's for different usage Configured. I've seen that they are using different amounts of memory. After rebooting the Server this will varying between 200MB and 2GB without any…
-
Printing slow in Nav2017 when logged on in Citrix 1912 cu3
Hi all! We have an enviroment with Citrix 1912 CU3 (Windows server 2019) and Nav 2017 CU51. We have an issue with Citrix UPD. When Printing requisition order for exemple in Nav the printer only print 3 pages at the time and then it goes down to rest startup printing 3 more and so on. Has anyone else the same problem. We…
-
VAT Registration in Business Central kind of broken
Hej guys, I am facing the issue that my VAT registration always tells me, adresses and names are not valid. When I am validating my customers VAT ID, the VAT ID itself is shown as valid. But clicking on details (VAT Reistration Log Details (227)) always leads me to the same situation: Names and adresses are not valid. I…
-
QRCode support for BC Online
Hi, Barcode is supported natively in Dynamics BC 2021 wave 1 onwards. https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-report-add-barcodes Question is, is QRcode supported in Dynamics BC online? Or It only works with using a 3rd party qr code generator service?
-
[BC140] Test for OnOpenPage event
There is a pageextension that changes the "Document Date" to WorkDate() when the page opens. It is working fine - using trigger OnOpenPage(). I'd like to write a test for that:procedure IsSalesInvoiceDocumentDateWorkday() var SalesHeader: Record "Sales Header" temporary; SalesInvoice: TestPage "Sales Invoice"; begin…
-
Tapatalk
Hello Admins. One simple question, could you implement Tapatalk support for this forum? This forum would be much handier if we all could access the site wherever we are. The plugin is free for forums to use. http://www.tapatalk.com/
-
copy text after hyphen/dash
Hello, how can I copy text after "-" or just delete the text before the "-" I tried copystr but it asks me for position and that could be dynamic. I have text := 'code - text1 text2 text3 text4 text5 text6'; int := strlen(text,'-'); text2 := copystr(text, int+1); what is a better way to write this?
-
Can we use same container number when doing transfer orders?
Hello! We need to transfer orders from our main facility to our 2nd facility. However, we are not able to register the pick. We get this error "Container CONT1856055 may not exist in more than one Bin Code". I believe its because we are using same container number where output was originally made. This is to avoid extra…
-
How to make web service with links from items?
Hi experts, This is regarding Business Central cloud. On an item, you can make several links to files on some public server. I would like to make these records available for a web service. How do I do that? I can see that this has something to do with the table "Record Link" (number 2000000068). But I need to show the item…
-
Error An internal error has occurred coming after extension is successfully published
Hi everyone, "Error: An internal error has occurred" Error coming after the extension is successfully published Thanks in advance
-
Error when I print Purchase order more than 2 times
The following error is appearing in one of my clients when printing a purchase order: The indexing 3 in the array is outside of the permitted range.
-
automation not initiated
Hello, I am getting an error when trying to open word from NAV. Its saying automation hasnt been instantiated, see below. Not really sure how to fix it, anyone got any idea? Microsoft Dynamics 365 Business Central The automation variable has not been instantiated.OK
-
Specify Condition on a Table Relation Property
Hello everyone, I'm creating a table in which there's a field for which is specified the property Table Relation = Item (so I can scan the item and select the one which I want). I would like to delete from the drop-down list which appears the items which have been already saved in my table (I think I need to specify a…
-
Business Central 140 - Debugger not working
Hi there, I have one trouble on new server with new installation (not upgrade). Debugger not working. At first P9504 was uncompilable because Control Add in that could not be loaded. After replacing Control Add ins from local machine where everything is ok, page can be compiled but the problem with debugger still…
-
Change the default action associated with right click Edit on a list page (Nav2016)
Hi, How do I define the default page action for right click edit or the double click action? I have a list page object in my system that is doing this (It runs a small bit of code) but I don't know how or where the link between the double click (or right click edit) and the action code that is triggered is created. I have…
-
ODATA and STARTSESSION
I want to use STARTSESSION in the oninsert trigger of a table. When I create a record in the page it also works. But if the page is shared as a web service and the record is created via ODATA, then STARTSESSION is not executed. I would only be left with the task queue as a trigger and process the data further. Is there…
-
Power automate - cloud flow send files to BC SaaS
Hi All, My client is running BC SaaS (latest version V19) and some records from 3rd party cloud solution are being send into the BC SaaS via cloud flow that I designed in the Power Automate. I am looking at blob storage module in BC for potential solution of recieving files via cloud flow. Is this going to work? Goal to…
-
Set boolean to True when a Item Category
Hi all, In a report I want to print a text if 1 of the articles in the order contains a certain Item Category Code. Example order with these items: Item No. Item Category Code 10000 X 10010 Y 10020 Z If 1 of these items contains the code X, the text must be printed, otherwise not. In this case, the text must be printed. I…
-
NAV WORKFLOWS
Good day to you all. I have workflows which are present on the NAV 2017 System. However, I would like to modify them. I would like to know what happens to journals, batches and entries which have already been sent for approval when I modify an existing workflow. Thanks
-
Temporary tables and concurrency
Hi Guys I have created a report based on a temporary table (combine sales orders and archived SO) and each time you run it , DELETEALL command is issued to delete existing records before loading new ones. Am I correct to assume that if two users are running the same report at the same time, there are two instances of the…
-
Programming web solutions on top of classic client
Dear all, What solutions are you guys using for developing web and mobile interfaces for interacting with Dynamics NAV? Is there any low-code or no-code framework available for Dynamics NAV?
-
Loading only 10000 Records from large table ( Cust. Ledger Entry )
Hi, so even after applying filters the table contains still 800.000 - 1.000.000 records. This seems to be too much for the system ( loading for multiple hours ) and I only need 10.000 at a time anyway. Is there a way to only load 10.000 at a time without an extra filter ? something like a "SELECT TOP (10000)" ? Cheers.