-
Table locking and Slow performance
Problem Description: We migrated from NAV 5.0 Native DB to NAV 5.0 SQL 2008 DB a couple of weeks ago. From last few days we are experiencing performance issues with Navision. The process speed is slow (posting few lines takes lot of time) sometimes and users are often locked while doing the postings. We did some SQL…
-
Payment Reconciliation Journal not Mapping the correct Text to relevant Sub-ledger Account
Hi All, Please may you kindly assist, The Payment Reconciliation Journal is not Mapping the correct Text to the relevant Account. When the CSV file (Bank Statement is uploaded) the transactions are populated. But only the G/L Accounts Map the text to the relevant account. All Sub-ledger accounts, Vendor and Customer are…
-
Outlook Add-In: Web Client Stored Credentials
I have a client I was help testing out the Outlook Add-in, by which I mean Contact Insights and the Document Links (not the Outlook Add-in for Sync -- can we get better naming?). We set it up with NavUserPassword logins, and when we logged in, it worked OK. Now he's changed his Nav password, but the stored credentials…
-
Federation Service endpoint login failed - BC16 to BC17 upgrade on Start-NAVAppDataUpgrade
Busy upgrading an environment to BC 17.1, and I'm at Task 8, step 1 - running data upgrade on System App and Base App. However, it basically just hangs - zero errors thrown in console. Zero app server CPU activity and nothing happening on sql server either. In the Event log, this immediately pops up:The Federation Service…
-
design pattern help - how to create a record from another system?
I'm trying to make creating a purchase order for our users easier and want to be able to create PO from another system with the Dimension 1 shortcut we have setup pre-filled Ideally I'd like to create a page that I'd like to like this https://MyIntstance/Live/?page=50&dc=0&mode=create&company=12345&Dimension1=abc What I'm…
-
Business Central 140 CU upgrade not support Azure SQL Managed Instance
I am going to upgrade BC140 CU 11 to CU 20 (In order to apply some platform bugs fixed by microsoft) Error occured when open Db in step of converting Db to new CU version "ALTER DATABASE ... SET SINGLE_USER is not supported" Database is hosted in Azure SQL Managed Instance (aka SQL MI) After a few research, I realized that…
-
OData Query values come back as "Error"
Hello, We have exposed page 1007 Job Planning Lines as a web Service and attempted to connect via 0Data. However you will see we receive "Error" in a lot of the columns. We have SUPER permissions on the user. Does anyone know why this may happen? Thank you.
-
"Wrong" encoding in webservice when asking for json
For a webservice in NAV2018 I have regular listpage showing all the customers that has been exposed as a webservice. When getting the data in an xml file everything looks as it should, but if when asking for the data in JSON all of the special characters æøå seem to use unicode. ie København transform into K\u00f8benhavn…
-
Inventory Valuation qty 0 but have value
Hello all, I have inventory valuation qty is 0 but have value. I already adjust cost item entries but it seems not success. anyone can help? Thanks.
-
Could you help to receive the list of objects
Hi! I haven't DOS-version of NAV. But I need the list of objects :( Could anybody help to receive this list of objects in text file? Thank you in advance.
-
Best practice for upgrading to NAV 2013 to nav 2018 with Mergetool (Code and database)
Hello, Previously when I have been doing upgrades it has always been best practice to import both the old standard version, the old custom version and the new standard version into the same client, so that the text files you exported would have the exact same "layout". But since we can no longer import old versions of…
-
Set Permission automatically.
we create a new extension. This new extension has some Tables, pages, codeunits. Is it possible to create the required permission to all roles automatically?
-
Please help to fix issue Navision 2018 Metadata is not sync for table ID
Please help to fix issue or advice how to resolve this error. Metadata is not sync for table ID 472. Please try again later or contact your administrator. Page Job Queue Entries must closed.
-
Error Metadata is not sync for table ID 472. Please try again later or contact your administrator.
Please help me advice to how to fix this error. Metadata is not sync for table ID 472. Please try again later or contact your administrator. Page Job Queue Entries must closed.
-
Export To Excel Workbook Setting Error
Hi, While using the default functionality for Export to excel for GL Entries from "form 20" available in NAV5.0, I am getting an error when the excel is opened stating that "Problems came up in the following areas during load: Workbook Setting". And this is not constant, for some records its working fine and for some…
-
How to bypass Excel security alert on Hypelink to NAV 2013 DynamicsNAV://
Hi all We have an excel document which has a hyperlink in it to launch a page in NAV 2013. This works a treat, however whenever clicked Excel throws a security alert warning of a virus. I can't work out how to make the DynamicsNAV:// protocol be trusted - same as a https:// in internet security trusted sites. Thank in…
-
NAV 2016 - SMTP Error
Dear All, I am using NAV 2016 CU 61, recently i have issue with SMTP mail setup, attached error message, please someone help me to resolve this issue. Note : we are using office365 for mail. it was working smtp mail setup past 1 year, suddently attahced error coming from yesterday. Regards, Muthu
-
The Dimension Value Does not exist. while running Physical Inventory Journal
I'm working on Physical Inventory Journal follow these step 1. go to Calculate Inventory, put information on 2. run the report and there is an error I have no clue what is the relation between Phys. Inventory Journal and Dimension ( Department for my case) It was working before though,How can I fix this? Thank you so much
-
Divide by Zero Exception when Adjusting Exchange Rates
Hi, we use Dynamics BC for international consolidation. Our Indian Office's financial data I just import from Quickbooks (Import every booking at the end of the month). I use USD as the additional currency as it simplifies reporting via PowerBI. When I want to Adjust Exchange Rates I get a divide by zero exception. When I…
-
Converting from Option to Enum in Business Central
Hello All! i have a problem and i'm not certain that i can get around it. I know that when the Option Type fields in Business Central were, well, still Option fields that we could not extend those options with additional values. That being said, we could still rename the captions. Now that everything is an Enum for the…
-
Uploading file in WebClient
Hi! I am developing some functionalities in BC17 for Cloud. I am currently working on a report which is going to open an excel file and analyse its rows. Done this before in C/SIDE versions. The problem is when I want to use UploadIntoStream function. The function takes: FromFolder and FromFile parameters but as Microsoft…
-
Work description field not visible on sales order page in Business Central
Hi experts, When our customer uses his Business Central Cloud (production), the field "Work description" on the sales order page, is not visible. There are no extensions or personal changes to that page. When he try to make personal changes to the page (add/remove fields etc.) the field "Work description" is NOT on the…
-
[BC 365] The wsdl of my web service is not complete
Hi everyone, I'm having issues while trying to install web services on business central. I've developped a web service on dynamics nav 2018 and I can't post it on a BC version. I used to create my web service on the web service window, and to verify if my web service was correctly posted, i used to follow the soap link…
-
A qüestion concerning a sales invoice report layout with BC and Report Builder
Hi mates: I want to implement the possibility of reseting the page number and the total pages for each DocumentNo in my report of Sales Invoice. I found the functionality to reset de "Page Number" field in this article: https://docs.microsoft.com/en-us/dynamics-nav/how-to--reset-report-page-numbers. The fact is that it…
-
BC 14 CU11 SignalR Queue and CU1 Error
Hello Everyone, Client is using Web Client for BC 14 CU11 on premise version. We are getting error of CU 1 in event viewer even though there is not reference for Codeunit 1 in any objects. Also, event viewer has "SignalR: Large Count of message in the queue" warning. I have noticed users start to have more errors when this…
-
Show Dimension value name in the Posted Sales Invoices
Hi Guys, may I ask, if it is possible to show the dimension values in the list of posted sales invoices? Specifically I only need the Dimension value names of all transactions in the list. with the dimension codes : AREA and DEPARTMENT see image below for reference. thank you for those who is gonna answer
-
How to Delete NAV Company on SQL Database
Hi, We're using NAV 2018 and we have multiple companies on our database. We want to delete a certain company including all data on it, we've already deleted it on NAV RTC but when we look on the SQL database all tables and views are still there. Is there a way to delete a company and all of its records in a simple way?.…
-
Navision 2018 CU 35
We have noticed that when printing reports from NAV 2018 on dot matrix; it actually changes the report layout to landscape. We've tried all possible items mentioned in articles mentioned. Anyone can hint us how to fix this issue.
-
Put away in D365BC
Trying to understand what triggers a posted receipt to create a warehouse put away. I am using the latest version of BC 17.2, have have ticked Directed Pick and Put away and have setup a standard put away template and flagged the create Put away. I am stumped as to why the put away document is not being created when the…
-
Changing G/L account in Purchase invoice line reset unit direct cost
Hi, maybe it is a dumb question but can't find a setup or a way to avoid it. Navision 2017 I create a purchase invoice, as line invoice i used type: G/L Account No. : my gl accouunt Quantity : 1 direct unit cost : 100 then i realized that i wrongly choose the G/l Account . As soon as i change it , the direct unit cost is…