-
Upgrade Nav 2017 to BC 14 with custom Extension : Issue Archived Data not restored
I'm working on migration of NAV 2017 DB with (Extension XYZNAVX Version 1.0.0.0 installed in it) to BC14 Steps I followed as per the guidelines https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrading-the-data As a prerequisite I prepared app file XYZAPP version 2.0.0.0 using VS Code that…
-
Unit Selling Price calculation using Unit Weight*Rate per kg
hello everybody! We are using Navision since 5 years but till now no solution has been reached regarding automatic selling price calculation. Please help. Our firm produces Steel Welded Mesh for Construction Industry and we make Mesh of different sizes and weights. Each item weight is calculated using the wire sizes &…
-
Performance issue | MS Dynamics 365 Business Central (Version 14)
Dear All, In the Cloud, we have two servers one for SQL Database and another for NAV Application (BC Application Server). The SQL Server Machine is running with 8GB RAM (25% Free) & the Application Server Machine is running on 16 GB (50% Free). The database size is less than 2.5 GB. Concurrent users are a maximum of 5.…
-
E-mail Vendor Remittance from Payment Journal
Dear Friends, Need you help in sorting out my issue that I am facing. I have few payment entries in Payment Journal for few Vendors (Account Type is Vendor in PJ). Say, VEND0001 VEND0002 VEND0003 VEND0004 VEND0005 Requirement: I need to send email to Vendors and Vendor Remittance report as attachment in it. I have placed a…
-
Handling Internally printed labels - Business Central (14) (on Prem)
We have a range of labels that we internally print from a plain label, that are applied during manufacture (which may be to order or to stock) To ensure we know which label to print we put it in the BOM, so a prod order will call for Label-0901. Label-0901 doesn't physically exist. We print a Label-0901 from Label-0001 and…
-
How to modify Factbox width in webclient?
Does anyone know the secret how to modify the width of factbox area in webclient? I have a control-add displaying a PDF using pdf.js - works very nice in Windows Client, but I can't get it to work in web-client, as it's seems locked to it's default width no matter what I try with my control-addin. I know the CSS parameter…
-
Getting error during sending PDF invoice attachement using bullzip pdf printer.
Hi Everyone, I am sending PDF invoice attachment through mail through Bullzip PDF printer. 1. when i am trying in server, its working fine. but 2. when client is sending from his local machine its showing error. Sometimes its showing: Error:1. 1. I have created shared path in server side and gave full permission to the…
-
Creating Charts in Excel using Automations
Hi, I create an Excel-Sheet with Navision using Automation-Variables to control Excel. Creating a Excel-Sheet and fill it with data is not a problem, but now I want to create a chart based on the data in the Excel-Sheet. I use the following Globals of type Automation: xlApp: 'Microsoft Excel 11.0 Object…
-
PowerShell: Get-SqlLogin
Hey there, maybe someone who is more into PS can help. I want to use the Get-SqlLogin command on powershell (see: https://docs.microsoft.com/en-us/powershell/module/sqlserver/get-sqllogin?view=sqlserver-ps). But it seems like i am missing somethin: I cannot find out which "Import-Module" command allows me to import the…
-
Cannot Insert Second Record into Temp Table
Using a report, I have a dataItem based on Ax Slave table. On After Get Record trigger I want to check if there is already inserted the combination between customer, caseID and InsuranceCompanyName and if it's then I just increment one field. I'm using the same table Ax Slave but is a temp table The problem is that I…
-
The best way of Creating a Webservice while installing Extension in MSDYN365BC.
Hi Readers, Once we have created our Extension, we might need to auto Publish the web service when we install the Extension in Microsoft Dynamics Business Central. Continue reading
-
Create webservice in NAV2018 to use in external app, return JSON with item information
Hi All, I need to create a webservice in NAV 2018 to be used in an external app. The webservice is called for a specific item number, the webservice should return a JSON with some relevant information of this specific item. I have a hard time finding a good example which is covering this issue, can anybody provide me a…
-
Error in event log for Business central 2020 Wave 1
I'm getting the following error/warning in event log. Unable to find defining app group for table with ID 2000000120, when initializing query from app group 2. Anybody know what it is?
-
BC14 Upgrade til BC16
Hi all Im looking for a guide for upgrading BC14 to BC16. I tried to use the BC15 guide, but without success. Anyone who knows howto or the guide? Best Regards /Erik
-
NAV WebClient, unhandled rejections
Hi We are experiencing some issues with unhandled rejections, but with a little less information to give: Error accessing Website Unhandled error occurred on a browser or device client: { "clientInfo": { "platform": "Win32", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko)…
-
How to install microsoft dynamic 365 business central on cloud?
I have an subscription on azure and i want to install MSD365BC, anyone know how to do that? Thanks :blush:
-
CFRONT.Dll and ASP.NET help needed.
Hi, I am trying to make ASP.NET application which takes data and insert into NAV Native database. When i am trying to execute my application I am getting exception ... The Navision CFront initialization failed, with following error: Exception of type 'System.Exception' was thrown.. Please verify that…
-
Export NAV Objects without language/translation
Hi Community, Is it possible to export objects from development to txt without language? Mergin objects with translations is pain in the cheek. Thanks
-
how to use textattribute in BC
Does anyone know how to use the textattribute in an xmlport in vc...?
-
How can I add lookup to a report field?
I am working on Aged Accounts Payable Report and I want to add a lookup to the Name field just like the other fields have. How can I accomplish this without adding a table relationship?
-
How can i make sales orders to b approved after prepament invoce has bees been released
hi. l created a sales order and it require the sales order first to be approved before posting invoice. Yet the process i want is for the prepayment invoice first to be posted and the document to send for approval to the dispatch clerk(the one who will dispatch the goods) since the dispatch clerk can only dispatch if there…
-
Business Central web client Login
I want to know if it's possibile configure BC to use Login page to authenticate users using Credential Type Windows and not NavUserPassword. Trying windows Credential type configuration, when non domain user tries to connect to BC, popup window is shown for insert username and password.
-
On-Premise object id range 50000-99999
HI All. For SaaS, 50000-99999 is 'free' meaning you can use any object number for any object type in that range for any app. Is this range also free for on premises? Or we need to get the object in customer license. Could someone explain this. Thank you.
-
how to copy records from one company to another company using configuration worksheet without excel
Hi everyone i need to know how to copy records from one company to another company in business central thanks in advance.
-
How to learn .NET?
Hi Guys, Does any of you know of a good resource to learn how to use .NET in a Dynamics NAV context? Any advice is much appreciated. Thanks, Thomas.
-
Write excel file no excel installed
Navision 4.01 SQL hi everyone, i was wondering if it is possible to write an excel file even if excel is not installed in the client machine: why? because a customer of us needs to export the budget from a TS where excel is not installed. Then he will eventually copy the file on his pc (where nav is not installed, but…
-
Business Central - purchase line - update shortcut/global dimensions
Good day, I am looking for a hint on how to update shortcut dimension codes on a purchase line, after an update to line dimension values. Here is the code I use to update the purchase line dimensions with values from external system: procedure AssignLineDimension(DocumentType: Integer; DocumentNumber: Code[20]; LineNo:…
-
ODATA - Adding header and lines in one call/round trip
Hi :) Hopefully someone here can help me with this, I'm finding useful documentation and examples for ODATA in Business Central hard to come by. I have custom tables ("Inbound Job" and "Inbound Job Task Line"), the usual page (InboundJobQuotes) and subform (serviceLines) setup for ODATA web services. Using Postman I can…
-
Powershell: Use Users full name of windows account to create NavServerUser
Hey there, I am creating a new local Windows User with a full name this way:New-LocalUser -Name "User03" -FullName 'testname' -Description "Description of this account." -NoPassword Works fine. Now I want to create a new NavUser and use the full name of that windows Account. Hardcoded it looks like:New-NavServerUser…
-
Upgrading Business Central Spring 2019 On premise to CU4
I upgraded a BC 14 version to cumulative update 4. All went well and the application runs, but... when i open extension management in the converted application, I find the standard installed extensions still being in the 'old' version. For example the 'Paypal Payment Standard' extension has version v.2.1.29537.0. When I…