-
Document Attachment, where BC/NAV are storing the BLOB data?
Please, I want to know where are storing the BLOB data Dynamics NAV/Business Central (version 14) in Database. I can see table 1173 - Document Attachment, but there is no BLOB field, but there is a filed named Document Reference ID of type Media which may be a candidate to point other table. But i cannot find where. Thank…
-
Upgrade Steps: from BC14 CAL (On-premise) to BC22 (On-Premise)
Hi Everyone. Is there a document that can help me upgrade from BC14 CAL (on-premise) to BC 22 (on-premise). Detailed step by step document. Microsoft Document for this "Upgrading Customized C/AL Application to Microsoft Base Application version 22"…
-
Retired Dynamics NAV (and Business Central ) Courses
Hello, Does anyone know where to find retired video courses for Dynamics NAV 2017 and Business Central? Microsoft made them free to download for a while, but now there are nowhere to be found. Maybe someone downloaded and kept them. Here is the list of this videos retired, Thanks. NAV 2017 80949: Introduction to Dynamics…
-
NAV 2015 Synchronize Schema Changes
I'm currently in an upgrade to NAV2015 (build 41779) and I'm running the 'Sync. Schema for All Tables'. It ran for a while and currently the progression bar is at 100% for some hours now but the 'State' is still saying 'OperationalSyncInProgress'. The database to convert is a large database but I'm getting a bit concerned…
-
Event Sub filer record to current record logic
Hi All I'm subscribing to the Sales-Post codeunit and trying to create a validation based on the current document a user is interacting with. I cannot understand the reason for the below highlighted line of code to filter the document no as I assume SalesHeader already is filtered to the current record…
-
run report for multiple companies
Hello developers, How to get data from multiple companies in report? NAV2009R2/ Classic report I need to show customer and vendor entries per company in report. Is there any solution?
-
NAV2013 Fatal Error During Installation - local client
Hi, Trying to install NAV2013 RTC client on local workstation. Ran setup from a copy of the NAV2013 stored on the file server - got the following errors in the installation log: Microsoft Dynamics NAV Build 34797 Error Report Client Microsoft Dynamics NAV Client Components Fatal error during installation. Error reading…
-
Converting Dynamics AX to Dynamics NAV
Is there a way to convert/integrate data from Dynamics AX to Dynamics NAV? If yes, how? If no, is there a possible way to convert/integrate Dynamics AX to Dynamics NAV? Thank You for the help. I really appreciate the help.
-
Report Rendering - BC v21 - Selecting specific layout through an action
Hi all, I have just learnt about the new rendering section in reports today. I'm not finding much information about it online, and was wondering the following: If I have a Sales Shipment report extension set up using Rendering as belowrendering { layout(SalesShipment) { Type = RDLC; LayoutFile =…
-
Excel import container error.
Hello I got an error when trying to import Excel file. Its works fine when i run it from site. But on the container i got an error I tried reinstal the container, but it didn't help.
-
Get Local IP address from NAV 2013 R2
Dear all, How to get the IP Addresses of the (RTC) Client Machines who is accessing the NAV SERVER ? Regards, Navuser1
-
Import from Excel hide dialog Shipment Date <> workdate
Hi All I have tried below code to hide dialog when importing Sales Order lines but it's not working SalesLine.Init(); SalesLine.validate("Document No.", SalesHeader."No."); NextLineNo := NextLineNo + 1000; SalesLine."Line No." := NextLineNo; SalesLine.SetHideValidationDialog(True); SalesLine.Validate("Shipment Date",…
-
How to become a member of AppSource/MarketPlace
Hi Out of curiosity, how do an individual freelance developer (with proper certifications and experience) become a member to get their own object id range and sell their apps on the market place? Couldn't find a clear guidance on this, please
-
BC 14.6 on prem Permissions!
I want to force users to do the put away on the handheld - removed the delete permission from our warehouse permission set on table data 7324. It works a treat for the one user who only has warehouse - they cannot register the put away! However another user has our operations set - which doesn't contain tabedata 7324…
-
Business Central: Sales order document date and warehouse shipment posting date
Most of the time the document date on a sales order is automatically changed to warehouse shipment posting date as soon as the latter is posted. But there are times it is not. As the document date is used for calculating due dates, we need it to be constantly following the warehouse shipment posting date. Does anyone know…
-
"The specified path is invalid"
Hello, I have recompiled the page "Item Journal", now when I try to run it I get the error "The specified path is invalid" What could be the reason for that? Thanks in advance!
-
NAV 2018 - Job No. must be equal to '' in G/L Entry when reversing a G/L register
I am trying to reverse several G/L Registers in NAV 2018 and I keep getting this message: "Job No. must be equal to '' in G/L Entry." Of course I get more identifying information but that is the general gist of the issue. I have debugged the process and found that it stops in the "Check GL" section of the Table 179 :…
-
Business Central OnPrem – Not refresh Total Balance in pages
Hi, I encountered the problem starting with version 22.3.X.X Example: General Journals I insert a new line, fill in the field must (I continue in the same register but change column) and does not update the total balance of the footer of the page, when I move line it does add it. In old versions it did well, validating the…
-
NAV Translator v1.1
NAV Translator v1.1 The PowerShell module works as addition to Dynamics NAV Development Shell commands and helps translating Dynamics NAV objects in a convenient and automated manner. It works from PowerShell console and provides an efficient interface interaction for a user. Featuring own csv-file dictionary and online…
-
cannot have any leading or trailing spaces
We are getting the following error for a couple of extensions, I was wondering if we will delete the space in that field, doesn't that change the ID for that field along with their records and data? Table/RecurringBillingLines.Table.al (53,18) - Error AL0770: The identifier '"Recurring Billing "' cannot have any leading or…
-
Objects not shown after update license file
Hello everyone! I have updated my license file in business central instance, after updating the license file some objects are not shown in Business Central tell me function, then I check effective permission page for and filter object id’s (Execute, Read, insert) fields are disabled. Please tell what is the issue, How to…
-
Dynamics.IS JSON Mgt codeunit question (generating well formed JSON string)
Hello! I am trying to implement the sample codeunit provided many years ago by Dynamics.is (https://dynamics.is/?p=2303) to modernize functionality we use in NAV2013. Currently, we are using a FedEx SOAP web service that is being deprecated by the host. They have created a RESTful API to replace the legacy SOAP connection,…
-
How do I translate from Danish using xlf files in Business Central cloud?
Hi experts. I have my own app in Business Central cloud. All captions etc. are written in Danish. Now the customer tell us that some users are going to use English and some are going to use Danish on the GUI. I guess that Business Central expect my app to be in en-US. Is that correct? Can I somehow set up my app to be in…
-
DotNet .... is missing (BC22)
Hi, I am desperately trying to understand why something that I have being doing for years in prior versions of NAV/BC no longer works in BC22. It is to do with Base64 encoding. In the past, I have often used TempBlob's Base64 Encode/Decode features. I realised recently that in later, but not BC, version Codeunit 10 "Type…
-
Action after salesOrder API Post
Hi everyone, Is it possible to perform an action (say release order), after an order is created trough API? I can release the order after one salesLine on OnInsert trigger, but not after multiple lines are posted. Would appreciate any insight. Thanks.
-
BC365 Disable Print Icon on Report Viewer
Hello. Good day. I would like to know if is there any way to disable the print button in BC365 Report/Layout Viewer? Photo for reference below. Thank you in advance to those who can help and answer my query. God Bless to all
-
clients that run on Microsoft Navision in Belgium
Hi! I'm looking for clients that run on Microsoft Navision in Belgium! Is there someone who can help me? Thank you!
-
NAVISION2015 print PDF square special character in place of thousands space since WINDOWS 11
Hello I have a problem displaying the thousands space on PDF printouts only of Windows 11 PC Does anyone have a solution to resolve this problem please? Thank's for your help . Best regards
-
Debug API Page Post
Hello everyone, How can I debug an API Page(POST) in Business Central? is it possible to create a log page to see the response of the API? Thanks.
-
LS Retail Z-Report Wrong Amount
Dear All, When I print the z-report is not showing the correct amount, when I check the ZReport-ID in Trans. Payment Entry its filling only the one with the biggest StaffID, For example if i have 4302,4303 and 4308, only the transactions made by 4308 will be filled and also printed on ZReport. Please any Explanation ?