-
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…
-
What’s Coming to Business Central? [Directions EMEA 2021 Reflections]
Founder of Simplanova Petras Butenas is sharing his reflections on the main announcements made at Directions 4 Partners conference in Milan. If you could not join Directions EMEA this year or if you missed some pieces, please find the recoupment of the main points in our latest blog post:…
-
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?
-
How to check multiple checkboxes on a page based on conditions
Hello everyone, I'm having trouble with a feature I'm trying to implement: I have this "Data Page" that shows Customers and their respective invoices below them: So I'm trying to click on the checkbox from the line where "Type = Customer" (Marked red) and the lines where "Type = GL Account" should get checked (marked…
-
Print Item.No in barcode font that scans
Trying to use the 3 of 9 barcode font on a label, '*' + Item."No." + '*', barcode generates, prints, but does not scan using a barcode scanner aredmond@thompsonpump.com
-
Microsoft Validation Error, While I changed field's data type from Option to Enum in BC V-19.1
Hi, I have a table with one of it's field is "Document type" as option. it has option members 'Quote,Order,Invoice,"Credit Memo","Blanket Order","Return Order",,,,"Add/Remove"'. Then I have changed this field's data type as Enum "Sales Document type". This Enum is Microsoft's standard and has all the option members except…
-
Any Visual Studio Code AL extension for removing fields or variables without references?
Hi, everyone. This is my first question in this website so, I apologize if I do something wrong. Currenty, I´m developing in AL with Visual Studio Code. The project has many fields without references: Does anyone know of an extension that allows automatic removal of these fields or variables? Thanks so much! Regards!
-
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
-
BC17 - OnOpenPage code executes before page is shown - How to avoid?
Hello All, I have an http call (OnOpenPage trigger) and based on the result, fields on a card page are populated. When I open the page, the browser cursor (mouse pointer) goes into loading, the existing page becomes unresponsive 'Working on it' message is displayed. After 10+ seconds the card page is opened. I moved the…
-
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,…
-
NAV 2013R2 integration question
Hi all, I have a client running NAV 2013R2, and they are looking for a credit card processing add-on. I've never worked with 2013, so I'm not sure if there's anything that would work. Any suggestions would be appreciated. Thanks.