-
[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…
-
Server License Expired even though License is not expired
Hey there! On of our systems we have multiple NAV Versions installed. When trying to open the DEV Env. for 2013 we get a warning saying "Your program license has expired". The unusual thing is that the Dev. Env. doesn't open at all, just the warning and then it's gone. We uploaded the license manually via the AdminTool…
-
current user as the type of email account configuration
Hello all , i am using BC 21 on premise, office365 as email plateforme i want to configure current user as the type of email account option. the problem is that BC point always to port 48900 which i did not configure. as http://mycomputername:48900/BC210/OAuthLanding.htm i have already set up the The redirect URI which i…
-
Current User Email not retrieved correctly.
Hello all, Just wondering if someone could help me with the following issue. Environment details BC22 OnPremise Version: W1 22.1 (Platform 22.0.56191.0 + Application 22.1.55890.56216) Two services, one using NavUserPassword and another AccessControlService The Problem When I update the "Authentication Email" on the User…
-
Developing Custom Approval Workflow?
I want to develop a custom approval workflow on creation of Resource record in the system. When a user inserts a new Resource in Business Central, it should be first approved by the approver, before it can be used anywhere. Any help in this regard will be highly appreciated.
-
Rendering Output failed for Report in RTC
Hi guys, When running a report in Classic, it works fine for both small and large amount of data. But when running the same report in RTC,it works fine only for a small amount of data. For large amount of data,when previewing,only captions are displayed with no values.When printing the following error message is displayed…
-
Remove-NAVServerUserPermissionSet error "No Access Control in filter"
Hello, We are using Business Central 230. In Powershell (run as Administrator) I use "Remove-NAVServerUserPermissionSet $MiddleTier -PermissionSetId "<name of the permissionset>" -UserName $LogonAccount -Force". When the permission set is super, I see no errors and super is removed from the user. But when I use a different…
-
Job Queue - "The current permissions prevented the Action (Codeunit ... Exceute)
Hey there! We created a job queue that executes a Codeunit in one of our extensions. We created a permissionset that includes the Codeunit with "X" permissions. Permissionset is assigned to the user. When we execute the Job Queue manually everything is working as expected. However, if the Job Queue runs automatically…
-
SMTP test error
Hi, Im not too tech savy so would appreciate if the anwear is in a "beginner level". Im trying to set up the SMTP Mail Setup settings for a customer in NAV 2017. When I try to send as myself, to myself the test goes through. But when I try to send to another mail I get the following error. I have tryed to enter another…
-
LSCIN Tax Transaction Value V2 data send Issue
In LS Central, I am enabled DD Send Transaction to push transaction from Store database to HO database, transactional data are pushed to HO except table LSCIN Tax Transaction Value V2 data.
-
Price includes VAT by default on Item Card?
Is there any easy way to make the system to assume and set "Price includes VAT" to true whenever an item is created? I tried subscribe to "OnAfterOnInsert" from Item table and make it to true. But it throws an error the VAT Prod. Posting group field not populated yet.
-
How to create Agenda Outlook Stile?
Good morning everyone, a client asked us to create an outlook-style appointment diary for him on BC21 (onprem). Currently our vertical (they are all customized tables) shows them in "matrix" style format, while the customer would practically like to see the agendas of the individual resources (even all together) with the…
-
How to lock columns in NAV 2018 using excel Buffer
I need to lock (protect) all columns except one. In Classic, the automation routines used, have protect and lock. In NAV 2018, the dotnet routines used do not seem to have these functions. Name DataType Subtype Length XlWrkSht DotNet Microsoft.Office.Interop.Excel.Worksheet.'Microsoft.Office.Interop.Excel,…
-
How to Merge cells in Excel while extracting report from navision using Excel Buffer...
How to Merge cells in Excel while extracting report from navision using Excel Buffer... I am using navision 2016 . i have tried this https://forum.mibuso.com/discussion/70593/how-to-merge-excel-cell-when-exporting-excel-buffer-nav-2016... but i didnt get solution...... please do needfull
-
Unable to select layout! Cannot build the page 9660, the metadata object was not found.
Hello all. I ran across a very weird problem that was bugging me, and after finding the solution I wanted to share it with everyone, it may help someone else. On production environment, client was unable to "select layout", whether from the "report layout selection" page, or by running the report directly and choosing…
-
Record IsTemporary useage and documentation
Hi Guys I see often when writing event-based code units something like: if Rec isTemporary then exit else begin end Is there any good resources that explain temporary records in BC and how and when they are used. ideally I want to create a test where the record is temporary and my codeunit or function exist to test. Some…
-
Batch job/job ques takes different time in BC
Hi, We are at a performance testing stage with a customer. We have an isolated on prem environment (BC22). We are testing batch jobs. We are running identical tests with the same amount of data, and the same code. But the time the jobs takes, differs from 2 hours to 6 hours. BC runs on a Azure platform with and Business…
-
Error the current permissions prevented the action
Hello everyone, I have created an extension for exported some data with reports. But i have an error when i scheduled my report with a job queue entry. This error is : "Sorry, the current permissions prevented the action (CodeUnit ****** Execute)" This job queue use my user session. I created a permissionset object with…