-
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.…
-
Make Posted Sales Invoice Page editable true
I tried to make posted sales invoice page editable true. I referred following website to get an idea. https://yzhums.com/16756/ In business Central (SaaS), Can we do this kind of development?
-
Business Central Extension Help
I'm not sure if there is a better place to ask this... We are fairly new to developing extensions in Business Central. We have over 20 years experience developing in NAV/BC C/SIDE. We've made great progress and have several extensions built using the number range our company was provided by Microsoft for extension…
-
Migration process from NAV2013 R2 with German localization to BC latest version (Saas)/OnPrem
Dear All, I have a enduser who has their HQ in Germany, where they currently have NAV2013 R2 with German localization and multicompany database, and they would like to migrate to BC and since they are not keen to have database in cloud, they are thinking to have some private cloud 9, since IT Director would like to get rid…
-
OData empty/0D date filter
We have a challenge with OData V4 webservices. We have exposed the Sales Price table (7002) as webservice through a custom page object. For example we want to show all the Sales Price records where Starting Date is empty/0D. I have tried several ways to filter on empty dates in the OData filter but or the webservice return…
-
A safe way to use temporary records
Hi Guys I have tried a couple of variations of the temporary record to display results on a page and report. First below examplevar TempVend: Record Vendor temporary; begin TempVend.Init(); TempVend."No." := '30000'; TempVend.Insert(); TempVend."No." := '10000'; TempVend.Insert(); TempVend."No." := 'blah';…
-
AWS Signature Version 4 - BC Cloud for AWS API
Hi all, This question is for latest BC cloud implementation. Has anyone had experience with calling an AWS API which requires a signing key for Signature 4 without using a .net dll? It needs to use an algorithm of HMACSHA256. Which is fine, as it is possible to do this via the GenerateHash function within the Cryptography…
-
Azure Blob Services API
Has anyone come across any useful information\documentation on this new feature in BC19?
-
I want to send pfx certificate for handshake with other details to Bank API for payment
I want to send pfx certificate for handshake with other details to Bank API for payment I am using XMLHTTPConn ClientCertificates but not getting proper syntax to add in HTTP request header
-
Identifying and logging database locks
Hi Do you know a workaround or script to implement in a NAV2017, where we can log who has created a deadlock for other users? Right now we can use sp_who/sp_who2 when it happends, but this only gives us the servicetier account, not the actual user of NAV. My thought is that, this relation has to be somewhere in the db,…
-
Business Central Odata authentication
I am trying to configure the odata (v4) webservices to access Business Central (V18) data through Excel Power Query. Unfortunately, every time I try to log in, I get an authentication error. Even using the EDGE or Chrome browser the same thing happens. Trying to use Internet Explorer or Firefox instead I can read my data.…
-
2009 R2 Latest Build Download
Okay I give up. Where can we download the latest build of the full NAV 2009 R2? Trying to do an upgrade and need the dvd. TIA Chris