-
Nav Events
how to track changes of Nav table through the Events
-
HttpClient and TLS compatibility
Hi, Currently I have been trying to integrate a website with Business Central 19 saas. The website doesn't have a SSL certificate, so I need to skip its verification when sending https GET request. Earlier I used ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12 to use TLS protocol while calling a…
-
How to send email with 1 email account ? (not SMTP)
Hi all, I have customized something that send notification to vendor using SMTP account. so no matter who click send email, it will be sent using SMTP email account. (let's say : admin@abc.com) understood that SMTP is no longer can be used in BC 20, so we should use email account. but how do we set only this email account…
-
The date is not valid
Hi all, We are going through an issue where we can't "View" or "Edit" one of the customers due to the following error I tried to debug it and here is where it's complaining Does anyone know what is the reason behind such an error message and how it could be resolved? NAV Version is
-
Missing Horizontal Scroll Bar - NAV 2015
Hi, Got a really strange issue for one user. Within Sales Orders (only this page), they have no vertical scroll bar on the subpage so cannot see all the columns (need to scroll right). Oddly if they page is opened very large (so it spans both monitors) the scroll bar appears. Shrink it down to 1 monitor and it disappears.…
-
Display all sessions under Database information
I'm running NAV 2009 R2 (Build 32012) classic client under SQL-2008 R2, simple security model, no traceflag. I can't manage do display all sessions for a non-sysadmin sql-database login with traceflag 4616 set off (with traceflag set on, it works). My database login TEST has got "VIEW SERVER STATE" permissions. (Each sql…
-
OAuth2.0 Redirect URL for Field Service
Hello everyone, We have a Business Central On-Premise version connected with Field Service web. The basic authorization was depreciated and we are trying to configure the connection with Dataverse, but we are having issues with the Redirect URL for Field Service. Does someone know the correct generic Redirect URL? Do you…
-
Display Guid on Page and Report in AL
Business Central SAAS Hi hope someone can help, I have added the SystemModifiedBy field to a page and it returns the GUID of the user. Is there a way I can change the value returned so that it shows the user value as it seems to show it if I hover over the returned GUID on the page. field(SystemModifiedBy;…
-
"Could not create SSL/TLS secure channel"
Trying to fetch data from external web service using BC client, but keep on getting the error "Could not create SSL/TLS secure channel". When using web browser the service response is OK. Any idea? Regards
-
MediaSet in temporary records
Hi! I'm building an image gallery page. The pictures should not be stored to the database but to the server folder. I am able to implement this by importing the file to the temporary table Media or MediaSet field Rec."Picture Media".ImportFile(FilePath, ''); I notice that each time when creating the temporary records, the…
-
SetSaveStream - Document Attachment
I'm trying to add a Document Attachment record via an Unchase Connected Service to a Microsoft Dynamics NAV database in C# (Visual Studio 2019). I downloaded the XML metadata from a Dynamics NAV URL. In Visual Studio, I perform an Add / Update Unchase Connected Service and point it at the metadata file. This process…
-
Subscribe on a custom API?
Hello! I'm trying to subsribe on a custom API that was created for the customer, but I can't get it to work for some reason. For subscribing on a resource I post to this URL https://{{baseurl}}/v2.0/{{tenant}}/{{environment}}/api/v2.0/subscriptions with the body { "notificationUrl":…
-
Simple boolean question
hi, i have the follwoing question.. what does this do boolean1 := not rec.boolean2
-
Sort by two columns
On the Payment Journal, when the user clicks on "Suggest Vendor payments". I want to sort first by Description, and then each Document No. should be sorted from the lowest to the largest number as well. Just as follows I tried to SetCurrentKey(Description) but that would sort the description only.
-
how to calculate planned Receipt date for POs?
Hi, Please share the calculation behind Planned Receipt Date in purchase Order lines with requested receipt date? I think Planned Receipt Date must be same as requested Receipt date. But in my PO's , it is not coming as true. in my PO's planned receipt date is always equal to expected receipt date. Why So? Please help...…
-
why my coding some times can't locate the records?
hello I meet a issue based on the Virtual Table: file in Navision 2009,can I discuss with you? I am doing the code like: (the ImportFile is the record based on File Record) ImportFile.RESET; ImportFile.SETRANGE(Date,WORKDATE); ImportFile.SETRANGE(Path,ImportPath); ImportFile.SETRANGE("Is a file",TRUE);…
-
Which version is this?
Why do I have to select"platform": "11.0.0.0",
"application": "11.0.0.0" in VSCODE to access this installation? I thought this is BC14 ?
-
Report Based On Temp Table Not Working
Hi All I have a report based on a temporary table (TableType = Temporary) in BC SaaS v19. If I comment out the table type = temporary then all works, however temporary table does not provide nay results (empty dataset)table 60030 SalesInvoiceCreditTemp
{ Caption = 'Sales Invoice & credit Temp'; [b] TableType =…
-
Danish version of Business Central
Hi experts, I have this question for the Danish Business Central users: Jeg har en bogført købsfaktura i Business Central cloud med danske apps såsom "Payment and Reconciliation Formats (DK)". Når jeg prøver at kredittere den via knappen "Ret", får jeg fejlbeskeden "Den valgte betalingsmetode er ikke en FIK-betaling..".…
-
Calculate derogatory depreciation quarterly instead of yearly ?
Hello everyone, One of our client wants to calculate his derogatory depreciations quarterly instead of yearly, but the calculation doesn't seem to work. To be a bit more specific, i have here an example with a linear depreciation calculated over 15 years and a derogatory depreciation calculated over 10. As long as i use…
-
Reference from BC customer running > 700 users
Hi, We have a far gone prospect with ~800 users. And I'm now looking to get in contact with partners who have a customer or customers with similiar amount of users. The reason is that we would like to give our prospect references from other customers in that size that runs BC. Since Microsoft says BC is out of the question…
-
QR Code not getting Printed
Hi All, Is there any setup in LS retail to print the QR code?. I am using Nav 2013 LS retail and the QR code is not getting printed. Can you please share the standard code for PrintBitmap. Mine dont have the path option along with it. I am using PrintQRBitmap. The QR is created, saved and loaded to file but not getting…
-
Use of Bar Codes in Business Central
I will kindly want to know if bar code can be assigned to items in Business Central without any form of customisations ?
-
ModifyAll Item Costing Methods
Greetings to all of you. CASE: My customer needs to change all of his items costing method, from average to FIFO. The items have already related ledger entries which means that i am not capable of modifying the value of the costing method , within BC. Due to that , i am trying to create a codeunit which will allow me to do…
-
Is there anywhere in Navision/Business Central that makes a chart/graph/image pop out?
Is there an example anywhere in Navision or Business Central that shows a chart, graph or image have a pop out functionality so that you can see it enlarged? I would like to observe the code behaviour so I can have similar functionality
-
FTP upload + NAV2017
Hi I want to upload *.csv files to a specifik ftp folder and I have found some code, that I do not understand. Can someone help me? FTPSetup.SETRANGE("FTP Active",TRUE); IF FTPSetup.FINDSET THEN REPEAT URL := FTPSetup."FTP Server" + ' '; URL += FTPSetup."Path to Files"+'/' + 'de-int2c5-05012021.csv'; FTPRequest :=…
-
Jobs Wanted / Offered forum location?
Hello - I can't find a location or working link for the Jobs Wanted / Jobs Offered forums? Could someone please point me in the right direction? Thank you!
-
How to make a CardPart page open up in a separate page?
How can you make a cardpart page open up in a separate page when clicked on?
-
Captionclass - BC140
I want to change dynamically the label caption from a page. I found some information about this matter and verify that there are a codeunit 42 that makes the changes. But I can't edit to make the changes I want. Does anybody have information about that to share with me?
-
Event Subscription running 2 times
This issue happened for a Dynamics NAV 2017 database in SQL Server 2017 There are couple of Event Subscriptions used in this database. One of the function is, on some NAV events some notifications / emails went out. Users complained that notification emails did not went out. Opened the Event Subscriptions page, found to my…