-
How can I get a member from a security group? AL
Hello, Is it possible to get a member from "Security Group Member Buffer"? It doesn't have reading permissions, I've also tried getting with "Security Group" Codeunit, but I am unable to succeed. I'd like to group users, and since "User group" is marked for removal, I am looking for a core alternative to keep users in…
-
Deploying Microsoft Dynamics Finance and Operations on Premise with minimal hardware requirements
We have a Microsoft Dynamics 365 on-premise with 7 server licenses, 5 full user licenses and 1 team license. Considering the usage of the system will not be that much, we were considering deploying on the following 1 AOS 1 Orchestrator 1 MSSQL Server 1 Reporting server Is the above possible as opposed to the…
-
Report in Loop
Good morning. I'm printing simple labels with the customer ID on them. I have to print only labels for specific users that have a specific boolean value set to true. Once i get the records, i loop through them and select only the ones with the boolean = true, but even if the "Rec" is updated on every iteration and…
-
BC22 OnPrem .net6 Dictionary issue
Hi all, Having an issue with our solution with BC22 specifically .net lib "System.Collections.Generic.Dictionary`2" Based on the information provided in the article https://demiliani.com/2023/03/21/dynamics-365-business-central-and-net-6/ , it has come to our attention that Business Central version 22 (BC22) brings about…
-
JSONPath SelectToken Problem
Hi community, I'm struggling in JSON parsing :s - I have the following JSON { "properties": { "cmis:creationDate": { "cardinality": "single", "id": "cmis:creationDate", "type": "datetime", "value": 1673529791000 }, "cmis:name": { "cardinality": "single", "id": "cmis:name", "type": "string", "value": "" }, "cmis:objectId":…
-
Re-use report object number causes system to crash-2013R2 38053
Hi I am busy developing a number of customized reports in the 50000 range. I am having problems if I delete a report and want to re-use that number. Or if I renumber/rename a report. Sometimes the new report still has the filters of the old report and gives an error when trying to run. Other times the RTC client crashes…
-
Business Central - Data Exchange Definitions - Documentation?
Hi. Apologies if this is in the wrong area. I am fighting with a data exchange definition to export an EFT file. Maybe I've missed it, but is there ANY documentation about these that is more then just a skim over the surface as in MS Learn? Thanks in advance!
-
Loading Posted Sales invoices to IC Outbox
Hello all, One of our users generated a sales invoice for an intercompany partner in Microsoft Business Central. However, due to the user’s restricted access to the other company, the invoice was successfully posted but is not showing up in the other company’s purchase invoices. Typically, I can locate such invoices from…
-
Print from page part
Good morning everybody. Starting from a list of data which represent shelves, i select a shelf and double clicking opens its card page, which is a documen type, that contains all the items placed on that shelf. This document contains some general data, which are a description of the shelf, and a second area wich is a…
-
How to use SQLDataReader to Handle BLOB Fields in Business Central
Hi All, I'm wondering if anyone have any experience using SqlDataReader to handle Blob,RecordID fields. Specifically, I have Blob(images,pdf,excel) fields in SQL databases and need to import them into Business Central On-Premises. I did something like this but the files comes in BC corrupted. SqlBinaryValue :=…
-
Text lines "Multicurrency" on Statement
Hi I have seen some lines with the text "Multicurrency" on a statement i a NAV2013R2 client. The lines are not a part of the customer records. Where are the lines from?
-
Assist-Button not shown in Listpage
Hello, I have a somewhat strange problem with a newly created page. The page displays all lines of sales offers and sales blanket orders. The customer would like the map of the respective document to be called up when clicking on the document number. When I now open the page via the menu, the Assist button is not…
-
Include caption not working on report?
I am trying to "include caption" for a field on a Business Central report. I have added the property to the field in the dataset: The field has a caption in the table and it is translated: I have added it to the layout like this: But it just prints the raw text: Can anyone help?
-
Auto fit not happens(Excel) while scheduling the report through job queue
while generating a report using code unit- excel buffer through job queue , column auto fit and row merging feature of excel is not working, but the same is working once i tried to run the code unit manually , Is there is any provision to work the auto fit and merging in excel through job queue?
-
Custom Lines Page Show Open In Excel Top Right
Hi All I have created a customer subpage similar to the sales order lines. However I cannot see the option to Open In Excel on top right as below (option appears as a drop down on the left). How do you add a similar open in Excel function on custom page?
-
Running out of entry numbers – use the ones below zero?
Issue: If a client is using NAV 2009 on SQL for many years, there is a risk of running out of entry numbers, for example in the table G/L Entry. And imagine that it is imperative to continue using the same company instead of creating a new one. Imagine this scenario: The first entry no. was set to 1 (many years ago) and…
-
Issue with creating a new record when filters are set on a page - Business central
Hello, I have noticed a problem in Business Central in that when I want to insert a new record on the page, there is a "reload" and the first record is selected/highlighted instead of a new blank record in which I can put the new values. The problem appears in BC15 and higher when there is a filter set on the date type…
-
Data Integration Nav to Power BI
Can I configure Odata services to use real-time data? I need to see real-time data on a daily basis on the Power BI dashboard once I publish Nav data into Power BI.
-
Navision 2016 installation
Hi All, I have downloaded the demo version that was available on mibuso.com. When I click setup in the zip file, it pops up the message asking whether I should allow this to make changes in the system. But when I click yes, nothing opens to continue installation. Could someone help me figure out this?
-
Endpoint for "Item Charge Assignment"
Endpoint for "Item Charge Assignment" A requirement for an OData endpoint to fetch all the data of the "Item Charge assignment" table for integration with other software. Because the standard BC page does not return any data without the purchase or sales document context. Please see below the screenshots of calling the…
-
Opposite of UPPERLIMIT for CalcFormula?
Hello. I need to make a FlowField for G/L account, that sums up balance, but it needs to be filtered to 1 day before the date period in Date Filter. I know about existance of UPPERLIMIT, but could not find anything that could be used to get the "lower limit", and how do I even get 1 day before that date? Sorry if this is a…
-
Error 701: Azure Key Vault
Hi BC 16.2, we see this alot, anyone knows whats wrong? There is not setup any Azure key vault, but is that required at all? It runs as an onPrem, on azure VMs Server instance: PROD Category: Azure Key Vault ClientSessionId: 6a295346-70c9-4d7c-a5a8-9f4b564aa735 ClientActivityId: 16f53968-b2d3-4f59-b527-0eedd770b481…
-
Event Handler
In the upcoming Microsoft update, there are several events slated for removal. I’m seeking assistance in replacing two of these events with their new counterparts. I attempted to substitute the second event with “OnPrepareLineOnAfterFillInvoicePostingBuffer”, but it doesn’t seem to be triggered as expected. Additionally,…
-
What’s new in Dynamics 365 BC version 2023 Wave 2
As the new version of Dynamics 365 Business Central is released at the beginning of October, Simplanova is organizing the webinar with Microsoft MVP for Business Applications - Stefano Demiliani, and encourages you to attend. During the webinar, you will hear detailed information about What’s new in Dynamics 365 BC version…
-
Trial Run Production Costing
We have lot of trial run production doing outside Navision, so high level expect to know the cost (material consumption and all other cost). Now I plan to create new Item card for Item need to trial run. For example, 1. create (Item-123-trial) for (Item-123) and link (Item-123)'s BOM and Routing to (Item-123-trial) 2.…
-
Can i use settableview sending a temporary table?
Hi friends, How to run a form object variable whose SETTABLEVIEW has Temporary Record set. Actually I want to see real data & temp data from the same form object.
-
NAV 2016 (9.0.50528.0) Docker
Greetings everyone, We are looking to migrate our NAV Servers and instances to on-prem Docker services, from my knowledge & research this doesn't seem possible, maybe I am wrong.. Does anyone have NAV v((9.0.50528.0)) running on Docker right now? If so can you please provide resources on how to accomplish this task.. Thank…
-
Can I determine the correct control add-in name for a third-party dll?
Hi - I have a third-party DotNet dll that I would like to deploy via the Control Add-ins table. However, we purchased this add-in, so I don't know what the internal "Name" property is. I assume that the Public Key Toek is the "PublicKeyToken" value on the variable definition in my codeunit:…
-
Incentive Co-op funds for BC migrations?
Simplanova invites Dynamics Partners to join our webinar: Incentive Co-op funds for BC migrations? What’s new in FY24 Event Agenda: -What’s new in Co-op Incentive program for FY24 - Cooperative Funds (Co-op) Overview - Co-op Planning - Co-op Management - Co-op Claiming Process and POE - Simplanova services under Co-op FY24…
-
Generate a auto receive without apply to original document
Hello all, Imagine this scenario: In our version of Dynamics NAV 2017,a change was made so that orders would create an advanced invoice, using an specific item for this. But the customer pays this advance, the problem is that it is only registered centrally many days later. Causing an analysis error as the customer paid…