NAV Three Tier

All versions starting from "7.0" - Only new technologies (RTC, Webservices, Reporting Services, Query, OData, ...) Use this forum to discuss topics related to RTC (Role Tailored Client), Reporting Services, Web Services. All new technologies which were introduced with NAV 2009 (SP1) can be discussed here, but NOT the classic client, native DB-server, NAS. Those topics belong to the general NAV/Navision Classic Client forum.

Dynamics NAV iPhone App will not connect
Im Trying to configure setup with NAV App (Business Central) in my iPhone and give-me all times that error... "Could not connect to the server". Im using the same internal network. This is a self-signed certificate, and I have already downloaded the certificate to the iPhone and installed it. If I try to access it via the…
How to GET rest api in AL?
Hi all, how to convert this rest api to become AL Code? GET /iras/sb/Authentication/CorpPassAuth?scope=EmpIncomeSub+CITFormCSSub&callback_url=https%3a%2f%2fwww.yourdomain.com%2fcallback&tax_agent=false&state=390b25fa-4427-4b10-9ae2-34d6e0cd91a1 HTTP/1.1 Host: https://apisandbox.iras.gov.sg X-IBM-Client-Id:…
Pass Recordset in Web Service
Hi All, are we able to pass record in web service? This is my code to sync data cross company in 1 tenant.Company.reset; if Company.findset then repeat ToGLAccount.ChangeCompany(SyncCompany.Name); ToGLAccount.Reset; if ToGLAccount.get(ParGLAccountNo) then begin ToGLAccount.TRANSFERFIELDS(FromGLAccount, FALSE);…
smtp.office365.com in SMTP Mail Setup | NAV 2016
Dear Sir, The following error message is occurred when I click "Test Email Setup" in the SMTP Mail Setup Page. Microsoft Dynamics NAV The SMTP mail system returned the following error: "Transaction failed. The server response was: 5.2.0 STOREDRV.Submission.Exception:SendAsDeniedException.MapiExceptionSendAsDenied; Failed…
BC Editable in Tile Mode?
Hi All, I am using cloud BC. just wondering, are we able to set editable when is in tile mode?
VSC extension - object ID helper
Hello, Looking for free object IDs is a little bit frustrating. Does anyone know any VSC extension that would help with finding not occupied ID for my new object in the project? Or what is your way to do that?
API vs OData for Cloud BC
Hi all, I am looking to integrate BC online with my api so now from BC Side, i have 2 options : API and OData. what is the plus minus between these 2? any recommendation which one should I use? Thanks.
as user sorts by any column of Page X, NAV client crashes
Hi All, I have strange issue as users open page 5076 - "Interaction Log Entries", where page Interaction Log Entry has set filtering in OnFindRecord, where page is opened as expected, but when user sorts records on field (i.e. Description) the page freezes and NAV client crashes. I tried to debug the error and it works…
Permission sets of the current user
In a Dynamics NAV 2018 - is it possible to find/lookup the permission sets of the current user (user SID) logged in, using C/AL? If it is possible - I am assuming that one or more virtual table(s) is to be filtered in order to search or find these permission set entries - but wich tables and how should it be filtered?
BC365: Remove grey background on a un-editable text field
Hi! Currently, I am working on implementing a solution that gives the user a possibility to add own instructions (i.e. captions and instructional texts) to certain wizard steps in a navigate page and I am very close to achieve it, but there is a minor detail that keeps bothering me. When you enter the first wizard step in…
Planning Worksheet didn't show Starting Date and Ending Date correctly.
Hi, I have a question about Planning Worksheet. I clicked Calculate Regenerative plan... and set Starting Date and Ending Date but the date didn't show as I set. Moreover, the Accept Action Massage field didn't check like it used to be. The date I set What it show And this is my manufacturing setup How do I fix this?…
NAV client crashes without any error message
Hi All, our customer has some strange issue that NAV 2013 R2 client crashes for unknown reason. I think the issue is with Page: "Interaction Log Entries" because it is opened from Page: "Contact List" where filtering is set on Table: "Interaction Log Entry", so page: Interaction Log Entries is opened with set filters as…
BC365 How to get Temporary Data on G/L Entry after Preview Posting on Journals
Hello Experts, Good day. Is there anyway I can get Temporary Data/records on GL Entry after Preview Posting using AL Extension? I just want to show it on a report on Journal Page. Thanks and God Bless Slight smile
BC365 Variables Empty After Running Request Page on a Report
Hello Experts, Good day. I have created a custom button on a default page of BC365, this button runs a custom report too. See code below action("AR Voucher") { trigger OnAction(); var rptJournalVoucher: Report "Journal Voucher"; GenJnlLine: Record "Gen. Journal Line"; begin Clear(rptJournalVoucher); GenJnlLine.Reset;…
Error in Invoke-NAVApplicationDatabaseConversion for Azure SQL
Hi, I am upgrading BC15 database to BC17. I am getting the following error when I run the Invoke-NAVApplicationDatabaseConversion command: Invoke-NAVApplicationDatabaseConversion : The database create operation failed due to the following error returned by SQL Server: Execution Timeout Expired. The timeout period elapsed…
BIN Contents lines....
Hi, a user has queried with me why BIN content lines exist when QTY is zero which has confused me a little .. why do they exist if the QTY is zero on the line ? is there a task that updates this table ?
External Tables in BC
Our client needs to connect to an external SQL database used by a third party application. I've been looking into how to accomplish this, but there seems to be surprisingly little documentation on this topic. I could find some information for Dynamics NAV, but our client uses BC Cloud. From what I can tell, there are…
Transfer header does not exists. Identification fields and values : No. = 'TS-00010'
While ship the transfer order, I'm getting Transfer header does not exists. Identification fields and values : No. = 'TS-00010' this error in Can anyone suggest some answer Thanks in advance.
BC140 Start-NAVServerInstance: "The system is currently updating, try to connect later"
We have four NAV servers. After a restart, we have the following warning on the heavy load NAV servers for about half an hour when we try to connect: Microsoft Dynamics 365 Business CentralThe system is currently updating, try to connect laterOK Can we make changes in the Configuration, or what is the problem?
How to split a record and format to string?
Lets say we have a Code record with 3 digits. Based on first digit we would want to format to string? Example: 001 = Lion 101 = Tiger 201 = Moth Would appreciate any help.
DELETEALL without locking table
Hi Guys I'm still trying to find better ways to do stuff in BC AL. I did a mistake in a loop and loop didn't stop so I had to delete records using something like below: SalesHeader.SETRANGE("Document Type",SalesHeader."Document Type"::Invoice); IF SalesHeader.FINDSET THEN SalesHeader.DELETEALL(TRUE); Now the I got an error…
Import Data by xmlPort - one File in different Tables
Hi, possible someone can help me out with my problem. I have a CSV file with 400 columns that I want to import with an xmlport into tables in NAV. For this I have created 4 tables with x fields and an xmlport. Structure of the xmlport see appendix. The Entry No I pass no per data record and table. There is no LinkTable…
Au Nz Statement - Email
Does anyone know of an extension available for emailing Aunz statement in AU BC
Better way to insert Dimension Set ID from AL code
Hi All I am developing an extension to import invoices from an excel file and the excel file contains columns for dimensions. Now I can get this to work but the code is long and looks inefficient. Is there a better way to handle this than below which is based on blog…
Export XML lines without header
Hi!, I'm using an XMLPort to generate an XML but I need generate an XML like this: (repeating error without header): <Response> <Errors> <Line Number=1> <Comment>comment</Comment> <Error>Error x</Error> <Error>Error y</Error> <Error>Error z</Error> </Linea> <Line Number=2> <Comment>comment</Comment> <Error>Error x</Error>…
How can I automate republishing?
As it currently stands, BC requires all apps with dependencies to another app to be unpublished before it's possible to update it, making us either have to unpublish multiple apps manually or unpublishing and publishing every custom extension through a hardcoded sequence of PS-commands. I find this very tedious and…
NAV 2016 TextEncoding problem
Hello, I have a problem with TextEncoding. In general, what I am doing is:TempBlob.INIT; TempBlob.Blob.CREATEOUTSTREAM(OutStream); OutStream.WRITETEXT(SomeTextVariable); TempBlob.ReadAsText('', TEXTENCODING::UTF8)) Where SomeTextVariable = 'xńx'. As you can assume 'ń' is making me some kind of trouble. Sometimes (but not…
Dataverse Integration Sales -> Business Central
Hello to All, I have setup the integration between D365 Sales and Business Central successfully. Creation and updates of accounts is working fine between the two systems however when i deactivate an account in D365 Sales this does not update the Customer in Business Central. I am using the OOTB functionality. I was just…
Testing ListPages
Hi, Is there any way to invoke the "New" Action on a Testpage based off of a ListPage (e.g. CustomerList), in a way that the CardPage opens with the new Record? TestPage.New only "puts the cursor in a row" - which does nothing in a Page that is not editable.TestPage.OpenNew does nothing in a ListPage as far as i figured it…
Item Unit Cost
Hi, In an average unit cost codebase .. is the "unit Cost" on an item record inclusive of "indirect cost %" or is this only considered when entered on a purchase line ? And is this ever considered when entered on a sales line ? MY current testing suggests no to both but im curious as to why, if it is so..

NAV Three Tier

Discussion List

Categories