-
Global variable in onDelete trigger
I need to delete a set of record in a table (Table1) applying filter. For each record in this table there may be other records in a secondary table (Table2). In onDelete trigger there is code to cascade delete all record related in Table2. But in this code there is a confirm to ask user every time a record was deleted. I…
-
How to convert Image to Base64 ?
Hi , Anyone has idea how Image can be converted to Base64 in navision?
-
In Business Central- Cloud- Error on connecting External WS- Http Content
I am trying to make a connection to external WS and I get an error related to - Misused Header name. I believe this is due to "Content-Type" and may be the syntax is incorrect.??? I have tried to access the same WS via Postman and I was able to get a success message.… Any Ideas what is wrong here? TIA //Header…
-
Force Boolean value to be "true" or "false", instead of "Yes" or "No"
Hi community, I need to write a boolean value to an xml file and am always getting a "Ja" (German for Yes), instead of a "true". I've tried all of the options shown here under "Standard Boolean Format" (Link) but without success. And I don't wanna do stuff like "if value = 1 then 'true' else 'false'" or so. Does anyone…
-
FDA Electronic system audit
This is an interesting request and its the first time I heard about it even with my prior job with Nav vendor. A little background, the company I work for is medical equipment suppler and we are ISO compliant and under FDA rules. We got audit by one of our customers. Based on the Electronic system audit checklist from FDA,…
-
Querying records by Dimension Set ID
I am attempting is to create a page on a role center that calculates the total amount for G/L Entries based on specific dimensions. Currently, the page performs this calculation when it loads. I have created a query for this purpose, which is functional but not optimized for performance. I'm wondering if there are any ways…
-
Business Central 19 Wave 2: Cannot Publish Extension With Updated License
A third party vendor added some granularity to our license and our partner downloaded it and sent it to us. Now we can no longer publish after importing the new license. It is giving the error: [2022-12-08 10:35:10.50] The request for path…
-
Need Help!!!
Am trying to convert picture to bigtext or base64. Again On xmlport am trying convert text to stream and save it in field of Mediaset type.? but it is not working Please find attached code . Please let me know where am wrong? With the above setup and code if i run i get the following error Please help
-
How to customize the creation of the Corrective Credit Memo?
Hi everyone, I want to customize the creation of the Corrective Credit Memo from Posted Sales Invoice so that it only adds a line of type G/L Account, is it possible to do it from an extension?
-
Setting up POS Terminal Discount
Hello everyone, I'm new to this group and I have a question regarding our retail operations. We are using Dynamics NAV 2016 and LS Retail for our system. We want to allocate a specific POS Terminal for Home Delivery orders only. Additionally, our management wants to apply a 10% discount on products that are billed through…
-
Dynamics NAV 2013 Generating a GS1 2D Matrix Barcode
Hi All Has anyone generated a GS1 2D matrix or can point me in the way of how to generate this type of data matrix barcode? I've tried using the datamatrix.net dll but that doesn't support the FNC1 character required. Any help appreciated.
-
how to add location field in Vat Entry table(254) and Vat Statement page(317)
Hi All, Can anyone of you suggest me, how to add location field in Vat Entry table(254) and Vat Statement page(317)? Thanks, Rajan123
-
Visual Studio Just-In Time Debugger error when publishing from VS Code
Hi, Since this morning, when trying to publish (with or without debugging) to any SaaS sandboxes from VS Code, I get a Visual Studio Just-In Time Debugger error I do not have Visual Studio installed, only VS Code I just click on OK and the process continues, but it's annoying. Doesn't happen if I'm publishing on Prem.…
-
Whats is the Link between Ordinary a Sales order and Purchase order in Navision?
I know that , Sales order is linked with Purchase Order in case of Purchase code is either "Drop Shipment" or "Special Order". Apart from that we can link Sales order with Purchase order by means of "Reserve" by Clicking Line ---> Functions---> Reserve in Sales Line of "Line"Action Button. is there is any other link…
-
BC TechDays 2023 Video
My impressions of this year’s conference: BC TechDays 2023
-
Transfer Nav Exported file to SFTP directory file and download file from SFTP to Nav directory.
Hi Everyone,[Nav 2017] I would like to transfer Nav Exported file to SFTP directory file and download file from SFTP to Nav directory.(File is in Csv format) Eg. Nav folder: C:\Desktop\DEMO\ForSFTP> SFTP folder: C:\Desktop\DEMO\FromNav Nav folder: C:\Desktop\DEMO\FromSFTP <SFTP folder: C:\Desktop\DEMO\ForNav For this I am…
-
NAV Business Central - is it possible to do SQL Query?
Good day! NAV Business Central - is it possible to do SQL Query using Microsoft SQL Server Management Studio and MS Excel? Thank you!
-
How do I get SQL Authentication to work on Dynamics BC v21
I am currently trying to setup SQL Authentication for Business Central I am running a three-tier architecture as below - APP Server - running BC v21(Installed all components except SQL components) - DB Server - running MSSQL Server 2022 (Installed only SQL Components) All the servers are running windows 2022 NON-DOMAIN…
-
Dynamic NAV2018 Could not find prepared statement with handle 6046
Hello all, I use NAV2018 get an "Could not find prepared statement with handle 6046". Sometimes once a month, sometimes every week one time. Than you can only restart SQL Server services / NAV service to solve the problem Are there other solution centers outside with the same problem and do have a fix for this. In the…
-
Unable Login Dynamics 365 Business Central Mobile
Hi all, is there a bug in the mobile app? Since april 10, 2023 some users cannot log in to mobile app. the app say session expired and after i click button refresh, the display return to login and this repeat continuously. I try to check event viewer in server but i dont get an error notification instead i get information…
-
NavHttpClient Request Failed
I get this error when executing a HTTP Client Request from BC Code: "Code: 0, Message: NavHttpClient Request Failed, Error: The operation was canceled.". The error is thrown after what looks like (more or less) precisely 2 minutes. If I limit my request in BC so that it takes less than 2 minutes, it completes without…
-
"Internal Server Error" production environment
Hi everyone, I'm trying to publish a production environment for a new customer and I keep getting an "Internal Server Error" when publishen or when downloading symbols. I tried a few things myself and nothing works; - I checked data in the app.json and launch.json objects and everything looks good. - I tried to remove the…
-
BC 22.0 Import-NAVEncryptionKey The provided encryption key file contains invalid data
Hello, I'm trying to install Business Central 22.0 on an Azure VM. I have created an Azure SQL database with a dba owner user. The database encryption has been enabled (CREATE MASTER KEY ENCRYPTION BY PASSWORD = ''). Now I want to configure the database user and password for the BC service tier. New-NAVEncryptionKey…
-
Find credit memo line(s) associated with an invoice line.
This is NAV 2015. My dev problem is this: From a given Posted Sales Invoice line, find any/all Posted Sales Credit Memo lines associated with that invoice line. I've hunted through a whole jungle of tables/recs to find a foolproof path from one to the other and I just don't see one. I would have thought there would be…
-
BC V20 on prem AAD auth using OpenID
I have managed to get the on prem working with AAD auth but only with WS-Federation. I had to set a flag in BC to enable WS-Federation. Looking thru the latest docs it appears I will need to move over to OpenID in the future. Does anyone have any links for a good guide on how to implement OpenID with BC v20 on prem?
-
Reverse Charge in UK
Can you advised me how to use Charge VAT. Please could you advise how this should be processed and any set up changes we need? We have to process postponed VAT and had to have changes made so I’, assuming this will be similar. Thank you
-
NavEncryptionKeyNotFoundException
Hi, BC16 OnPrem, when you open Customer, Vendor or Contact cards, you get aMicrosoft.Dynamics.Nav.Types.Exceptions.Encryption.NavEncryptionKeyNotFoundException Kind of found a workaround which suppresses the error by disabling CDS on the CDS Connection Setup page. I get the same exception when then trying to run…
-
Is there a way to link Nav 2015 Session ID to SQL SPID?
Hello, I am wondering if there is a way to link a Nav 2015 Session ID found in Active Session table to the SPID of the session in SQL (found by running the sp_who2 stored procedure for example) The sp_who2 command will let me identify what session is causing blocking, but it won't say anything about the user as it only…
-
How to open 2 windows session in Business Central
Hi, I want to open 2 windows authentication user session in 2 different tabs in Google chrome. If anyone knows how to do , please let me know the steps to achieve it. Thanks in advance. Regards, sekar.
-
Old versions base app
I need to download symbols for older versions of base report 7305 “Whse.-Source - Create Document”. Does anyone have to code or know how to do that? I want to compare the code from version 18 with the current one using one of those online code comparisons. I tried to view the code in NAV but it's a long report, so checking…