-
XML File Signature
I need to send an XML file created with XML Port object to an external web service. Webservice verify file signature to check real file format. It expects to receive an xml file with the first 5 bytes set like this: 0x3C, 0x3F, 0x78, 0x6D, 0x6C, 0x20 but file created from BC contain file text signature: ef bb bf or ff fe…
-
Error While Using Business Chart DLL in Factbox of Item List Page!
Hi Experts , Iam getting below error when i defined Business Chart Variable in a new card page and setting ControlAddin Property of the field . When i try to recall the new page created with Business Chart as Part-Page in Item List page using Business Chart Buffer Table (485). it is throwing below error. A DotNet variable…
-
Excel Buffer How to Check Worksheet Exists
Hi All I'm importing an Excel file with multiple worksheets into BC SaaS, and I want to check if a specific worksheet exists and if not provide a user friendly error message. Say worksheet "Order" does not exist.
-
Need help: Migrating Business Central 14 to business central 22
In my version 14 fields were directly inserted into the system tables instead of making extensions. As a result, when migrating to business central 22 , when you publish the "Base Application" extension on version 22 and you want to synchronize, you get errors relating to the base tables of version 14 modified (The tables…
-
Business Central 140 CU9 - Issue with SignalR
Hi We are seeing alot of SignalR messages in relation to poor performance with BC140CU9 WebClient Anyone experiencing the same or know what the issue is ? Prod.Client.WebCoreApp.ReliableMessagingHubMiddleware SignalR. Large count of messages in the queue (50). We cannot see any direct performance issues to server…
-
Potential risks of deleting G/L entry (Archive to new table)
Hi Experts, Can somebody tell me the potential risks of deleting G/L Entry data (Archive to new table for later reference purpose) which are older than 7 years as customer don't want to keep old history coz of growing day to day data in this table. This table is already huge (over 100M records). For the deleted GL entries…
-
User Permission set issue
Dear all, When user try to post purchase receipt , he is getting following error. sorry current permission prevented the action (tabledata vat setup read : base application) error in business central. please let me know which permission set to add in BC Thanks in advance. Regards, sekar.
-
SOAP API Call returns Message: Message is closed.
Hi All, I encountered a very strange situation for a customer. We have a live VM running on azure. Which has 4vCPU's. On this VM we have 6 BC 17.0 instances. We have split up the services for the functionality so 3 of them are SOAP API services. Every time the server reboots after .net updates our 3th party receives the…
-
Warehouse register table and ADCS
We have been having issues with some of our picks not registering on NAV. Having looked at the event viewer logs, I could see that the warehouse register table had been locked. I am not entirely sure if the picks aren't registered because of this locking. Anyone here has had this before? Or is it something else that might…
-
Send PDF to Azure Function
I am trying to create azure function which will take PDF sent from BC and encrypted it with password. I try two different approach. First, to send instream from BC with content And azure function is like down there, but always got an error. Seams like I don't take stream parameter on azure function correct. I also try to…
-
CurrPage.EDITABLE together with CurrPage.UPDATE
Hello, we have made the following adjustments to the P41 for some customers; When an offer is moved from the Released status to the Open status, it should be editable. Basically, it works, BUT, you first have to leave the offer completely and then open it again so that the fields are no longer disabled. I've tried putting…
-
Problem when upgrading onprem v18 to v22
Hello all, I'm trying to upgrade a BC database from version 18 to version 22. The service is running on an Azure VM and the database is an Azure SQL database. I'm following this walkthgrough. The problem is that when I execute the step to synchronize the System Application, I'm getting the following error in Administration…
-
JSON string truncated to 240 characters
Hi everyone. I'm using the Newtonsoft JSON library in NAV2016 C/AL to format a JSON web request. The code is straightfoward: JsonTokenWriter := JsonTokenWriter.JTokenWriter;
JsonTokenWriter.WriteStartObject; //curly open {
CreateJSONAttribute('name','Shawn…
-
How to correct fixed asset accounting after the fact if one month's accounting has been missed?
is there any standard procedure for this? Thank You.
-
Presentations of BC TechDays 2023
Presentations of BC TechDays 2023 Presentations of the BC TechDays 2023 conference of 22 & 23 June 2023 in Antwerp (Belgium) Thursday 22 June 2023 Microsoft Presents: Introducing Microsoft Dynamics 365 Copilot (Evgenij Korovin, Sam van Lieshout) Microsoft Presents: What's new in Power Platform development: Power Automate…
-
Fixed Reorder Qty in BC
Dear all, I have set the Reordering Policy = Fixed Reorder qty for FG item Reorder point = 15 Reorder Qty = 5 Current Inventory for FG = 15 Now if i run calculate regenerative planning batch job, instead of populating as 5 for new firm planned order its coming as 20 . My Question is why is it adding reorder point also when…
-
Convert a DotNetDictionary into a JSON string
Does anyone have any C/AL code examples of deserializing a DotNet dictionary object (System.Collections.Generic.Dictionary`2.'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089') into a JSON object?
-
PO attachment
I'm trying to get the file(Terms and conditions) from a field in a table. And then attach that field to the Purchase Order attachment. But I'm getting the following error when I get that file downloaded, please note the file size is ZERO Bites. Could anyone explain why??
-
Sales Invoice report - sales line type blank removes totals
Hi all, I am kind of a newbie in AL programming. I am working with customized sales invoice report where I run into a strange issue. Whenever the last sales line is type blank (the customer uses it to add some comments to the invoice), the totals are not showing up. I have tried to look into my rdlc layout but I am not…
-
Restrict one field in the permission sets
The goal was to restrict this one field "Last Direct Cost" in the permission sets, but I only see how to restrict all edits to the item card itself. There is no standard way to put permissions on the record to make a field non-editable for specific users. However, this could happen by adding a small enhancement so that…
-
Let me how to view Detailed Stock Ledger Report in navision?
Let me how to view Detailed Stock Ledger Report or report related to it in navision.Please
-
How to find top n order of all customer in the report in nav.
when I run this report it can prints all order of all customer can you please help me solve this issue.
-
Purchase Requisition worksheet to purchase quote
Dear all, Is there any way to convert from Purchase Requisition worksheet to purchase quote instead of Purchase order when we do carry out action message from requisition. If have please let me know. Thanks in advance. Regards, sekar.
-
Lanham eShip Issues
I can't believe I'm the only one in the world that has encountered this problem with eShip, but I can't seem to find any other examples... We use the Multi-Document feature of eShip extensivley. This is a great feature because it allows us to save a tremendous amount on freight by combining multiple shipments into one,…
-
Custom Approval Workflow
Hello, I have a custom approval workflow which i created from scratch. I have noticed that anytime i delegate approval or use workflow user group that once my document is approved, the status of the document does not change to Approved. But when i use direct approver, it works perfectly. what could be the issue?
-
After cloud from BC 14 to BC Online, some tables data not came
After cloud from BC 14 to BC Online, I checked all tables are came but change log setup & change log entries are not came. I followed each step very carefully but these tables are getting into trouble.
-
Page.Close() don' t work
Hi All, Can someone tell me why the CurrPage.close() don' t work in page trigger such as OnOpenPage but work in action trigger or control add-in trigger. Thks for any reply.
-
controladdin function
I need to convert a string representing a numeric expression into its corresponding result. In the same way by when in an excel cell you enter "2+2*4" and the result is 10. EVALUATE Function not work. Need for a 'numerical' string and does not calculate expressions and I cannot use DLL. Cannot find a solution. I had…
-
add email recipient during send sales invoice
Hi All. I have added new field in Customer card, which is "E-mail 2" --> text 250 how do i include this when i send Email from Posted Sales Invoice ? any idea? Thanks.
-
Fail update Odata Web Service BLOB field with return 400 Bad Request using larger file
Hi, i have create request Bussiness Central W1 19.5 OData Webservice to update BLOB field based on this Dynamics Picture Update It return successfully with 204 code for small size file (100kb) But if i try with larger file size (ex. 200kb) it return fail with 400 bad request Is there any suggestion to upload image to BC…