-
Incoming Documents
Hi, I have a client running Dynamics NAV 2016. They create a Purchase Invoice, and then in the top ribbon select the option 'Create from file' to then link the invoice to the saved file. My client has multiple companies in the same database, and when a particular user who has the same permissions for all companies does…
-
Link subform to subform
Hi to all, I want to link a subform to a subform by using the property providerID. Both subforms are used for data entry. So i've created the following objects : Maintable.altable 50132 "Main Table"
{ Caption = 'Main'; fields { field(2; "No."; Code[20]) { Caption = 'No.'; DataClassification = CustomerContent; } field(3;…
-
Imoprt from csv file not creating a balancing line
hi guys, I am writing an import but its only creating one balancing line for my journal whereas I want it to create balancing line for each document No in the import. Here's my code. Not sure what I'm doing wrong? WITH GenJnlLine DO BEGIN SETRANGE("Journal Template Name",JournalTemplateName); SETRANGE("Journal Batch…
-
Open Image using Temp Blob codeunit
Hi I have code on a page in NAV that uses the TempBlob record to open an image. CALCFIELDS(Image); IF Image.HASVALUE THEN BEGIN FileName := AppSetup."Temp Image Path" + "Document No." + "Image Extension"; TempBlob.Blob := Image; FileName := FileManagement.BLOBExport(TempBlob,FileName,FALSE); HYPERLINK(FileName); END; I…
-
Zero value GL Entry is created after apply 2 transactions
Hi, I posted 2 GL transactions A and B with account type Vendor, same vendor. B is contra of A, then applied B to A. Navision then created 1 new GL entry with Doc No A and Zero amount. Anyone can help explain me whether this is a bug or feature? any reference? P/S: I'm using NAV 5.0 SP1 Thank you.
-
Modal dialo BC14 Webclient
Sometimes, even with different browsers, when I register a purchase invoice and a problem occurs it is not possible to close the error window because the one that shows the progress of the registration remains in the foreground and does not click on the Ok button of the window with error. Anyone know how to fix or work…
-
BC14 Webclient cannot open card page from list
I've a custom page list (Car list). When I move mouse cursor on field primary key (Car No.) tip show "Open record XXX1 in new window" but when I click on it nothing happens. In page list property "CardPageID" was set to correspondent card page id. What could be the problem?
-
Day rates in different countries?
Hi Guys, Does anyone know the market rate for senior consultants around the world? How much do the biggest consultancies in your market bill their end-users by hour or by day? In Denmark I know of consultancies who charge 1100DKK, 1400DKK and even 1600DKK per hour. In the UK, the dayrate is between 700-950 GBP. Does anyone…
-
Vendor Approval Workflow issue
I have a created a Vendor Approval Workflow that is triggered on Event "A vendor record is changed". The condition is set to <Always>. I presume this workflow is triggered by the table's OnModify event. The problem is, when a user edits a Vendor, there could be multiple record saves, and thus multiple Approval Requests are…
-
Autofit column width & Wrap text
Hi guys, May I know how to autofit column width & wrap text when export to Excel file? I saw many people advise use the Autofit function in the Excel buffer table (370), but I can't find the Autofit function in my Microsoft Dynamics 365 Business Central. Anyone expert can give me some suggestions on how I can archive the…
-
Wrong language in Mail subject.
Hi When I want to send a posted sales invoice (for instance) and press "Send via mail" - the proposed mail subject (and file name) is based on the language I am using and not the language of the customer. So in my case english customers will receive an email with Danish subject (unless I change the application language to…
-
signing text string using certificate key and convert into base64 string to send over API.
How can I achieve this using in AL code? I have tried using encryption management codeunit but I could not find the function to get key from stored certificate. 1.Token String 1 := String 1 + String 2. 2.Generate message digest of the token string above using SHA256 hashing algorithm. 3.Sign the message digest using the…
-
pass parameter null to dotnet function
Hello, Any one can help plz. i want to pass a null parameter to dotnet function. reader : System.Data.SqlClient.SqlDataReader I already try to declare an array but i get didnt get the same result as c# When i run the same code in c# num2 = 1277 but when i run it in business central i got 0. Thanks in advance
-
Business Central Telemetry
Hello, I would like to better understand Telemetry capabilities within Business Central. Does anyone have any useful resources I could read / watch to get this information. Thank you!
-
Business Central LDAP -> LDAPS
Hi All does anybody know if this change has impact on BC 15? https://support.microsoft.com/en-us/help/4520412/2020-ldap-channel-binding-and-ldap-signing-requirements-for-windows Do we have to change something in BC? thanks
-
How to change complextype mixed=false in wsdl
Dear All I published the web service using code unit (xmlport). The WDSL has the below <complexType name="xmlPort" mixed="true"> Is possible to change mixed='false'? Thanks & Regards Nasheer.
-
Business Central: Returning Max Sessions (Max Connections) in AL Online Extension
Hi folks, I have a need to return (access) the variable representing the maximum number of concurrent sessions a particular database is Licensed-for in an Online BC install. And I need to be able to access that from my own AL Extension. You used to be able to read the text-part of the License File from a System Table in…
-
iPad dragging the view
I have a simple page with the Sales Header, and Sales Lines.. The sales lines is at the bottom of the screen, and the iPad doesn't seem capable of dragging it up to show more Sales Lines.. Anyone have a solution?
-
iPad printing receipt
I'd like to install a receipt printer in our forklifts so our loaders can give the drivers a receipt of what is on the truck. Anyone printed to a Bluetooth printer from an Ipad in NAV? Using NAV2016 right now, but in the middle of upgrading to NAV2019
-
NavApplicationProfiler & NAV 2018
Has anyone managed to run this successfully in NAV 2018 (CU29) If i dont enable function tracing i can capture the database access, but when i enable tracing i get an error when stopping the trace. Th e error is along the line of invalid typecast when calling the stopfunction in the dll. Alternatively i could use a hint on…
-
NAV ODataV4 vs NAV API
Hi, I would like to ask what are the practical differences between the OData V4 web service Custom Page and the Custom page API. So far, I've only noticed: API is better-structured thanks to properties (like APIPublisher, APIGroup, APIVersion, EntityName, EntitySetName ..) The API allows you to use templates. Are there any…
-
The trust relationship between this workstation and the primary domain failed
Hi Experts When I try to open USERS List from RTC I get this error in NAV 2017 Version(10.0.16177) -- ref: " The trust relationship between this workstation and the primary domain failed " Please Help...
-
Inventory Valuation - 0 Quantity on Hand, but contains values
Hi everyone, I'm running the standard Inventory Valuation report on a 2016 database, and I'm seeing a LOT of items popping up that say there are 0 on hand (for that location), but still has an inventory value. Most of these are between -$1.00 and $1.00, so it's not a huge problem financially, but there are many times more…
-
Business central Sandbox Publishing Error
Dear all, When I try to download symbols in visual studio editor before publishing an app in Business central , I am getting error as follows. The I/O operation has been aborted because of either a thread exit or an application request.. The I/O operation has been aborted because of either a thread exit or an application…
-
Alternatief ECB Exchange Rates voor de TWD
Beste gebruikers, Ik ben benieuwd of iemand van jullie ervaring heeft met het volgende; De TWD (Valuta gebruikt in Taiwan) wordt niet aangeboden door de ECB in de ECB Exchange Rates. Zie ook http://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml Graag zouden wij toch gebruik willen maken van een soortgelijke tool.…
-
Automate page testing attach files
I want to automate the testing of attaching file purchase order. The process of attaching file to purchase order as follow: 1. Click action File attachment from purchase order list 2. It will open file attachment fact box. In file attachment fact box click import: 3. When clicks on import, it will open file dialog box to…
-
Page Testing Error when Create New Vendor Bank Account
I'm defining a page test to create new vendor bank account as below: 1. Go to Vendor List and find a particular vendor 2. Open bank account list page for that vendor 3. Click new and create vendor I have written the code as below: VendorList.OPENEDIT; VendorBankAccountList.TRAP; VendorList."Page Vendor Bank Account…
-
Subtotals
Greettings, I need to create a subtotal on a table based upon the value of a field . On the table 5601(FA Ledger Entry), I want to be able to sum the values of the field 'Amount' based upon these creterion : - FA Posting Type : Depreciation Knowing that this can be rolled out by the use of Setfilter , the totaling needs…
-
EFT Payment Export with Bank of America
Hello greetings. Has anyone built the Data Exch Def setup for EFT Payment Export with Bank of America and Business Central?
-
[BC15] Event Recorder - No events have been recorded
Hello everyone, I've problem with event recorder. When I try record any events I always see message "No events have been recorded": The proper scenario (I hope): Of course I've tried many scenarios like open new window (not tab), start record when 2 session windows are already open etc.. I've tried on BC15 OnPrem with…