-
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…
-
objectID on page open
Hi all, Hope someone can help. Is there any way to return the pageID when the object gets opened? I know there isn´t anything in NAV CU1 I can find, just tables you can hook to (OnAfterGetDatabaseTableTriggerSetup etc). however, perhaps someone knows a way, using some external dll or similar. thanks a lot.
-
AL code - use file saved within AL project folder in the code
Hey y`all, Might be a dull question (Google didn`t help either), is it possible to use/reference a file (let`s say RapidStart package) which is stored within an AL project in a separate folder, and import it from code? Thanks a lot in advance.
-
NAV 2016 in Docker Container returns "Could not create SSL/TLS secure channel" on web request
Hi all, We do our in-house development in local Docker containers. We have a shipping solution that communicates with Fedex web services. Since the last update of the NAV2016 Docker image artifacts (approx Nov 1, 2021 - perhaps a week earlier), when running a Fedex web service request, we receive an error "Could not create…
-
Why is SMTP Relay necessary
Hi, sending an email from the service tier server using following code (via powershell) works fine: $EmailTo = "<email>" $EmailFrom = "<from>" $Subject = "Test" $Body = "Test Body" $SMTPServer = "<smtpserver>" // is an exchange server $SMTPMessage = New-Object System.Net.Mail.MailMessage($EmailFrom,$EmailTo,$Subject,$Body)…
-
OnAfterValidate fail if Modify(true) on purchase line - line does not exist error
Hi Guys I have this code on purchase line Onvalidate on quantity field as a table extension on purchase line table. With Modify statement it doesn't workmodify(Quantity) { trigger OnAfterValidate() var PurchHeader: Record "Purchase Header"; begin PurchHeader.Reset(); PurchHeader.SetRange("Document Type",…
-
Cloud BC Integration to WooCommerce
Hi All, any recommended app that can integrate Cloud BC to WooCommerce? Some of the Sync features we need : From Business Central: Business Central products (Item card + Item Attributes) to WooCommerce Products Business Central Stock Level real time sync to WooCommerce Business Central Prices to WooCommerce Business…
-
How to Skip Confirmation Message for Posting in Item Journal?
hi All, I have created new module. after insert Item Journal Line, i want to immediately post it. how do i skip this confirmation message? my code :ItemJournalLine.Insert;
CODEUNIT.RUN(CODEUNIT::"Item Jnl.-Post", ItemJournalLine);
-
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…
-
SQL Profiler with Business Central
Has anyone successfully used SQL Profiler with Business Central? I'm working with a BC15 On-Premise installation. I'm trying to user SQL Profiler to trace some locking sequences. Something I've done countless times with NAV. The problem I'm having is SQL Profiler seems to lock up BC. My BC process will not end unless I…
-
Copy Company
Hello, I am a SUPER user and trying to copy a company in the Sandbox BC Cloud 18.5 and getting this error message Any feedback will be greatly appreciated.
-
Restore an individual line from the Sales Order Archive
Hi All, I have a developer license and I'm trying to restore only the lines selected in the Sales Order Archive instead of restoring the whole document or at least I need to have the option to restore only the lines selected or to restore the whole document Can anyone help me to create such a function? Thanks!
-
Grid to control the width
Hi all, Do we possible to use a grid control that is divided into 3 groups with different width? For Example, group A is 50%, group B is 30% and group C is 20%. Version: US Business Central 19.0 (Platform 19.0.29884.30666 + Application 19.0.29894.30693) Thanks.
-
DLL Extensions call a IEnumerable<string> C# Function
how can i use this function in nav bc c/al i want send a list of userinformation in nav bc and get the list back
-
Credit memo for sales invoice related to blanket order
Hi all, When you create a credit memo (using the functions Correct, Cancel or Create Corrective Credit Memo) the fields 'Blanket Order No.' & 'Blanket Order Line No.' are not copied from the sales invoice lines to the credit memo lines. Result is that the quantities to deliver on the blanket order are not correct. Someone…
-
Insert data into a Azure Postgresql Tabelle
Hello, I would like to fill several tables in an Azure Postgresql database from Navision (Onpromise). How could I do that. Thanks stony
-
ChangeCompany in Gen Journal Line
Good Afternoon, I have a problem with my Company when I try to use CHANGECOMPANY in the page of Gen Journal Line for field "Applies-to Doc. No." in the table Customer Ledger Entry. I create a new page but still not work the filters I can only see the results of the main company. I have this Code. I use the changecompany…
-
how to block download source for cloud BC version 19?
Hi All, i notice there is no more ShowMyCode for app.json in BC 19. how do we block download source? i used this, but still able to be downloaded"resourceExposurePolicy": { "allowDebugging": true, "allowDownloadingSource": false, "includeSourceInSymbolFile": false },
-
Decode Document Attachment (pdf file) to Base64
Hi All, how do we convert Document Attachment from Posted Sales Invoice to become Base64? I just cant find any blob file from Document Attachment table Please advise Thanks.
-
Calcdate for Multilanguage in Cloud BC
Hi All, I have customer in cloud bc. some of users are using English, some are using Danish. I have created some of the date using calcdate e. g : StartDate := Calcdate('-CY',Today); if user select English language then no problem. but if user select Danish, then it will show error message : "Fejl: Der skal indgå en…
-
Web services question
We are building an integration to push sales invoices to BC and currently using ODATA and creating the header and then sales invoice lines separately I'd like to do these as a single transaction and think the right way to do this is a AL Web service that takes the header and an array of lines and commits or rollsback…
-
Services Default Time Zone not working
Hi, Can anyone every figure out how to get the "Services Default Time Zone" setting in NAV Administration working? I am using NAV2017. I tried setting this to "Server Time Zone" and also other time zones. But it does not seem to work. I tested this using web services. When I specify "DateTime" in a web service client, it…
-
Undo Receipts
Hi we have a situation, where we have received X quanity from a purchase order in our warehouse location.That X quanittiy was tranasfered to Internal Locations via Transfer Orders. Now the buyer realizes that there is some issue with the Dimensions on PO, so thinking to Undo-Receive it and receive on correct Dimensions.…