-
FET and Sales Tax
Hello- I have a client that has a unique requirement i have not come across. They have items that have a FET (federal excise tax) added to specific items. These items require this 12% tax ALWAYS. However, that specific customer might also be tax liable and depending on the area, have a 6% tax added. So this single item…
-
Extension dependencies
I have some trouble designing an extension in AL. My extension uses a field of a certain table in it's code (which happens to be in the OnPreReport trigger of a reportextension object) [App 3]. The field is defined in a tableextension object in a different app [App 2]. The table is defined in yet another app [App 1]. I…
-
how to solve field error in BC
Hello, I am trying to register a purchase order in BC, but I get this error,Shipping No. Series must have a value in Sales Header: Document Type=Order, No.=V-002. It cannot be zero or empty., I already filled out the fields and it still shows the error
-
Business Central Extension - Table not showing in CAL
Hi everyone, I don't know if it's possible, but my question is: Is there any way I can view a table created through an extension in CAL? (same question for viewing table fields in CSIDE created through an extension) The BC version I'm using is 14. Thank you very much.
-
how to export nested JSON Value
Hi All, i want to export nested json value. something like this how do i make that? Thanks."Signature": [ { "Id": "signature", "Object": [ { "QualifyingProperties": [ { "Target": "signature", "SignedProperties": [ { "Id": "id-xades-signed-props", "SignedSignatureProperties": [ { "SigningTime": [ { "_":…
-
Data mirroring
Good afternoon, I'll give it a try whilst I am having troubles finding simple tutorials or look-a-like projects. Our company is using: NAV 2009 R2 I have limited access (only object designer) due to license. I am trying to write code behind a report. I would like that once the report is ran, it mirrors delivery weeks…
-
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:…