-
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…
-
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…
-
How to print batch sales invoice but with separate PDF
Hello comunity, I want to print multiple posted sales invoices. With Print->PDF the system group all the invoices in one PDF. The request is to print multiple sales invoice but in separate PDF. Does anybody know how can I accomplish this ? If there is any way to save the in different pdfs on a specific location ? Thank you.
-
Pillars from Directions EMEA 2021 by Microsoft MVP for Business Applications Stefano Demiliani
Pillars from Directions EMEA 2021 by Microsoft MVP for Business Applications Stefano Demiliani: Dynamics 365 Business Central growth on adoption and its improvements in all aspects. Have a look at Simplanova's latest blog post and find important messages that were given to partners and customers during the…
-
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.…
-
Problem with Visual Studio Code (Publish with debugging, Publish...)
Hello guys, I have a problem with my Visual Studio Code and I dont kwow how to fix it. In my office this works, but in my house with a VPN connected to my office no, I think its an timeout of Visual Studio cause the ms of the extension is around 3000ms but my connection its good. I try to connect with my mobile internet…