-
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
-
Dashboard for job queue entries from different clients
Good morning together, we use several different clients in NAV 2016. In each client, there are job queue entries. I look forward to monitor all of these entries. What possibilities are there to monitor the entries for errors etc.? Maybe there is also a possibility that you will be notified in case of errors. I look forward…
-
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 =…
-
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
-
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…
-
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…
-
How to integrate NAV with Sage
Hi All, I have to investigate and resolve issues of salary/employee costs calculation inside NAV 2013 R2 database and Sage. User insert data in NAV so the integration should be somehow designed to transfer data from NAV to Sage (client version 15x). I do not know anything about Sage, but I do have a lot experiences with…
-
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…
-
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
-
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…
-
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…
-
Pallet Maker
Anyone knows if exist an add-on or 3rd party software for Navison BC to make an optimize pallet? example: I sell 200 products, those products has different packages size, Pack1: 10X10X10 , Pack2: 15X10X5 , Pack?: ??X??X??. I would like to know how many Pallet do I need and optimize how to build the pallet, according…
-
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()…
-
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…
-
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,
-
Powershell Publish APP
Is there another way then using the Powerfull Powershell to Publish developed APP's (VSC - AL) to the NAV Folders ? Problem now is the needed accessrights for using Powershell and the possible danger with using Powershell
-
Intrastat
In Business Central there is a table exit/entry point where you can define from where your goods will be received from/delivered to. This field is also available on sales/purchase order. If you enter exit/entry point on order level, it will appear in item ledger entry. However, intrastat report itself does not take this…
-
Workflows
Hi, I have an issue with the workflows that have me confused and I cannot seem to find any solution for this issue. The scenario is as follows; We have 1 workflow that is setup under sales, MS-SOAPW where we have set certain criteria for this workflow. It is a custom field on our Sales Order for Gross Profit percent, and…
-
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.
-
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…
-
Edit Blank Lines in Sales Quote Subform (95)
Hello, I have tried to find a solution, but I didn't find the right Approach. What I Need is to update the blank lines, witch will added by the Page 95. The OnValidate trigger is not the right place to get the blank lines. Here I can only modify the user edited lines. I guss it depends on the page Setting Multibleline and…
-
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…
-
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…
-
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)…
-
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.…
-
How to deploy a my language to Dynamic BC150 Wave 2 that not support by Microsoft for countries yet?
Hi all, I installed a instance of BC150 (Dynamic 365 Business Central Wave 2 Released) on my server with Docker Container Installation and it run on. Then, I have built Base Application from source code that exported from Docker Container with custom version and it included my custom translated XLF file "Base…
-
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…