-
Resources for Partners – Business Central that’s way less boooooooooring.
Tired of hunting for BC docs like it’s a side quest? MS just dropped a one-stop portal for partners working with Business Central, and yes, it’s bookmark-worthy. 👉 aka.ms/BCAll (or scan my QR code, ez) - Setup guides, dev docs, onboarding flows, and more—all in one place. Tired of boring thing? Let's learn without the…
-
SO ASKIGN QUESTION FEELS LIKE BLOGGING MORE LIKELY. I SEE. TEST PLS DO NOT REPLY
THIS IS A TEST. PLS DO NOT REPLY
-
HOW ABOUT Q & A. THIS IS TEST PLS DO NOT REPLY
HOW CAN I CREATE BLOG AT THIS. BEFORE I WAS JUST AN SPECTATOR AHAHAHAHA
-
Ctrl-E: Table vs Page
Hi everyone, Does anyone know why Ctrl-E on a table results in something like this and Ctrl-E on a page in something like this, with frozen row and filters Are there any settings at all (Nav and/or Excel?) related to what this shortcut does? I actually have a sad user who's trying Ctrl-E on page 'XYZ' and it results in the…
-
How to Fax Nav Reports from Nav
Hello I've recently posted a blog on how to fax from Nav. Hopefully people find it useful. Here is the link for detail explanation. http://mibuso.com/blogs/ara3n/2009/06/1 ... amics-nav/ IF ISCLEAR(FaxServer) THEN CREATE(FaxServer);IF ISCLEAR(FaxDoc) THEN CREATE(FaxDoc);FaxServer.Connect('');FileName :=…
-
How to install mutiple versions of Business central demo database on the same sql server?
I am trying to setup another BC environment using the same SQL server . Anyone know how to install database components ?
-
consume an external web service from navision
Hello, I would like to consume an external web service from navision, my current version is BC 14 and i try to do it using codeunit. thank you in advance.
-
Filter Group
What is Filter Group In Navision what is the use of this filter group where should I use this one can you tell me one scenario and give proper example when i will use filter group in which one is will be reflected in frontend
-
How to call a NAV2016 SOAP (codeunit) Webservice from nav
Hope someone could help me in my quest to be able to consume a NAV SOAP (Codeunit) webservice from another nav instance (both running on NAV2016 RTC so c\al code only). In NAVinstance1 I have a NAV WebService (Codeunit) that returns me the next available number in a number series. I would like to call this WebService (CU)…
-
Business Central: company data migration between different databases
Hi, i have a customer with 2 different DB (BC21 version onprem); each DB contains a company (DB1 company A, DB2 Company B) , and both companies are used. These DB have the same apps (and version). My customer asked me to migrate company B into DB1, for having only one DB with 2 companies. I tried "ExportData" page (9901),…
-
Can Dateformula calculate hours?
Do anyone know if it is possible to enhance dateformula fields to not only calculate days, weeks, months, etc., but also for it to calculate hours? E.g., Syntax: 12H, description 12 hours. Thanks in adavnce.
-
Can Dateformula calculate hours?
Do anyone know if it is possible to enhance dateformula fields to not only calculate days, weeks, months, etc., but also for it to calculate hours? E.g., Syntax: 12H, description 12 hours. Thanks in adavnce.
-
How to find all references (or occurrences) of a certain field in the code of an .app
I'm working with the .app LS Retail, it's open source (but readonly) so I can click in the .app file in Visual Studio Code and navigate through all its code files (tables, extensions, codeunits...). Let's say I'm working with a certain field of a table extension, and I need to know how this file is used in the .app, so I'd…
-
Convert CaptionML to new syntax.
Hi all, Is there any way (tool) to convert existing CaptionML syntax CaptionML = ENU = 'Caption in ENU', DE = 'Caption in DE'; to new syntax Caption + translation in xlf file. I have lots of *.al files with translation in ML but in future "The multilanguage syntax is being deprecated. Please update to the new syntax.", new…
-
Tracking the standard "Open in Excel" in BC21 (On-Premise)
Hello BC Users, I noticed that, by default, Business Central allows lists to be exported to Excel using the standard "Open in Excel" function. I tried to check if this functionality was being tracked in some way, for example through the raising of an event or with telemetry data, but I wasn't very successful. Do you have…
-
How to pass temp table to page lookup?
How can i pass temporary table to a lookup page? I am aware of Page.SetRecord(Rec) but on the doc. said it is not for temp table, and Page.Run(PageID,tempRec), but i need to be able to multi-select and use getselectionfilter... any help will be appreciated
-
What’s new in Dynamics 365 BC 2024 Wave 2
As the new version of Dynamics 365 Business Central (Dynamics 365 BC 2024 Wave 2) is coming, we are organizing a webinar with Stefano Demiliani, Microsoft MVP for Business Applications, and we encourage you to attend. During the webinar, you will hear detailed information about What’s new in Dynamics 365 BC 2024 Wave 2.…
-
How to see why you are getting CONSISTENCY Error
This is a trick I use whenever I do try to solve and see why you the db is getting CONSISTENT Error. I create the following CU. OBJECT Codeunit 50000 Single Instance CU{ OBJECT-PROPERTIES { Date=10/11/07; Time=[ 2:50:02 PM]; Modified=Yes; Version List=MOD01; } PROPERTIES { SingleInstance=Yes; OnRun=BEGIN IF NOT StoreToTemp…
-
Nav->ForNav->Foxit(pdf reader)
Hi all, Imagine two ForNav reports in the same database/company having same label/caption in them with Japanese hieroglyphs. If previewed as PDF, one of them shows squares instead of Japanese and another one is totally fine. What could it be? 😬 I’ve ran out of ideas of where to look. If anyone has any leads, please, share.…
-
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 :
-
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.
-
Excel Buffer with extended formatting
Hello all, I would like to share a solution that allows to export data to excel via "Excel Buffer" with extended formatting: alignment, cell borders and etc. You can find source code with code samples on GitHub: It doesn't require any additional components, it uses only OpenXML components for extended formatting. This…
-
How to free space from the Tenant Media table?
Hi, I have 20GB of information from the Tenant Media table, I need help on how to free up space on that table. I deleted the images of all the products from the Items table and they are still visible in that table, there are even images that had been removed a long time ago. I am using Dynamics NAV 2018.
-
How to do deep inserts into a custom API in Business Central?
Based on this question: https://forum.mibuso.com/discussion/78013/how-to-insert-multiple-rows-in-a-business-central-api-with-a-single-call I was testing and found the deep inserts. So I've decided to build a sample API page with a page part: page 60000 "Sales Order Inserts MIM API"
{ PageType = API; SourceTable = "Sales…
-
How to insert multiple rows in a Business Central API with a single call?
I'm trying to insert a json with multiple records into Business Central via Web Services page 60000 "Sales Order Inserts MIM API"
{ PageType = API; SourceTable = "Sales Order Inserts MIM"; Caption = 'Sales Order Inserts MIM API'; EntitySetName = 'SalesOrderInserts'; EntityName = 'SalesOrderInsert'; APIPublisher =…
-
How can I reload current page with a temporary table records?
I'm in page "Assembly Orders" 902 trying to filter out some records and display only the assembly orders that the user is allowed. Basically, trying to populate a temporary table to reload the current page with the records of the temporary table: pageextension 60008 "Assembly Orders PL" extends "Assembly Orders"//902
{…
-
O Data URL - From Dynamics NAV 2018 to Business Central-
Our company will update from Dymanics NAV 2018 to Business Central. Currently we import in excel several Queries from O Data URL. After the system changes I need to change all sources with the new URL for each query. My question is : Will it work? Or tables , formats and contents will be different? In that case it will…
-
How to handle the visible property of an actiongroup
hello, i need help to handle the visible property of an actiongroup in a role center, i created a boolean variable and then when i try to assign a false value i receive an error message : No trigger code is allowed on page of type Role Center. Thank you
-
What’s new in Dynamics 365 BC version 2024 Wave 1
Dear Dynamics Community Members, As the new version of Dynamics 365 Business Central is coming, Simplanova is organizing a webinar with Stefano Demiliani, Microsoft MVP for Business Applications. During the webinar, you will hear detailed information about What’s new in Dynamics 365 BC version 2024 Wave 1. Register now…
-
Display a number with its superscript in a report-Nav 2016
I am looking for an option in Nav 2016 to display a number with its superscript in the report. I tried many options but none of them worked. It seems like there is no in-built option available. Please advise with any workaround.