-
Export to Excel - Business central 365 Wave 2
Hi folks - I have a processing only report with 2 data items and a procedure Makedatabody. I get the errors that Sales shipment header and Sales shipment line does not exist. Can anyone please let me know how do i refer to a field in 365 BC. Many..Many thanks for your help. Sales shipment header Sales Shipment Line…
-
NAV2018 - Working on file system with different user
Hello experts, i have the following situation: the customer is migrating from NAV2009 to NAV2018. In the older version there are some functions that allow users to open folder (launching explorer) or navigate file system from dialog. The customer's IT have defined a large permission set on different folder in their system,…
-
How can I use NAV2009 RTC without domain accounts?
I'm porting an old NAV 2009 installation to a new server (from Windows Server 2008 to Windows Server 2012). I installed NAV on the new server and restored the SQL Server database to a new SQL Server (2012) instance. On the old server we had the logins handled with domain accounts. The new server is not the domain however,…
-
Customer Statement Report calculate the number of pages per customer
Hi Is there any way in the Standard Statement report 1316 RDLC layout to determine the number of pages being printed for each customer? I need to display Page x of n on the header of the document thanks
-
How to Create a query using multiple periods?
I want to create a query where I can use more than one period in a row. For example: I want to show Item Ledger Entries for each item per month. If I add an other Dataitem the query doesn't work correctly. Can someone give me a hint? What my customer expects: Item No. - Description - Qty January - Qty February - etc.…
-
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…