-
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 Import Item Pictures using XMLPORT in NAV 2016?
Hi, I am trying to IMPORT 'Item Picture' for a particular Item present in NAV by using XMLPORT. I can't find out how to do it. Can anyone suggest the C/AL required for this operation? Best, Souvik
-
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
-
When page is opened , need to to select all records
I have customization on pages, when a page is opened, first all records should be selected, can any one suggest me how to do it? Advance Thank you
-
Doubt about SumIndexField
Hi friends... I have a doubt about SumIndexField in a Table Key.... I tried to find it on internet but I can't, so I hope one of you can clarify my doubt... I have one table (Table A) with many keys with diferent fields... and many of them have specified the same field as SumIndexField (Field "Total Importe producción"…
-
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…
-
SSRS reporting in F&O discontinued?
I’m new to F&O, used to work with Nav/ Business Central for years. Now I started off in a F&O project where all reports are developed via SSRS. The reports mostly relate to functionality of an ISV for Logistics Service Providers, but also to standard F&O. The project is currently on hold, as there is a discussion whether…
-
Pre-Sales material
Hi All Microsoft used to share all the pre-sales presentations and info on partnersource. I am unable to find it there anymore. Can some one share where this material is shared, if at all.
-
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…
-
Database Restore Failure - Incorrect Checksum
Hi All, I am getting an error when I am restoring Database in NAV 2009 R2. "Database Restore Failure - incorrect Checksum" Can anyone please help me to restore. Raghubir
-
Please see this below question (it is lengthy, that's why posted below)
General Journal, Payment Journal, Cash Receipt Journal, Recurring journal both having "Gen.Journal Line" as table, can anyone explain in theory way what's the difference between it. & Technical, if possible, please.
-
"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…
-
Application Management MAKEDATEFILTER
As usual, something I thought would be simple has turned into a dog-fight. I need to put a control on a report request form to collect a date filter. Looking at a stock example I went to form 490, Acc. Schedule Overview. There, the date filter is a textbox with the source expression "Acc. Schedule Line"."Date Filter". I…
-
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…