-
Date format DDMMYYYY and use as Date data type
I need to format the date into DDMMYYY. But want to use as Date, not a text. This gives me correct formate FORMAT(TODAY,0,'<Day,2>/<Month,2>/<Year4>'); but want to assign to date, when used EVALUATE again my date become DDMMYY. I am using RecRef therefore need to use same date formate IF (TableID = 271) AND…
-
Warehouse recepit from Transfer order
Good morning, I have an issue creating the warehouse recepit from Transfer Order action ribbon: once filled in all the required fields and clicking on the "warehouse receipt " button, any window opens, while clicking on the "warehouse shipment" button works perfectly. Could it depend on the Locations settings? Am I doing…
-
Insert data to MySQL-Server with assembly MySql.Data ADO.NET
Hello, I want to write data to a MySQL-Database with C/AL and assembly MySql.Data. This code works very fine: ... ADOMySQLCommand.CommandText := 'INSERT INTO t_ado VALUES(NULL,@PLZ)'; ADOMySQLCommand.Prepare(); ADOMySQLCommand.Parameters.AddWithValue('@PLZ', '99999'); ADOMySQLCommand.ExecuteNonQuery(); ... The code above…
-
records from 2 tables shown in 1 page
Hello everyone, Can anyone tell me if it is possible to make a temporary page with records from 2 different tables? And if so, how to do this? If it is not possible to do this, does anyone have a good idea too get records from 2 different tables into 1 page. My best idea is to use a temporary page or table, but I don't…
-
Can i catch error message without "GETLASTERRORTEXT" ?
I would like to track every error message and time of error message and save result into my table without GETLASTERRORTEXT, Can i do it?
-
Deserialize Json as an array/list of results
Hi, I am trying to call a Rest web service, which returns response in the form of a json "Result": [ {"id":"1", "firstname":"xyz"}, {"id":"2", "firstname":"abc"} ] I have created a dotnet dll and imported it into navision. I use the ApiResult := JsonConvert.DeserializeObject(Json,GETDOTNETTYPE(ApiResult)); to deserialize…
-
Adding global variables on a request form of a report
I have a report which uses 15 global variables, already initialized on the OnPreReport trigger. I need users to be able to change their pre-determined values on launching the report. I would thus like to add thoses 15 global variables on the request form. Sure, I can manually add 15 checkboxes/textboxes + 15 labels then…
-
How to catch changing of the variable?
Is it possible to realize smth like: IF (value changed) then ...
-
Report output is .CSV if you file the file it appears to be garbage
I have a NAV report (2017 on-Prem) that is set to save to a CSV file and placed on a seperate server from the NAV servers. When I run it manually it is fine. When we run the code unit that was created to run the Report the output looks like garbage. Towards the top of this garbage I have found the below bit of info that I…
-
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?
-
Power Apps - Navision
Hello, Anyone know if Microsfot give a free apps to Navision made from power apps? Thanks Regards
-
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);…
-
G/L Entry Reconciliation
G/L Entry Reconciliation This is a G/L Entry Reconciliation functionality, same like 'Apply entry' in other modules G/L entries can be applied to each other to close off to analysis the related/linked entries part amount or Multiple G/L Entries can also be applied i.e. 1 payment for multiple invoices Setup Mark the G/L…
-
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 :)
-
Unable to Run Batch sales Posting (Report 297) using Job Queue
I want to batch post sales invoices for which I am using Report 297. which is working fine if run the report manually. However, when I schedule the report 297 to run through Job queue, it shows successful in the Job queue logs but doesn't post the unposted invoice. NAS scheduler is working for other reports and codeunits…
-
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…
-
Printing a default at the end of a report ?
Hello everyone, I couldn't find a solution anywhere for my issue, so i'm starting to wonder if what i'm looking to do is even possible. I want to print general terms and conditions of sales at the end of my invoice report. Whether the report has 2 or 50 pages, I want to print at the end of it a single page (text + image)…
-
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 :) .