-
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:…
-
Navision V4 SP3 Update 6 (Windows Vista Support)
Does anyone know where to find a copy of Navision V4 SP3 Update 6? A customer of ours is still running V4 SP3 on a failing server and we need to install it on another server. Upgrading is unfortunately not an option as they plan to move to another product and ideally we would like the new server to be later than Windows…
-
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…
-
Update Automatic Dimensión Employee
Hi, I have a doubt You would need to know how to carry out an automatic loading of a series of employees with their dimensions through a process (report or CodeUnit). When you manually register a dimension of an employee, the standard executes a series of processes so that the dimensions are created in the different…
-
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…
-
Cannot unregister sales return line that has been registered by wrong: This lot is marked against an
Dear all, in Dynamics 365 finance and operations --> Sales and marketing, we had registered an item by wrong in sales return order and this item enabled for quarantine management (item model group), when trying to click on registration in order to reveres it its gave this error: This lot is marked against another inventory…
-
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…
-
Fail to run bat file for ftp upload
Hi Expert, I have 2 machines, both running NAV 2009 SP1, classic client with same version, and pointing to same database. There is a NAV report created for generating a bat file which pointing to another ftp script file. Machine A Machine B Manually run report in NAV OK Fail Manually run the NAV created bat file in window…
-
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?
-
You do not have the following permissions on TableData Published Application: IndirectInsert.
Good Morning All, Hope everyone is well and safe. I have come across an issue that has caused me confusion. I have created an extension that previously was publishing ok to the sandbox instance however when i try publishing the same extension with some changes I am getting the following error The request for path…
-
How to check if table is locked or not.
Dear All, Is there a way to find whether a table is locked before doing any update operation on it? For eg before I go on updating the records in the Table MyREC, I would like to know before hand whether the table is locked or not IF MyREC.FINDSET(TRUE, FALSE) THEN REPEAT ...... UNTIL MyREC.NEXT = 0 Thanks.
-
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…
-
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…
-
how to upload a tool in website ?
Fyi;
-
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…
-
How to prevent XMLHTTP to get client-side cached result?
NAV2009 R2 Classic - I am downloading an XML file using this code:l_XMLHTTP: Automation 'Microsoft XML, v6.0'.XMLHTTP60
l_XMLDomDoc: Automation 'Microsoft XML, v6.0'.DOMDocument60
l_InStream: InStream…