-
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…
-
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…
-
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
-
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:…
-
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…
-
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.
-
Why do we need so many table keys in NAV/BC
Hi Guys I have looked at couple of tables to understand the base app allocation of table keys, for example, sales line table contains 19 keys for all possible combinations to retrieve data. Is this the norm when creating your own tables as well? For example I created a table with say DocType, Number, Customer and possible…
-
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…
-
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.…
-
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…
-
Key field in Webservice
Page 201 "Job Journal" is published as a webservice, when i read multiple lines from the job journal through post request from Postman i get all the data plus a field "Key". I am not sure where that "Key" is coming from and how is its value populated. I want to store this key to a custom field in Job Journal Line table,…
-
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…
-
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 ?
-
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?
-
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…
-
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
-
The SELECT permission was denied on the object 'Object Metadata', database 'NRANAVDB', schema 'dbo'.
I recently install a new instance of Dynamics NAV 2016 and copied the database from the old server to the new server. The servers have different names. I logged on to the SSMS of the new server and updated "[NRANAVDB].[dbo].[Server Instance]" table [Server Computer Name] to that of the new server. After doing that I…
-
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…
-
Database Key Groups (Item Tracking)
In NAV, there was a feature known as "Database Key Groups". This was used to group keys across multiple tables, allowing them to be enabled\disabled together. An example if a customer using Item Tracking. The keys to support item tracking and not enabled in the base product. The appropriate key group would be enabled if…
-
Cannot start the service
Hello, I am getting the following error after installing Dynamics.365.BC.23795.US. ServerInstance 'MicrosoftDynamicsNavServer$BC180' failed to reach status 'Running' on this server due to the following error: 'Cannot start the service.'. Additional information may be in the event log of the server. Tried few solutions…
-
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…
-
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?
-
confirm dialog to go back to document without error
Hi Guys I have a confirm dialogue on the sales order to check if the posting date is equal Today. If the date is not equal to Today I want to go back to the sales order without the error message as we have already shown this to the user. Below code works except unnecessary showing of error message. How to not show error…
-
OData web service endpoint with OAuth2
In a BC Cloud demo environment, I'm trying to call an OData web service using OAuth2 bearer token. It's working when calling a service based on a standard BC page, but not when calling a service based on a page added in an extension. I'm able to get the token. Like I said, the OData call works fine if it's for a standard…
-
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:
-
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.
-
Double validation if same value entered
Hello, I have very specific problem which I cannot find any information on. I am working on Microsoft Dynamics NAV 2017. I have created custom Page, where I use variables on fields. These fields have custom ControlAddIns (to change color or sizes of the fields). I have the case where I have to validate same value two times…
-
Monitoring Business Central
Hello Everyone, today as we have a lot of people working from home, sometimes the people work outside of working hours, this is good but block some routines "Lock tables" is it possible to monitoring who is blocking those tables? Thank you,
-
Rec.Skip in PageType = List
it's possible to skip a record from a page list given certain conditions that cannot be added in filters (SourceTableView)? In a report it's possible with record.skip but in the list page it's not available
-
PO with UK VAT, EU VAT and ROW VAT all in one consolidated invoice from popular parcel service.
Customer ships all over the world and at some point in the past we've modded the Purchase Order and Purchase Invoice Subform pages to allow line level access to the VAT Business Posting Groups. So, when the delivery company sends in their consolidated invoice, they can setup an Invoice that matches what they were sent.…