-
Memory usage on BC on-prem service tiers
Hi, First of all, I don't know if this is the right forum? We have a fairly large installation, with 16 service tiers spread out on 3 servers, and a complete test/development copy. I have three questions. Is there any way to know what causes high memory usage? It seems that in time the service tiers consume almost all…
-
RTC Client: Partially keying No. field and tabbing vs hitting Enter
I have filters that are entered when the Item List page opens so when you manually key in part of the full Item No. on a sales order, it will use those filters and show the results on that inner field page. Here's the issue. When you hit Enter, it will use those filters and return the 1st record found. However, when you…
-
How to add barcode in Navision Reports?
hi all, Can you please tell me how to add barcode to nav reports? thanks, Rajan
-
Error on Data Upgrade from NAV2009 to NAV2015
Hi, I am doing an upgrade from NAV2009 to NAV2015, but on the Data Upgrade, I always get the following error (in german): SessionId : 5124 CodeunitId : 104055 FunctionName : StartUpgrade CompanyName : xxx StartTime : 27.04.2016 16:16:31 Duration : State : FailedPendingResume Error : Fehler bei einem Aufruf von…
-
BC ExternalSql
hello I have connected an external table to my BC. the connections are correct in fact the insert instructions work correctly. The problem is when I go to read the inserted data. I cannot change the field type on the external SQL table. Any ideas? Thanks
-
Xml import question
Hi, is there a way we can import a complex type element in an xmlport? I am getting the error 'the element cannot contain text. Content model is empty'. I'm not sure how to get around this Regards,
-
NAV Regular Expression - Match Transformation
Hi, I notice something peculiar with the NAV Standard RegEx - match found in Page Transformation Rule Card (1238). This NAV standard RegEx Match skips the 1st match result. e.g. I expect to see As match results. But NAV RegEx match skips the 1st match result. When the same Regex expression in tested in: regexr.com/73md2 It…
-
Allowing Pop-Ups when using hyperlink to start software
Hello, I would like to open a PDF-Viewer or other software and I used so far hyperlink, which works fine with NAV2017 With BC I get a message from the brower that I have to allow pop-up messages and I entered http://localhost:8086/BC190/ But the browser (Chrome) still does not allow to start the software. What is wrong or…
-
NAV 2017 Client freeze att random times
We have a very weird issue where one of our customers clients always freezes at random times. This is for the whole company. Main Issue Freezes at random times at all their computers we cant derive this to anything special they do. It happens like 5 times a day 30 sec freezes always, and then the program starts workning…
-
Line Amount Excl. VAT getting calculated wrong!
We have a receiving invoice that was posted. Normally the Items for our lines will pick Direct Unit Cost automatically and we don't let users select it nor do we let them change the Line Amount Excl. VAT. We noticed as attached below that Line Amount Excl. VAT which is 86.40 is not correct. The Quantity * Direct Unit Cost…
-
RDL Error Definition of Report is not valid
Hi, I have this weird error below when trying to modify a rdlc layout and compile a report object. Microsoft Dynamics NAV Development EnvironmentError while validating RDL content: The definition of this report is not valid or supported by this version of Reporting Services. The report definition may have been created with…
-
Why do we need so many table keys in NAV/BC
Hi Guys I have looked at couple of tables to understand the base app allocation of table keys, for example, sales line table contains 19 keys for all possible combinations to retrieve data. Is this the norm when creating your own tables as well? For example I created a table with say DocType, Number, Customer and possible…
-
internet browser is not installed
Hello everyone, I have a problem in NAV 2013. When I click on the icon next to the Home Page field (customer or vendor), I get the message "internet browser is not installed". NAV 2009 works. Do you have an idea? I have already uninstalled and reinstalled IE9. In addition, I made a repair run of NAV 2013. Everything seems…
-
There are any Microsoft Tool in order to convert the database in EUR?
Dear NAV & BC experts, We have a croatian Company. As you know, in January croatian companies have to pass to EUR currency. Dou you know if there are any Microsoft Tool in order to convert the databe in EUR? Thanks in advance.
-
BC API Company reference in url
Dear NAV & BC experts, i have a Businnes Central 14 implementation, i have a problem when referencing API url exposed by BC. I've configured all OData parameter in sertvice configuration (except Company Default Name). When is use, for example, an out-of-the-box API such as payment method, in order to retrive all data i use…
-
My question related when we are adding to new fields from existing table.
Suppose if i was adding a field 'Sno' to customer table it was working fine. But i want to use same field in sales related pages it was not showing through customer pages i mean in linking.
-
Totaalbedrag sales line niet zichtbaar in uitgedraaid report.
De titel is een beetje vaag, dus ik zal het wat beter uitleggen. Ik ben met een opdracht bezig, waarin er in de verkoopfactuur een tabel voor openstaande ongefactureerde artikelen uit de Sales Line moet komen. Mijn opdrachtgever wil een totaalbedrag onder het tabel met de Sales Line artikelen hebben. Ik heb een global…
-
Removing dates from Reservations.
This is an issue I have seen for a few clients, normally a training one, but one particular client really does need reservations to be independent of date. The client is on old 3.10 objects. The issue is that if you are in (say) a sales order and you want to reserve an item, it will only show you purchase orders with and…
-
Heavy query with 2-Abort in profiler
Hi, During a (re)search for a performance issue using the SQL Server Profiler we found (large) query's with an Error '2-Abort'. Sometimes the reads are enormous (>200.000) and a duration of +73000 We see this query every time we open a sale/purchase order (or create a new) but not when we open a sale invoice (same table)…
-
Controlling VSIFT selection in BC
I'm working on tweaking a process in BC18 (On premise). Part of the process uses a Query object that is summing "Warehouse Entry" records. I've isolated the issue to the VSIFT index it uses to calc that sum. The 2 indexes of concern are Key5 and Key8. Both shown below. The process is summing "Qty. (Base)". The query is…
-
Print to ELO with BC
Hi, my customer has an ELO archive to which documents are printed through a printer driver. The Document has special control chararacters, so ELO know what document it is. With NAV 2017 this worked fine, as the printer output is textual based and therefore can be interpreted by ELO. The same print from BC results in a way…
-
Is it possible to check whether the field has autoincrement property or not?
Hi! I'd like to know if there is a way (in AL code) to see whether the Field has AutoIncrement property or not? I've already looked into fieldrefs, Field Table, but nothing useful crossed my mind.. :neutral:
-
Navison 3.53 license
Hi Does any one have Navison 3.53GB license and want to sell it/share for educational purpose?
-
random files on temp folder of service account?
The windows user "service.sql" is only used as a service user of the NAV ( 2017) , and c folder of the server is totally filled because of the produced temp files ( each has size 70 mb, so far total: 213gb ) in temp folder of this account. Please see the attachment . Do you know any reason why NAV produces this temp files,…
-
Guidelines for Partners: The Universal Code Initiative and SaaS related cases
The latest guidelines for partners on the Simplanova blog will explain the Universal Code Initiative, and its goals and will enlighten you about the most popular breaking changes regarding Cloud development. Take your time and have a read here:…
-
Mail codeunit doesn't open e-mail in outlook anymore since last Office 365 update
Hi, We have been using the mail codeunit to create & open mails in outlook with the "RunModal" parameter. This has always been working fine, until one of the last Office 365 updates. When running the functionality now, it doesn't do anything. No e-mail opens in Outlook, no error in event viewer. This specific customer uses…
-
Anyone syncing D365 and Business Central Items with Multiple Units of Measure?
https://docs.microsoft.com/en-us/dynamics365-release-plan/2021wave2/smb/dynamics365-business-central/use-multiple-units-measure-when-synchronizing-items-resources-dynamics-365-sales This new feature enabled the ability to have multiple units of measure sync with D365. It does this by creating an Item Unit Group for EVERY…
-
Cryptography Management and TempBlob
Hello Everyone, I'm trying to do something that is harder than expected. I have to send a file (a pdf report, for example), via httprequest with multipart form-data. I managed to do that, only working with the tempblob codeunit (it has to be compatible with cloud environment). The problem is that the provider receiving the…
-
Running ADCS on Business Central 180
Hi. I am trying to setup ADCS on a Honeywell scanning device. I am able to setup 3 miniforms for Main Menu,Warehouse Picks and Warehouse Put Aways. I have created a web service for the ADCS and setup ADCS Users,enabled ADCS on location card. But now getting the link login with on the honeywell devise is my challenge. I…
-
AL Triggers are not working in VSCODE.
new to AL and not sure if this is the right place to post but,page 50110 DataTypeCard { PageType = Card; ApplicationArea = All; UsageCategory = Documents; Caption = 'Date Type Card'; layout { area(Content) { group(GroupName) { } } } actions { area(Processing) { action(ActionName) { ApplicationArea = All; trigger…