-
Problem with reconnection of NAV2016 client causing it's crash
Hello, I'm facing a problem with reconnecting to the NAV server after the session timeout. Problem description: After upgrading from NAV2009 to NAV2016, we have encountered a problem, which causes some issues for the users. In NAV2009 if the client timed out, it was able to connect to the server and restore the session.…
-
Pass value from form (header) to subform (lines)
I have a Header table; table 50108 "Production Time Log Header"
{ DataClassification = ToBeClassified; fields { field(50000; "Entry No"; Integer) { DataClassification = CustomerContent; } field(50002; "Production No."; Code[20]) { DataClassification = ToBeClassified; } field(50003; "Total"; Decimal) { FieldClass =…
-
Communication Component - waiting for respond if service is down
Hello everyone. I'm trying to understand where my problem is. Most of the time the code is working just fine, but sometimes it is waiting to be respond for a long-long time. Sometimes the service, from which I'm waiting a respond is crushed. Is there any way to find out, that it crushed and don't wait for it? Is there any…
-
Error in Report:A DotNet variable has not been instantiated. Attempting to call WinSCP.Session
Hi All I have created a Dot Net Variable with Name SessionOptions with type DotNet and SubType as WinSCP.SessionOptions.'WinSCPnet, Version=1.6.5.9925, Culture=neutral, PublicKeyToken=2271ec4a3c56d0bf' I have clear the Variable. I have also set the property Run on Client to Yes But still this error is coming. Please help
-
Release Wave 2 sandbox - cannot connect
Hi Experts, I have create the new project from template. When I hit F5 it asks me which sandbox version I want to connect, I select "4.0 Release Wave 2. " It tries to download symbols but cannot. I can connect when I create another project and select "3.0 Spring Update" It seems I do not have enough rights for this, should…
-
error in Item table while selecting
The provided statistics stream is corrupt. Page Select must close. Can any one help me with this error when I am selecting item it is giving error in Purchase line entry warm regards Kris
-
Import Excel Files From a Folder in FTP Site directly to NAV table.
Hi, I am trying to import Excel files which are located at a Folder from a FTP Site directly into NAV 2016 Table. Please Share your views.
-
Incoming document factbox on sales return order
Hi all How to add incoming document fact box on sales return order. regards satish
-
Is there any way to hide a standard report from search box by extension?
Hello everyone, I am working on D365BC on-prem with extension. I would like to customize standard report So, I export the report as text file then convert it to AL. After I've published the extension. There are two reports in search box (a standard report and a new one). Is there any way to hide the old report from search…
-
Nav 2009 - Webservice
Hallo, I enabled the webservice for an Nav 2009 client. When I go to http://localhost:7047/DynamicsNAV/WS/Services the webservice give me: But when I go to http://localhost:7047/DynamicsNAV/WS/Test/Services the webservice give me an HTTP 500 internal service Error. And the company Test (capital) does exists. Can someone…
-
Report printed in Folio format
Hi everyone, Is someone knows if there is a link between NAV and the printing property "Paper Size" ? Few days ago, reports in NAV has been printed in the Folio format for some users (not for all) and we have not idea what happened. Thanks, Michael.
-
Consuming web service in email
Hi, One of my clients wants that Navision(2016) will send their approval requests thru emails & end-users can able to take decision(Approve/Reject) from email body without accessing Navision client. Required details of the documents will be available in email body in row wise & user can be able to Approve or reject the…
-
Unable to apply filter on Virtual Date Table
Hi, We are facing a problem in NAV 2015 CU 8. Your help will be much appreciated. I don’t know, it is due to some code bug or some NST bug. But sometime, NAV is not able to apply filter out data on the Date Table. It is always picking first entry from Date Table. Rest virtual tables are working fine. And the common thing…
-
Current price field in the table "Item"
I have created a field in the item table.That field will display the latest current price of the item. Ex. I have updated the price for the item A as $10 from 01/01/19 to 31/12/19.the field will show $10 as the current price. Suppose when i update the price of the item A for a certain period 01/10/19 to 30/11/19 as $15. It…
-
only single item shows on purchase order of report?
Hi all , this is my second post about issue. i have created custom report for purchase order as it is multiple copies such as original,duplicate etc. on purchase order there are four items but report printing first item only . how i can get all item in line level of report thanks in advance
-
Send to excel incorrect translation
Hi, We have a nav2017 running with french translation. In the general entries page, everything is translated correctly. But when the page is sent to excel, all options fields is in English in excel. Anyone knows why? Jordi
-
Multiple line of items of PO on the report not printing?
Hi all, I have to create custom Purchase order report in which multiple copies of PO report. I have done that using page loop and copy loop but one poblem is PO having multiple item say 4 item lines then report only showing first line item any solution so i get all four items printed on reportDocumentation() OnInitReport()…
-
Query on Sales Header (filter by customer)
Hi all, I created a simple query calculating for all customers the items and quantity bought. Expanded Type Data Source Name Method Type Method Group By 1 DataItem Item Ledger Entry <Item_Ledger_Entry> No 0 Column Item No. <Item_No> None Yes 0 Column Source No. <Source_No> None Yes 0 Column Quantity <Sum_Quantity> Totals…
-
Scanner lector de Códigos de barras
Buenas noches: En mi empresa estamos intentando integrar unas pistolas PDA para poder implementar el almacén avanzado. Para esto, hemos adquirido una PDA CK3X de Intermec con un sistema operativo Windows Embedded handle 6.5.3. Por lo que he podido leer, se pueden descargar APPs que se conectarían con Navision (NAV 2018 en…
-
how to change field value in table in bc?
Hi all, I have added two boolean field in purch.rcpt.line Qc needed Qc Tested now i want to change it's value as we checked mark that field. my question is how i can change it's value by page extension then which page it extends. thank you in advance.
-
Pick According to FEFO and reservations
Hi All I have a customer using "Directed Put-away and Pick","Pick According to FEFO" and "Require Shipment". They want to reserve a salesline to a specific LOT-No. But the pick does not care about that reservation - it picks according to FEFO no matter if the reservation is for another LOT. Is it true, that "Pick According…
-
Select the same "destination no." records avoid the different "destination no" records.
Hi All, While multiselection of the 'Get source document' in Warehouse shipment page, "I can only able to select the same Destination no." records otherwise system has to throw an error. Example: Multi-selection 1) selecting the same destination no. records (C0001 and C0001) ->System should allow. Multi-selection 2)…
-
BC 365 - Team Member permissions
Hello, I have a question about the Team member license for BC 365. Has the user with an team member license rights to an customized installed extension (App)? Kind regards,
-
Date format as MM/YYYY
Older NAV versions were able to define customized date formats in CU-1. Currently in newer versions like NAV2018 and 365 BC, after Microsoft has redefined CU's, these formats suppose to be handled in CU-45. By using table field properties 'AutoFormatType' and 'AutoFormatExpr' and related code in CU-45 (function…
-
2 report headers
I want to use 2 report headers in a report, so for page 1 to use Header1 and the next page(s) Header2. I'm struggling to achieve that. I tried a few approaches but neither one of them worked. I'm not using the Report Page Header but defining both headers in the tablix. The reason for this approach is (compare i.e. report…
-
Copy record using transferfields with records of linked table
Hi All, I need a some advice on how to link a table to a source table from the one I have to copy record. Source table has some records in a linked table and I would like to copy also these records of the linked table. code:JobTaskRec.CHANGECOMPANY(CompanyTo); //copy record in another…
-
Using functions in Odata Webservices
Hi everyone, I am creating an extension for integrating via REST webServices with an external application. First of all, I've created a simple table:fields {
table 50701 "KanbanizeCard"
..... field(1; "ID"; Integer) { Caption = 'ID'; DataClassification = ToBeClassified; } field(2; "Nombre"; Text[200]) { Caption = 'Nombre';…
-
Non-converted Value in G/L Register Report.
I am trying to tackle a problem I was assigned to solve; In BC when we create General Journals, we get an option to select a currency. If we select a currency other than the LCY of the System, let's say, LCY of the System is set to GBP, and while creating a Gen. Journal I select USD. After posting this Gen. Journal when we…
-
Returning value when performing Odata operation(i'm using postman as test)
Hey, is it possible to return a value when a page is consumed as odata? i published a page as Odata with bunch of fields that can be used externally. The page creates a new customer, and it should return newly created customer number. However, the issues is that, when the action is perfomed, i get the query back as result.…
-
BC140 - bad performance of import via xmlport on SQL Azure (and very fast on local SQL Server)
Hi there, We are experiencing very bad performance of a xmlport that is used to import gen. ledger entries. The server and webclient (Business Central 140 - Spring release cu2) are running on a Azure VM, the dabase is on SQL Azure. I've created some files with different sizes. A small file (50k) takes about 15 seconds to…