-
Create General Journal Line with dimensions
Hi experts, I use NAV 2016 and create some records in the General Journal Line table. I need to add values in "Shortcut Dimension 3 Code" and "Shortcut Dimension 4 Code", but I don't know how to do that. Can someone please show me a few lines of code with this? I think, I should use DimMgt.GetDefaultDim() somehow and add…
-
Job Planning Lines Page very slow switching between fields and lines
Hello, We use the Jobs module and the job planning lines table is very big. We have about 50 jobs and each job can have up to 100,000 job planning lines. The issue we are running into is when users are trying to create new job planning lines or edit fields in existing lines, it takes a almost 4 minutes to switch to the…
-
BC 16 migration.json to migrate custom fields and tables to extension in upgrade
Starting in BC 15.3, Microsoft added the migration.json table that from their doc, looks like it will migrate custom and ISV fields and tables to pre-existing extensions using the extension app id. If this works like this, it will make upgrades less expensive, since we do not have to write code to move the data moving to…
-
Location Code and Requisition Worksheet
HI Mibuso members, I'm running into an issue with my Business central On-Cloud instance. When I run a requisition worksheet the PO's do not include the location code in the header. It use to do this automatically but now it selects the default company address. I checked my company info and vendor card but those are both…
-
Query object not appear in AL Object Designer
Hi, I need view the code of the 2464 query object "Posted Sales Credit Memo Line Items" I have included the extension "System Application" in app.json file but the code still does not appear what can I do to check this thanks
-
Table already exist Identification fields and values.. even though the record is unique
Hi, I having an error when running this script: TransSales.DELETEALL; TransSalesTransform.RESET;
TransSalesTransform.SETCURRENTKEY("Store No.","POS Terminal No.","Transaction No.","Line No.");
TransSalesTransform.SETRANGE("Trans. Date",CALCDATE('-1D',RunDate),RunDate);
TransSalesTransform.SETRANGE("Store…
-
Introduction to Business Chart Control Add-in in Business Central
In this article, we will introduce you to the basics of Business Chart Control Add-in in Business Central by creating an example chart using the AL code. Read the full blog post here: https://bit.ly/3fy8CZE
-
Hurry up to register for the Extensions training on the 12-13th of August
Simplanova invites you to attend a full 2 days/8 hours online Extensions training next week, on the 12-13th of August from 2:00 to 6:00 PM CEST, where we will introduce you to AL world and assist you in moving your solution to Extensions. There are only 10 spots available, so hurry up to save yours! Please find the…
-
Access CIFS share over WebClient from Docker-Container as a host
Hi everybody, we have the problem, that it is not possible to save files or open files in the webclient (in an report) from an CIFS share. Everything runs in a container. The service account that runs the service tier in the container.. Must he have the permissions to open that network share? Or the user that is currently…
-
This message popup when i open web client.
I don't know what going on, what kind of way to check this error ?
-
XML Parser error
I am trying to import an XML file and am getting the following error: "The XML Parser returns the following fatal error: Illegal qualified name character. Line Number = 1, Column Number = 2" Here are the first several lines of my XML file: <?xml version="1.0" encoding="utf-16"?> <ShipUpdateEntity> <Notifications>…
-
Error: localhost refused to connect
Hi All, I am trying to implement NavUserPassword for Business Central 14. I followed the following post: https://chrisdsilvablog.wordpress.com/2017/11/16/how-to-login-windows-client-and-web-client-using-navuserpassword-authentication-in-microsoft-dynamics-nav/ and it is working for the Windows Client. However, i keep…
-
Web Services Navision 2016
I am connected to a Web Services, and I would like to insert the result of this call in a table. Could you help me please? I leave you an overview of the code I use. url := 'http://192.168.16.23/CAMESER/cfmsv.asmx'; uriObj := uriObj.Uri(url); Request := Request.CreateDefault(uriObj); Request.Method := 'POST';…
-
Error while Installing NAV 2016.
Hi all, When I'm installing Nav 2016 on Windows server 2008 R2, I'm getting the error, Below is the screenshot and log. Please suggest the resolution. Screenshot: Log: RegistrySearch: Id = 'IISInstalled', checking registry key existence. Id = 'IISInstalled', Key = 'SOFTWARE\Microsoft\InetStp', Exists = '1' RegistrySearch:…
-
What is needed in order to become a Dynamics NAV Developer?
Hi, I come from C++/C# world and I know that for programming Dynamics NAV a knowledge of C/AL is needed + knowledge of a How ERP systems works, but a thing that is not clear to me is what do I need in order to have a Development environment access? The current situation is following: - My company uses NAV 2009 trough a…
-
Using web service is not work?
Hello everyone, i am new in navision i used web service of sales order and customer in dot net application when i run my project direct from visual studio and create order from application then it create record in navision sales order, but when i host application on IIS server then run it and create order then it create…
-
How to edit "ClientUserSettings" in Dynamics NAV 365 V.16.3 ?
I can't find ClientUserSettings in this version V.16.3 , I need to change ClientServicesCredentialType = Windows to NavUserPassword ,What will I do?
-
Page.RUNMODAL = Action::OK in 2013 R2
Hi there, I have a following problem: CustLedgEntry.SETRANGE("Customer No.","Bill-to Customer No."); CustLedgEntry.SETRANGE("Currency Code","Currency Code"); CustLedgEntryPage.SETTABLEVIEW(CustLedgEntry); CustLedgEntryPage.SETRECORD(CustLedgEntry); IF (CustLedgEntryPage.RUNMODAL = ACTION::OK) THEN BEGIN ... END; When the…
-
Strange problem when import txt source in 2009R2
Hello. I found strange behavior at one of our bases today. When importing a file with the source code, where there is an action with additional properties after RunObject, for examle: { 42 ;1 ;Action ; RunObject=Codeunit 15; Image=EditLines } the classic gives me an error and stops the import. Microsoft Dynamics NAV…
-
NAV 2018 - How Customer and Contact are linked?
Client wanted to convert all contact name in Customer Card in to a Contact for CRM purposes. I investigated the code that links both in Customer Card page. Confused a bit. There is no mention of customer no in the Contact table. So, Email address or Mobile Number is used to link them both? Is there any other way to…
-
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…