-
Adding Excel option to report
In report 10019 GLRegister report, when you go to print it has the option to Print to Microsoft Excel. We have a custom report that we built and when we select Print, we do NOT have that option... its missing. Was using that report as reference as it shows the button... Where or how do we add that button?
-
Open Invoice Integration
Hi, has anyone done any API integrations to the Open Invoice Platform from BC140? We use BOOMI to handle messages but was looking for a leg up on the invoice export process if anyone has done an implementation.
-
BC AL: It is not possible to add a breakpoint at line number
Hi, We created a Business Central Extension that we can debug locally, i.e. in the development environment. In the live environment we run into an issue that we want to debug, however we are unable to do so. We receive the followin error: Error: It is not possible to add a breakpoint at line number 445 in application…
-
Securing a Published App
Just wondering, what the steps we must follow to secure our published apps, so code cannot be seen or copied. I know only 1 place which is on app.json "resourceExposurePolicy": { "allowDebugging": false, "allowDownloadingSource": false, "includeSourceInSymbolFile": false } is there any other thing, we must do before…
-
Keyboard and Accessability
Hi All, Got a user who is very heavy on keyboard shortcuts due to not being able to use a mouse. Set up keyboard commands for various actions, however does anyone know of an action to jump from the "header" to the "lines" on a document. For example, if cursor is in the "No." field on a Purchase Order, in order to get to…
-
Error: Unable to compare operands of type 'NavInteger' with 'Boolean'.
Hi i'm still new to BC and i'm running into this error while executing the Send Method of the HttpClient ( Same error occurs when using the Get Method directly ). I have no idea why i'm getting the error since i can't see the line of code in said method that's causing it. Also the same URI + Authorization works perfectly…
-
Cloud Migration: Permissions
I have completed an upgrade from BC14 to Business Central Cloud V20. The Cloud Migration Setup has completed but as stated in the guide, permissions are not carried across. As it stands my permissions have only "Intelligent Cloud". What am I meant to do to get the permission sets back in the system. Thank you. Ignore:…
-
Running Multiple Reports in BC
I am currently upgrading a customer from old NAV to BC SaaS. 2 or 3 times a year they send out renewal documents to a few hundred customers. Each "pack" has 3 reports. We currently have a batch that prints them as report 1, report2, report 3, for each customer as separate prints. This makes it easy to collate the…
-
Copy NAV webservice in SOAP UI give Premature end of file error
Hi, When I copy to URL from the webservices page in NAV in SOAP UI, I get the error Premature end of file. If I copy it into the browser I see the wsdl, so that works correctly. What is the problem with SOAP UI? Best regards, Maurice
-
SQLDataReader call not returning any records (works if using SQLCommand.ExecuteNonQuery)
Hello, I've got a SQL Stored Procedure that is called using one input parameter (sales order no.) and two output parameters (one text and one decimal field). If I call the SQLCommand.ExecuteNonQuery and retrive the 2 output parameters, it works. However when I translate this to a SQLCommand.ExecuteReader call, the…
-
RapoidStart create duplicate entries
Hello, I have googled far and wide and can't find an answer to this problem ... I use file FORECASTUpload4Test(2bleentries).xlsx to upload some forecast data in that table 1 row gets uploaded but 2 get applied (And inserted) - see resulting data (I extracted the data using RapidStart) files available here:…
-
use of kingswaysoft as ETL for integration between BC/NAV and CRM
Hi experts!! does anyone use this SSIS tool for integration between these platforms? I have a query about it I need to send the value of the company that I have in the connection to a variable but I can't find it among the system variables thanks for advance.
-
XMLPort requestpage visibility before .run
Hi All, This is something I think I've done in the past dozens of times but, it doesnt seem to work or I can't find the event. If you want to pass a parameter to condition the visivility of certain fields in a requestpage, it seems like there isn't a trigger for this example: Clear(X50026);
X50026.SetDocType("Document…
-
NAV 2016/2017 with ADFS (SSO)
Hi, Please let me know the document to follow for integrating Nav 2016/2017 with ADFS 4.0? we want to log users with UPN (User principle name), which is possible with sso configuration.
-
instream error when word download
Hello, I have functionality which in old NAV I could export word and open it with the following code Table1.SETRANGE("Mark for Printing", TRUE); Table1.SETRANGE("SayYes", FALSE); IF Table1.FIND('-') THEN REPEAT _servertempFileName := _FileMgt.ServerTempFileName('DOCX'); _clienttempFileName :=…
-
Automate C/AL to AL upgrades
Simplanova invites Dynamics Partners to join our webinar introducing a unique proposition for NAV to BC code upgrade automation – SALT (Simplanova AL Tools). Webinar Date and Time: Wednesday, 11th of May, 2022, 04:00 PM CEST (Central European Summer Time). Register now:…
-
Dynamics NAV 2016/2017 + problem to login UPN (Email ID) with ADFS integrated setup
Hi, I am testing Dynamics NAV 2016/2017 to integrate with ADFS (4.0 on Windows server 2019) to login users with UPN (Email ID). I followed this article: https://docs.microsoft.com/en-us/dynamics-nav/authenticating-users-with-active-directory-federation-service-2017 1. Created SAML 1.0 & JWT tokens in Claim Issuance Policy.…
-
Underscore character in the API page (extension)
Dear all, I need to create an API page with some fields with the underscore character (like "_id", etc.). When publishing the extension I'm getting compiler Error AL0528: "The name of field controls in pages of the type API must be alphanumeric." As a result, I can't publish my extension. In my case the sender can not…
-
OAuth2.0 Redirect URL for Field Service
Hello everyone, We have a Business Central On-Premise version connected with Field Service web. The basic authorization was depreciated and we are trying to configure the connection with Dataverse, but we are having issues with the Redirect URL for Field Service. Does someone know the correct generic Redirect URL? Do you…
-
Display Guid on Page and Report in AL
Business Central SAAS Hi hope someone can help, I have added the SystemModifiedBy field to a page and it returns the GUID of the user. Is there a way I can change the value returned so that it shows the user value as it seems to show it if I hover over the returned GUID on the page. field(SystemModifiedBy;…
-
Subscribe on a custom API?
Hello! I'm trying to subsribe on a custom API that was created for the customer, but I can't get it to work for some reason. For subscribing on a resource I post to this URL https://{{baseurl}}/v2.0/{{tenant}}/{{environment}}/api/v2.0/subscriptions with the body { "notificationUrl":…
-
Calculate derogatory depreciation quarterly instead of yearly ?
Hello everyone, One of our client wants to calculate his derogatory depreciations quarterly instead of yearly, but the calculation doesn't seem to work. To be a bit more specific, i have here an example with a linear depreciation calculated over 15 years and a derogatory depreciation calculated over 10. As long as i use…
-
Cycle Count Calc Qty
Dear All I am trying to assess the accuracy of our inventory obtained during Cycle Counts. I am able to pick up the adjustments made to Items using the Ledger Entry Table but I need to know the Calc Qty (expected bin qty) to enable me to determine % errors. Is the Calc qty at the time of the Cycle Count held anywhere.…
-
BC Excel Buffer Import - Capture Worksheet name for error handling
Hi All I have created an excel buffer import to a new table in BC. All works except when users do not use the specified worksheet name, the system throws an error which is not end user friendly. Is there a way to capture the worksheet name and compare it against the predefined name in codeunit, then show a custom error. I…
-
What’s new in Dynamics 365 BC version 2022 Wave 1 (April)
As the new version of Dynamics 365 Business Central is coming, 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 version 2022 Wave 1.…
-
Working with Data Exch. Definition in SaaS
Hello everyone, I was wondering if Data Exch. Definition is working correctly in SaaS version of BC? I am planning to implement a global integration system for BC SaaS and I want to use Data Exch. Definition as a part of it for importing/exporting XML,CSV etc. since its pretty convenient. But when I check the standard…
-
ExtendedDataType -> call custom application
Hi all, system: NAV2013 R2 OS: Windows 10 Pro I would like to set the custom application that is being executed/called as user clicks on field "Phone No." on page "Contact Card", but I do not know how the call to execute default application is being called. I have done this: 1. CallToFromNav -> inserted the new default app…
-
Business Central - Warehouse Shipments / Filtering Sales Orders
Good Day, We are moving to Business Central and are struggling with what we believe should be a simple concept and we have yet to come up with a solution for this issue, nor has our developer. Within BC, we will need to pick and ship many sales orders at one time. We thought this would be simple, creating a Warehouse…
-
VAT Statement Line - Column amount calculation
Hello to everyone, I don't know where to post this thread, because I am new on forum, and I am posted here. I used Business Central, and added two new fields on VAT Entry table: TOTAL = Base + Amount, TOTAL UNREALIZED = Unrealized Amount + Unrealized Base, and on VAT Statement table field "Amount Type" (Enum) I aded two…
-
Excel Nav Add-in exciting sheets on new server
We are in test phase of moving a NAV 2017 to a new server. We are going from on prem AD to Azure ad. Customer has like 50 sheets with various BI like reporting made with the Excel Nav Add-in. We have the add-in on working new server. But the old sheets does not work. Is there any way of making the old sheets working?