NAV Three Tier

All versions starting from "7.0" - Only new technologies (RTC, Webservices, Reporting Services, Query, OData, ...) Use this forum to discuss topics related to RTC (Role Tailored Client), Reporting Services, Web Services. All new technologies which were introduced with NAV 2009 (SP1) can be discussed here, but NOT the classic client, native DB-server, NAS. Those topics belong to the general NAV/Navision Classic Client forum.

Error print in a report
I'm new in Navision. I'm having a error that "you cannot print in a report where the property 'ProcessingOnly' is set to 'Yes'. Coud please advise me on this
Arranging Fields on Page
Dear all, I'm new on business central and trying to make some pages. I'm struggling with the alignment of fields on pages. Let me try to explain: I've created a page of type card where i have three groups definedgroup("Address & Contact") { Caption = 'Address & Contact'; group(AddressDetails) { Caption = 'Address';…
How to Export the excel layout using ExcelBuffer
Hi All, I have a button called 'ExportSaleLine' on the Sales order page. While clicking the button in the sales order, it has to show the output like the below screenshot. Please advise me on how to make the 'Company Logo'(with proper merge) part and Company Info part (B column with address details and D and E column with…
DotNet dll can run in 2013R2 but fails in 2016 / 2018 / BC14, why?
Hi! I have have so far never needed to ask for help but right now i have hit the wall regarding this. Hope i am posting this in the correct place. Background We are upgrading a customers solution to BC14, its a very big customization with multiple custom DLL files in the Add-in catalog of the server. These DLL's are from…
The trust relationship between this workstation and the primary domain failed
Hi Experts When I try to open USERS List from RTC I get this error in NAV 2017 Version(10.0.16177) -- ref: " The trust relationship between this workstation and the primary domain failed " Please Help...
Inventory Valuation - 0 Quantity on Hand, but contains values
Hi everyone, I'm running the standard Inventory Valuation report on a 2016 database, and I'm seeing a LOT of items popping up that say there are 0 on hand (for that location), but still has an inventory value. Most of these are between -$1.00 and $1.00, so it's not a huge problem financially, but there are many times more…
Automatically updating Assembly Order due date when posting warehouse shipment
We currently use NAV 2016 without WMS functionality but a significant part of our business relates to ATO orders. We have found the the assembly order due date defaults to the sales order shipment date when the assembly order is first created. However, unlike standard sales order lines' shipment date, the assembly order…
Business central Sandbox Publishing Error
Dear all, When I try to download symbols in visual studio editor before publishing an app in Business central , I am getting error as follows. The I/O operation has been aborted because of either a thread exit or an application request.. The I/O operation has been aborted because of either a thread exit or an application…
Is it possible to exclude production orders and sales orders when running MRP?
Hello, Is there any way to run MRP without looking at production orders and sales orders?
Page Testing Delete purchase invoice
I want to run a page testing to delete a purchase invoice. I could not able to find any option such as "DELETE.INVOKE". Can someone suggest me, how I can execute this test?
A DotNet Variable has not been instantiated.Attempting to call System.Xml.XmlNode.ChildNodes
Hi All I have created some Dot Net Variable . There details are as below. Also i have attached the error. Name DataType SubType 1. ChildNode DotNet System.Xml.XmlNode.'System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' 2. ChildNodeList DotNet System.Xml.XmlNode.'System.Xml, Version=2.0.0.0,…
Navision Client is crashing when using NavUserPassword for Dynamics NAV 2016
Hi, When I use NavUserPassword for authentication in Dynamics NAV 2016 my client is Crashing but can login with the same user name and password in Server. Can someone please help out to solve the error. And I'm attaching the error reports which are generated in Event Viewer. Thanks in advance. Srinivas
Automate page testing attach files
I want to automate the testing of attaching file purchase order. The process of attaching file to purchase order as follow: 1. Click action File attachment from purchase order list 2. It will open file attachment fact box. In file attachment fact box click import: 3. When clicks on import, it will open file dialog box to…
Copy Text to the Clipboard
Hi mibuso.com In NAV 2009 R2 I used the Automation routine 'CSIDEClipboard'.Text to copy Text out of NAV to the Clipboard. This works great but now want to do the same thing in NAV 2018 - how is this possible please?
System Application definition is not shown in Visual Code
Hi all, I have a simple question (I think). When trying to open the definition (code) of a System Application object (e.g. table Language) in visual code it shows the following screen: When trying to open any other object from the Base Application or System works just fine. I spent quite some time trying to figure out why…
Upgrading from 2013 to 2017, Error: Modification not allowed, item record already exists
Upgrading from 2013 to 2017 During the data upgrade, I get the following error below. Does anyone know what is the solution to this problem? or how to debug? I looked at the Item records and I don't see a blank record. SessionId : 500 CodeunitId : 104000 FunctionName : UpdateItem CompanyName : ABC StartTime : 4/22/2020…
Override OnValidate trigger on table field
There I a way to skip onvalidate trigger in table filed?
How to get Printername in Reports?
hi, does anybody know a solution how to get the printername after printing reports? I am using NAV 2018 and want to print a pdf file on the same printer after running a report.
Page Testing Error when Create New Vendor Bank Account
I'm defining a page test to create new vendor bank account as below: 1. Go to Vendor List and find a particular vendor 2. Open bank account list page for that vendor 3. Click new and create vendor I have written the code as below: VendorList.OPENEDIT; VendorBankAccountList.TRAP; VendorList."Page Vendor Bank Account…
Ü in Export
I am trying to make a CSV export but somehow the Ü is not exporting. Any tips?
Temp Blob codeunit advise
Hi with the pending removal of the TempBlob table I believe the advice is to use the Temp Blob codeunit. How would I use this codeunit to get data out of a blob field and assign it to a text variable in the same way that I would have used the ReadAsText function in the TempBlob record Thanks
Browse for Folder in BC V15
Hi is there a way to programmatically browse for a folder on the users PC and return the path from the web client in AL? Codeunit 410 File Management had the BrowseForFolderDialog function however this codeunit is no longer available. Thanks
Blog Series Part 5 Calling Base Function for AL in MSDYN365BC.
Hi Readers, I am sure everyone was able to develop an XML Port in AL based on the Previous article. If you haven’t read the earlier article Blog 01 – Customer Requirement for AL Development Blog 02 – How to Develop Table for AL in MSDYN365BC. Blog 03 – How to Develop List Page for AL in MSDYN365BC. Blog … Continue reading…
The value of Decimal parameter is outside of the permitted range.
Good day, We are experiencing issues in NAV and currently cant generate any cash receipt; Error : The value of Decimal parameter is outside of the permitted range. The current value is: 4,534,602,003,201,000. The permitted range is: from -999,999,999,999,999.99 to 999,999,999,999,999.99. Please help
i need to add incoming document feature in the Physic inventory journal. it doesn't work !!
i need to add incoming document feature in the Physic inventory journal. it doesn't work Any help please
'Windows Script Host Object Model'.WshShell .NET
Does anybody know if there is a .NET assembly equivalent to the 'Windows Script Host Object Model'.WshShell. component? I'd appreciate any suggestion. Thanks.
Hide rectangle in report Visual Studio
Hi all, Within a report I added a rectangle and within this rectangle a table with rows from SalesLine table. I want to hide the rectangle when the table does not have 20000 as No_ For this rectangle I have this part of code in the Rectangle properties - Visibility: =IIF(Fields!No2_SalesLine.Value<>20000,True,False)…
"Could not load file or assembly ‘Txt2AlConverter, Version=14.0.0....." Business Central v14 On Prem
Hello All, I am trying to run this command for Business central On Prem V14. finsql.exe Command=generatesymbolreference, Database=”Demo Database NAV (14-0)”, ServerName=Server1 I follow this link https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-running-cside-and-al-side-by-side It…
Extending “Sales Line Type” enum in Business Central 16.0
i am working on BC version 16.0, as in BC 16.0 option field is replaced with enum, as you can see here ( ) that i am extending a "Sales Line Type" enum and adding a new value to it. But when i inspect the "Sale Line" table it is showing that the field Type is option and not an enum ( ). So the value i have added to enum is…
AL post data to external API
Hi, I'm new here and I hope that someone can help with my problem. It is possible to post data from AL BC 15 to external API but as multipart/form-data not JSON? Thanks,

NAV Three Tier

Discussion List

Categories