-
instream error when word download
Hello, I have functionality which in old NAV I could export word and open it with the following code Table1.SETRANGE("Mark for Printing", TRUE); Table1.SETRANGE("SayYes", FALSE); IF Table1.FIND('-') THEN REPEAT _servertempFileName := _FileMgt.ServerTempFileName('DOCX'); _clienttempFileName :=…
-
API Calls PATCH/DELETE not allowed for table.
Hi, so i built an API Page for the customer bank account table and i cannot modify or delete entries i created ( Error says those calls are not allowed for customerBankAccount with EdmType „Collection“ . How do i solve this?
-
page not searchable
hello, i am encountering the following problem - page is not searchable when i search for it however, if I go to the waffle menu i can see it there. this only happens on certain role centres I have application area and usagecategory filled in in the code any ideas?
-
Filters on Queries
hello, I created a simple query that returns some data from table 36 and others from table 37, so far so good. Now I would like to filter the data, and I would like to let the user do that. I thought it would be an idea to call a page from the query's OnBeforeOpen trigger where you can enter the values and then have them…
-
Error when start running Business Central
Hi I create a new instance and a new webclient instance server with the command New-NAVWebServerInstance. I can download symbols in VC but can't run Business Central. Appears the error below: Already see some configurations, database... but I'm a rookie in BC so I don't know if I'm doing something wrong. Any suggestion?…
-
Is there any way to get information about the local session?
I have an issue that requires that I know which station/computer a user is logged in with. The user itself isn't important, but I need to know if they are using computer A, B or C. Is there any way of achieving this with Business Central 19 CU 1? Some sort of session metadata that includes information about the computer…
-
New Purchase Job Price list screen, costs are not picking in the purchase lines.
Hi, Enabled the New sales price feature from feature management. Here is my Purchase Job Price List, with Job JOB00020, Item 1908-S, Min Qty 3, Cost 45 and Discount 10%. Trying to create the purchase invoice with Vendor 20000, Job JOB00020, Item 1908-S, Min Qty 3, but it didn't picked the cost 45 from the new purchase job…
-
Unapply Payment Via API
Hi All, is there a way that we unapply payment via web services? is there any standard api? or must be customized? Thanks.
-
Retain Dimensions field error
I'm trying to troubleshoot an ongoing issue that is happening when Adjust Cost is being processed. We have created a Codeunit that processes Adjust Cost at night after posting has been completed. This has been running for over 10 years but occasionally, we have an issue where the system will crash when Adjust Cost is…
-
Show undelivered Drop Shipment order lines in posted shipment
Hi, When posting a shipment from a sales order, all order lines are copied to the posted shipment. Also the ones you did not ship any quantities for. This could be seen as a 'backorder' funtionality. However, when using Drop Shipments, only order lines on which has been actually shipped/received are transferred to the…
-
Print 2 consecutive reports using Business Central
I have a requirement where the client wants multiple(2) reports to print automatically when the status is changed on a form. I have been able to successfully print all the reports from code individually, and they download on the downloads folder, However when I try to run more than 1, only the last report goes in the…
-
Underscore character in the API page (extension)
Dear all, I need to create an API page with some fields with the underscore character (like "_id", etc.). When publishing the extension I'm getting compiler Error AL0528: "The name of field controls in pages of the type API must be alphanumeric." As a result, I can't publish my extension. In my case the sender can not…
-
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.…
-
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.
-
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..".…
-
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…