-
SAVEASEXCEL in old format
Hi there I have client which is working on Dynamics NAV 2017. There is one function which is creating one of the reports in excel and send on their customer e-mail. The problem starts when some of the customers use old xls formats and they can open only xls formats. When I'm using SAVEASEXCEL function the format by default…
-
How to prevent closing the page after error?
Why page is closing after error and how to prevent this scenario?
-
adding report to Role Center Ribbon
Hello. I'm trying to figure out why some reports, when you right click on them, offer you "Add to Actions on Role Center Ribbon", some reports offer you "Add to Reports on Role Center Ribbon", and I even found one that offers "Add to Navigation Pane". What setting on a report is responsible for this? Or is this a setting…
-
Open Excel File Saved by reporting services, on BC14
Good Morning I can't open Excel files saved in xlsx format from Reporting services, it gives the attached error ExcelBuffer.OpenBook fails If I open the file manually with Excel and save it in xlsx format then the OpenBook does not give an error Anyone know if something can be done? Thanks in Advance
-
DecimalPlaces Property
I need to have only 2 decimal places. I tried to change DecimalPlaces Property in "Unit Price" field from 5 to 2 (0:5 --> 2:2). But it does not work. Why DecimalPlaces Property does not work ?
-
Open a Sales invoice page when open a database
Hi everyone, I need to open a sales invoice page automatically when i open a database from file database open. Please suggest me some answer Thanks in Advance
-
PopulateAllFields issue
Hi! I need help with PopulateAllFields property. I have a group of filters on a record and PopulateAllFields is active on page, but only automatically fill in a single field. None of the fields is part of the key. My code is: myrecord.FILTERGROUP(2); myrecord.SETRANGE(Type,Rec.type); myrecord.SETRANGE(code,Rec.code);…
-
Pictures and Labels
Hi Mibuso.com World :) ! Is it possible on a Label Report (NAV 2018) to have an Image side by side? In NAV 2009 Reports they lived together no problems... But converting to NAV 2018 they're being pushed to the right? Thanks for your help :) !
-
NAV2018 System Tables modification
hello I am running a NAV2018 database with side-by-side development. I added a boolean field in the Company table through c/side (since these cannot be extended through Extensions). However when I am referencing to it through an extension, it is not visible. I've already generated symbols and tried with different tables,…
-
CSV file from a Report
I am trying to develop a report that the End User can initiate so that the Check Ledger Entry table is sorted by Check Date. I have all of my columns needed by the Bank, and I have been able to get all of the data exactly the way I want it. The issue I am having is I cannot figure out how to get the code written to export…
-
Report on Microsoft Dynamics NAV 2016
Hello Everyone, I'm a student currently doing my internship at an IT consulting company and I have to develop a new report on the system. Is there a posibility to track the number of user logged on per day via a report on NAV 2016?? If yes, grateful if you can guide me through the steps to do so. Thank you :)
-
Data Exchange Transformation Rule
Hello All, Setting up a Data Exchange Definition two transformation rules do not seem to work. Initially I want to remove - from the Bank Account Sort Code for example 20-55-77 should be set to 205577. Please can someone review the setup and give any suggestions to correct it. When I do a Test on the transformation rule it…
-
Blog Series Part 10: Automize process for Sales Transaction in MSDYN365BC
Hi Readers, I am sure you might be able to create the functionality in below mentioned blog.If you have not seen my previous blogs I have mentioned the links Continue reading Blog Series Part 10: Automize process for Sales Transaction in MSDYN365BC →
-
Blog Series Part 9: Developing Matrix Report in AL for MSDYN365BC
Hi Readers, This blog describes how to create Matrix report in Microsoft Dynamics Business Central.. Continue reading Blog Series Part 9: Developing Matrix Report in AL for MSDYN365BC→
-
CDS (16.2) RegisterTableConnection
Good morning, after creating a table of type CDS as described here If we try to access the table through a simple list page, we receive this error: Table connection for table type CRM must be registered using RegisterTableConnection or cmdlet New-NAVTableConnection before it can be used. Is this a bug or are we missing…
-
Substitution for UploadFileSilent on web client
Does it exist substitution for UploadFileSilent (not supported on web client) in AL. I tried with UploadIntoStream, but it opens dialog box to choose file, which I don't want.
-
Error while Executing the "Refresh Production Order" report.
Hi all, I'm getting error when I run the "Refresh Production Order" Report from codeunit. Code which I'm executing: Error: Thanks in advance, Srinivas :) .
-
Prevent cursor from jumping to next field
I am working on barcode code. i want my cursor to b fixed at input field so that i can scan barcode continously.
-
Prevent cursor from jumping to next field on Enter?
Hi all, Is it possible to make the cursor stay at the same field in a page upon pressing enter key? Regards, Rahul
-
I cannot open an Item!
I have a problem with an Item in Dynamics NAV 2018. When I want to register it in a sales order it tells me that the product does not exist, and I go to the Items table to create it, but it tells me that it already exists. When filtering by the Item number, it does not give me a result in the search. I decided to look for…
-
How to add new Custom Module in Business Central.
Dear All, Can some one please explain me how add custom module in Business Central.
-
Report Only Modify in Buisness Central with AL
How is it possible to Modify the default Report's Only if there is no Extensions ?
-
NAV BC Planning Worksheet Page (99000852) - Column Sorting
Hi Everyone, Is there a properties field where I can allow column sorting for the user so when they click on the column it will sort? It was by default in NAV 2013 and now it seems users can't sort on this and other pages. Thank you
-
BC/VSCode: Build package and download symbols in Powershell
Hi! Does anybody know if there is any possibility to build an app-package from Powershell and download symbols from Powershell, instead of from VSCode? I am playing around with automatically updating dependency version numbers via Powershell in order to have all dependency versions updated in all apps when a new version of…
-
how to put page link in cues using extension
hi guys. how do I add these in my cues page, using an extension in AL?
-
How to convert the datetime field into CST
Hi All, I have created one customized table with field 'DateTime'. Now i want to convert that DateTime field into CST(Central Standard Time) and show it on a page. Please guide me to solve this. Thanks in advance, Jacob.A
-
The user process has terminated unexpectedly. Check the Windows Event Viewer.
Hi All, I'm getting error while posting sales order using Background Posting i.e., Job Queue. Error in Job Queue: Microsoft Dynamics NAV The user process has terminated unexpectedly. Check the Windows Event Viewer or the Session Event table for more information.OK Event Log for the Error: Server instance: DynamicsNAV90…
-
[NAV 2017] ODATA Web Service - POST Json Body with root
Hello community, I have a problem with above topic. I published a simple page as ODATA Web Service. If I test the web service with postman it works with a simple JSON body as POST statement: { "Field1":"Value1", "Field2":"Value2" } But if I change the JSON body to the following, it don't work: { "JSONBodyRoot" [ {…
-
Factbox with ProviderID and Code
Hello, I have a page (page is not based on any table) that contains 2 subpages. Related to one of these Suppage I want to access an factbox by code. if the user switches the line in the subpage the infobox has to change accordingly. UpdateProgagation = Both seems to be not enough, cause it seems that it doesnt call an…
-
Business Central 14 upgrade to 16.2, error during upgrade.
Hey I'm trying to upgrade a BC 14 to BC 16.2 and got stuck at the process, where i need to sync the base application. I am following the steps in "https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-unmodified-application-v14-v16". When I run this command below: Sync-NAVApp…