-
NAV 2013 R2 Object changes not working until service is restarted
Hello Everyone I am facing problem then I am making change in Codeunit but it does not work until service is restarted or Sync-Tenant Command is used using PowerShell. Version is 2013 R2. I have verified and assigned necessary permission to Service Account and my user on SQL Server and service tier. Any suggestion or help…
-
Adapting Dotnet usage - Moving into Cloud development
Hello all, As you know, in AL development, when you change your target:"OnPrem" to "Cloud" to follow the Universal Code Initiative, your dotnet variables and some functions blow up. I lost count of all the modifications that I had to do to XML/HTTP/web request-related variables and file management, so I thought it would be…
-
is it possible to select customer template before create new customer (via API)
Hi All, I am planning to create new customer from API (Cloud BC) but i want to select from which template first. is it possible? Thanks.
-
Run codeunite when a new value is added in Service Invoice Header.
Hi everyone. How I can run CodeUnit when a new value is posted in Service Invoice Header.? Thank you for help
-
PageBackgroundTask issue
Hi all, I have a problem understanding why OnPageBackgroundTaskCompleted and OnPageBackgroundTaskError are not triggering in my page, in some cases. The page consists of a group and a repeater, the repeater shows some records and the group contains cues for totals. I want to update the value of one this cues through a…
-
Data Upgrade Error
Hi, i've been working on this for several days now, but can't seem to find any solution. I am doing a test upgrade from NAV2009 to NAV2015, but on the Data Upgrade, I always get the error 'Choose a valid field in the Contact table'. The error shows up when I execute a Get-NAVDataUpgrade -ServerInstance -Detailed |…
-
Creation of "My Notifications"
I want to implement custom "My Notifications" for all users. Where are these initialised in code? Thank you.
-
Change user password?
After login into BC on-Premise (using NavUserPassword), how can a user change his own password at any time.? Is in't supposed to be under MySettings page?
-
Reports multiple dataitems
Hi , I am making a report where there are three datatiems and the last two dataitems makes a relation with first dataitem. Both last dataitems consists of multiple records(table of list page). Report layout have diff tables for every dataitem. Now If I do publish the report, all tables in report layout gets equal no of…
-
Full upgrade path from 22 to 23
What is the recommended way to do a full upgrade of a live system (On-Premise) from BC 22 to the latest release available now? May I know whether there is a step by step guide somewhere? I searched and came across only the Technical upgrade guidelines. My understanding is that this is different from a full upgrade ??
-
Read XML File
I was hoping someone could help me. I want to be able to read an xml file in code rather than through an XMLPort. I know there are other threads out there on this but they can all get a bit confusing especially as it's an area i'm not overly familiar with. Can someone just give me a quick pointer on how I can read the file…
-
Business Central OnPremise – Microsoft AL connected to SQL Server by .NET
Hi, I have replicated the code, but when build it gives me the following error. I've done my research, but I not find anything. https://robertostefanettinavblog.com/2023/06/22/business-central-onpremise-microsoft-al-connected-to-sql-server-by-net/ Error: [2023-07-27 17:18:31.80] Publishing AL application using launch…
-
Json reading array using JSON Management, Variant value to loop throw the values arrey 1 to 10?
{ "enum": [ "1", "2", "3", "4", "5", "6", "7", "8", "9", "10", ] } Hello every one¨need your help please :-) Json reading array using JSON Management, Variant value to loop throw the values arrey 1 to 10? gJSONMgt.InitializeObject(TempBlob.ReadAsText(CRLF,TEXTENCODING::UTF8)); gJSONMgt.GetJSONObject(gJsonObject);…
-
Problème with the use of Trigger when service order is posted.
Hello everyone, Please I need your help. I have one CodeUnit that I want to run when I post Service order. In post action of Page 5900, I call the codeunit (CodeUnitName.RUN(xRec);) but I receive the following message. . I think that the error occures because when I post "Service order" the related data was submitted.…
-
LS retail : text file transfert from server to pos
Hello, I want to transfer a txt file from the server to the pos. I followed a procedure and activated the "Old DD support" and check "Allow File Transfer" option. I set up a scheduler job with "job type" = Custom, codeunit 99001465 and text option "SRC=c:\temp\test.txt;DEST=c:\temp\test.txt". But it doesn't do anything.…
-
The record is already open ?
I have a page with area faxboxes, part attached documents, but I get an error, "The record is already open". It is in all companies in this environment. The same code works fine in 25 other environments. Customer Card works fine in this environment, so where to look for the error? Regards Maria Code: area(factboxes) {…
-
BC on prem V22 upgraded from V20 dreaded An Error Occurred OpenID issue?
I am working on an upgrade from V20 to V22. The V20 uses AAD and works fine. Moving to V22 means that we have to change to OpenID. I worked thru https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/authenticating-users-with-azure-ad-openid-connect?tabs=singletenant,admintool this now…
-
Remove a record based on a filter from a CSV file
How can I delete a record from a table based on the item No that exists in a CSV File? I have 3090 Item Nos For example, I would like to SetRange("Item No.", 'Item #1 from the excel sheet') IF Findfirst() then Delete(); and then SetRange("Item No.", 'Item #2 from the excel sheet') and so on
-
Building a "Generic" lookup function
I have a table that references multiple fields from other tables (similar to Config. Template, although Config. Template Line is limited to one “external” table.) Each one of these fields has a “unique” lookup based on the table Relation on the field, or may be a Boolean (in which case the lookup should be Yes/No) or an…
-
Decimal number format
Hi everybody! I tried to format a decimal number to get "76543.21" using: FORMAT("Credit Limit LCY)",0,'<Integer><Decimals><1000Character,.>') This is the Navision help file syntax, but not working... the result was: "76543,21" (comma instead of dot). And if I have "zero", the result is only "0" but I need "0.00". What's…
-
How to save an excel book with Microsoft.Office.Interop.Excel
I am trying to save an excel file as xlsx. I tried to add Local:=true but the file is open but not saved (with no errors): XlFileFormat DotNet Microsoft.Office.Interop.Excel.XlFileFormat.'Microsoft.Office.Interop.Excel, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'…
-
BC OnCloud : Deployment failed : check the country and version availability in the extension market
Hi all, I have one simple extension, and when I try to install it via Visual Studio, works everything fine, but when I try to install the extension as PTE in the TEST-Sandbox I'm getting the following error message: Deployment failed. Errors: App ID Message : { The app (or one of its dependencies) is not available for your…
-
SMTP with OAUTH 2.0 - BC22 OnPrem
Hi all, Configured a BC22 instance with Credential Type = AccessControlService. Created an Email Account entry, Account Type = STMP: * Applied Office 365 Server Settings * Email Address & User Name = support@<domain>.com * Sender Email Account = Specific User * Authentication = OAuth 2.0 * Completed the "Set Up Azure…
-
This SqlTransaction has completed it is no longer usable
Hi folks, I am facing this error for days and I still can't find a solution. Here is the error: I have multiple services that connect on the same sql server instance and obviously on the same database. Our IT Managers did this for balance computing, or at least this is what they said. This is part of the stack trace,…
-
Browse a "network" folder and import files (pictures) - NAV 2016
Hi First - i'm not all that familiar with the 3-tier yet and therefor I struggle a little on different development issues. One thing i'm working on (and struggeling with) at the moment is how to do the following We have a lot of items (fashion clothes) and needs to attach pictures in NAV to these. In the old NAV (2-tier) I…
-
User take a long time to access Dynamic NAV client 5.0 when i changed AD (hostname and IP address)
Dear ALL, I'm using Dynamic Nav 5.0 client with SQL2008 option and using Windows authentication (AD 2012R2). I upgraded to AD 2022 with a different IP and hostname (still keep old DC off not destroyed yet), then our NAV users take a long time to access Dynamic NAV app (10-15mins). it just took 5s before. is there anybody…
-
Excel Buffer Import Date Issue
Hi, I am using the Excel Buffer functions to import data in NAV from an Excel Spreadsheet. The functions are ReadSheet and ParseCellValue. The issue I am finding is that it reads the date column and somehow it always ends up 1 day earlier than the actual date. So if I have in Excel 05/08/2012 it will bring in 05/07/2012. I…
-
Inconvenience when trying to obtain information in a report
I created a custom report in BC, information is obtained in the header, however I cannot obtain the records for the lines. I have already confirmed within Microsoft Report Builder that there is no visibility condition, so I think the problem is in the .al code but I have not been able to detect the error. I share my code…
-
Docker and HTTP send
Hi, I've set up docker with a type sandbox and I have to test some HTTP sends to an external URL (it is a government test URL for submitting tax details). However, every time I try a HTTP send I'm getting an error code 0. Is there additional setup for docker to handshake with the outside world? I am running BC22 :)…
-
Modify data inside "<cac:PaymentMeans>" (Peppol)
How do I modify the data inside "<cac:PaymentMeans>" when generating PEPPOL BIS XML? <cac:PaymentMeans> <cbc:PaymentMeansCode>Change value from 31 to 30</cbc:PaymentMeansCode> <cac:PayeeFinancialAccount> <cbc:ID>Set bankgiro value</cbc:ID> <cac:FinancialInstitutionBranch> <cbc:ID>Set to SE:PLUSGIRO</cbc:ID>…