-
Automation translate in DotNet Help Me!
Hi all, I'm new in this area, in my company we are making a full migration from NAV2009 to NAV2018. There are some automations but as you well know they have been abandoned. One of them is the following : Microsoft ActiveX Data Objects 2.8 Library.Stream we would like to replace it with the DotNet does anyone know how to…
-
Error in Invoke-NAVApplicationDatabaseConversion for Azure SQL
Hi, I am upgrading BC15 database to BC17. I am getting the following error when I run the Invoke-NAVApplicationDatabaseConversion command: Invoke-NAVApplicationDatabaseConversion : The database create operation failed due to the following error returned by SQL Server: Execution Timeout Expired. The timeout period elapsed…
-
BIN Contents lines....
Hi, a user has queried with me why BIN content lines exist when QTY is zero which has confused me a little .. why do they exist if the QTY is zero on the line ? is there a task that updates this table ?
-
External Tables in BC
Our client needs to connect to an external SQL database used by a third party application. I've been looking into how to accomplish this, but there seems to be surprisingly little documentation on this topic. I could find some information for Dynamics NAV, but our client uses BC Cloud. From what I can tell, there are…
-
Are you concerned about converting your customers to BC SaaS cost-effectively?
Simplanova invites Dynamics partners to join the webinar: Cost Effective Way to Convert Your Customers to BC SaaS. Register for the webinar HERE. Webinar Date and Time: Thursday, 19th of August, 2021, 04:00 PM CEST (Central European Summer Time). During the webinar, an instant upgrade quote model will be presented which…
-
Transfer header does not exists. Identification fields and values : No. = 'TS-00010'
While ship the transfer order, I'm getting Transfer header does not exists. Identification fields and values : No. = 'TS-00010' this error in Can anyone suggest some answer Thanks in advance.
-
BC140 Start-NAVServerInstance: "The system is currently updating, try to connect later"
We have four NAV servers. After a restart, we have the following warning on the heavy load NAV servers for about half an hour when we try to connect: Microsoft Dynamics 365 Business CentralThe system is currently updating, try to connect laterOK Can we make changes in the Configuration, or what is the problem?
-
How to split a record and format to string?
Lets say we have a Code record with 3 digits. Based on first digit we would want to format to string? Example: 001 = Lion 101 = Tiger 201 = Moth Would appreciate any help.
-
DELETEALL without locking table
Hi Guys I'm still trying to find better ways to do stuff in BC AL. I did a mistake in a loop and loop didn't stop so I had to delete records using something like below: SalesHeader.SETRANGE("Document Type",SalesHeader."Document Type"::Invoice); IF SalesHeader.FINDSET THEN SalesHeader.DELETEALL(TRUE); Now the I got an error…
-
Import Data by xmlPort - one File in different Tables
Hi, possible someone can help me out with my problem. I have a CSV file with 400 columns that I want to import with an xmlport into tables in NAV. For this I have created 4 tables with x fields and an xmlport. Structure of the xmlport see appendix. The Entry No I pass no per data record and table. There is no LinkTable…
-
Au Nz Statement - Email
Does anyone know of an extension available for emailing Aunz statement in AU BC
-
How to get the "Temporary Navision Path"
Hi, Does anybody know how to get the "Temporary Navision Path" (TempFilePath from Navision options) within Navision. I need this path to save a Temporary file. If this is not possible I would like to get the Windows Temporary path. Thanks, Emiel Romein
-
Credential Types | ExchangeIdentity and TaskScheduler
Hello guys, Do any of you know what these types of authentication are for on the Administration Server? (ExchangeIdentity and TaskScheduler) In the microsoft documentation it just says "or internal use only, and should not be used." Thanks!
-
Better way to insert Dimension Set ID from AL code
Hi All I am developing an extension to import invoices from an excel file and the excel file contains columns for dimensions. Now I can get this to work but the code is long and looks inefficient. Is there a better way to handle this than below which is based on blog…
-
Export XML lines without header
Hi!, I'm using an XMLPort to generate an XML but I need generate an XML like this: (repeating error without header): <Response> <Errors> <Line Number=1> <Comment>comment</Comment> <Error>Error x</Error> <Error>Error y</Error> <Error>Error z</Error> </Linea> <Line Number=2> <Comment>comment</Comment> <Error>Error x</Error>…
-
How can I automate republishing?
As it currently stands, BC requires all apps with dependencies to another app to be unpublished before it's possible to update it, making us either have to unpublish multiple apps manually or unpublishing and publishing every custom extension through a hardcoded sequence of PS-commands. I find this very tedious and…
-
NAV 2016 TextEncoding problem
Hello, I have a problem with TextEncoding. In general, what I am doing is:TempBlob.INIT;
TempBlob.Blob.CREATEOUTSTREAM(OutStream);
OutStream.WRITETEXT(SomeTextVariable);
TempBlob.ReadAsText('', TEXTENCODING::UTF8)) Where SomeTextVariable = 'xńx'. As you can assume 'ń' is making me some kind of trouble. Sometimes (but not…
-
A how-to question
Hi everyone, I wonder if it’s possible to make a phone call using URL? If so, how can I do that? Thanks in advance.
-
Dataverse Integration Sales -> Business Central
Hello to All, I have setup the integration between D365 Sales and Business Central successfully. Creation and updates of accounts is working fine between the two systems however when i deactivate an account in D365 Sales this does not update the Customer in Business Central. I am using the OOTB functionality. I was just…
-
Testing ListPages
Hi, Is there any way to invoke the "New" Action on a Testpage based off of a ListPage (e.g. CustomerList), in a way that the CardPage opens with the new Record? TestPage.New only "puts the cursor in a row" - which does nothing in a Page that is not editable.TestPage.OpenNew does nothing in a ListPage as far as i figured it…
-
Item Unit Cost
Hi, In an average unit cost codebase .. is the "unit Cost" on an item record inclusive of "indirect cost %" or is this only considered when entered on a purchase line ? And is this ever considered when entered on a sales line ? MY current testing suggests no to both but im curious as to why, if it is so..
-
Reservation Entry
Reservation entry not getting update when changes in sales line.
-
How to Import XML File to BC
Hi All.. how to import xml file to BC? I am not familiar with XML port? should we use XML Port? or use standard code? anyone can share? here is the sample file.<supplier operation="add" id="V-000001" exportTime="2021-07-16T18:03:04">
<alias>VENDOR ABC</alias>
<company>Vendor ABC</company>
<addUser id="1">dcs…
-
Activating "SN Warehouse Tracking" afterwards
Hi all, this has been asked before, but with no real answer. We have just one Item Tracking Code with "SN Specific Tracking", "SN Purchase Tracking", "SN Transfer Tracking" and "SN Sales Tracking" enabled assigned to many items. No we want to use bins for some locations, and in order to create Warehouse Entries with the…
-
Sorting cannot be done based on following FlowFields, you must set the security filtering mode to ‘F
Hi, Need help I logged into development environment and changed the property of the flowfield from validated to filtered but the error still persists
-
OK button in BC
Hello, I have an issue when running a page using runmodal = lookupok The source of the page is a temporary table And when this table is empty the OK button is disabled Is there any way to enable it?
-
FILTERGROUP Sales Order by Location
I'm having a filter problem on the Sales Order list and the Employee warehouse table. I want to set filters the Location codes on the Sales Order (sales header) according to the location codes of the user when opening the Sales Order List page. (The Sales Order list only shows the location codes by the warehouse employee…
-
Key field in Webservice
Page 201 "Job Journal" is published as a webservice, when i read multiple lines from the job journal through post request from Postman i get all the data plus a field "Key". I am not sure where that "Key" is coming from and how is its value populated. I want to store this key to a custom field in Job Journal Line table,…
-
xxx is inaccessible due to its protection level AL(AL0161
Hi, We are in the process of migrating our C\AL application towards AL. One of the issues we need to deal with is that in some page extensions we would like to access the value of a global variable in the base page. However this is impossible, getting the message "xxx is inaccessible due to its protection level AL(AL0161)"…
-
NAV Mobile App cannot connect to the server on Tablet
Hello Good day, Masters. I have a problem using NAV Mobile app, it says Cannot connect to the server. 1. I didn't use HTTPS, only HTTP. didn't use any signed or self signed cert. all I did is that I install normal configuration and that includes web and just forwarded the port. 2. Outside network, Web and Phone client…