-
Variable value passed to report is not being printed
So I'm trying to display my variable value in my report. But it prints in the message "Numerario" but in the report is not showing anything.. OnPreDataItem() PaymentMethodCode:=CustLedgEntry2."Payment Method Code"; PaymentMethod.GET(PaymentMethodCode); PaymentMethodDescription:=PaymentMethod.Description;…
-
Display a number with its superscript in a report-Nav 2016
I am looking for an option in Nav 2016 to display a number with its superscript in the report. I tried many options but none of them worked. It seems like there is no in-built option available. Please advise with any workaround.
-
How to add the custom field in the standard workflows
How can I add a custom field to a base workflow in Business Central?
-
Unexpected error when trying to open a custom list page.
We have designed a custom list page in of our extensions. When we try to open this page we get the following error, I have tried to debug this error but the debugging session does not stop at the spot where the error happens, I presume cause the error is called in a protected system object. All I know is it happens after…
-
VS Code debugger in wrong place on standard code - BC v23
When debugging, I go through several functions of bespoke code and everything works fine. Stepping into, over and out all fine, but when I get to here and step into the standard Sales Header table code, it brings me here I believe it is debugging the correct lines in the background, it's just not taking the Namespace ___…
-
Dynamics 365 Business Central
pageextension 50010 PostedPurchaseinvoice extends "Posted Purchase Invoices" { actions { addafter("&Invoice") { action("Create Purchase Order") { ApplicationArea = All; Image = Invoice; ToolTip = 'Create Purchase order'; Promoted = true; PromotedCategory = Process; trigger OnAction() var PurchInvHeader: Record "Purch. Inv.…
-
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.…