-
Ready for BC v24? Manage all updates in one place
Simplanova invites Dynamics Partners to join the webinar "Ready for BC v24? Manage all updates in one place with Partner Admin Center" Webinar Date and Time: Thursday, 14th of March, 2024, 04:00 PM CEST (Central European Summer Time). Webinar duration: 30 mins Register now HERE. Session description: Simplanova presents…
-
Login status does not work correctly
Something is off with my login status. Right now, I am logged in when I am on page 2 and higher on "Recent Discussions" but not if I am on the first page with URL https://forum.mibuso.com/discussions. I see, however, the same content using the manually entered URL https://forum.mibuso.com/discussions/p1 , but with this URL…
-
Copyfilter from multiple filtergroups
Hi there, I have a form that displays sales lines. A filter is set on a couple of fields on opening the form. These filters may not be removed, so they are set in filtergroup 0. The user is allowed to further refine the view by setting more filters (in filtergroup 2). In a function in the sales line table, I want to define…
-
Using Control-AddIn WebPageViewer in NAV 2016
Hello all, got a Problem with a Control-AddIn that has me rather baffled. In NAV 2017 you have a new one called WebPageViewer. NAV uses this to give you a preview show (in page 9700, Email Dialog) of the email body if you defined a word document to be a Body for a report. When selected in NAV 2017 the AddIn created 4…
-
Find the specific "Sales Price" the used to validate "Unit Price" on Sales Order Lines
Hi! This is in Business Central cloud. I'm looking for a way to find the specific "Sales Price" the system fetches to determine the "Unit Price" when validating the "No." field on Sales Lines for orders. I have a custom field on the "Sales Price" table that needs to be transferred from the correct "Sales Price" line to the…
-
Preventative maintenance in Navision
Dear All, I am currently studying service management. In a demoscript service management, in page 16, I read as follows: So, it seems navision can handle preventative maintenance, however in www.wikipedia.org (http://en.wikipedia.org/wiki/Preventative_Maintenance) , I've read as follows: Preventive maintenance (PM) has the…
-
Luhn or Luhn formula - also known as modulus 1 or mod 1.
Hi Friends, Does anyone worked in Luhn algorithm or Luhn formula, also known as the "modulus 10" or "mod 10" algorithm (in Navision)? Luhn algorithm is a simple checksum formula used to validate a variety of identification numbers, such as credit card numbers, barcodes etc., Also see this link:…
-
VS Code unable to connect BC Instance
Hi, The VS Code on my VDI can not connect to the Business Central Instance ( on Server B ) due to below error message. The VS Code and BC Instance are installed in two different machine. I can access BC environment using Web Client on MY VDI but can not connect BC Instance and download the symbols. Configuration of BC…
-
Copy records within Companies
I have a client who needs some tables to not be DataPerCompany. I don't want to change the property because I will have to maintain several databases. Is there any way to insert a record from one company to another when I enter a new record on a Table? For example, I open customer table and I add a new record, and at the…
-
Luhn Algorithm (Modulus 10) in Dynamics NAV C/AL & Business Central code - Creating a check Digit
Hello people, So a client required Luhn algorithm (also known as modulus 10 or mod 10) to be used on their database to create a check digit for a given number and a valid OCR reference for payments. I saw some solutions on this website that did not work so I decided to post a good solution below: For Luhn algorithm, you…
-
LS Retail Trans. Sales Entry Status table
Hi, Can anyone explain to me what the Trans. Sales Entry Status table is used for in LS Retail? I am trying to understand why there would be entries in this table but not in the Trans. Sales Entry table? Thank you.
-
XMLport Import Text Element not clearing itself - still filled on next loop
Hello I got a problem while importing an xml file. Somehow I can't find anyone having the same problem on google ._. So my structure is following MLIST - M - DATA1 - DATA2 I do processing in the M - Import::OnAfterAssignVariable() Now let's assume DATA1 is always filled and DATA2 like every third loop only. So it's filled…
-
XMLDSIG signing XML data with .NET or Bouncy Castle / use higher .NET Framwork version?
Hello :smile: In short my issue: I need to xmldsig my xml data to fulfill some regulations. As NAV 2016 offers .NET System Security 4.0 which has System.Security.Cryptography.Xml.SignedXml Now I need to set the algorithm, but as of 4.0 it only offers those SignatureMethods:…
-
Adding a permission set for a single codeunit in BC?
Hi all, I'm using a BC (SaaS) and I have created a new Codeunit: 6000 "Test" with some subscribers to the Tables: "Sales Line" and "Purchase Line": [EventSubscriber(ObjectType::Table, Database::"Sales Line", 'OnBeforeValidateEvent', 'Quantity', false, false)] local procedure SalesLine_OnBeforeValidateEvent_Quantity(var…
-
Sql Error sync-navtenant error NAV18
I´m upgradaing from Nav 13 to Nav 18, when ´m trying to compile objects I´m getting this error The following SQL error was unexpected:Incorrect syntax near '$7'. In the Event Viewer Message: <ii>El siguiente error SQL no se esperaba: Incorrect syntax near '$7'. Instrucción SQL: DECLARE @StatisticsToDrop NVARCHAR(MAX);…
-
[Solved] Restrict access to table 15 and 17
Hello, Two of our customers have expressed a similar concern: certain employees should be denied access to the accounts and general items. Problem: Employees should still be able to book (orders). If I understand it correctly, full read access (i.e. not just indirect access) must be available. Is there a way to ensure that…
-
G/L entry
Hello, I would like to transfer some customer columns from sale invoice to G/L entry. After posting sale invoice. What event can I record on? (Event Subscriber in business central)
-
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,…
-
Why do AL use record.Copy() instead of temporary tables
Hi All I'm trying to understand Record.copy function in relation to order planning worksheet so I can extended and add other fields. for example below procedure:local procedure InsertSalesLine(var UnplannedDemand: Record "Unplanned Demand") var UnplannedDemand2: Record "Unplanned Demand"; begin with UnplannedDemand do…
-
Track who uninstalled an extension on production environment of Business Central cloud?
One of the extensions from production env was uninstalled, I have checked Change Log Entries and it doesn't keep a log of such events. How can one, find out who installed or uninstalled an extension?
-
Requestpagehandler cannot address variables in report extension requestpage
Hi there, We have created a report extension on "Create Reminders": - added two variables to the request page - added some code to the OnPostReport() trigger For automated testing purposes, I now want to use this report in a test codeunit: fill these two variables from code and then proceed with OK. My expectation was that…
-
Error in Sync-NAVTenant
I am updating a version from NAV2015 to BC22 so I'm performing the first step that upgrades to version BC14. When execute Sync-NAVTenant -ServerInstance DemoInstance system return this error: Sync-NAVTenant : The following SQL error was unexpected: String or binary data would be truncated. The statement has been…
-
Editable field on page in al code
Greetings experts, Forgive me, I’m new to working with pages in al code. I have created a page with two fields. I want to take the input of one field, send it to a method in a codeunit using an action, and show the returned text in another field. I’ve marked the field and the page objecr as editable, but it is not editable…
-
NAVClient hang at splash screen for 20 minutes, then shows connection lost
Hello community, hope you can help me. We opened a new location for our company. The new location should use our NAV 2013 CU58 via NAVUserPassword authentication. At first we gave them a OpenVPN Client and the NavClient runs fine at the new location. Now we established an IPsec Tunnel between our location and the new one.…
-
Permission Sets
When doing a conversion from a previous version to BC14 (in my case from NAV2017 to BC14) there is an issue with Permission Sets that are not base but custom. The custom Permission sets that are converted are defined as type (scope) = System so that they cannot be modified/updated. Is there a way through a pre- or…
-
Can I get Business Central to find the right unit price using the new price calculation v16?
Hi experts, This is in Business Central cloud. I have made my own table with some of the same fields as there is on table "Sales Line". I have fields with "Item No.", Quantity, "Unit Price" etc. I also have a customer number. How do I call the new price calculation v16, so it finds the right unit price for my item?
-
Are customers, not partners allowed to develop in the latest versions of Business Central?
In old Dynamics NAV, they had to buy an Application Developer license for 6000 euros to do that, and yet it was not allowed to modify a Codeunit 80 to for example fill out a field in the invoice. Only the 30 000 euro Solution Developer allowed that. How does that work in Business Central now? Are they still allowed, if…
-
XMLPort import xml with variable tag position
In NAV 2017 I want to import xml file from third party source. Some tags in source file has the same tag in variable positions. For example: Variant 1 <x> ...subtags </x> <invoicee> ... some subtags </invoicee> <y> ...subtags </y> Variant 2 <x> ...subtags </x> <y> ...subtags </y> <invoicee> ... some subtags </invoicee> How…
-
Intermittent sending email on NAV 2016
We're facing an odd issue where emails sent from NAV will not send intermittently. The error is: /The SMTP mail system returned the following error: /Failure sending email/. Authentication failed because the remote party has closed the transport stream./ The email account is an O365 account. This issue started happening…
-
Send to excel function does not open excel
Hello, I have problem when sending data from page to microsoft Excel. When the button is pressed, for few seconds the mouse shows loading icon, but apparently excel never opens. It works on one of the clients computers, and stopped working on other cient computer and also server. I get no error messages, nothing. It just…