-
report
Good morning all, I have a problem I created a report which calculates the due date according to the date entered the report compiles well but once I am worth executing the report the following error message is displayed
-
Where can I download Business Central 2020 Wave 1 from?
I understand that via 'Power Platform' you can get early access to releases 2 months before their 'General Release' date which means that BC 2020 Wave 1 is now available in that way .. however, I want to actually download the package (as I did with BC 2019 Wave 2) so that I can develop/test locally. Is this possible? Can't…
-
Printing A5 layout on A4 printer
We need print A5 layout on A4 printer (half sheet). Layout has landscape orientation with A5 page size. - print without preview resulting A5 print (OK) - print from preview resulting A4 print (Wrong) - print from preview with printer layout resulting A4 print (Wrong) - print from preview with format settings resulting A5…
-
Workflow Question
Hi In NAV 2018 is there any way force a purchase approval for all users? ie every purchase order requires approval regardless of the amount. Thank you
-
Find Dynamics NAV/BC actual build number.
Hello! I'm working on webservice code in BC14 (C/AL). Is there a way to find actual Version/Build Number from code that's universal to all NAV versions with SQL, and maybe works in AL. The way i've found that's the PRODUCTNAME function, but on BC this does not provide information about the version, all of them are called…
-
Ability to Edit a Released Document
Hi All, in the Windows client if I go into a Purchase Invoice which is approved / released I still have the ability to edit the document (Clicking Edit in the Manage tab). In the Web Client the Edit button at the top of the page isn't able to be selected. Please could someone explain why the behaviour is different? Thank…
-
RapidStart field length limitation
Hi, I've added some text fields to table 27 Item that have a length of 2048, which is the maximum length allowed in BC14. Now I want to process the fields in a RapidStart package. Unfortunately though, RapidStart is limited to the old field length of 250. During import, it simply truncates the input text. In T8615 Config.…
-
Save/Preview/Copy Picture functions inside a factbox NAV2016
Hi all, In BC, the standard appears to be for pictures to be in a factbox. I'm trying to emulate that practice in NAV2016. If my picture field is on the main page, if I right-click, I get the options to Select/Save/Preview/Copy/Delete the picture blob. If I move the picture field to a factbox, I cannot figure out how to…
-
Best web text editor NAV18
Hi all! I have found some options for text editing. The best here is the Erik Hougaard WYSIWYG. Unfortunately, it doesn't work in Web. All I tried works stupid in Web. Best solution now is something like this: It doesn't extend to the whole window. And in general looks ugly for me. Please share your best ideas to visualize…
-
smtp.office365.com in SMTP Mail Setup | NAV 2016
Dear Sir, The following error message is occurred when I click "Test Email Setup" in the SMTP Mail Setup Page. Microsoft Dynamics NAV The SMTP mail system returned the following error: "Transaction failed. The server response was: 5.2.0 STOREDRV.Submission.Exception:SendAsDeniedException.MapiExceptionSendAsDenied; Failed…
-
Set filter for table lookup on Request Page
I want to set a table filter for a lookup (or drilldown) on a table, like the Customer table, for a Request Page on a report. I want to set filter: 'Customer Posting Group' so that only customers for that posting group will show up in my lookup. I want to do the lookup for the Customer.'No.' field. The field is added to…
-
Auto selection of item from that lotNo,which has expiration date near during creating sales order.
Hi Everyone, I am creating sales order, so i need to select in sales line item from the LotNo which will expire first[ie. which LotNo 'expiration date is near']. It should be automatic. How can i proceed this; whether i should try with codeunit or should create a button in sales order page. eg. ItemNo LotNo Expiration-Date…
-
use of setrange ?
Hi all, i am very confuse by seeing use of SETRANGE 1)PurchHeader.SETRANGE("No.","No.");//same field of record variable twice. 2)DefermentBuffer.SETRANGE("Document No.","No.");//different field one from record variable and one from purchase header table which is source table for page why so what happening in two cases any…
-
Data upgrade to Business Central Cloud
Hi all, What tools/options do we have when we want to upgrade data to BC15 cloud from previous version of BC onprem? And how we actually do that data upgrade? Thanks, Stefan
-
Iterating a directory
When iterating a directory using a background client is it possible to ignore files that are empty? I'm using the getserverdirectorylist function but i want to exclude files that have zero size Regards,
-
How to add a Generic Chart to Role Center in BC Wave 1 OnPrem
Hi, I am designing a new Role Center and I want to add an existing Generic Chart to the Role Center via C/SIDE development environment. I have tried to add a Part of type Chart to the Role Center page. Sadly the Chart is not shown. Have you ever tried something like this and can guide me to success?
-
[.Net] Adding user to AD group
hi all. The task is to add a user in AD group from NAV 2018. This is the reference instruction. My problem is that I don’t understand the syntax for NAV. I tried something like this: Nevertheless it didn't work. Could you please help me find the examples of correct syntax? Thanks!
-
ABA ROUTING NUMBER MOD 10 USA
Hi whow work with checkdigit routing naumber as MOD 10 using navision 2013 or NAV... , can you please put the code on comment Thank you
-
Jet Reports
Hi, One of my customer is using D365 BC along with Jet Reports. A user from the company has got himself a iMac and there is a question from them like can we install Jet Reports in iMac? Regards Kwaja
-
on post of purchase order how to show error msg if field is empty?
Hi all, I am trying to add error mssage if any field in purchase order is empty while posting.for that i have added a code on Post action asIF "Buy-from Vendor No."='' THEN BEGIN ERROR('Error:Empty field'+FIELDCAPTION("Buy-from Vendor No.")+'Please Add Data in field.'); END; IF "Buy-from Vendor Name"='' THEN BEGIN…
-
Create JSON file using C/AL Code
Dear Sir, Suppose I'm using standard nav 2016 database & want to create a JSON file on Customer Master tabledata. So how can I do that using C/AL code ? Kindly reply. navuser1
-
Fix dynamic header in RDLC report
So, I am trying to fix a report and keep running into a strange situation. This report prints multiple Sales Order Confirmations from the Sales Order List. On this report there is a textbox for a field of concatenated comments on the order. The initial problem was if the textbox spanned more than a page, the header data…
-
Dynamics 365BC Fact box question
In Dynamics 365BC on Premise if you go to any page-->design-->You can move or remove a fact box and no where I see an option to put them back, does anyone know how to put the fact box back once removed or hidden. Thanks for your help. RJ.
-
To Show the 'Report Totals' part in Footer of the RDLC report
Hi All, I am using the sales invoice report 1306. While customizing this report our customers want to show the 'report totals' part in the footer of the report. Please find the attached screenshot. Layout: Output: I am not able to show this in the footer section of the report. Please help me. Thanks in advance, Jacob.A
-
NAV2017: Audit on Extensions
Hi all, we had a small mishap with an extension in NAV2017. I now need information on who installed the extension in question and when. Or if I don't get that info, I need to set it up so that in the future I will. I tried setting up the change log, but the table NAV App is only virtual and cannot be tracked. Since…
-
App search not working in sandbox BC cloud
.
-
NAV License File Clarification
Dear Team, Can anyone help us to understand the max user license available with following NAV license information shared for the NAV 2018 version with LS Retail. License Module List ************************************************************************************************************** Module Quantity Included…
-
Workflow Notification Email is in HTML Format
Dear all, I am using Business Central 15 Cumulative Update 2. When I receive workflow notification email, the format is incorrect. The correct format is below. Please help how to solve this issue. Thank you. Best Regards, Johanna
-
Deactivate Change Tracking on SQL server (Performance tuning)
Hi, Have a customer with performance problems. They have a SQL consultant looking into SQL performance. He says that Change Tracking is activated on database, and that gives performance issues. Can we deactivate Change Tracking on SQL database without problems for the running NAV 2018? Are there any other areas to do…
-
Allocate a cash receipt to a Proper Customer
Good day, I have cash receipts transactions posted in Navision but to wrong customers, to reconcile I need to allocate these receipts to their proper customers. Please help me with the proper steps I need to go about. Thanks, Nagaboona.