-
EU VAT Reg No. Validation Service Setup
Hello, Does anyone know if or when a service will be available for UK to validate VAT Registration Numbers? This was previously available via the service connection "EU VAT Reg No. Validation Service Setup" but is no longer valid since we have left the EU. Thank you.
-
wave 2 Add-in not found
I want to use control add-in in my project on wave 2 With setting But I have this error An assembly named 'Microsoft.Dynamics.Nav.Integration.Office, Version=13.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' could not be found in the assembly probing paths 'my folder\./.netpackages, C:\Windows\assembly,…
-
Want to create sales order for each line from sales quote
Hi All, I have created a sales quote with multiple lines added. Here i want to to create a different sales order for each line of sales quote. Explanation: I have a Sales Quote with two lines(X and Y). While i am clicking the 'make order' button in SQ page, It should create two different Sales orders one with item line X…
-
Page error.
Is there a way to clear the error on a page. I have code on a page that will throw the error message when a person tries to ship too much product. Simple calculation... works perfect. But when they correct the entry, the error ribbon still retains the error even though you can continue on with the entry. Just an annoying…
-
I can't evaluate a DateTime value
Hi, I'm trying to evaluate a value, however I am getting the following error: The value "2021-02-16T09:26:36.953" can't be evaluated into type DateTime. With what method can I solve the problem?
-
Cannot insert date to warehouse activity header table
Hi Guys I'm trying to insert current date when a warehouse activity (inventory pick ) is created and thought it would be simple but below code is not working: Table extension- Warehouse Activity Header .(inventory Pick) also tried "validate": trigger OnAfterInsert() begin Rec."Posting Date" := WorkDate(); Rec.Modify();
-
Execute function for two minutes or until nested function responds true in Business central
Hi I need execute TryCallData for two minutes or until GetPDF responds true How can i do it in Business central?, Thanks procedure GetPDF(Bill: text) ReturnPDF: Boolean begin <Statement> end; procedure TryCallData() begin while not GetPDF('HMO986') do message('waiting...'); end;
-
Quickentry not working?
hi All, hope someone can help. It seems like we don´t have nextcontrol anymore so I placed quickentry in few fields. However it seems not to work (it goes always to the next field and then to the top of the page). Do I have to set quickentry=false in all the remaining fields? Thanks. Edit: I will answer myself: On classic…
-
Report layout in NAV/BC.
Hello, I'm creating a Sales Invoice report layout. I am trying to hide one of the columns in a row but keep the size of my table. E.g. when the "Item No." column is hidden, the "Description" field size grows. I would be grateful for your suggestions. Thanks.
-
How can I install Test ToolKit on an existing Azure Container?
I have created a Business Central conatiner in Azure using az container create ` --resource-group 'RG-Container' ` --name 'democontainer’ ` --image mcr.microsoft.com/businesscentral/sandbox:13.1.25940.26323 ` --dns-name-label 'democontainer’ ` --port 80 Once installed, how can i now add / install the testtoolkit ? I dont…
-
Nav 2016 Web Services Pausing
We use Nav 2016's web services for various minor tasks. All has been working well for years, but yesterday we started getting random slowdowns that seem to consistently last 2 minutes. For example we'll send a command to update an order, let's say changing a checkbox from checked to unchecked. The response will take a…
-
Converting Unicode to UTF-8
Hello, I am trying to convert a simple text from Unicode to UTF-8 because our Webservice can't handle Unicode. I couldn't find any NAV native functions to do this and after trying to find a solution online for a couple hours I find my self here. NAV Version: BC14.12 Any help is appreciated
-
Permission error when upgrading from Business Central 16.1
Hello, I am trying to upgrade Business Central 16.1. I have tried upgrading to 16.2, 16.6 & 16.10. No matter the version, when I run the commandStart-NAVAppDataUpgrade -ServerInstance BC160 -Name "System Application -Version 16.10.21502.0" I get the following error: The "same" error, has also looked like this with later…
-
how to add AL code extension to a Condition
Hello Everyone, Good day. I'm having this problem right now adding AL Code extension to a condition. Please see screenshot below Does anyone have an idea on how to proceed ? Thanks and God Bless :) Regards,
-
Matrix
How can I find the cell (column no.) that the cursor is currently in without having to click into the cell? (NAV BC)
-
How to connect to MVC application
Hello, How to connect to MVC application eg ASP.NET C# to import data from web service? From Business Central Cloud it is not possible to connect to the server due to restrictions, so I need to use an offline "bridge" to import data from the Web Service. Is there a way to do the above approach? The image above is a diagram…
-
Problems with Job Queue Entries and Task Scheduler in Business Central 14.0 OnPremise - C/AL
Hi everyone, In our team we are facing an issue with "Job Queue Entry" and "Task Scheduler": Every process enqueued in the "Job Queue Entry" is executed only once even if it's scheduled to execute more than once. The first time it runs only when the service associated with the task scheduler is starting or restarting. Here…
-
How to setup trailing sales orders NAV 2018?
I need to show amount the only that is not accumulated from the previous year in the picture is sum previous year thank you for your answer.
-
Lot Expiry Dates on Whse Item Journals
Hello, When items are booked in during the putaway, a lot number expiry date is applied. However we have a situation that Warehouse entries based upon Whse Item Journal lines are not carrying the expiry dates. Is this supposed to be this way, or is there missing setup to carry these dates? Thanks
-
Setting Change_Status on Service Contract Header
Unable to Open & lock Service Contract Header : ServiceContract contract = new ServiceContract(); contract = css.Read("SK-99999"); contract.Change_Status = Change_Status.Open; css.Update(ref contract); contract = css.Read("SK-99999"); contract.Change_Status = Change_Status.Locked; error -> css.Update(ref contract); Errors…
-
NAV 2013 R2 with Azure AD authentication
I'm trying to configure app registration from Azure AD for NAV 2013 R2 using Access Control Service (ACS) credential. the web client is working well and can login using azure AD account, but the windows client having some error as below: Understand NAV Windows client does not fully support Windows Azure AD and we can only…
-
Using a x-www-form-urlencoded Rest API with Business central (to get token)
Hi everyone, I'm trying to develop a function with AL that permits to Post a url encoded content. It works fine with postman. The following procedure that I've started developping doesn't work : procedure GetToken() ResponseText: text; Var client: HttpClient; cont: HttpContent; header: HttpHeaders; response:…
-
Task Scheduler: How to pass parameters to OnRun Codeunit
Hello there, the TaskScheduler.Createtask Function has the optional parameter of RecordId. How can I "access" the value of the specified RecordId when the task is executed? Is there some kind of parameter that's getting passed to the OnRun Trigger of the Codeunit that gets executed? There's almost zero documentation to the…
-
B365 Excel Buffer Autofit, BorderAround and GiveUserControl no longer exist in the Excel Buffer
We are recently upgrading a client to Microsoft Dynamics 365 Business Central from NAV 2013. The following functions no longer reside in the Excel Buffer table and I am wondering how these functionalities are being done in Microsoft Dynamics 365 Business Central. Any help would be appreicated. • ExcelBuf.AutoFit •…
-
Required AD Functional Level for BC17
Hi, Setting up BC17 in a proper 3 tier environment. Service account has been provisioned and configured according to this. However, can still only access the web client from the web server. From other domain attached machines: The AD functional level is currently on 2008, will this suffice or what is the minimum…
-
AL Code error AL0999: Internal error: System.AggregateException
Hi all, I'm working on some code merge pdf files (using the old code in C/AL ) on business central using AL Code. I got an error while compiling: and this is my code: Many thanks for your help!!!!
-
Payment Entries Appearing on VAT Exempt Section of VAT Statement Report
Good Day All, I have a Business Central Query Regarding Payments Appearing on the VAT Exempt part of the VAT Statement Report: I've Navigated to VAT Statements on Business central as seen on VAT1.png And once the VAT Statement Report Opened, I quickly Clicked On Preview as shown on Preview.png This opened up the VAT…
-
design pattern help - how to create a record from another system?
I'm trying to make creating a purchase order for our users easier and want to be able to create PO from another system with the Dimension 1 shortcut we have setup pre-filled Ideally I'd like to create a page that I'd like to like this https://MyIntstance/Live/?page=50&dc=0&mode=create&company=12345&Dimension1=abc What I'm…
-
Auto Export of Item List
Hi Experts, I need to automatically export data (Item List) from NAV 2018. I've been searching online and got a clue that I must create a codeunit for this and use a job queue, but I really don't have a background in writing script. May I know if is the right way to do it and where I sould start?. Thanks in advance.
-
Federation Service endpoint login failed - BC16 to BC17 upgrade on Start-NAVAppDataUpgrade
Busy upgrading an environment to BC 17.1, and I'm at Task 8, step 1 - running data upgrade on System App and Base App. However, it basically just hangs - zero errors thrown in console. Zero app server CPU activity and nothing happening on sql server either. In the Event log, this immediately pops up:The Federation Service…