-
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…
-
Lock Table & Job Queue
Hi All, I have a job (Job1) that runs every minute in a Job Queue which posts journal entries. There is another job (Job2) that runs at the end of the day which locks the ledger table. When that happens Job Queue for Job1 crashes and the Job Queue Status gets updated to Error. I'd like Job1 to run only if it the ledger…
-
CRM 2013 and Exchange 2016
Hello everybody, I'm new here and in the CRM's World. I had to connect the CRM 2013 to Exchange 2016, i follow this tips : https://docs.microsoft.com/en-us/previous-versions/dynamicscrm-2016/administering-dynamics-365/mt622062(v=crm.8) But i still the "in progress" status, not failed or wish i'll prefer the success status.…
-
Start-NavDataUpgrade during upgrade to v17/18 - how to detec when it is finished?
I am running upgrade to V17 according to this MS guideline Upgrading Customized C/AL Application to Microsoft Base Application Version 17 . Everything is fine but... Task 10 point 1 when I run Start-NavDataUpgrade is asynchronous :( In next point they say: "To view the progress of the data upgrade, you can run…
-
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…
-
XLPivot .SubTotals
Hi, In excel vba - i can turn subtotals off for a field in a pivot table.. e.g. below.. For Each pt In ActiveSheet.PivotTables For Each pf In pt.PivotFields 'First, set index 1 (Automatic) to True, 'so all other values are set to False pf.Subtotals(1) = True pf.Subtotals(1) = False Next pf Next pt but in NAV - ( First 2…
-
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
-
Adobe Reader loaded via control add-in stopped working after Windows security update
We use the Adobe Reader to view pdf files from within NAV and it's been working great for the past year and a half, however, with the most recent Windows security update (KB5003637) it stopped working. The odd part is that it's only happening to some but not all PC's. Has anyone else experience similar issues? Our only…
-
Log in Perm set
Hello all, I want to create a user with the minimum permissions. So I just created new permission set via the "Record permission" function. It's all good, but it's not enough because I cannot "record" what is happening when users log in. I started manually adding codeunits one by one but looks there are too many of them.…
-
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.…
-
Xmlport export
Simple one, but not getting it right. I have a custom Boolean field in purchase header called 'exported'. It gets checked when a purchase order gets exported. Now I want to export purchase lines which are not already exported using a variable text XMLport. Wondering what would be the right way to filter purchase lines as I…
-
Cannot create companies in Business Central OnPrem
Dear all, We have BC 19 Spring Edition on a SQL Server 2019 standard edition. When I want to create a company or copy a company I get the following error: "Online index operations can only be performed in Enterprise Edition of SQL Server". Is there a way I can disable Online Index operations? Or do I have to upgrade to SQL…
-
Create/Import Blanket Sales Order using dataport from csv file in NAV 2009 R2.
Hi Everyone, I tried to create 'Blanket Sales order' using one dataport from csv file. In csv file suppose: have 8 mandatory column in one row, 3 from sales header and remaining 5 from sales line. How will i linked each other so that data will import from single row that is from two different table? or, can be exported the…
-
Promoted action is shown in the wrong category
Hi experts, In Business Central cloud on page "Posted Sales Invoice", there is these promoted action categories: PromotedActionCategories = 'New,Process,Report,Invoice,Correct,Print/Send,Navigate'; On the same page, the action "AttachAsPDF" has this promoted category: PromotedCategory = Category6; It is shown under…
-
Show SSRS report within NAV Page
Guys, Has anyone found a way to show native SSRS reports within NAV page? Thanks
-
Upgrade from NAV 2017 to BC. NA version to CA or US?
Hello One of my client is upgrading from 2017 NA to BC and they have companies in US and Canada. Since they have split the databases, which version will they be upgrading? Has MS released a document on this?
-
GS1 Datamatrix in NAV classic report
Hi, does anyone know solution for generating 2D GS1 Datamatrix code on classic report?