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.

Import flat file to create invoices in BC
Hi Guys I have looked at below NAV thread to get ideas on how to import a flat file and create invoices to BC https://forum.mibuso.com/discussion/52828/xmlport-flat-file-import-header-line-on-one-line So my file is imported to a staging table and external number is used as unique key since auto numbering of invoices Ext_No…
Error msg "You cannot reverse Cust. Ledger Entry..."
I try to reverse Customer ledger entries and get an error message "You cannot reverse Cust. Ledger Entry No. 871 because the entry has an associated Realized Gain/Loss entry". How to solve this issue? Is there any way to reverse the payment if it is in foreign currency?
how to check if record already used
hi, urgent help, please how can i check if record from one table has already been used, i.e. im filtering table x by vendor no, then i use this vendor no in my table. how can i check if its already there
Hello during the installation of BC 14 I have the following error message
Hello during the installation of BC 14 I have the following error message:
all page long fields
hello, how can I make the fields on the page long from one end to the other
Temporary tables outside of license range
Has there been a change in the last 12 months for how these are handled? A BC14 license from Jun 2020 allows me to use tables outside of my license range so long as they are Temporary = yes. But when I try do design the same object using a license from July 2021, I get: "You do not have access to read the 'XXXX' table.…
SSRS: How can i format decimal number without rounding ?
In ssrs, how can i format 1.52467 to 1.5246 without rounding up ?
Bank balances
hi! how do you do bank rec on a new implementation
Test codeunit failed after Modify
Hello. I have a problem with testing. In a test codeunit I am inserting a record to a table. In application, which is being tested, I have a subscriber to OnAfterInsertEvent, which is modifying a record if some particular conditions are satisfied. Debugger stops on "Modify();" line and after that all I can see is…
NAV Server/NAV Web Services and SQL: fail
I have this installation: NAV Server 2009R2 with service account to start NAV Server and NAV Web Services (domain\navadmin). The SQL server is on another server with a login account (domain\sqladmin). I have registered these SPNs setspn -A DynamicsNAV/servernav.domain.local: 7046 DOMAIN\navadmin setspn -A…
Using BC on a mobile browser without being asked about the app
I have to set up a Business Central client on multiple Android devices using the Ivanti Velocity Browser. It works fine, but every time the session is started there is a page asking the user if they want to download the dedicated mobile app instead. I already tried using a direct link to a page to see if it would…
Single Sign On Authentication, Sign In screen error: an error has occurred
Hi, We have an installation of NAV2009R2 (CU22). We have a NAV Service configured to use Single Sign On (authentication type "AccessControlService"). It works fine for most users, but for one particular user, we receive an error (attached): An error occurred in the script on this page Error: Script error:…
Onprem App version downgrade
Is it, in any way, possible to downgrade a custom app (onprem) ? For instance v. x.x.x.3 to v. x.x.x.2, without deleting all app data? The downgrade should only forcefully overwrite the schema. Any help would be appreciated!
Create file on azure storage in Business Central
I am trying to create a file on azure storage using PUT request, Below is my code and i get the error The value for one of the HTTP headers is not in the correct format. The Code and the headers formed are: procedure CreateFileNew(FileName: Text) var requestMethod: Text; request: HttpRequestMessage; RequestHeader:…
Breakpoint on Default Code on BC365
Hello, Good day. I'm new to AL Extension and I really want to learn more. I have this problem that I need to view the code of a default PAGE so that I can understand the behavior inside. E.G AR Voucher on Sales Journal is not showing any report or prompt a request page after I click it. I need to check the code behind AR…
SSL certificate replacement, firewall, packet inspection.
Hello, We have a cloud situation, where a firewall is inspecting packets of webservice calls, and re-encrypting them with it's own certificate. Business central does not like this, and gives an error the packets are not valid according to the validation policy. We have installed the certificate in the correct store on the…
WORKFLOW CONDITIONS SALES ORDERS
Hi all, we need to set up a sales order approval workflow by controlling a condition on the order header. The field to be checked is the 116 "VAT Bus. Posting Group". If the condition is true it must activate the flow 1, otherwise the two. How can we achieve this?
I have the following error message when I do a Clickonce deployment in a virtual azure serve
Hi teams, I have the following error message when I do a Clickonce deployment in a virtual azure server ERROR SUMMARY Below is a summary of the errors, details of these errors are listed later in the log. * Activation of C:\inetpub\wwwroot\BC-TNK\Deployment\Microsoft.Dynamics.Nav.Client.application resulted in exception.…
How access VAT Amount Line (290) table from code
Hi Guys I'm trying access VAT Amount Line table or the table that details VAT lines - for example in North America you will get multiple VAT Lines for a given SO line based on tax jurisdictions. Looks like this table is virtual or something like that and I cannot update it
Hiding enum values
Hello, I am currently working with the newest version of Business Central. I have created an enum, let's say Enum "Colours" with following values: • Red, • Violet, • Yellow. Afterwards, I want to create two tables with field "Colour" of type Enum "Colours". In the first table I want to have all colours available, so the…
How to Sell/Purchase services in Dynamics NAV 2016.
Hi All, Can someone please suggest How to sell/Purchase services in Dynamics NAV 2016. Thanks in advance, Srinivas Maddula.
Export a license from NAV 2017 or 2018
Hello, I'm a partner, and I need to know how to export the NAV license (FLF file) from NAV 2017 or NAV 2018? There doesn't seem to be a way to do it from the Development Environment, so there might be another tool to use or a script that can be run. Does anyone know how this could be done? Thank you in advance
BC How to Show columns when data is empty is RDLC report
Hi Guys I have got a report with column groups filtered by a value - say GL account sub category. When I run the report for a date range without data for any filtered column, the column does not show at all, and when no data is in the report report doesn't show anything. I guess this is standard behaviour in BC/NAV. Is…
Get page number from change log (CU1)
Good morning, I was wondering if someone has some idea (even with external components like a dll) to get the current page number/name just before opening and trigger that from change log. I´m looking to know the page that is being opened and check if the user would have permissions (in a new bespoke table). Thanks.
Is there a way to get the 400 respons message and the response JSON with .Net 4 in CSIDE?
Hey I use the following to send a json to a server. The problem is, when an wrong formatted JSON is send, i only get the Message "400 Invalid [...]" , while the server is sending the wrong JSON (with some notes) and the 400 errorcode back. Any ideas how i get the Json (the one with notes)? // Authorization HttpWebRequest…
BC14 CU23 Session Timeout
I have upgraded client Platform from BC14 Cu16 TO BC14 CU23. Application version is still CU11. Client is using multiple add-ons and they might have be based on different CUs. But, all add-on functions correctly. If User session is idle for 20-30 minutes then it gets timeout. We have configured it for 8:00:00 Hours. Still…
Upgrade Tool Kit objects -NAV2013 to NAV2015 -need for data upgrade
I am doing a data upgrade from NAV2009 to BC2014. Following the steps, Microsoft papers say to go from NAV09 to NAV13 to NAV15 to BC14. The first step to NAV2013 was painless... but upgrading from NAV13 to NAV15 is proving a challenge for the data. I opened the db with a NAV15 executable and it did its thing with…
Invoice Number to be filled in on Report Requestpage textfield
I need to get information from the customertable based on the Invoicenumber (invoiceHeader.No.) The problem is that is is first initialized when the report is running and The invoice report is called with the invoice record (standard). How do i Get that ?
Report group expression on 1 item no
I want to add an extra Group by expression in my report by item number. This group by must only be done with 1 item number. So if item number = 92070 then group and otherwise not. I tried this by putting this code in the GroupExpression but it doesn't work. =iif(Fields!No_SalesInvLine.Value = '92070') In what (good) way…
Renewal of Dev-Licence NAV-2018 not possible?
Our Dev-Licence-Files for NAV 2018 have an expiration date of 31. July 2021. If I try do dowload or generate a new one, ist has the same expiration date. How can I do this? Or am I missing som news? Has https://businesscenter.mbs.microsoft.com/ moved somewhere?

NAV Three Tier

Discussion List

Categories