-
Remove Schema from Xml export via XMLPORT
Hi, I'm trying to remove the schema part from the xml exported by a xmlport. The objective is to only get the generated xml without the schema part. I'm about to quit this xmlport nonsense and go for a codeunit. I tried something like this after the export, but it never finds the node i'm after <xs:schema>…
-
item tracking. importing serial nos from external system
Hi, Not an expert on item tracking here :-) External system assigns serial numbers to Purchase Order Lines via BC extension method (see code below) Sometimes, purchase order line already has the serial numbers assigned and they could be the same as those in external system. External system does not know about it and still…
-
BC14 Service Tier Event Log errors
Hi, we are running BC14 and in the eventlogs of our servers I see a lot errors like this one. Protokollname: Application
Quelle: MicrosoftDynamicsNavServer$BC14-TEST-EK1
Datum: 08.12.2023 11:34:49
Ereignis-ID: 708
Aufgabenkategorie:(33)
Ebene: Fehler
Schlüsselwörter:Klassisch
Benutzer: Nicht zutreffend
Computer:…
-
Service to service auth and multiple api customers
Hello, guys I would like to investigate such case: - BC Api exposed with s2s auth i.e. creating webshop integration - is it possible using azure and BC to distniguish customers i.e. register the api with s2s muultiple times but in oauth claims put customer no and use it in bc? - or the only possiblity in such case would be…
-
API Page-OnInsertRecord(BelowxRec: Boolean): Boolean
Hi all, I have created a new custom API page, and I have seen in a book and in the standart API pages that exit(false) is used in OnInsertRecord(BelowxRec: Boolean): Boolean on API pages. Could you please tell me why is like that. In which cases I have to use exit(false) ? Thanks Ivona
-
Document signature - XAdES-BES format
Hey, Is there anyone who has implemented Documents (such as xml) signing in XAdES-BES format in AL or C/AL?
-
BC service falling over
Hi, I have a client whereby the BC service is falling over a couple of times a day, this is from the event log:- I was wondering if anyone has seen this before? Regards and Thanks Roddy Server instance: SVCT-Live Tenant ID: Environment Name: Environment Type: User: Type: System.OverflowException Message: Arithmetic…
-
Codeunit SignedXML
Hello, I'm trying to use the codeunit SignedXML in Business Central to get an XML signed. I have spent a long time without any results, Can anyone help me? Thanks in advance
-
Block users from deleting system notes that wrote other user
Hello, I used OnBeforeDeleteEvent for this, but the problem is that it also triggers when users are converting a Sales Quote to Sales Order. It also happens when deleting Records containing notes. Is there a way where I can block the user only when it's pressing the delete button of a systempart Note? Thank you :)
-
How to make reusable sales quotes in BC?
Hello, we want to make templates for sales quotes which can be used for different contacts/customers. It is possible to copy sales quotes, but prices etc. get lost or have to be recalculated. So I want to know what's the best practice. Should you create a "master" contact or a "master" customer to store the templates?…
-
separate schema inside NAV or BC database
Hi All Is there any issues in creating and maintaining a separate schema inside the BC or NAV database and creating and maintaining custom SQL views to extract data from NAV tables? Will this be lost or change or creating any problem?
-
Problem reading xmlnode
From webserwis I get the following file XML. <?xml version="1.0" encoding="UTF-8"?> <reservations> <reservation> <comId>84913135</comId> <resId>63960910</resId> <lanId>11</lanId> <voucher>REZ/2022/0153</voucher> <term> <from>2022-11-20 14:00:00</from> <to>2022-11-23 10:00:00</to> </term> </reservation> <reservation>…
-
Restore BC OnPrem from BCOnLine Bacpac file
Hi, Has any one ever done this before? The steps I used to do this: 1) Download bacpac from BCOnline 2) Dowload and Install BCOnPrem with the same app version as BCOnLine 3) Import bacpac file to a SQL Server database 4) Set BCOnPrem to multitenant 5) Mount BCOnline tenant db to BCOnPrem instance 6) I get errors in NAV…
-
How to create custom workflow for customized table and customized page?
Hi experts, Is it possible to create customized workflow for a customized page related with customized table in NAV. How far it is possible and if yes, how we can achieve it. Please help.
-
question regarding calcfields repeat-until
Hi Guys, Kinda new here.. My issue is that i'm trying to calculate and sum all the 'remaining amount' entries in vendorledgerentry based on the start date and vendor no i'm entering in the report request page. For example if its 11/24/2023 that i'm entering on the request page all the entries before this date's remaining…
-
Degraded the Calcum of Quantity per Min and Max , and Level
Hello I have create a table Configuration whish the field's is (SalesPersonneCod;StartDate;EndDate;Level(Option : 16); WeightFrom;WeigtTo; and Amount So, i need to calc the sum of item ledger entry. entry type:: SALES per Salespersonnecode,and Posting date [StratDate|EndDate] and after get the difference between two…
-
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.…