-
Setup OData in NAV2013r2 to connect PowerBI
Hi, May I ask anyone try to connect Power BI to NAV2013r2 via OData?? I look at the Power BI demo, they are using the OData URL in NAV2016 Web Service. However, in NAV2013r2 web service page, we do not have the OData URL. I try to put below URL but cannot connect: http://<Server>:<OData Port>/<DB instance>/OData It give me…
-
GL lines
Hello! When posting an invoice it i ssummarizing my lines. I am aware this is because of the localization, but what code do I need to amend to fix this? I coudltn find anything in codeunit 90..?
-
Power Automate integration with BC SaaS
Hi, we are using BC (SaaS) and HRCloud (SaaS) and their is a business requirement to have integration between HRCloud and BC (SaaS), now the HRCloud (SaaS) is going to get a connection for Power Automate, and since Power Automate (MS Dataverse, right?) is integrated with BC, is it possible to enable the integration from…
-
Discounted Unite price Automatically
Hello ;, how can discounted NexLine on sales order for the some Item code and some delivery date Automaically ,but discounted with apply Level , its mean when creat order and get Item in the first Line (10000) its equal level 0 , so for the second line (20000) Equal level 1 then uniteprice deucted by -100 decimal Amount…
-
Add filter on request page on report
Hi experts, I have made my own report in my extension on Business Central cloud. I have a button that is used to call the report and save it as a pdf-file. To do that, I call the request page first and then run the report. If the user has a filter on the list page, it must be copied to the request page on the report. And…
-
Intercompany Transaction Add-Ons in NAV
Hi All, Could you please suggest some Add-ons that will help the Intercompany Transactions in NAV? Thanks in advance, Jacob.A
-
How to avoid order modification proposal in planning worksheet / MPS?
Dear all, when I'm using the MPS planning worksheet for resupply my stock, often I get the "modify" action. However if the purchased is already sent most of time I cannot change it and I have to create another one. Is there any way to force the MPS process to not modify existing purchase or production orders? Thanks
-
inventory valuation 1001 Report
Hi experts , Do any one face a problem in low performance of this report if we have a big database? Navision 2009 R2 Thank you
-
Salesconfirmation as E-mail, want non-modal mode
Hi, On a NAV 2018 with Continia Document Output users complain that the Confirmation to Email action is run in modal mode. When user hits that button, it takes around 5-7 seconds to generate the outlook mail Window (the waiting time is bugging customer too). As soon as the sales confirmation window is up with the pdf…
-
New Workflow Event
Hi! I'm trying to creata a new workflow event (In BC 17.5.22499.22680) using the guide at https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-walkthrough-workflow-events-responses but I'm having some problems. In the guide the this procedure doesn't return any data when called. {…
-
Returning Multiple Value on ODATAv4
Hello Everyone, Is there any way to return multiple value on procedure in codeunit shared using ODATAv4 in Business Central on SaS ? For Example i create a simple function to return Description and Description 2 of the item. First, i tried variable parameter below and had no luck. procedure GetItemAndDescription(ItemNo:…
-
SSRS report to PDF
I'm looking for a way to silently print an SSRS report to a PDF from within NAV. I'd prefer to use a call to the SSRS URL or NAV DotNet. I've looked at the Microsoft.ReportViewer.WebForms assembly but can't find enough info to be able to tell if that would work. I can call the SSRS URL but it pops up a web browser which…
-
Odata Service Reference
Hi all, Recently we've made a migration to a new server with Dynamics Business Central 365. We have a internal application in c# that uses Odata to Update/Delete information between NAV and c# When i try to update the service it gives me this error I also changed some IIS configurations accordind the old server. Enabled…
-
Post image into Business Central via API page
Hi I would like to publish an API page through which an image can be transferred to a table in Business Central. I am using Business Central 2020 Spring release wave 1 Can anyone please give me an example of how to achieve this. Thanks
-
sales price discounted by an amount between level parametre
Hello friend, please I have a question on the unit price, once I want to create the order and (enter the item that will be programmed in a special price contract) the price of the second line of the same item is discounted by an amount set in a field in the price contract. I show you an example:: Line NO Item Delivery Date…
-
UnitPrice in sales line
Hello , My need is how to change automaically price unite if insert second line for the idem item on sales line , the sales line is connect to contract price , and can change if shipped for next qte on idem delivery date for 3 leavel variante.
-
How to add Chart in Role Centre Page
Hi ... is there any way to create a custom generic chart and add that to any roll canter page in new BC? Previously in NAV desktop application by add new chart part and then customize that part and selecting the required chart from generic chart list. I could not find this option in Business Central web version. I can…
-
Automatically declining sales price for each trip.
Hello I have a serouselly question in the nav 2016 how to Automatically declining sales price for each trip., for exemple Tripr one it lunch for start date 01/01/21 to 01/01/21 with sales price record from contrat for item No 000001 = 100 $ When shipped the first delivery unite price get from contract but when i send a new…
-
Export to Excel
Hello, a user have to connect to navision using RDP. When she tries to export Vendor ledger entries to Excel, a blank Excel sheet opens. When she tried to copy the lines from Navision and paste it on the Excel installed on her Laptop, the format of the amount changes. For all 4 figures amount, the formatting is as Text and…
-
Zetadocs Express Addin unable to open docs without Internet Explorer
As Internet Explorer is being discontinued later in the year, we have started disabling it in pcs. An issue we discovered though is Zetadocs Express addin is unable to open any documents without IE. Nothing happens. We raised it with Equisys, who informed us of the below KB.…
-
Webservice with table datapercompany=no
Hello, Business Central Spring Edition, We have Table1, with datapercompany=yes. this table has a field with a relation to table2 table2 is datapercompany=no. Via webservice, we add a value to table2 and after, add a line to table 1 => Error : related info in table1 doesn't exist ... If we look into the table with classic…
-
How to increment a field value if it has same another field value
In Nav 2009, I am creating a dataport export where I am taking values from g/l entry table. My question is For suppose if we are having document no as 'qwerty123' I need to keep '1' in another field 'numbers' and again if I have the same same document no in next line the field 'Numbers' should be incremented by 1 and…
-
Illustrator Tech Pack Fashion integration NAV
Hello, I would like to discuss a possible project to implement and i would be open to read some ideas. Designers fashion use Illustrator or speadsheets to make their tech pack fashion. Imagine a scenario where designers build their tech pack in illustrator and the goal here is to intregate with nav's manufacturer so that…
-
SetRange in Dataport
Hi, Primary: Boolean Item: Code 20 I'm trying to import a CSV file using Dataport. This CSV file has multiple records. I want to check if there are any records in the table before importing the CSV file, if so, then if their Primary field is true, then before importing the CSV File I want to set that Primary field to be…
-
Trying to openEdit a General Journal TestPage
Hi, I'm trying to test the Post Action in TestPage General Journal, but when i use the OpenEdit() it always returns an error saying that i can't open the page. If i don't put this option the returned error is "This Page is not open". Here is my codevar
LibJournal: Codeunit "Library - Journals";
GenJournal: TestPage…
-
Batch Report
Hi everyone, I'm trying to create a batch report/routine that automatically updates all open POs that contain items that have had their purchase price quotes updated. This batch report will update the relevant cost/etc.. information on the purchase order lines from the item card Can anyone please help me with such a task!?…
-
Insight works shop floor
Does anyone have experience with Insight Works shop floor for BC and is willing to share
-
Warehouse management
Hi all, If I need to restrict shipments (only direct shipping) from a particular BIN, which setup needs to be activated? I know there is a setup on Bin "Block Movement" for inbound/Outbound/All, but that doesn't work correctly. Thanks in advance!
-
UseWindowsAuthentication for SaaS
Good afternoon. I have an App working for OnPrem with this line: HttpClient.UseWindowsAuthentication(User(), PasswordF()); I need to migrate to SaaS, and then I get this error: The type or method 'UseWindowsAuthentication' cannot be used for 'Cloud' development. How can I replace HttpClient.UseWindowsAuthentication for…
-
Description formula in Recurring Journals
hello, is there a way to have something like "payment 10 out of 20" in recurring journals? Obviously, the next one will be "11 out of 20" etc etc Is there a way to make this work