-
Using RecordRef and FieldNo Instead of dependency to get fields from another extension
Hi All We can get fields from another extension by using something like below without delcaring dependency in app.json file. Are there pros and cons with just using recordref vs dependecy. Eitherway if the field is not there second ext wil fail local procedure TryGetFieldValue(RecRef: RecordRef; FieldNo: Integer; var…
-
Tenant media Growing Too Large
Hi, One of my clients' Tenant Media table sizes is growing quickly. The data in this table can be viewed or exported, but records with the MIME Type "application/octet-stream" cannot be read. This kind of record typically takes up a lot of room. I assume that this record is created in the Tenant Media table when an Excel…
-
How to Fix a Corrupted MDF File?
I have an MDF file that seems to be corrupted. I can’t open it in SQL Server, and I don’t want to lose my data. Is there an easy way or a tool to repair the MDF file and recover all the data safely? Any suggestions or steps will be really helpful.
-
Project/Resource Planning
So here is the problem I'm having (BC cloud, version 27.3): I have a project planning line with a single resource on it, and that resource is only available for 40 hours a week. If I enter a task that requires 160+ hours, the system doesn't seem smart enough to change the dates accordingly. This is confusing to me for…
-
mdf vs ndf ina a SqlServer Database
Hi, When I create a SqlServer Database in Navision, It creates an mdf, ndf and ldf file. Ok, ldf is the Log file an I see that all my tables are in ndf file. What is the purpose of mdf file?? What does mdf file contain?? Thanks Asier
-
SELECT * FROM
Hi, I have executed the following SQL query on a NAV Database for two different companies and I surprise to see the column sequence. It differs from one another. SELECT * FROM CompanyName$TableName; What is the reason behind it? How do I fix that ? Thanks, navuser1
-
Unable to open SQL Server database file (.mdf)
Experts, I have a SQL Server 2005 database file (a .mdf file) that I am trying to open in SQL Server Management Studio so I can add a field to a table, but I am unable to open the file. I can't say that I really understand how SQL Server handles these databases. I especially don't understand the "attaching" and "detaching"…
-
D365 F&O Implementation Document
HI there i am looking for a project plan to use for a fresh D365 implementation project plan please or any documents welcome
-
Best Approach to Upgrade from Dynamics AX 2012 to Dynamics 365 F&O in 2026?
Hi everyone, We are currently running Dynamics AX 2012 and starting to evaluate an upgrade to Dynamics 365 Finance & Operations. I’d like to understand from those who have already gone through the upgrade: Did you choose full reimplementation or code upgrade? 2. How did you handle customizations and ISV solutions? 3. Any…
-
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…
-
What are the differences between the Essentials and Premium versions of Dynamics 365 Business Centra
What are the differences between the Essentials and Premium versions of Dynamics 365 Business Central, and how do you choose the right one? How customizable is Dynamics 365 Business Central for industry-specific needs such as manufacturing, retail, or professional services?
-
How to embed RDLC format within the AL code and extension
Hi All When developing reports in AL you automaticlaly create and rdl fiel thats in xml but later in front end report editor we chnage the look and feel of the layout. Is there a way to convert the rdlc fiel back to xml and embed it in extension so when deploying theres no 2 steps, deplo extensions , import RDLC to the…
-
Missing table(s) when upgrading from BC 16.5 to 25.15
I am attempting to upgrade an on-premise instance of Business Central 16.5 to 25.15. However, when attempting to synchronize System Application, the following error occurs: Table 4152 Temp Media :: The table 'Temp Media' cannot be located. Removing tables is not allowed unless they are temporary or are being moved by…
-
Why doesn't copying project planning lines reset their picked quantity?
I noticed that when copying project tasks to a new project in Business Central 25.2, the copied planning lines won't reset their fields related to their warehouse pick ("Qty. Picked", "Completely Picked" etc). I thought this was a bug, but even 25.12 has this behavior. This occurs in the codeunit Copy Job, specifically the…
-
Block Warehouse Shipment Posting by Code- Event to use
Hi All We want to block warehouse shipment posting if all pick list lines are not picked. What's best event to subscribe. Found this [EventSubscriber(ObjectType::Codeunit, Codeunit::"Whse.-Post Shipment", OnBeforeCheckWhseShptLines, '', false, false)] local procedure ValidatePicksCheckedBeforePost( var…
-
OdataV4 Error : An error has occurred.
Environment: Windows, Microsoft Dynamics NAV 2018 I am writing here because I spend few hours for fighting with this error and hope will help someone in the future. In the Event log the error was registered as: Type: System.ArgumentException Message: <ii>An item with the same key has already been added.</ii> The error…
-
Business Central OCR (Kofax/Lexmark): Invoice lines imported as G/L Accounts instead of Items
I am using the standard Kofax/Lexmark OCR service in Business Central to process vendor invoices. The OCR import works, but all invoice lines are automatically created as G/L Account lines. Because of that, I receive this error: Cannot find an appropriate G/L account for the line with description ‘LL-LAMPE’, ‘KOP-A’,…
-
How Does a Data Fabric Solution Simplify Enterprise Data Management?
Hello everyone, Managing enterprise data across multiple systems, platforms, and environments has become increasingly complex. I’m currently researching how a data fabric solution can help organizations streamline and modernize their data management strategies. Discussion Question How does a data fabric solution simplify…
-
Lines in CSV is not breaking
Hi, I am facing issue while exporting the data in CSV and send it an auto email to respective user on click of a button. While creating a csv, header and line are coming in one single line instead of multiple lines. Unable to understand why it is coming in same line and not shifting the data to next line. If anyone has…
-
Inventory Valuation
Inventory valuation report lines it is showing negative stock with a negative valuation, but zero 'Expected Cost Included ' please advise. Thank you
-
How effective are Azure hybrid services in reducing operational complexity across multi-cloud enviro
How does Azure Arc help organizations extend Azure management, governance, security, and policy controls to on-premises servers, Kubernetes clusters, and workloads running on AWS or Google Cloud? In practical terms, what benefits does Arc provide for centralized monitoring, compliance, and lifecycle management across…
-
How I Use AI for Technical Documentation: Practical Experience
I decided to share a bit of my experience. I hope you’ll find it interesting and useful. How I Use AI for Technical Documentation: Practical ExperienceDocumentation is always a challenge. It’s rarely complete, hard to keep up to date, and any change in the system can trigger dozens of edits that no one makes. As a result,…
-
What are the key challenges and best practices for implementing Dynamics 365 Supply Chain Management
What are the key challenges and best practices for implementing Microsoft Dynamics 365 Supply Chain Management in a complex manufacturing or distribution environment, and how can organizations effectively configure demand forecasting, inventory optimization, warehouse management, supplier collaboration, and real-time…
-
What are the key benefits of using Dynamics 365 manufacturing cloud ERP for smart factory
What are the key benefits of using Dynamics 365 manufacturing cloud ERP for smart factory transformation? How can manufacturers integrate IoT and machine data with Dynamics 365 manufacturing cloud ERP?
-
What’s the most efficient way to migrate on-premises applications to Azure with minimal downtime?
I’m currently planning a large-scale migration of several on-premises applications to the Microsoft Azure Cloud. These applications include a mix of web apps, databases (SQL & NoSQL), APIs, and background services that are actively used by multiple departments. Because the business operates 24/7, minimizing downtime is a…
-
How do I download and use DotNet Packages in BC25
I need to transliterate non-latin characters and found a DotNet package in the package manager NuGet. I don't know how to download it from the command line and make a proper dotnet project yet, but I can download it manually, which gets me a ".nupkg" file. Is this usable in my AL project? Do I just put the it in the…
-
Subcontracting Order Line -> Qty Per Unit of Measure
Hi All, I have following Problem: 1) When I calculate subcontracting Worksheet for Subcontracting Requirement then "Qty Per unit of Measure" field is zero for All Subcontracting Requisition Line. 2) Creating Subcontracting Order from Subcontracting Worksheet then Subcontracting Order Line -> "Qty Per Unit of Measure" field…
-
Invalid Date - Behaviour using Modify / Insert
Hi all, in the last days i stumbled upon a strange behaviour of our Navision2018 System. And i think(?) this behaviour is knew. I did not recognize that in the past. Situation: We use Nav2018. We have to Import data from a text file. One field is a date field and the value is "1102025". (The data was send by a customer.)…
-
Showing new Dimension Set in Posting Preview
Problem: As part of posting of a Sales Order we generate G/L ledger entries and assign a new Dimension Set ID to them. When we run Preview Posting we see the generated G/L Entries but the dimensions are empty (Global Dimensions are filled out). Inspecting the line we can see a new Dimension Set ID is generated. If we post…
-
BC14 Word Layout – How to Hide Empty XML-Mapped Fields?
I’m working on a Word layout in Business Central 14 that uses XML-mapped content controls (from the dataset). I have a field like EinsatzortBeschreibungLineTextWord, and I want to hide it if it’s empty so that no blank lines or labels appear in the document. I tried using an IF field like this: "{ IF…