-
Join the webinar: AIM with Simplanova: Earn up to $5k for each Upgrade Assessment
Dear Dynamics Community Members, Simplanova is a Microsoft Modernization Center under the AIM program and will help Partner organizations migrate end-customers to the cloud with future-proof solutions. So, we invite Dynamics Partners to join the webinar "AIM with Simplanova: Earn up to $5k for each Upgrade Assessment".…
-
Move Multitenancy
Hi Guys, Im settings up multitenancy (move to) on 3 tier setup So NAV and SQL are seperate. I have the scripts so far and now i want to move several companies to new databases. I have tried the script: NAV2017 CU2.1\WindowsPowerShellScripts\Multitenancy\NAVMultitenancySamples.psm1" -verbose and from there:…
-
Fixed Assets
Hi We have been left with an amount on a Fixed Asset below .01. Does anyone know of a way to clear off this final balance. This is in NAV2017
-
Can't populate user name on a report header
Hello! I have looked into this issue for a good time and can't seem to figure out what is going on, I'm hoping someone can shed some light. One of users is unable to show her user name on the header of the report. However, there are 2 of her team members that are showing correct, with a name. We have looked at permissions,…
-
How to group with a query?
How do you group lines (i.e. purchase lines) based on fields such as location code, posting group using a query? These lines would be grouped later when the document is posted and the grouping would be split into the separate documents
-
Business Central- Update Listpart Page
Hi, can anyone tell me how can I update listPart page from another ListPart Page? for example, in Bank account reconciliation page there are two part pages, 'bank account statements' and 'bank acccount ledger entries', can i i update view on Bank account ledger entries part page from Bank account statement part page ? Is…
-
Webservice <Key> Tag
Hi, In NAV SOAP web service the Read method will return a Key value. E.g. For Chart of Accounts, the Key value returned is: <Key>20;DwAAAAJ7BDEAMAAwADA=7;52265190;</Key> Do you know how the value 52265190 is derived? Is this some sort of time stamp?
-
App Version number: best practices / guidelines
Hi, I'd like to ask for some advice on the version number for the apps (the parameter "version" in the app.json file). We are currently using the below convention: 22.5.20231011.7 Being: - "22" for the BC major version - "5" for the application version - "2023" - year - "10" - month - "11" - day - "7" - version within the…
-
This is actually a question for Business Central
I am trying to setup the smtp / email account to send out notifications on workflow approvals on cloud and I cant get it right. Has anyone done this and can you share how you have manage to get it working please
-
OAUTH Token Request using Azure AD
First off, I was able to create a working call in Postman and received back a token, however, I can't seem to make it work in NAV2013. In Postman, I can use form-data or x-www-form-urlencoded, but neither seems to work in NAV. I either get a Bad Request (400), or connection forcibly reset by host error. Any tips? OAuthReq…
-
Default Views in Filter pane
Hello, I have a List page and it has a field named "Open". Also, I have Open and Closed views written in code for the page to filter on the field "Open", so that the user can click on each view to filter the records. I can see three views on the page "All", "Open", and "Closed". I have a Role center Cue to view only the…
-
Non Business Central tables in BC database
Hi, Someone knows if having non BC tables in the database and use them via SQL stored procedure to save additional info can affect to the Business Central performance and locks? The scenario is that, just as there are tables like "dbo.CompanyName.Table," there are other tables created, such as info.OrderLog, and many of…
-
PDF Files Error (109) when opening in Adobe Acrobat Reader
Hi all, We have noticed that some of the PDFs generated by BC, that are attached in emails, won't open in Adobe's Acrobat Reader with the error "There was a problem reading this document (109)". They'll open fine in other applications such us Microsoft Edge. The scenario is sending email statements for customers in bulk.…
-
Outlook Integration - Prefers SaaS to OnPrem
Hi, Our config is completed according to Microsoft documentation. However, we have a SaaS Sandbox environment but using OnPrem for Production. We downloaded the outlook add-in files from the OnPrem installation and added them to Outlook. If you open it up, you can see everything is pointing to the OnPrem instance. However,…
-
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…