-
Blog Series Part 6: Process Selected Lines for List Page in AL for MSDYN365BC.
#Microsoft365, #msdyn365bc, #morderclient #msdynnav #divyeshchittenavbc #businesscentral #msdyn365 #d365bc In this blog we will discuss how to create Sales Document from the Import Data as shown in Customer Requirement for AL Development 2.6 Process. View Details
-
Codeunit with CREATE - Error: Either the caller does not have the required permission ...
Hey Guys, i built a xmlport to export table data to a .csv / .txt. This works. Now I'm trying to make a codeunit, which creates the file to a specific folder. This is the code i am using in the codeunit: varXmlFile.CREATE('C:\Program Files (x86)\Microsoft Dynamics NAV'); varXmlFile.CREATEOUTSTREAM(varOutputStream);…
-
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…
-
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
-
Cannot send e-mail new SMTP provider
We want to use a SMTP server from a new provider. When I tried to send a test e-mail I get the error message "Unable to read data from the transport connection: net_io_connectionclosed..". The provider told me that they use explicit SSL and that probably Business Central (.NET) use implicit SSL. How do I change this, I…
-
JSON file type missing
Hello guys, Please help me. JSON file type missing???
-
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…
-
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…
-
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
-
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?
-
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…
-
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...
-
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…
-
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…
-
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…
-
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…
-
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
-
Installation of Two versions of same NAV 2016 in one Computer?
Hi Experts, Is it possible to install two version od nav 2016 on same computer i have install nav 2016 version 9.00.49.146 and i want to install nav 2016 9.00.51175 and want to access it independently. also please tell me any online space where i can install nav 2016 .is it possible from azure for free. thanks in advance
-
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
-
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,…
-
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…
-
Need to recive more quantity than PO quantity when workflow is enabled.
Hi, I need to receive more quantity than PO when workflow is enabled and partial quantity is already received. Thanks in advance, Srinivas
-
Option and Enum.
Hi experts, I would like to ask about the relation between Option and Enum. If my existing customized table got the option field, could I change it to enum field? May I know the existing option data will be lost? Thanks.
-
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';…
-
Override OnValidate trigger on table field
There I a way to skip onvalidate trigger in table filed?
-
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?
-
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…
-
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…
-
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