-
User Access Report
is it possible to run a report from BC showing user access over a period, so who logged and on what dates?
-
New Company Request
Hi I need to add another company to our system. It isnt live yet but is is based in SWITZERLAND so I need to maje sure the tenant set up etc is correct. Please advise how to add a company?
-
if boolean of a field is set to true then Editable in another field should also be true
Hi, can someone please help? on Business Central AL, I am trying to set a rule, where if a Field Property Editable is set to true then another field should be set to true, if it's set to false then the other field should also be set to false. field (Record1Boolean) { Editable=true } field (Record2Date) {…
-
Post Code Look Up
We are looking to upgrade to BC later in the year and would some information in regards to how the POST CODE LOOK UP function we have currently works in our current version of NAV. Are you able to provide the information?
-
Repeated Refresh Issue
Users getting repeated message asking to refresh, see image
-
Discount column missing on sales order
Dear community, I've a question regarding Dynamics NAV 5.0 (2007): Dear Community, perhaps someone can help me. The following: I have added a discount to some of the prices (under "line discounts"). When I create a "quote", these discounts are shown in a separate column, so far so good. However, when I create a "sales…
-
Put away per zone and bin?
In Business Central, it is possible to create a pick per zone, bin, etc. But is this not possible for Warehouse Put-Aways? For example you want to create 2 picks for 2 different zones? Thanks.
-
How to change the "Credit Limit (LCY)"
Dear community, I've a problem with Dynamics NAV 5.0 (2007): Could you please indicate how to modify the "Credit Limit (LCY)" of a customer. By default, I always have €1,000.00 filled in, but I want to give a customer more, but unfortunately I cannot edit the field on the customer record. Do you know how this works? I hope…
-
How to store file in BLOB field in business central ??
what procedure to add to upload a file of type text??
-
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 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…