-
Hide and Show Records based on Group
Hi All, i am using cloud bc for my customer i am thinking is there a way that we can show / hide for certain records based on the group. for example user A,B,C is group 1 so he/she only can see the records for his/her own group meanwhile user X,Y,Z is group 2 so he/she also can see records that belong to group 2. but there…
-
Connect to BC web service from a windows console application using Oauth 2 for user authorization
Hi community, I am using following code to access business central web service using Oauth2 authentication from C# console application, the access token generated successfully but I'm unbale to access BC web service due to invalid credentials, problem is that the access token generated from below code is rather shorter…
-
Error: Failure while emitting method.
Hi, I've created this xmlport (csv import) in BC17: xmlport 50000 "Invoice Import" { Direction = Import; Format = VariableText; FieldDelimiter = '<None>'; FieldSeparator = ','; TextEncoding = UTF8; schema { textelement(Root) { tableelement(Integer; Integer) { UseTemporary = true; textelement(Field1) { } textelement(Field2)…
-
NAS NAV Exception
Hello all, I'm getting this error . Server instance: BC140_WebServices Tenant: default The Microsoft Dynamics 365 Business Central Application Server session for tenant 'default' has failed and will be restarted in 30 seconds. Reason: Type: Microsoft.Dynamics.Nav.Types.Exceptions.NavNCLNotSupportedTypeException…
-
Business Central product coupling to CRM in two companies
Hi experts!! I need to copy a product from company A to company B and at the same time in CRM, I also need to couple them (BC to CRM) in both companies. I manage to create the product in company B and also in CRM but at the time of making the coupling only in company A and I cannot do it in company B. This is my code:…
-
Client crashes when trying to save a filtered view
Hello an employee of one of our customers has the following problem: When you start with a specific Role Center and try to save a filtered view, the client crashes with the message that the server has been disconnected. Other employees can save filtered views in the same Role Center. I renamed the .zup file. If another…
-
Selling Apps on App Source
Just wondering, if someone can help My apps are free at the moment on app source how can I sell my apps so I can charge a monthly fee from customers I cannot understand microsoft co-sell policy Thanks for your advise
-
TableData Permission Related Issue
Hi All, While trying to send General Journal Lines (Page 39) for Approval an Enduser is facing the following permission-related issue in BC 14 Environment. To investigate, I have found the following things.. 1. Tab 1506 Workflow Table Relation Value has a function called "CreateNew" that is creating the issue. 3. The…
-
How to setup Odata webservice request for Page 197 (Account Schedule KPI Web service)
I am trying to set up an Odata webservice connection for Account Schedule KPI Web service.This is done by publsihing page 197, so the data can be used with Excel. We are publishing several account schedules, so I want to be able to filter on the account schedule name. On normal pages it is not a problem to add an filter…
-
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…