-
Best Practices for Managing EPC Project Lifecycles Using Dynamics 365 or Business Central
Hi everyone, I’m working with EPC (Engineering, Procurement & Construction) project environments and exploring ways to improve coordination across engineering, procurement, construction, and financial controls. EPC project management often face recurring issues such as cost overruns, schedule delays, slow approvals,…
-
XMLPort odd behavior
I'm executing a function that calls an XMLPort and then on Success it archives the file. Out of 800 files tested 6 archived the file without importing it. I'm not sure why it archived even though I only archive when Success of the XMLPort is TRUE. I'm thinking of using GETLASTERRORTEXT to see if that traps an error…
-
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.)…
-
AX 2012 to D365 F&O Upgrade: Best Approach?
Hi everyone, We’re currently running Dynamics AX 2012 and planning a move to Dynamics 365 Finance & Operations. I’d appreciate some practical insights from those who’ve already gone through this journey. Did you go with reimplementation or code upgrade? What influenced your decision? How did you handle existing…
-
How Can Organizations Build Trusted and Consistent Business Insights for Enterprise Analytics?
I’m exploring how organizations can build enterprise analytics solutions that deliver trusted, consistent, and governed business insights across teams. Even with tools like Business Central, Power BI, Dataverse, or SQL-based data models, many companies still experience data silos, conflicting KPIs, inconsistent reporting,…
-
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…
-
Recref between companies
I'm using recref to copy data between companies not copying the key because I want that to be perform by the insert in the destination company but it looks like the insert it's working in the current company
-
Insert new line on second List Part - The view is filtered, and the entry is outside the filter
Hi Guys I have created a second list part on the Service order screen to show service item worksheet table rows, second list is filtered by the service item lines . same hierarchy such as sales lines and item tracking lines. all works when viewing records however I cannot insert a new record to the second list part (items…
-
Nav 5.0 SP1 - Not saving last open Company in File menu
We have installed NAV 5.0 SPI on a new server, and on that server it does not save the last open Company like it did on the old server. See picture. The SQL server is the same, and ZUP files seems to be saved correctly. Is there a setting some where that enables this ?
-
Stack Overflow when executing Report Adjust Cost - Item Entries
Hello, One of our customers can no longer excecute the report 795 Adjust Cost - Item Entries for a specific item. This error message appears. At first glance, it is not obvious that inventory regulation is stuck in an endless loop. When debugging, you notice that the functions ForwardCostToOutbndEntries and…
-
Does anyone still have an old Navision 3.56 demo license and Cronus database?
Hi everyone, I’m working on a hobby project to study and recreate the UX of the old Navision 3.56 client as a modern Rust-based terminal application. I’ve already got the engine running in DOSBox-X, but I’m missing the original demo license and demo database, for example Cronus, database.fin, or cronus.fin. If anyone has…
-
Statical Prism for AL 4.5 SE
Statical Prism for AL 2.1.0 SE Prism for AL is our analysis tool and code browser for Microsoft Dynamics 365 Business Central. Total solution overview Module details and dependency graph, table relations graph and more. Extensive code graph Run powerful code queries on your workspace-as-a-graph — leave no stone unturned.…
-
Differences between warehouse entries and item ledger entries
Hi everyone, I’ve found 100+ items in NAV with quantity differences between Warehouse Entries and Item Ledger Entries. All locations use WMS with Directed Put-away and Pick. Does anyone know the correct procedure to reconcile these quantities and bring both ledgers back in sync? Thanks!
-
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
-
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’,…
-
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…