-
Join the webinar: "Upgrade to SaaS: Overcoming file management Limitations"
Upgrade to SaaS: Overcoming file management Limitations Webinar Date and Time: Thursday, 17th of February, 2022, 04:00 PM CEST (Central European Summer Time). REGISTER HERE: The following topics will be explored during the online webinar: • Universal Code Initiative • The limitations of Business Centrals' cloud environment…
-
Technical Guidelines: Code Analysis Tools (CodeCop, UICop, AppSourceCop, PerTenantExtensionCop)
I would like to share a useful blog post for developers about Code Analysis tools: CodeCop, UICop, AppSourceCop, PerTenantExtensionCop. You will find here some tips on how to make your solution more readable and clean as well as some tricks on how to modify some rules, make them more or less important, and in such a way…
-
Use subpage in Report Request Page for Dynamic Request Fields
Hello, i require to have a Request Page with a dynamics number of ASKED FIELDS to the user. So my idea is to use a REQUEST PAGE with a SUBPAGE LIST done by Key / Value. To do that i'm using a Temp Record of a Table that i want to automatically FILL when the request page is loaded (base on a table with all DEFAULT VALUES),…
-
How to Create SQL Query for this scenario ?
I want to Purchase date against posted sales invoice item. Let me explain in brief. 1> First I am open "Posted Sales Invoice" Table & take one Invoice. 2> now open this invoice and from line you have to select one item & navigate to "ILE". 3> now the task is to find purchase date of particular item for this item. Problem…
-
Calculate distance from post codes
Hi, I need to know how to calculate a distance between two postal codes (location table and sales shipment header-ShiptoCity) and know the distance and put it in a field of a custom table. How can I do? In case if I were to use a webservice, how do I implement it on nav? For nav 2018 Thanks so much
-
Dynamics 365 Business Central Email and Email Message
If you are interested, how to use the functionality of Dynamics 365 Business Central for sending emails, check Simplanova's latest blog post in which our developer Raimund reviews specific settings that enable additional functionality, such as adding attachments and recipients in a letter. Have a read here:…
-
Guidelines for Partners: GIT with VS Code
In previous technical blog posts, we wrote about managing AL code with Git and VS Code. Within them, we recommended a tool called GitExtensions, for performing most Git actions. Since then, the amount of Git features and their availability has increased within VS Code. It is possible to perform most of Git actions without…
-
RDL or RDLC for Business Central development?
Hello all, Which type of file is recommended if you have to create an RDLC layout for a report or report extension in Business Central? RDLC or RDL? Or perhaps it does not matter? I prefer RDLC because I can use Visual Studio for faster development and a better experience, also standard reports use .rdlc files. But if you…
-
Pretty Printing a Json Blob for a Message in BC SaaS
Built this code for BC SaaS, since we cannot use any DotNet tools, and was getting tired of saving the output and putting it in a Formatting tool to make sense of the one long string.. It's not perfect, but makes stuff readable. Feel free to post a suggestion. codeunit 50000 "Json Library"
{ procedure…
-
Printing Blob Field
I have pasted this text from Word Document to a NAV Blob Field: ~!@#$%^&*() ‘something’ “something more” end And printed this blob fields through a NAV report as pdf, it looks like this: It could not decode the Left Single Quotation, Right Single Quotation, Left Double Quotation, Right Double Quotation when printing. This…
-
Print Item.No in barcode font that scans
Trying to use the 3 of 9 barcode font on a label, '*' + Item."No." + '*', barcode generates, prints, but does not scan using a barcode scanner aredmond@thompsonpump.com
-
BC17 - OnOpenPage code executes before page is shown - How to avoid?
Hello All, I have an http call (OnOpenPage trigger) and based on the result, fields on a card page are populated. When I open the page, the browser cursor (mouse pointer) goes into loading, the existing page becomes unresponsive 'Working on it' message is displayed. After 10+ seconds the card page is opened. I moved the…
-
Insert Templates via Web service - BC15
Hello, I m on BC15 and I tried to published the Template Web service to insert Item templates directly with an ETL (Scribe). An error message appears when I try to use the ETL (see attached file), do you have any suggestion? Thanks
-
What’s new in Dynamics 365 BC version 19
As the new version of Dynamics 365, Business Central is coming on the 1st of October, Simplanova is organizing the webinar with Microsoft MVP for Business Applications – Stefano Demiliani, and encourage you to attend. During the webinar, you will hear detailed information, about What’s new in Dynamics 365 Business Central…
-
Got Error A call to System.__ComObject.Open failed with this message: The type of one or more argume
Hello guys! Have a problem with one point: BC18CU3 using this dll dotnet file function - got the error on "Open" method error Maybe You have some ideas, I used docs.microsoft.com and other forums but nothing helped I also tried to change some parameters in this function but it still error
-
NAV pictures in BLOB fields
hello guys, im new in business central. im looking for a way to make the image in the attachment bigger when i click on it. how can you do that? the image is stored in a field called picture which has a type BLOB and subtype BITMAP
-
Tips & tricks: How to handle limitations during the process (Automations, File Management, .NET, etc
Simplanova invites Dynamics partners to join the webinar: Upgrade to extensions: limitations and workarounds Webinar Date and Time: Thursday, 9th of September, 2021, 04:00 PM CEST (Central European Summer Time). Register HERE. The session will explore the most popular limitations and refactoring cases developers face when…
-
Dynamics 365 Business Central 2021 Wave 2: what to expect
The new release of Dynamics 365 Business Central 2021 Wave 2 is coming out this October. In the new blog post, Stefano Demiliani summarizes all the upcoming new features planned for the launch date and the next months after the launch. If you are interested in what to expect from this new major product release, have a read…
-
Cannot create an instance of the following .NET...Microsoft.Office.Interop.Excel Version=15.0.0.0
I have to use an excel file as a template, compile it and return it to the user. With previous versions (BC14) I took advantage of "Microsoft.Office.Interop.Excel.dll". With the BC 17 version, running the same report, I get this error: "Cannot create an instance of the following .NET Framework object: assembly…
-
in case "if Page.Runmodal(...) = Action::Lookup then" doesn't show an ok-button
It is caused if you run a page from the launch.json. If you then run another object that uses the above code, it will never show the OK-button. If you then CLOSE the page that was opened on publish and reopen it again in the session, then the OK-button will appear It seems that launch.json runs a page as RUNMODAL which…
-
LS RETAIL JOB NOT RUNNING AUTOMATICALY
IF YOU HAVE CONFIGURED JOBS AND THAT NOT RUNNING AUTO THEN check codeunit 99001469 (in job que set interval in 1min) and compile and run codeunit99001468
-
How change sql database in BC Container?
Hello. I have BC18 Container that use standard CRONUS database. I restored one more database. And now how can I change from CRONUS to new one?
-
File Name with Special Character ~ changed
I am trying to do download file using downloadstream. var
FileName: Text
InS: InStream;
begin
FileName := '01~Jan~2021.txt';
DownloadFromStream(InS, '', '', '', FileName);
end; When the file is downloaded the file name is changed. All ~ is changed to _. In above example downloaded file name will be 01_Jan_2021.txt How to…
-
Using OpenFileDialog to select multiple files (Multiselect)
I couldn't find a solution for this here on Mibuso, so now that I have one I wanted to share. As some may know, the problem with multiselect is that Dialog.FileName then only returns the path as it's actually a <NULL> separated list and NAV can't handle the <NULL> (considers it to be the end of the string). However there…
-
Could not download reference symbols BC Saas 17.5
Hi All, We purchased BC SaaS version 17.5.22499.22680 and I would like to start with development. Is it possible to do development on our Sandbox environment, not on some demo Sandbox that I got from Microsoft? I have installed Visual Studio Code and and AL Language extension, and when I would like to download reference…
-
How to get container for BC16.7
Hi All We are on prem with BC2020 Wave 1 and CU's installed (Update 16.7 for Microsoft Dynamics 365 Business Central 2020 Release Wave 1 (Application Build 16.7.18411, Platform Build 16.0.18359)) Help says we are on "Version: NA Business Central 16.7 (Platform 16.0.18359.0 + Application 16.7.18411.0)" I want to download a…
-
How to sent notification in business central?
Is there a way to send a notification to a user when his scheduled report finish? My purpose is to send a dynamic notification to the user who scheduled a report in wherever page he is. How this notification bar works? Can this be used to diplay a counter and different notifications? I know the existance of the…
-
Join the webinar👉 What's new in Dynamics 365 Business Central version 18
Join the online webinar on What's new in Dynamics 365 Business Central version 18. The following topics will be explored during the online webinar: - What’s new for administrators - What’s new for the client and the application - What’s new for developers - Q&A session Webinar Date and Time: Wednesday, 7th of April, 2021,…
-
Item card field visibility
Hi NAV Experts, Sorry for some basic questions. There is a field for example "Replenishment Type" on the Item card and it is not hidden. One user is able to view the field on the item card, But another user is not able to view the field. I have tried to customize the fast tab and check if the field is not selected. The…
-
Using DotNet var on Business Central
Hi all, Anyone knows how to use DotNet variable on AL Code and Business Central (Saas for the client). I'm trying a code to merge 2 pdf files but can't found a solution how to use a var dotNet type