-
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:…
-
Register record of Sales Shipment/Invoice Line
Hi, I have a project for NAV2013R2 where i have to take some records of sales shipment line and sales invoice line and write them on custom table(with page action). Before this, the user can filter (when push the action page) records for POSTING DATE only month and year(for example if user set 04/2020, "process" write on…
-
In CalcFormula of FlowField, how to filter the values on basis of some field from a setup table?
I have a solution where FlowFields are calculated on the basis of a hard coded filter, now i have moved all the hard coded values to a setup table to make the solution generic. But i am unable to filter on the basis of field from setup table. In the image below, i want to filter it like "Job Task No." =…
-
SOLVED: An error occurred while sending the request. Unable to read data from the transport...
Hi, I'm trying to publish an extension from Visual Studio for BC16. It has worked many times before, but now I am getting this error: The Danish part means: "An existing connection was forcibly closed by remote host." I've tried repairing the BC installation, restarting service, restarting IIS, but I'm still getting the…
-
XMLport send Post Code plus Ship-to Adress
Hello all, I'm building a XMLport that sends some information to our internal sofwtare, such as name of contact, address , post code etc..im getting difficulties on the post code. The logic is, if the the contact is customer, then it returns by default the customer post code. If that customer has more than shipping address…
-
Cloud Migration - Failed to enable replication
We are currently migrating a customer from NAV2017 on premise to the cloud. I have carried out all steps to upgrade to BC16 on premise, but when attempting to setup the cloud migration, I am getting the message "Failed to enable your replication". We tried this a couple of weeks ago with the Sandbox, and it worked a treat,…
-
Pages on mobile devices - Warehouse Processing
Hi Guys, I am wondering what approach do you take to implement pages on mobile devices. So here is the simple scenario: I want my warehouse worker to scan the product and receive the qty on hand. What we have been doing is providing workers with android phones with Bluetooth scanners with the connection to NAV (2016 on…
-
Write only to an external database in BC 15 OnPrem
I'm trying to write (insert) to two external tables from an on premise installation. We're essentially updating shipment label information for an external process to pick up the label data. I have no need to read or modify existing records in the table, although I will need to be able to delete based on a date/time filter.…
-
Dimension not appearing after running Calculate Depreciation for FA
Hi Friends, [Version NAV 2018]. After running Calculate Depreciation for Fixed Assets, in FA G/L Journal in the Dimensions Code column the value is not picking up from Fixed Asset's dimension and it is blank for all Fixed Assets. I might be missing something somewhere. Can anyone let me know what am I supposed to do?
-
Can I modify the Standard report in BC 16?
Hi guys, May I ask how I can modify or add a new field in the BC 16's standard report? Thank you.
-
[Business Central] Showing Notifications on Sales Oder Processor Role center Page
Hi Community, I have a problem regarding notifications on my Business central 16 On Premises version. I am showing a notification on 'Order processor role center' page using 'OnRoleCenterOpen' EventSubscriber but what happens is when I refresh the role center page it refreshes twice and notifications appears twice but When…
-
Cannot create an instance of the following .NET Framework object:assembly TransAutomClient
Hello, I am newbie here. During my testing for a scheduler job, testing connection, i have encountered this error. Please help me.
-
Mass updating sales lines
Hi All Written a few small extensions and need to write one that updates all sales lines with no shipments. We frequently have to swap out items for replacements (but need to keep the old ones as we may sell later) So I need to create a codeunit to swap the item on sales lines. I've got it working except for when the sales…
-
Sorting on flowfields (in NAV 2017)
Typically, we can sort on any field by clicking on the column header, even flowfields. E.g. sorting on Net Change in T18 Customer works fine, as well as on Inventory in T27 Item. However, if I try sort on Net Change in T15 G/L Account I get error: "Sorting cannot be done based on the Net Change field(s) in the G/L Account…
-
how to clear listpart data?
When I'm creat a new card page it gets previous card page data. How I can remove this problem?
-
Authenticating against Web Services on Docker
Hi, We're building local Docker Development Environments for NAV2016 development (Using standard NavContainerHelper functions). I'm trying to call a NAV web service using a couple of different web service testing tools (Postman and SOAPUI). In either case, I'm getting an authentication error: HTTP/1.1 401 Unauthorized…
-
Business Central 17 - D365 2020 release wave 2 preview
Hi All, I'm upgrading a vertical solution to business central AL from BC 14 C/AL. Does anyone know of a preview version of BC 17, maybe on docker that I could get my hands on please? Or do I need to use BC 16 for now? Regards and Thanks Roddy
-
Date Formula
Hi, I have a hard time figuring out what my date formula should look like on my items. Our suppliers deliver 2 times a week (tuesday and friday) so what I would like to achieve is that the customers would get the fastest delivery date. E.g. if a customer orders on a wednesday and our suppliers have 3 weeks delivery the…
-
Read image file by webservice in AL
Hi All, I hope somebody can help. Im trying to read an image returned from a webservice, however, I´m not sure much about it. This is what I´ve used for reading xml response which is fine, since is a text that I then parse, but as image, I´ve never done before. Any ideas? thanks a lot. RequestHeaders :=…
-
[SOLVED] Passing Data to JavaScript Addin
Hi Guys, We are starting with the Adding development and I was wondering what is the preferred way of passing a lot of data to JavaScript addin. Sure, passing single variables is simple, but what about something like an array? How about a record? Any help is appreciated. Thanks
-
Two Sales Order Workflows required
Hi, I have an issue with the workflows that have me confused and I cannot seem to find any solution for this issue. The scenario is as follows; We have 1 workflow that is setup under sales, MS-SOAPW where we have set certain criteria for this workflow. It is a custom field on our Sales Order for Gross Profit percent, and…
-
Can't "Print WHT Certificate" on page "Payment Journals"
I've tested and debug from different version, The result is still the same error, What should I do?