-
How to remove underscores on the excel layout report in Business Central
Hi, Am new in business central and I want to create the excel report layout. This is what I did, 1. I selected my filters on the report request page 2. Click on Send to 3. Select the Send to Excel (Data only) 4. Then run the report. 5. It download the excel report. Issue: The report headings comes with underscores (e.g…
-
Read JSON Object
Can we extract Object (nested Object) name from this kind of JSON? I am able to count how many objects are in the json, but cannot extract value. ("27675","27676") I am using Newtonsoft "27675":{ "entity_id":"27675", "status":"complete", "coupon_code":null, "shipping_descript }, "27676":{ "entity_id":"27676",…
-
Problem with Nav C/AL Queries
Hello, i'm using NAV 2017 and i attempt to the the following (the real case is more complex but i just ask for a specific function): I have a table Items and i want to use a Query that give me bak ONE record for ITEM, with some static field and some computed fields: - purchased quantity (sum of quantity from Item Ledger…
-
ASN1 encoding with System.Formats.Asn1 / DotNet Enums in general
Hi everyone, right now I'm working on an extension, that among other things has to encode data into a predetermined ASN1 structure. For that task I wanted to use the DotNet assembly System.Formats.Asn1. I referenced the assembly in the dotnet.al looking like this: The assembly is on the server with the service tier…
-
How to change license type of user from Full user to Esentials
Hi, Thank you. Actually, I missed to tell you that, this is Business Central latest version. BC 20. Microsoft partner who sold the license told me that, for a new BC license, we don't need to buy any extra tables. this is not mylicense.flf, it is mylicense. license How to change in user card in BC 20, and also from 'Full…
-
Problem grouping SUMS using Queries
Problem with Nav C/AL Queries Hello, i'm using NAV 2017 and i attempt to the the following (the real case is more complex but i just ask for a specific function): I have a table Items and i want to use a Query that give me bak ONE record for ITEM, with some static field and some computed fields: - purchased quantity (sum…
-
Business Central License for extra objects
Hi, Thank you. Actually, I missed to tell you that, this is Business Central latest version. BC 20. Microsoft partner who sold the license told me that, for a new BC license, we don't need to buy any extra tables. this is not my license.flf, it is mylicense. license I am using 30 tables, in the case required, I will buy…
-
How to get effect new license to the users with Essential, Premium, Team Member, External Accountant
How to get effect new license to the users with Essential, Premium, Team Member, External Accountant list in user card in on-promise Warm regards Krish
-
Can anyone help on Permission on custom tables
You do not have the following permissions on Table Cash Collection: Execute. To view details about your permissions, see the Effective Permissions page. To report a problem, refer to the following server session ID: '29'. Internal session id: 42535434-d994-4bfe-a31c-439ff2c0d0fe Application Insights session id:…
-
Consume Webservice and Import data in Navision
Hi All, Hope you are all doing well. I want to consume webservice(GET) and import that data(Xml format) into Navision table. Is there any code reference to consume and import data from Webservice. If you need more info about requirement. Please ping me. Thanks.
-
My sub form/page is not editable
Hi Before migration sub-page was working fine, with minor customization and it is a copy of the Standard sales invoice but a completely new object itself. Subform is not editable. it is going grey. Does anyone help me, please. my code in AL is page 50002 "POS- Sales Invoice Sub" { AutoSplitKey = true; Caption = 'Lines';…
-
What's the point of SetTableView
Hi All I'm trying to understand the usage of SetTableView . My understanding is that it creates a filter so the question is why we cannot just use Setrange or SetFilter instead. Below is from purchase order subform to find linked sales orders:protected procedure OpenSpecOrderSalesOrderForm() var SalesHeader: Record "Sales…
-
You do not have the following permissions on CodeUnit Prova: Execute
In Dynamics Nav 2018 I made this codeunit 50006 called Prova: OnRun()
MESSAGE('Hello'); When I Ctrl+R or run it will display this error message: You do not have the following permissions on CodeUnit Prova: Execute My user has SUPER permissions. If it's a license thing I really don't know how to check that. How can I run…
-
Record being modified but can't find where even exporting all objects to txt
In Dynamics Nav 2018, I'm using the selected action in this page rows, when I click "Validar", all selected rows will change it's status to "Pendiente". After some time, the row will change to status "Error": I can see in debugger when it changes from "Registrando" to "Pendiente". But I can't see when it's changing to…
-
Docker Development
Hi Experts, I need suggestion on a Development environment setup for more than 2 developer. Scenario: We have a Azure VM and a Container is setup there with Latest BC insider image of V17. Now i want to give access to 2-3 developers target to that BC Container from there local system. I want to give them access of…
-
BC20 CU2 on-premise - help links in the navsettings.json doesn't work
Hey, since BC16 or 18 we have stored our own help links in the navsettings.json of the web server. Like this: }, "ApplicationIdSettings": { "BaseHelpUrl": "http://support.firma.com/{0}/", "BlogLink": "https://www.firma.com/", "ComingSoonLink": "https://info.firma.com/", "CommunityLink": "https://www.firma.com/",…
-
How to translate xlf-Files
Hi guys, I am updating from Dynamics2017 to BC190 and at the moment I am facing how to translate the xlf-files I have exported the old caption-translation from 2017 and I also generated a custom.de.xlf. How can I now translate missing captions from en-US to de-DE? I also tried to use the microsoft translation service, but…
-
Using Newtonsoft JSON Library to find specific key-value pairs in a JSON string
Hi everyone, There are a number of posts here about parsing JSON files, but none that use the DotNet Newtonsoft JSON library. Has anyone used the DotNet library Newtonsoft.Json.Linq.JObject to read specific key/value pairs from a JSON string? I've loaded values into a Json Object:{ "item": { "ID": "72795", "Latitude":…
-
usage of Exit after filtering in AL
Hi I have written a query to filter by setrange/setfilter and then findfirst to get the filtered records. If I don't use "Exit" then the query doesnt work so trying to understand why. Is using Exit best practice example first works and the second doesn't workGenJournalLine2.Reset(); GenJournalLine2.SetRange("Journal…
-
Is required Test Library extension in Upgrade Business Central 14 to 20
Dear Friends Is required Test Library extension in Upgrade Business Central 14 to 20, can you tell me the purpose of Test Library, is it mandatory ?? Krish
-
Invalid language ID supplied: 0.
Hi After Upgrading Business Central from 14 to 20, when I want to run any report, it gives an error. "Invalid language ID supplied: 0." Please suggest Warm regards Kris
-
Small customisation on standard tables , what is effect on Upgrade
Dear Friends, I have made small custom fields in table no 37. How do I upgrade the to AL and thus into Business Central
-
Migrating data with Configuration Packages
Hi I have tried to upgrade data from Business Central 14 to 20. It looks very complicated. I have custom app complied and updated in a new version (20). now my Business Central is ready with my custom extension. So I have decided to migrate G/L Entries and others related. Please advice. at least I can do it this way I am…
-
How to extend features in business central ?
Hi, when a feature is turned on from feature management, the symbols are still missing in AL. Does anyone have a solution for this?
-
Replace namespace in xml Ports with .net
Hi, i created an xml-export with a .net variable. (System.Xml.XmlTextWriter.'System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089') My example code is like this The result is: So far it looks ok. Now I want to change 'xmlns" in the CustomField-part by 'name'. Anybody an idea how to solve this?…
-
Copy ZPL file to printer in BC
Hi, does anybody know how to copy a ZPL file to a Zebra printer in BC OnPremise?
-
Migrating Multiple On-Premise Companies to BC Online
Following the MS documentation for the Migrating process we have successfully migrated several customers from BC14 on Prem to BC20 Online. https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/migrate-data But now we have a customer with multiple Companies in the same On Prem. Database and…
-
VAR reserved object numbers and On-Premises customer licenses
We have recently been granted object numbers from MS in order to develop our own apps into the AppSource, and we have currently transformed some of our standard modules from region 50000 and 60000 to this number series. Apps are not (yet) published to AppSource, but they can still be installed into the cloud version…
-
Unpredictable Pauses during Report Processing (BC14)
Hi one of our customer complains about delayed output of RDLC-reports printed on local or network printers. This happens at unpredictable times, but several times a day (per user). Often a customer of our customer is waiting to get the paper report (shipment or invoice). The time varies from some seconds up to 10 minutes.…
-
Mass Update User Setting in Business Central
Hi, Is there a way to do a mass update on User Setting in Business Central. I tried Rapidstart but because it is a system table, it is not allow.