-
Sorting new field in page list
Hi, may I know how can let the new field have the sorting function in the page list? e.g. I created a new field to calculate the Balance in page list, but I can't do the sorting, I want to design same as below, when click the field will show like below one.
-
Can we delete all order lines by Quote at once in Microsoft Dynamics Nav?
I want to delete all order lines at once from the quote in Microsoft Dynamics Nav. But I could not find the service through which I can perform this action. Need guidance to delete order lines with the help of service.
-
Dynamics NAV 2013R2 and XmlPort Calls on Windows 10 Enterprise
I was using Windows 7 on a pc and everything in Nav worked perfectly. I have updated the computer to Windows 10 Enterprise and something has happened because when executing an XmlPort it does not present the dialog box to select the file to import. Can someone help me with this please.
-
Dynamics NAV 2017 North America Tax per order
Hi guys, i have a question for Sales Orders in Standard. We have a webshop which is providing us all information like net / gross amount / tax rate / line discount. Now we want to create sales orders based on these values, but actually we do not know how we have to setup the system. - Do we need Tax area code? - Can we…
-
Job Queue not runing automatically; only when user logs in
In a NAV 2017 CU6 i am facing a situation where a job that has been set up in the job queue will not run automatically. Instead it is running the instance I log in. We have set up a range of jobs, both codeunits and report, and all except one run just as they should. However one job will not run automatically. Going…
-
the type 5056 was not defined for the function
We had this error when trying to export some tables in .txt format in NAV 2018, this was a database upgraded from NAV 2009. by looking at this post https://forum.mibuso.com/discussion/61125/the-type-5032-was-not-defined-for-the-function we were able to solve the problem by looking at custom added fields removing them and…
-
Microsoft Dynamics 365 Business Central Build 36510 Error wavw 2
The service 'Microsoft Dynamics 365 Business Central Server [BC15000]' (MicrosoftDynamicsNavServer$BC15000) failed to start. This can be caused by one of several issues. For example, the password for the account that runs the service may be incorrect, or there could be a conflict in port sharing for the port settings for…
-
How to link files in Dynamics Business Central 160
We are updating from NAV 2017 to BC160 that runs only on the web client and no longer has a RTC. The link functionaly has been radically changed. You can link to an internet URL or sharepoint file easlily, but we have not been able to set up a link to a network or local file. This link will work perfectly:…
-
Production: Project orders vs. Seperate Production Orders.
Hi Guys, In BC, we can choose to create a multi-level production as a project order, or as a series of separate production orders connected with reservations. Do you have an opinion of the pros/cons of choosing one strategy over the other? Thanks. Thomas.
-
BC: Change the name of a standard page
Hi Folks, Is it possible to change the name of pages from the base application via a Page Extension? I tried but thus far it is not working.
-
Field groups in AL
Does anyone know how to modify field groups in a table when using AL (ext v2)?
-
Handling Send HTTP Request POST
Hallo, i'm new in this Context, and have some Problems with the Authentication. I want to receive the Token from a Webservice to Consume and Download Data. I get Errors by sending the Request with username /Password The Service Provider means i have to take the creantials in the Body, but it doesnt work The Error is this:…
-
Error when creating link
I'm getting an error when trying to create a link in one the pages (i.e: Sales Order): A call to System.__ComObject.MoveFile failed with this message: Exception from HRESULT ...CTLE_PATHNOTFOUND. Any ideas?
-
Automated Testing in business central (BC 16)
Hi Community, I am doing automated testing in Business central and while testing one of my functions is using following code: CreatesubscriptionInvoices.RunModal(); CreatesubscriptionInvoices variable is of type Report. to run processing only report along with a request page but as soon code hits that line test case…
-
Sales Return Order - Wrong goods physically sent compared to posted sales shipment
Hi, I have a scenario where we have shipped Item A according to Nav but in reality we have physically sent Item B. I want to use a return order to arrange the collection\receipt of Item B back from the Customer. However as from the Nav perspective it never left stock I don't want to do a receipt or credit the customer for…
-
Sending PDF in NAV2017
Hi everyone, I need to publish a webService in NAV2017. This webService will receive a posted sales invoice number, and need to return the invoice in a PDF format. is this possible? A time ago, I read something about converting the PDF into base64, but now I cannot find any info about it. Any hint to solve this issue?…
-
Error while Importing Text File through Xmlport
Error while Importing Text File through Xmlport Cannot import the specified XML document because the file is empty.. How can i skip these error. or Skip the Empty File.
-
Business Central: Cannot publish...error about missing serverInstance..
Hello, Trying to publish an extension but getting error that serverInstance cannot be blank when I have in fact a value for it in the launch.json. Here's what it looks like: "version": "0.2.0", "configurations": [ { "type": "al", "request": "launch", "name": "Testing Customizations", "server": "http://xxxxservernamexxxx",…
-
Print PDF report instead of XML report
Hi Everyone, Is there any way in Nav BC to default the Print button to auto print the PDF version and not the XML or any other version. Is that easy to set in the request form or something?
-
NAV BC SOAP Navuserpassword Error 216 HTTP 500
Hi! I have a strange problem and i can't find a solution for it. I have created a service for SOAP access. Configured with NavUserPassword and SSL. In a web browser i type in the soap address https://nav.url.com:1111/NAVService/WS/Services. Enter username and Webservice key and login. It shows all available endpoints.…
-
Export to multiple sheet in excel - Nav 2018
I'm looking for an exemple of how to export data to excel in Navision 2018 using multiple sheets. We have a custom report for one of our client in nav 2013 R2 that export orders informations to different excel spreadsheet. Now that we are upgrading them to 2018, the code is not working anymore Here is part of the code in…
-
How to create sales order from web shop program?
Hi experts, A company is making a new web shop for our customer. The web shop is calling the NAV page 42 ("Sales Order") in order to create a new sales order and some lines on it. When they use Wizdler in the Google Chrome browser, it works fine. When they use their own code to call NAV, there are some "401 Unauthorized"…
-
[Business Central] Where to find BC170 preview images (docker or artifacts)
Hello! I'd like to ask where can i find BC17 on-prem preview images for docker, or as far as i know there are new artifact images as well which are "very well documented on microsoft's site". Thanks! Peter
-
Iterating over record set twice
Hi All Working on an extension where I need to swap items on Sales orders and Blanket Sales Orders (where qty shipped = 0). If I have sales order lines linked to the blanket lines, I need to do the following:* Disconnect the Sales line from the blanket * change the item on the line * Change the item on the blanket line *…
-
Associate field two tables
Hi, I'm working for a project and I need to take field "Sales Account" on General Posting Setup and put it on custom table to field "Id Account". The advice of project manager is: How can do this? Thanks so much and sorry for bad english
-
Global variables in a single instance codeunit
Hi experts ;) I am wondering if there are any recommendations about using global variables in single instance codeunits in Business Central/NAV. Generally, in modern object oriented programming defining and using global variables should be avoided at all costs. Are there any official guidelines for BC? Here is an example…
-
REST API call Date Header format
Hi, In BC16 I'm consuming an external REST API. To make a request, I use the HttpClient datatype. I'm struggling to add the http-header Date. It's unclear to me what is the correct format for the date header value as it is not documented. Already tried following date formats: 1/ httpHeaderDate := FORMAT(CurrentDateTime(),…
-
Copy Result of SetFilter to temp table (or other structure)
Hi All I need to filter sales lines by a number of attributes and make a copy before I update the selected lines. After updating the original; sales lines, I need to compare the updated values with the original ones: So SalesLine.SETRANGE("Document Type", SalesLine."Document Type"::Order); SalesLine.SETRANGE(Type,…
-
NAV 2013 to NAV 2018 CU2 upgrade error
I´m upgradaing from Nav 13 to Nav 18, when ´m trying to compile objects I´m getting this error Server instance: NAV2018CU2UPgraded Tenant ID: <ii>default</ii> <ii>Session type: UnknownClient Session ID: 5 User: MyComputer\Administrator Type: Microsoft.Dynamics.Nav.Types.Exceptions.NavSqlException ErrorNumber: 102…
-
401 when web service tries to access NAV soap web service without usedefaultcredentials
Hi, I have built a web service to be hosted on IIS. If I set useDefaultCredentials to true and I test my web method on IIS express it works. When I publish the web service to IIS and I attempt to run it with the same parameter set to true, I get: System.Net.WebException: The request failed with HTTP status 401:…