-
Sorting on a Flowfield
Hi all, I have two tables, one of them has "detailed" transactions about the master table. From the master table, I created a flowfield which gets the current status from the detailed table. However it always just get the first record for the filter. Is there a way to get the flowfield to get the last record? Can you use…
-
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…
-
How can I restart the BC14-Service in a BC14-Dockercontainer
Hi everyone, I created a new BC14 docker container together with a Cronus-DB. I would like now to import my development license into the database. To activate this license I normally have to restart the BC-service. But when I list all of the windows services from the docker container I cannot find any BC-services. Can you…
-
This is a real head scratcher! - Server killing sessions
I've been rattling my head over this for best part of a year, and its known to have been occurring for longer .. Essentially we have LS retail running on NAV 2017 (CU5) and every 7-10 days (no obvious frequency) the LS Retail scheduler service tier gets its SQL session killed. The only common factor is it usually occurs at…
-
NAV 2018 - Task scheudler strange behavor
Hello NAV and BC experts, i want to share with you a strange behavior i'm expiriencing within a process which is using task scheduler to execut background task. Appearently, the task created by the process are all exevuted except some with a very specific property. Here the case:i have created a table "Post Process Buffer"…
-
Navision 4.0 SP2
Any one has the old CD/DVD for Navision 4.0 SP2. I need to the NODBC installation to get some data out from the Navision Native Data
-
Sorry, the current permissions prevented the action (Table data modify)
This is BC22. I have made a table to store user login data from all companies. It is a simple table with two fields (field(1; "User ID"; Code[50]), field(2; "Last Login DateTime"; DateTime)). The table has DataPerCompany = false; so it will record logins for any company. Here is the code that is giving me the error:…
-
How can I use a React.js component in a Javascript add-in?
I would like to use a fluent UI component based on React in a Javascript add-in. How can I import and use a module for this? Here is a code example for JS: import * as React from "react"; import { Calendar } from "@fluentui/react-calendar-compat"; import type { CalendarProps } from "@fluentui/react-calendar-compat"; export…
-
Mapping Intercompany transactions
I have set up an intercompany partner and enabled auto-send transactions. I created a purchase order and sent it to IC, which then created a sales order in another company. However, I want to map the expected receipt date of the purchase order to the shipment date of the sales order. Currently, the posting date of the…
-
BC24 Cloud Migration from Azure SQL not accepting same version
I am trying to use the Cloud Migration Setup to copy data from Azure SQL to Cloud. I keep getting the major version mismatch error. The cloud version is 24.2.20227.20460 and it is a sandbox. The Azure SQL database has the following settings in place: $ndo$tenantdatabaseproperty applicationversion = 24.2.20227.20460…
-
BC to CRM integration Tax
Hi Guys Dynamics CRM does not have Tax on the Sales Quote. Has anyone integrated tax or implemented tax with dynamics sales with integration to BC? Quote created in Sales and flows through to BC with tax codes
-
Bearer Authorization does not work
I am currently working on an API with GraphQL that uses Bearer tokens for authentication. It's strange because it always works in Postman, but when I try it in Business Central, it doesn't. It seems like the API doesn't recognize that I want to use Bearer tokens for authentication because I always get some HTML code as a…
-
Dynamics BC Data Upgrade Nightmare rant
Hi, Have anyone tried to successfully upgrade data from a custom BC14 solution on C/AL to BC 18 on prem before? I find the experience very confusing. I am stuck at : https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-to-microsoft-base-app-v18#task-14-synchronize-final-extensions While…
-
CRM Sales Quotes automatically archive in Business Central
Has anyone seen where Sales Quotes that initiate in CRM and flow into Business Central. automatically archive in BC even though archiving is turned off in BC?
-
Can't send mail through new outlook client.
Hello! I have a situation where the new Outlook client doesn't seem to work with NAV. We can't send emails through it, so we had to roll back to the previous version of Outlook. I just want to check if we should escalate this matter or if we can expect it to be fixed before it goes live for everyone else? Didnt find…
-
Exploding assembly bom on assembly order
We currently create assembly orders for Sales orders. In some of our assembly boms we have other sub assembly boms, when we assemble the top level item we pick and assemble all the sub assemblies at the same time. We do this by exploding the sub assembly boms on the assembly order. this adds all the components and changes…
-
Can't connect to Microsoft Current User Connector
We can't connect to the Microsoft Current User Connector so that users can send emails from their sign-in account. The email address on the Email Accounts List Page is always empty in Version 24 (on-prem). This worked perfectly in Version 18 (on-prem), shows the user's email address and allows us to send a successful test…
-
AES Encryption for Cloud BC
Hi All, I need to encrypt for AES Encryption in Cloud BC. is BC able to do that? usually i encrypt from here --> https://www.devglan.com/online-tools/aes-encryption-decryption
-
URGENT: CustomerSource missing. Need to download OnPrem License
Hi There We all know the customersource is now retired. Unfortunately, I could not find a place to download the latest license for OnPrem BC. We urgently need to download this and the partner staff is not very helpful. I checked my admin.microsoft.com portal but it is not there. Anyone know the correct URL to access the…
-
Report with temp tables
Hi experts, This is in Business Central cloud. I have made a header table "H" and a table "L" with the lines in the header. I have made a report that prints one H and the connected L records. When the header table is posted, all fields on H and L are copied to two other tables, "Posted H" and "Posted L". And the H and L…
-
The 157.55. ***** server cannot be found. Try again later or contact your system administrator. HELP
The 157.55. ***** server cannot be found. Try again later or contact your system administrator. Hi guys I have a situation trying to connect to a server from the development environment of a server. I am outside the server network and for business reasons the server is not open to the internet. It doesn't even ping me on…
-
Consume a soap web service from asp.net application
Hello, I' m trying to create a web application with visual studio 2022 by adding a reference to a navision web service, it gives me this error :
-
Run codeunit
We need to run specific codeunit (OnRun trigger) and stop session afterwards from Windows Task scheduler. Our issues: - for logged user client shows message to confirm connection (-consolemode parameter doesn't help) - for not logged user codeunit isn't invoked. Event viewer reports unspecified error - probably concerning…
-
Presentations of BC TechDays 2024
Presentations of BC TechDays 2024 Presentations of the BC TechDays 2024 conference of 13 & 14 June 2024 in Antwerp (Belgium) Thursday 13 June 2024 AL Development for OGs [90 min] (Eric Wauters (waldo), Arend-Jan Kauffmann) Double Trouble: A New Perspective on AL Testing [90 min] (Vjekoslav Babić) Microsoft Presents:…
-
Slow start of BC service
At one of our customers the BC service takes more than 4 minutes to start. We're using BC24 on-prem. We're getting three events like this in the event log: Held lock "App Group Update" for 165986 milliseconds. I made a technical support request to MS but the support engineer doesn't seem to have a clue... So I'm hoping one…
-
BC TechDays 2024 video
My impressions of this year's conference: BC TechDays 2024
-
Create new BC23 on-premise development enviroment
Hello, I would like to create a new development environment from my BC23 on-premise server instance because the test data is outdated. Unfortunately, I can't find any instructions on how best to proceed. Greetings Hubertus
-
Passing quantity back to originating function
Wondering the best way to pass a quantity value back up a chain of functions. I have an originating function that calls another, and another, etc. to where the final function is 5 steps down from the originating. This is all base NAV. I'm looking for a way to pass a quantity from the final function back to the originating…
-
BC14 developer license
Hello I want to extend my BC14 license and a solution developer(developer license). My partner said that it is impossible, can you confirm it? I've done it with different clients with NAV2016 and there was no problem.
-
I could not create pick from my assembly order in Business Central.
Hi Everyone, Good morning. In Business Central, I am trying to create pick list for raw materials from a bin in storage zone to a bin in the assembly zone for an assembly order. But it says 'Nothing to handle'. Attached are my location configurations: Please assist. Thanks.