-
Editable field on page in al code
Greetings experts, Forgive me, I’m new to working with pages in al code. I have created a page with two fields. I want to take the input of one field, send it to a method in a codeunit using an action, and show the returned text in another field. I’ve marked the field and the page objecr as editable, but it is not editable…
-
Cannot start NAV2018 NAS service on Windows 11 23H2
Some computers that run latest version of windows 11 can't run NAS service anymore. The same settings work on other windows 11 based machines but some don't and I can't figure why. The error appears right at the start of this year on some machines that run build 22631.2861 of windows 11. Tried removing the latest update…
-
Scheduled Reports crash Job Queue (BC14 on Prem)
Hello, I have a problem with BC14 on Prem and scheduling Reports. Scheduling reports via the task queue works in principle. However, there are always problems when the reports processes large amounts of data and produce many pages. For example, we have an invoice journal that lists all posted invoice headers with invoice…
-
RDLC Layout issue
Hi, PFA . I need to remove this space from this report? Is there any solution? The space is coming in between the detailed row and footer.
-
Are customers, not partners allowed to develop in the latest versions of Business Central?
In old Dynamics NAV, they had to buy an Application Developer license for 6000 euros to do that, and yet it was not allowed to modify a Codeunit 80 to for example fill out a field in the invoice. Only the 30 000 euro Solution Developer allowed that. How does that work in Business Central now? Are they still allowed, if…
-
how to remove caption of a cardpage?
Datacaptionfield property in table in empty...the card page caption is coming as the key of that table.. I wanna remove that caption . Thanks in advance.
-
Why some extensions marked _exclude_?
BC 23.1 OnPrem I received request to add few custom fields to the "Bank Deposits" sub form and ledgers. When try to extend, I couldn't find the Bank Deposits objects initially. Then I found them under namespace "Microsoft.Bank.Deposit' or "Microsoft_Exclude_Bank Deposits_23.1.13431.13812.app" and extended them after adding…
-
Upgrade/conversion from WW to NA
Hi all, I have someone who is a US subsidiary of a Spanish company. Currently, they are on NAV2016 and just a separate company within that database. There are some unique business requirements for the US company - Sales Tax, for one - they have been "adapting" the VAT feature in the WW version but it's not optimal. The…
-
How to get name of database server in AL w/o dll usage?
Hi community, is there a way to determine the name of the sql database server in AL without using dlls? I need the database name which I should get from the active session, but I have no clue how to get the database server name - the active session only carries the name of the BC server. Thanks in advance and best regards…
-
Current User Email not retrieved correctly.
Hello all, Just wondering if someone could help me with the following issue. Environment details BC22 OnPremise Version: W1 22.1 (Platform 22.0.56191.0 + Application 22.1.55890.56216) Two services, one using NavUserPassword and another AccessControlService The Problem When I update the "Authentication Email" on the User…
-
Developing Custom Approval Workflow?
I want to develop a custom approval workflow on creation of Resource record in the system. When a user inserts a new Resource in Business Central, it should be first approved by the approver, before it can be used anywhere. Any help in this regard will be highly appreciated.
-
Server License Expired even though License is not expired
Hey there! On of our systems we have multiple NAV Versions installed. When trying to open the DEV Env. for 2013 we get a warning saying "Your program license has expired". The unusual thing is that the Dev. Env. doesn't open at all, just the warning and then it's gone. We uploaded the license manually via the AdminTool…
-
Remove-NAVServerUserPermissionSet error "No Access Control in filter"
Hello, We are using Business Central 230. In Powershell (run as Administrator) I use "Remove-NAVServerUserPermissionSet $MiddleTier -PermissionSetId "<name of the permissionset>" -UserName $LogonAccount -Force". When the permission set is super, I see no errors and super is removed from the user. But when I use a different…
-
Job Queue - "The current permissions prevented the Action (Codeunit ... Exceute)
Hey there! We created a job queue that executes a Codeunit in one of our extensions. We created a permissionset that includes the Codeunit with "X" permissions. Permissionset is assigned to the user. When we execute the Job Queue manually everything is working as expected. However, if the Job Queue runs automatically…
-
Can I get Business Central to find the right unit price using the new price calculation v16?
Hi experts, This is in Business Central cloud. I have made my own table with some of the same fields as there is on table "Sales Line". I have fields with "Item No.", Quantity, "Unit Price" etc. I also have a customer number. How do I call the new price calculation v16, so it finds the right unit price for my item?
-
LSCIN Tax Transaction Value V2 data send Issue
In LS Central, I am enabled DD Send Transaction to push transaction from Store database to HO database, transactional data are pushed to HO except table LSCIN Tax Transaction Value V2 data.
-
Price includes VAT by default on Item Card?
Is there any easy way to make the system to assume and set "Price includes VAT" to true whenever an item is created? I tried subscribe to "OnAfterOnInsert" from Item table and make it to true. But it throws an error the VAT Prod. Posting group field not populated yet.
-
How to create Agenda Outlook Stile?
Good morning everyone, a client asked us to create an outlook-style appointment diary for him on BC21 (onprem). Currently our vertical (they are all customized tables) shows them in "matrix" style format, while the customer would practically like to see the agendas of the individual resources (even all together) with the…
-
Issues with NAV 2009 R2 RTC and Windows 11
Is anyone else having issues with NAV 2009 R2 RTC connecting when running Windows 11? Hopefully, everyone is well beyond NAV 2009, but I have some older Windows 11 builds that work fine with NAV but the newer ones are throwing an error that "The login failed when connecting to SQL Server XYZSQL". I suspect it has something…
-
Record IsTemporary useage and documentation
Hi Guys I see often when writing event-based code units something like: if Rec isTemporary then exit else begin end Is there any good resources that explain temporary records in BC and how and when they are used. ideally I want to create a test where the record is temporary and my codeunit or function exist to test. Some…
-
[SOLVED] BC - Charge Item from Purchase Document to Sales Document
Scenario: I have a sales order with one line Quantity 1 Price 1000 € The sales order is delivered and invoiced. Now I create a purchase invoice with a charge line of €100 and charge this to the sales shipment. When I post the purchase invoice, I receive a g/l entry of €50. But the corresponding value item is negative.…
-
Compare JSON-Objects
Hi folks, how do I compare the equality of two JSON objects during runtime without breaking out into the .net world? I'd like to have something like this: if MyJsonObject1.Equals(MyJsonObject2) then ... A workaround could be converting both to text, removing all whitespaces, probably lowercasing everything and then compare…
-
VS Code unable to connect BC Instance
Hi, The VS Code on my VDI can not connect to the Business Central Instance ( on Server B ) due to below error message. The VS Code and BC Instance are installed in two different machine. I can access BC environment using Web Client on MY VDI but can not connect BC Instance and download the symbols. Configuration of BC…
-
Export data from two or more tables to Excel
Hi everyone, In Dynamics NAV 2015, I need to export information from two tables (e.g Vendor or Customer) to Excel, but depending on the checkbox checked, I must show the information from one or the other table, or both. Is it possible to do this through a report? How can I define both tables in the DataItem? Or is it…
-
Apply documents in two different currencies with changed Exchange rate
Hi, I have such issue - at posting date invoice is equal 14 800,00 CHF ( at this day it's 14 523,78 USD agreed with customer to pay in two months). My LCY is GBP, and two months later currency has changed by 3%, so I have now difference in LCY valuation between those two documents by 381,99. I've tried to simply just Apply…
-
Norway, VAT reporting (Report 10618)
Hi, I have a Norwegian Customer (NAV 2018 11.0.46855.0), they are working on Dynamics NAV 2018. In their Norwegian Company, they are trying to upload the Xml file at /Skatteetaten/ using the report 10618 (Trade Settlement 2017). They receive the error attached. Is the output xml file, from report 10618 not valid anymore?…
-
XMLPort Namespaces
Hi. I want to export the xml with some specific namespace. I have the following properties:DefaultNamespace = 'dm22irccli-net';
UseDefaultNamespace = true;
Namespaces = "version" = 'v2023'; What is exported:<My_XmlPort xmlns:version="v2023" xmlns="dm22irccli-net"> What i want:<My_XmlPort xmlns="dm22irccli-net"…
-
Checking/Comparing for empty string filter
Hi there, today I stumbled upon something I thought would be a simple problem but I couldn't figure out why it did not work. So I wrote some code which checks if specific filters on a Reservtion Entry record are set (those filters are set in the base app) And one of those filters is a filter set on the field "Source Batch…
-
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>…
-
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…