-
Microsoft Dynamics NAV 2017: ExcelBuffer => How can I add an AutoFilter function?
I try to add a new function AutoFilter to ExcelBuffer (370). attempt (without succes): XlWrkBk := XlApp.ActiveWorkbook; XlWrkSht := XlWrkBk.ActiveSheet; XlWrkSht.AutoFilter; Anyone ever written something similar and can help me out? Thanks in advance!!!
-
"Incoming Doc. Attach. FactBox" causes massive performance problemes
Hi guys, when opening the Sales Order Page (9305) the data are shown after 11 seconds. While analysing the performance, I figured out, that the subpage "Incoming Doc. Attach. FactBox" causes these problems. It is strange that this is not always the case. The same fact box sometimes causes this problem also when opening…
-
Email CC customization
I'm trying to modify the Send Email "CC" field in Posted Sales Invoice page to populate the value of the custom email fields(Email 2 and Email 3) that I have in the Customer Card I have found the following event to subscribe to in order to modify those fields (To, CC, or BCC) but I encountered an issue when they have a…
-
How to create unique records in navision
i have created a table with fields id,name,roll no,age id name rollno age 1 A 1 20 2 b 2 20 3 c 1 20 i will create a actiuon called unique now i have to count unique records in roll no field like it should show message after clicking on action unique then it should show "No of unique records is 2"
-
customization of sales invoice emailing
Three email fields have been created, and I want to take all those emails from all those three fields and add them to the "To" field. Anyone knows which event I should subscribe to or what needs to be done to include those emails?
-
Base function missing
hi all , I am using Nav 2018.in the report 1401(check),the base functions are missing. I have checked with someone who have same version of navision 2018. for the reference i have attached the screen shot of the function which i have currently. I need to use the FormatNoText function from report-1401.but it is missing for…
-
NAVCancelCredentialPromptException with infinite loading loop
Hi everyone, after upgrading from BC17 to BC21 onprem we are encountering the issue that some users will get caught in a seemless infinite loading loop after changing the language or company in BC. We are using AAD fot authentication. After clearing cookies it works just fine. The event log for the time of the problem is…
-
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.…