-
How to edit the Find row in Items by location Matrix.
HI All, I would like to know if there's a way to edit the subpage Find in the Items by location matrix Scenario : I just want to change the default field in this subpage From Description to No. Cheers! Thanks,
-
Import CSV file that has different table structure then the table into CSV is being imported
Hi, I need to import some data saved in CSV file into T81 - Gen. Journal Line File structure of CSV file is not identical to table structure. How to import such CSV using XMLPort? Should I import first in Temp Table and then from temporary table to T81? Thank you BR Damjan
-
Nav.Client.exe -consolemode Parameter not working with 140?
Hey there, can anyone confirm that the -consolemode command line parameter, that worked perfectly by at least v71, stopped working in or since v140? I'm starting a "ui-less" windows client to run a codeunit like this (yes I know, there are better ways to do this): "C:\Program Files (x86)\Microsoft Dynamics 365 Business…
-
Transfer Generic Diagrams
Hello I am currently faced with the task of transferring the generic diagrams from a Cronus demo database to a real environment where there are no diagrams at all. It doesn't seem to work with the configuration package because the table behind it is a system table. Now I wanted to export the diagrams individually as an XML…
-
How can automate the serial number assignation
how can i automate the serial number assignation to the released component and insert the serial number in reservation entry
-
Microsoft Intereop Excel addin missing
Hi, I have one network user who can't export from NAV to Excel - a message displays "Cannot load an instance of the following .NET Framework object: assembly Microsoft.office.Interob.Excel, Version=15.0.0.0. Culture=neutral, PublicKeyToken=71e9bce111e9429c. We're on NAV 2016 CU32 with Office 365. I've run the setup.exe…
-
How to setup trailing sales orders NAV 2018?
I need to show amount the only that is not accumulated from the previous year in the picture is sum previous year thank you for your answer.
-
Execute function for two minutes or until nested function responds true in Business central
Hi I need execute TryCallData for two minutes or until GetPDF responds true How can i do it in Business central?, Thanks procedure GetPDF(Bill: text) ReturnPDF: Boolean begin <Statement> end; procedure TryCallData() begin while not GetPDF('HMO986') do message('waiting...'); end;
-
Cannot insert date to warehouse activity header table
Hi Guys I'm trying to insert current date when a warehouse activity (inventory pick ) is created and thought it would be simple but below code is not working: Table extension- Warehouse Activity Header .(inventory Pick) also tried "validate": trigger OnAfterInsert() begin Rec."Posting Date" := WorkDate(); Rec.Modify();
-
Insert Sales Lines AFTER Sales Header complete Or aster MakeOrder complete
Hi All We want to insert freight charges (non inv items) on sale orders automatically. The item inserted will be dependent on the ship method. We have a version that works using a event subscription on the ship method code in sales header Works great when I change the ship method, but I have 2 problems 1. if I create a new…
-
Automated Testing: Check Validation Message
Hi All I'm writing automated tests for one of our extensions and I need to confirm that the validation message is correct as part of the test. Let's take a simple (made up) case Record.Field1 cannot be more than 2x it's current value. The extension would have an Subscription to the OnAfterValidateEvent and raise an error…
-
Page error.
Is there a way to clear the error on a page. I have code on a page that will throw the error message when a person tries to ship too much product. Simple calculation... works perfect. But when they correct the entry, the error ribbon still retains the error even though you can continue on with the entry. Just an annoying…
-
Debugger very slow
Hello, i just installed my machine and i still have a great problem. If i debug any Nav Version (2013,2013R2,2015) the debugger reacts very slow. Slow means i click and get a responds in 30 seconds or more. Actually i have just installed NAV 2013 R2 and NAV 2015 and SQL Server 2012. The Service runs on a networkmachine, so…
-
How to correctly read XML to import the data into a table?
Hi, Currently I have a procedure that reads and imports some elements from the XML to a table correctly, I only need to read some elements well, since some fields are repeated when they are imported. I get the XML of a response from a WS, the response is stored in InStream and then I read it to import the information into…
-
EU VAT Reg No. Validation Service Setup
Hello, Does anyone know if or when a service will be available for UK to validate VAT Registration Numbers? This was previously available via the service connection "EU VAT Reg No. Validation Service Setup" but is no longer valid since we have left the EU. Thank you.
-
wave 2 Add-in not found
I want to use control add-in in my project on wave 2 With setting But I have this error An assembly named 'Microsoft.Dynamics.Nav.Integration.Office, Version=13.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' could not be found in the assembly probing paths 'my folder\./.netpackages, C:\Windows\assembly,…
-
Import attachment in Web Client is not working
Hi All, [Version: NAV 2016] In a customized page, I newly kept an feature for Importing, Exporting and Deleting an attachment. I can able to Import/Export/Delete without any issues in Windows client. When I try to import an attachment from web client, immediately the web page gets closed and am getting below error: An…
-
I can't evaluate a DateTime value
Hi, I'm trying to evaluate a value, however I am getting the following error: The value "2021-02-16T09:26:36.953" can't be evaluated into type DateTime. With what method can I solve the problem?
-
Quickentry not working?
hi All, hope someone can help. It seems like we don´t have nextcontrol anymore so I placed quickentry in few fields. However it seems not to work (it goes always to the next field and then to the top of the page). Do I have to set quickentry=false in all the remaining fields? Thanks. Edit: I will answer myself: On classic…
-
Convert DateFormula to text
Hi experts Is it possible to convert a DateFormula to text? Example: Input=3M, Output=3 Months Detail: FORMAT works, but returns just 3M as a text string. Documentation for FORMAT does not mention DATEFORMULA... Thanks in advance. Thomas
-
Multitenancy PowerShell Script not working
hi, we have this scenario: 1. Separate SQL and NAV Servers 2. Multitenancy enabled - trying to move companies from a single tenant to multiple tenants 3. SQL Server 2017 - SQL Server Management Studio 18 I'm working on the NAV Server, where I am importing the NAVMultitenancySamples.psm1 and running the…
-
Breaking change in Item Cross Reference BC18
Microsoft is going to replace the Item Cross Reference functionality with item Reference. https://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave2/smb/dynamics365-business-central/write-longer-item-references Microsoft has created a migration feature for this The breaking change consists of that it migrates…
-
How can I install Test ToolKit on an existing Azure Container?
I have created a Business Central conatiner in Azure using az container create ` --resource-group 'RG-Container' ` --name 'democontainer’ ` --image mcr.microsoft.com/businesscentral/sandbox:13.1.25940.26323 ` --dns-name-label 'democontainer’ ` --port 80 Once installed, how can i now add / install the testtoolkit ? I dont…
-
Nav 2016 Web Services Pausing
We use Nav 2016's web services for various minor tasks. All has been working well for years, but yesterday we started getting random slowdowns that seem to consistently last 2 minutes. For example we'll send a command to update an order, let's say changing a checkbox from checked to unchecked. The response will take a…
-
Converting Unicode to UTF-8
Hello, I am trying to convert a simple text from Unicode to UTF-8 because our Webservice can't handle Unicode. I couldn't find any NAV native functions to do this and after trying to find a solution online for a couple hours I find my self here. NAV Version: BC14.12 Any help is appreciated
-
Business Central Codeunit 49 Global Events do not react
I have created a new codeunit with an event subscriber function to the event "OnAfterOnGlobalModify" in Codeunit 49. But when I make changes in a record, the event subscriber does not react. Properties of my subscriber: EventPublisherObject: Codeunit GlobalTriggerManagement EventFunction: OnAfterOnGlobalModify I tried also…
-
Permission error when upgrading from Business Central 16.1
Hello, I am trying to upgrade Business Central 16.1. I have tried upgrading to 16.2, 16.6 & 16.10. No matter the version, when I run the commandStart-NAVAppDataUpgrade -ServerInstance BC160 -Name "System Application -Version 16.10.21502.0" I get the following error: The "same" error, has also looked like this with later…
-
how to add AL code extension to a Condition
Hello Everyone, Good day. I'm having this problem right now adding AL Code extension to a condition. Please see screenshot below Does anyone have an idea on how to proceed ? Thanks and God Bless :) Regards,
-
Problems with Job Queue Entries and Task Scheduler in Business Central 14.0 OnPremise - C/AL
Hi everyone, In our team we are facing an issue with "Job Queue Entry" and "Task Scheduler": Every process enqueued in the "Job Queue Entry" is executed only once even if it's scheduled to execute more than once. The first time it runs only when the service associated with the task scheduler is starting or restarting. Here…
-
Merge PDF files
I am trying to merge two files (in1 and in2) and create a new file (ut1=outfile) and I have NO luck. Se coding example and error message below. Is there anyone who had success with the Merge function in Bullzip.PdfWriter? // test in1 := 'C:\Faktura1.pdf'; in2 := 'C:\default2.pdf'; ut1 := 'C:\Faktura2.pdf'; Datetime :=…