-
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.
-
Upgrade Windows OS version NAvision 2009 R2 Application
Hello, My navision 2009 r2 application is installed on windows server 2008 R2, I would like to know if it's possible do direct upgrade to 2012 R2. I'm not telling create a new machine. Thank you.
-
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.
-
Windows client issue
Windows client is resetting in every 4-5 minutes This issue only happens on Windows Client connected to particular Server instance and we compared the server instances and are same. Its showing below message “The server is either unavailable or your connection has been lost. Do you want to attempt to reconnect?” I am…
-
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…
-
I am designing a form and subform in classic based on the item table. How do I add a filter field
I want to create a filter field that will allow filtering by inventory posting group. Please someone give me some code
-
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…
-
How to invoice deleted purchase order that was received only but not yet invoicedd
Our PO was deleted now we can't invoice it even using get receipt line as it will look for the PO line
-
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.
-
NAV2009 on Server/SQL 2016+
Does anyone know of a solution still running NAV2009 but on a newer MS Server OS (2016+) and MS SQL solution (2016+)? Or alternatively stopped an update of Server/SQL from doing this for any reason, bug etc?
-
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…