-
Upload Multiple Files from RTC
Recently, I was given task to be able to upload multiple files onto Navision server instance from RTC(2009 R2). I found it to be very interesting because Navision(2009 R2) doesn't provide inbuilt functionality. Had some problems because of 3tier atchitecture. Though I'd share with others in case anyone needed to do the…
-
Drag and drop functionality in NAV/BC
Hi all We have developed a function Drag&Drop on NAV standard fuctionality. You can find the code below: 1. On a page on the field choose attribute Control addin - WebPageViewer 2. This Control addin allows to display websites through the function SetContent. This function could have 2 parameters - HTML Code and Script on…
-
SAVEASPDF on Network Drive
Can you please help me on this I am saving report as pdf on a network drive, we are on citrix with NAV 2016 when I run the code, it works fine but it is not working for other users, I made other users as super user folder is shared with 'everyone' read/write report.saveaspdf return true with no error but file is not…
-
NAV auto report transformation (ART) service. Classic to RDLC. Free usage
Hello NAV community, We would like to present a new NAV Auto Report Transformation (ART) service. It allows the transformation process of old Classic reports to the new RDLC standard. You do not need any installations or specific automations/DLL, or licenses - everything is on the web-site. Just import an OLD report (TXT…
-
Dangers of importing non-trusted .fob files due to Event Subscriptions
The source code at the end of this post is perhaps a light hearted take on a serious issue, albeit one that is probably not well known. After some thought I feel that the wider community being aware of this is better than not letting the cat out of the bag, and any malicious hackers having a zero-day environment to play…
-
Android Mobile Application: HOTFIX ENCLOSED
I've been working with Microsoft Support team (big shoutout to Mohamad Vajid and Duilio Tacconi who got me the fix to try same day) on this one. Since the update for the Android App came out on December 11, version 2.5.19628, all our customers on Android phones are reporting that when ANY pages are open in Edit Mode, the…
-
NAV2017 Running PowerShell scripts from C/AL code
Hi, I would like to export NAV objects using code instead of the Dev Environment tool and i have the cmdlet for this in a .ps1 file. Question: Can i run a powershell script from NAV itself (ex. an Action button) without the need for creating a .net extension library? Any tip appreciated
-
Invalid object name 'XXXX.dbo.company$xxxxx'
Hi, We just ran into an interesting problem with one of our clients, on a Nav 2015 environment. In a newly created company the users received the following error message: The following SQL error was unexpected Invalid object name 'xxx.dbo.company$xxxxx' We spent some time finding the problem and would like to explain what…
-
Invalid user after BC upgrade (configurations not modified) [BC20 to BC24]
Hi all, i had a BC20 OnPrem envinronment with Windows Authentication that used Kerberos. I upgraded it to BC24 keeping the same configurations (also for Kerberos) but now i cannot sign in to the web client because BC tell me that my user is an invalid user. I am sure that the upgrade was succesfull because if i change the…
-
Changes to record cannot be saved because some information on the page is not up-to-date
Hello, In the "Item Variants" page we have a customized field "Packsation" - "Packtisch". By validating or changing this field, the new value should also be updated on the "Packstation" field on the "Sales Line" table. The error occurs in the Item Variants page and not in the Sales Order Subform page Therefore, I have this…
-
Reporting/tracking data Storage Capacity Usage
Hello, I have had a few Business Central clients report that they have checked their data Storage Capacity Usage in their admin center and discover that they are over capacity, which they had not anticipated. There are data retention tools and procedures, which we have helped these clients with, but as far as I am aware,…
-
Error the current permissions prevented the action
Hello everyone, I have created an extension for exported some data with reports. But i have an error when i scheduled my report with a job queue entry. This error is : "Sorry, the current permissions prevented the action (CodeUnit ****** Execute)" This job queue use my user session. I created a permissionset object with…
-
Business Central G/L Budget Export
I have a financial year with differing period lengths, having created the budget I need to export in period order but cannot see away of exporting in Accounting Period Age Buckets ?. Thanks
-
Business central standard application/system app code to protect a pdf-file with a password
Hello everyone, is there maybe a way to protect a pdf-file with a password in the business central application/system app? Or would be the only ways to implement this with azure functions or a control-addin? Best regards and thank you very much in advance
-
Setting password on pdf file OnCloud
Hey! I would like to set a password on pdf file (or just it's stream representation) in cloud ready solution; that means I don't want to use a DotNet. Ideally no Azure Functions either. Just a pure AL - is it even possible? Have any of you encountered such issue?
-
BC 18.7 - NavBaseException constructor was used without privacy classification
Hi all.. i am using bc on prem version 18.7 w1 after i restore the database from server, i got this error message any idea ?
-
Records, RecordIDs, and RecordRefs OH MY!
Arg. Ok, I grew up on MS C/Side documentation examples like: Sally works in finance, and likes cats. Not all cats, just fluffy ones. Sally wants to know how often a customer has ordered a particular item. So she asks Todd in I.T., but he' been unable to overcome his breakup with Sally and is off sick from severe allergy…
-
RDLC group by - add rows dynamically
Hi All, I am changing standard report 111 - "Customer - Top 10 List" where I need to insert the customer contacts (Customer A has 3 contacts); those 3 contacts have to be displayed as the subset of second row (fields: [No_Customer], [No_Customer], [SalesLCY_Customer], [BalanceLCY_Customer]). I have inserted a group by…
-
Dynamics BC Data Upgrade Nightmare rant
Hi, Have anyone tried to successfully upgrade data from a custom BC14 solution on C/AL to BC 18 on prem before? I find the experience very confusing. I am stuck at : https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-to-microsoft-base-app-v18#task-14-synchronize-final-extensions While…
-
Breaking change in Item Cross Reference BC18
Microsoft is going to replace the Item Cross Reference functionality with item Reference. https://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave2/smb/dynamics365-business-central/write-longer-item-references Microsoft has created a migration feature for this The breaking change consists of that it migrates…
-
API / ODATA BATCH PATCH requests with decimal values
Hi all, I have an ongoing project where an external system is using custom API's to update jobs in our Business Central (Onprem, 16) system. Everything has been going fine until we start trying to use a combination of batching and numbers with decimal values in them. Send a single non-batched request with decimals -…
-
Business Central - purchase line - update shortcut/global dimensions
Good day, I am looking for a hint on how to update shortcut dimension codes on a purchase line, after an update to line dimension values. Here is the code I use to update the purchase line dimensions with values from external system: procedure AssignLineDimension(DocumentType: Integer; DocumentNumber: Code[20]; LineNo:…
-
Updating Excel without losing formatting
Excel Buffer provides a functionality to update worksheet - but the trick is: it is forcing new cell Decorator during update - function WriteCellValue looks like this: [External] WriteCellValue(ExcelBuffer : Record "Excel Buffer Advanced")
WITH ExcelBuffer DO BEGIN GetCellDecorator(ExcelBuffer, Decorator); CellTextValue :=…
-
How to colorize lines in the report?
I have the report "Employee - Vendor" connection and I need to mark lines where "Employee Name" <> "Vendor Name" by another color. Does anybody know how I can do it? May be it can be done by report layout?
-
Authenticating against Web Services on Docker
Hi, We're building local Docker Development Environments for NAV2016 development (Using standard NavContainerHelper functions). I'm trying to call a NAV web service using a couple of different web service testing tools (Postman and SOAPUI). In either case, I'm getting an authentication error: HTTP/1.1 401 Unauthorized…
-
BC 15 webclient how to overview Report Dataset
When we had the RTC client we could get the Dataset for the report from Print Preview page -> About this report Who knows how to get the Report Dataset on Webclient when we don't have RTC anymore?
-
Multitenancy PowerShell Script not working
hi, we have this scenario: 1. Separate SQL and NAV Servers 2. Multitenancy enabled - trying to move companies from a single tenant to multiple tenants 3. SQL Server 2017 - SQL Server Management Studio 18 I'm working on the NAV Server, where I am importing the NAVMultitenancySamples.psm1 and running the…
-
Dashboard for job queue entries from different clients
Good morning together, we use several different clients in NAV 2016. In each client, there are job queue entries. I look forward to monitor all of these entries. What possibilities are there to monitor the entries for errors etc.? Maybe there is also a possibility that you will be notified in case of errors. I look forward…
-
Q for a heavily customized system that will be redesigned: Customers can buy and sell back to us.
Hello. We have a heavily customized solution that allows our customer to buy and sell within the same transaction. This customization is done due to nature of the business. Now there is a new project for NAV upgrade to ver. 2019 and I am trying to figure out with our dev team how we can utilize the base product to the max…
-
D365BC App Source Object ID Requirements
Hi, In the link --> https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-checklist-submission This details out the checklist for app source validation submission. But I do not see any mention of object id's reservation. What am I missing here? If 2 (or more) partners submit app source…