-
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…
-
Web client shows 2 reports when only one was modified
I modified the Inventory Valuation report using the development environment and now on the web client it shows 2 Inventory Valuation reports. One of them work as expected and the other just goes to an error page. I did previously copy the original to a new report I called Inventory Valuation2 but after I was done with the…
-
Deleted report still shows in NAV and Web Client
I recently created a 2nd report named Inventory Val2 to help practice for modifying an existing report in the NAV Development Environment. After all changes were done and copied to the original report(Inventory Valuation) I deleted the 2nd report. But now when I search in the NAV client or Web Client I see 2 Inventory…
-
Slow performance with SAVEASPDF and custom report layouts
Hi, Have any of you experienced slow performance when using SAVEASPDF on a report with custom layout in NAV 2018 (CU3)? Our experience is that once you select a custom layout for a report the time it takes to run SAVEASPDF increases from a few seconds to between 15-30 seconds - for the same built-in layout! Try the…
-
SMTP Mail Setup not working after Multi Factor Authentication
Hi All, I am not able to configure SMTP Mail Setup after the MFA implementation. We know earlier this was a simple step to configure SMTP with Office 365 Server Setting. In my knowledge after MFA, the password will be the AppPassword. I tried this but no luck. See the setup and error in below screen shot. Business Central…
-
Replace the warehouse shipment line while selecting the different record.
Hi all, I have created one new warehouse shipment. Here (Ribbon->Getsource Documents). I can able to select any record from the source document page(without considering the 'Destination no' field). If i try to insert another record, it has to delete/replace the first record with a new record in the warehouse shipment line.…
-
Get current value of page control and past it using GETRECORD
Hi All, I have multicompany database and I need to write the code to get (currently users' logged in compnay) record of table: "Job: and copy it to the same table of different company. I just can't get the GETRECORD working as it should. CopyJob is a record link to the Page="Copy Job" Company is a Page Control on the Copy…
-
can we create Credit Memo on Partial Prepayment Invoice
Hi im new to nav, Can we credit memo the prepayment invoices partially or for a particular invoice can we post credit memo by clicking it. Thanks in advance,
-
Question for Workflow Steps When Event
Hi Experts, May I know if the Order of When Event matters when in terms of approval process? Thanks in advance for your answers!
-
The supplied field number 'xxxxx' cannot be found in the 'xxxx' table. <SOLVED>
Hi everyone, While trying to run page 89 Job List, I hit upon the following error message: The supplied field number '50025' cannot be found in the 'Job' table. I used to have field 50025 in my job table but I don't have it anymore and nothing references this field in 89 page. I exported in a text file and tried to find…
-
Printing external excel file with multiple sheets
Is it possible to print all sheets from external excel file?
-
Data Matrix 2D Barcode
Dynamics NAV 2013 I'm trying to get a Data Matrix label printed (have got 2D QR Codes printing using the Mexico version of Nav mentioned somewhere on this forum). There are recommendations to use DataMatrix.net.dll as mentioned on https://forum.mibuso.com/discussion/comment/329727#Comment_329727. Once downloaded I've…
-
While Run the Customized report getting this error frequently,can u please any one suggest on this
Type: Microsoft.Dynamics.Nav.Client.NavClientClosingException Fatal: False ShowError: True Message: This operation cannot be completed. There is no active connection to the server. Close the application and start it again. StackTrace: at…
-
BC140 Can't print directly
Hey everyone, BC Version: Problem: On the RTC I can't print directly a report, when I press print and select the printer/xps/pdf or any other thing it just crashes my client. It works fine with the Webclient, but not with the RTC. If I do preview and then print on the preview it works OK. I've tried this in different…
-
NAVAppProfiler
I was checking the NAV App Profiler and I found this, https://archive.codeplex.com/?p=navappprofiler. I downloaded it but the dll is missing. I can't compile the page because it's returning error "Could not load type 'EtwPerformanceProfiler.EtwPerformanceProfiler.'EtwPerformanceProfiler, Version=1.0.0.0, Culture=neutral,…