-
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…
-
Error with extension not properly connected to separate company
Hi there, I am installing an extension that I only want active in one company. However, when I try to use my other company where the extension is installed but not connected/active, I get this error on the pages that the extension touches. We can't connect with this other company since it is in a different country and the…
-
Updating Profile role from web client
Hi there, if you go to the profile role, there exist the possibility to customize the profile for all. But when I click to Customize a new site is opened with following link: http://s22-navapp2c:48900/BC190?profile=BUCHHALTER/IN&customize the port 48900 does not exist. May be it is because of missing the Client Base URL in…
-
Troubleshooting session resource consumption
Hi, I recall in the old versions of NAV, (before 2009 classic client) you could view connected sessions and view the resources used by each session. E.g. Processor time, and memory usage. Is there anyway to do this in modern client? I Am currently using NAV2017.
-
What is the structure in C# to add records to a BC Cloud table via the OData v4 web service?
I have created an application in Azure and I have given it read and write permissions in BC, in BC I have published the page as a web service. So far I only have the C# code to display the records. The requirement is to monitor a specific folder in Windows and whenever a text file is added, the content of that text file…
-
NAV 2013 R2 QL Server error or errors occurred when accessing the Object table
Hello i have just restored a database frp, live, iam gettin SQL error after restoring the database in sandbox server, the database located on Azure. i have tried to sync the database via Tools-> "Buld server application object " whch comes with bunch of ForNav objects. i have have finaly tried on powersheel sync-NAVtenat…
-
Build Docker Container in a VM running Windows Server 2019
Hi all, Has anyone had success using bccontainerhelper to build a Docker image inside a VM that is running Windows Server 2019? I believe I've installed Docker correctly - it shows that the service is running and the Hyper-V and Containers are active in Server Manager. I'm trying to build various images, but here's an…
-
v16 Sales Price Lists
We're upgrading a customer to SaaS and as a trial we've enabled the new sales price experience in a sandbox. The feature upgrade has created 3 separate price lists, S00001, S00002 and S00003, and I can't see a reason why it did this. They've all got data from the old Sales Price table, and the last one also includes some…
-
OData WebServices BC14
We have custom normal page which we have incorporated OnNewRecord trigger which populates the document no (based on balance of the journal and the no series present =UpdateBalance / SetupNewLine functions). (based similar to Page = 39) The custom page works well when used manually (document number is populating). When we…
-
how to fix this in bc cloud
report 8069153 "Financial Statement Export" { Caption = 'ECF Sage Export'; ProcessingOnly = true; dataset { dataitem("G/L Account"; "G/L Account") { DataItemTableView = SORTING("No.") WHERE("Account Type" = FILTER(Posting)); trigger OnAfterGetRecord() begin Win.UPDATE(1, "No."); Win.UPDATE(2, Name); DecGMntC := 0; DecGMntD…
-
how to Import json file to navision Table
Hi all, I am new to Navision, can anyone of you tell me , how to import json file to Navision ? thanks, Rajan.
-
Deleting Reservation Entry Table Reservation from AL code
Hi All We have sales order item demand reserved to production orders. I want to delete the reservation entry table entry for sales order--prod order (2 lines for each reservation) and re-create the reservation linking production order to Job Planning line. Are there any known risks involved in deleting reservations and…
-
What is Smart SQL and does anyone have any documentation?
I see that there's an option to disable it, but I wanted more info on what it was and whether there was any documentation that I could review with my team as to whether we should enable it for our clients?
-
Release & Reopen
Hi I have created My own project in Navision in this project I have created one document page and also I added two action buttons one is Release one more is Reopen I had called to function through code units but it was not working can you plz share the code if you have and any refer links also put it here only
-
Protecting C/AL Code
Hi all, I was wondering is there any reliable way to protect NAV code from being reused by other partners. I thought extension is the answer as object disappears. But when I try to debug, I'm able to see all the code in the extension. It's as easy as I created a tool to export licence file from NAV DB. So it appears the…
-
How to transfer data from ONE Sql server DB to another Sql Server DB
Hi All, We are using two Sql servers in different locations. Is it possible to transfer table data from one Sql server DB to another sql server DB without manual intervention. This sync has to be done on daily basis. Please share your ideas. Thanks & Regards, Kishore
-
TLS 1.2 and Development Environment Client using NAV2013 R2
Hi, We recently banned TLS 1.0 connections to database server on a NAV2013 R2 environment and everything seems to be working fine except the Classic - Development Environment Client. Does anyone know if there's any solution to make it work? Are newer NAV Development Environment versions compatible with TLS 1.2? Regards,…