-
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?
-
How Lot no tracking works for a component in Work orders?
Sir/Madam, How lot no tracking Works at various stages of Work order process? While creating a work order, whether it is placed in any table...? Also while creating a warehouse Pick (not posted) where it is stored ? Where it is placed in order to check how much quantity is reserved for one component while creating a pick…
-
File Management limitations in SaaS using BlobStorages
One of the major limitations we face when upgrading to Business Central’s SaaS environment is the usage of our local or server’s file system. Quite often, various NAV or BC solutions use the file system to save files for archiving purposes or to be processed later by an automated job. There are multiple methods of…
-
Pegging Report
Is there a way to obtain a 'pegging' report for an item after MRP has been run? Nav 2009
-
BC Custom connector with Oauth2.0. Authentication issues
We created an API connector to a PowerApp which works fine, but after some time (ccouple of hours) an error appears saying that the connection needs to be repaired which makes us relog in with the user for the connector. This is a problem because not all users have the account for the connector. We have tried giving…
-
BAS Calculation Sheet Import sample xml
Does anyone use BAS Calculation sheet or anyone has sample xml file for BAS calculation sheet?
-
Secure life in a Dynamics 365 Business Central tenant by Stefano Demiliani
New hot and really important topic – secure life in a Dynamics 365 Business Central tenant. Read Microsoft MVP for Business Applications Stefano Demiliani article on Simplanova blog: https://simplanova.com/blog/secure-life-in-a-dynamics-365-business-central-tenant/
-
Cycle Count History
Hello All I am looking to assess our daily cycle count accuracy. As such I need to determine how many items / bins from each days count required an adjustment compared to those items / bin locations that did not require any adjustments. My question is how can I determine how many items did not require an adjustment? I am…
-
Can't see serial numbers at invoice screen
Purchased the product, whose serial number we tracked, into stock. We transferred to another location. Then we want to make sales from that location. However, it does not appear among the available serial numbers in the item tracking section of the sales invoice section. When we examine it from Ledger Entry, there is no…
-
Currency Error
There is no problem in cases where there is invoice and then payment, but when the payment and then the invoice are received and these two transactions are applied to each other, that is, when the application is made, there is a problem in the G/L Entry records and the realized loss or gain account line. This problem…
-
Application Errors
I've searched the forum but couldn't find a clear answer, so I'm writing this comment. 'even though “application method” field is set as “apply to oldest” in customer and vendor cards, payment and invoice transactions dont automatically apply to each other.' i am getting error. What could be the source of this problem and…
-
XMLport field delimiter within field delimiter issue
Hi All, Hope some1 can help. I'm doing an xmlport for importing data, however, I've found an issue with field delimiter within field delimiters (FieldDelimiter = '"';): 6864,"Friends Bombas de baño con forma de langosta (2x50g), efervescente y rosa,""Tú eres my langosta""", As you can see this makes it fail (double…
-
Navision MS-Message Queue Bus Adapter error
Greetings to all. I want to make code that will work with MSMQ. I use Nav2009 R2. Communication component (NSComCom2.dll and MSMQBusAdapter.dll) are installed and registered with regsvr32. Then I created private queue "test". Then I wrote simple code in codeunit (SingleInstance = Yes):OnRun()
IF ISCLEAR(ComCom) THEN…
-
Captions get hidden when Converting BC14 TextFiles to new Syntax
Hi everyone, i am currently trying to convert some BC14 Objects to AL Code. I have noticed that on one (out of about 200) Pages the Captions are now hidden. When looking at the Files i saw that, when converting the Exported BC14 Text Files to NewSyntax, "ShowCaption=false" gets added to all fields on the page. Does anyone…
-
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…
-
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 ?
-
How to configure VAT Sales Ledger
Hi everyone, I need to open the VAT Sales Ledger page in Business Central. It seems that I need to do additional configuration because, at the moment, such a page is not available. Could you please guide me on how to access this page? Thank you! Best regards