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.

NAV ODataV4 vs NAV API
Hi, I would like to ask what are the practical differences between the OData V4 web service Custom Page and the Custom page API. So far, I've only noticed: API is better-structured thanks to properties (like APIPublisher, APIGroup, APIVersion, EntityName, EntitySetName ..) The API allows you to use templates. Are there any…
adding blank Line in custom report/
Hi all, I have one issue in NAV report. I want to add blank lines in body of report when records are less than 4 then body filled with blank lines so total design of layout remain same.i have tried some solution but it didn't work for me please tell me how to achieve same
How to export the BLOB in excel using Excel Buffer in NAV 2018
Hi All, I am exporting Sales order details in excel using a report. How can I export the BLOB(CompanyInfo.Picture) in excel using Excel Buffer in NAV 2018? Please help me guys... Thanks in advance, Jacob.A
How to select multiple records to filter a report
Hello everyone. I'm creating a simple report (Dynamics NAV 2017), that reads data from two similar tables, joins all into one temporary and prints it into excel. All nice and simple. I've set the RequestedFilterField for both tables to "Document No.". Now as filters go, I can select single record, put a pipe (|) and select…
New Installation 365 BC V15 (CU03) OnPremise: Error Log shows Errors on missing Objects
Hi, we've got a problem in a new Installation V15. In Error Log there are many Errors "NavMetadataNotFoundException". Ever and ever again concerning to Page 697 (Manage Style Sheets - Pages), Page 1260 (Bank Data Conv. Service Setup), Page 1822 (Setup and Help Resource Visual), Report 9171 (Export Profiles), Report 9172…
How to filter the customer's first sales invoice in Cust.Ledger Entry
Hi EveryBody I am making a report to filter customers with the first and last sales day arising from date to date and calculating the total number of sales invoices. [b]Cust. Ledger Entry - OnAfterGetRecord()[/b] "Cust. Ledger Entry".SETRANGE("Posting Date",0D,GETRANGEMIN("Date Filter")); "Cust. Ledger…
Return Value from Get-NAVAppInfo powershell
Is it possible to wrap Get-NAVAppInfo powershell command in a function to return certain values. For example the Synch state and the installation status? Thanks you
Excel Buffer Freeze rows
Is there a way to freeze rows or columns, using the Excel Buffer table functionality? Currently there is no option to define that but I'm sure it can be coded but I don't know how. Has anyone done this before?
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

NAV Three Tier

Discussion List

Categories