-
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…
-
[solved] How to set different SQL SERVER instance on Dynamics Nav 2018 client
Hello, I had to create an additional instance of SQL SERVER. I can set that instance in development by defining Database Server to SRVNAV\MSSQLSERVER01 and Server Instance as link/dynamicsnav110. And it seems to set fine in dev environment. BUT when I try to open some page, i get data from old instance, and I not sure how…
-
Changes in execution time for recurrent job queue entry
Hello I created a codeunit with one only code : sleep(180000) meaning the execution time will be 3 minutes I published on BC Version: FR Business Central 19.2 (Platform 19.0.32956.36014 + Application 19.2.32968.33612) Then I created a JobQueue Entry for this Codeunit, with "Recurring Job" checked (every day) and "Starting…
-
Report Page Header Not Printing in Every Page?
Hi experts, I have an issue with a report in RTC. When the data in the report is limited to 1 page everything goes fine but when the data in the report exceed one page, the page header dosen't get printed in the next page. Is there any way to resolve the same. Thanks in advance.
-
RDLC Report
How to set the number of lines coming in a report to 8 in RDLC layout? Thanks in advance.
-
Cannot start NAV2018 NAS service on Windows 11 23H2
Some computers that run latest version of windows 11 can't run NAS service anymore. The same settings work on other windows 11 based machines but some don't and I can't figure why. The error appears right at the start of this year on some machines that run build 22631.2861 of windows 11. Tried removing the latest update…
-
Scheduled Reports crash Job Queue (BC14 on Prem)
Hello, I have a problem with BC14 on Prem and scheduling Reports. Scheduling reports via the task queue works in principle. However, there are always problems when the reports processes large amounts of data and produce many pages. For example, we have an invoice journal that lists all posted invoice headers with invoice…
-
Export data from two or more tables to Excel
Hi everyone, In Dynamics NAV 2015, I need to export information from two tables (e.g Vendor or Customer) to Excel, but depending on the checkbox checked, I must show the information from one or the other table, or both. Is it possible to do this through a report? How can I define both tables in the DataItem? Or is it…
-
Apply documents in two different currencies with changed Exchange rate
Hi, I have such issue - at posting date invoice is equal 14 800,00 CHF ( at this day it's 14 523,78 USD agreed with customer to pay in two months). My LCY is GBP, and two months later currency has changed by 3%, so I have now difference in LCY valuation between those two documents by 381,99. I've tried to simply just Apply…
-
[SOLVED] BC - Charge Item from Purchase Document to Sales Document
Scenario: I have a sales order with one line Quantity 1 Price 1000 € The sales order is delivered and invoiced. Now I create a purchase invoice with a charge line of €100 and charge this to the sales shipment. When I post the purchase invoice, I receive a g/l entry of €50. But the corresponding value item is negative.…
-
Upgrade/conversion from WW to NA
Hi all, I have someone who is a US subsidiary of a Spanish company. Currently, they are on NAV2016 and just a separate company within that database. There are some unique business requirements for the US company - Sales Tax, for one - they have been "adapting" the VAT feature in the WW version but it's not optimal. The…
-
RDLC Layout issue
Hi, PFA . I need to remove this space from this report? Is there any solution? The space is coming in between the detailed row and footer.
-
how to remove caption of a cardpage?
Datacaptionfield property in table in empty...the card page caption is coming as the key of that table.. I wanna remove that caption . Thanks in advance.
-
Compare JSON-Objects
Hi folks, how do I compare the equality of two JSON objects during runtime without breaking out into the .net world? I'd like to have something like this: if MyJsonObject1.Equals(MyJsonObject2) then ... A workaround could be converting both to text, removing all whitespaces, probably lowercasing everything and then compare…
-
How to calculate new Migration Incentives and Assessment Report program
Simplanova invites Dynamics Partners to join the webinar "AIM with Simplanova Program Updates: how to calculate new Migration Incentives and Assessment Report program FAQs". As a Microsoft Modernization Center, Simplanova will help you navigate through the programs. Webinar topics: 1. AIM Deployment Offer program has been…