-
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)…
-
Changing report dataitem in NAV 2017
We created a custom report with a single DataItem Sales Cr. Memo Line that runs fine. I changed the DataItem to Item Ledger Entry along with all the columns references, however when I try running the report, nothing happens and NAV exits. Do I have to change the Layout? If so, how? Many thanks!
-
BC17 Upgrade fails on Database Conversion
Doing an upgrade from V15.5 to V17.0 and it fails doing the database conversion with an SQL timeout after 1 minute. This is on an Azure VM ( Standard E4s v3 (4 vcpus, 32 GiB memory) ) connected to an Azure SQL db (31GB). Steps followed from here:…
-
connect to BC web service from a windows console application using Oauth 2 for user authorization
Hi Community, I need help, I want to connect to BC web service from a windows console application using Oauth 2 for user authorization. Previously I was using Basic auth but it is being depreciated. Can anyone guide/help in this regard? I have achieved that through postman but how to do it from windows console application…
-
Only 2 users can publish to Business Central Cloud from VS Code
Hi All, we have an issue that only 2-3 users can publish the customization from VS to BC cloud version. But all the users have same user groups and permissions assigned. please suggest the resolution. Thanks in advance, Srinivas.
-
Download Multiple File Failed (Using Stream)
Hi All, i want to generate file using stream but if i use repeat , in order to generate multiple files, it will generate the last one only any advise? here is my code procedure GenerateFile()
var
GJL : Record "Gen. Journal Line";
begin GJL.Reset;
if GJL.findset then
repeat DownloadFile(GJL."Document No.");
until GJL.next =…
-
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…
-
The server stopped the session (ID: *) because of a stop session request.
Client is facing issue that User's session is stopped automatically by Middle tire. Client version is BC14 Application CU11 Platform CU16. The scenario is user opens any page via RunModal and then remain inactive for certain time. Below details are logged in event viewer as Information. There is no issue if user remain…
-
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…
-
A call to System.__ComObject.BOF failed with this message: Not enough storage is available to comple
Hi, I am getting this error in 2013 R2. While fetching data from other s/w by using ado connection. I used automation variable. if data is less then everything working perfectly. If anyone faced the same please revert.
-
Problem to Read Json Stream REST API
Hi Guys, I'm trying to read a REST API Stream (Json) but something doesn't work. For example: i try the same Configuration with Postman and get a json stream, with ca. 2250 KB (Only Body Size) like this: IF i use the same Configuration in NAV, and read the Respons, ist look like this. The Blob Size is exactly the Same…
-
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…
-
NAV Client Freezes on click of Apply Entries Button on Payment Journal
One of my NAV User is having this strange issue: when he clicks on “Apply Entries” on a Payment Journal NAV freezes and become totally non-responsive. You have to close it from task manager. This is in NAV 2016. The Payment Journal had only one line. Deleting it and creating the line did not fix the issue. If he logins…
-
invoice lines
hi! i post invoice and it sumarizes all lines for 1 gl code. how can i make it separately - theres a swich in pur/pay setup
-
Displaying Global Dimensions in a Query
I've created a query which includes Shortcut Dimension 1 and Shortcut Dimension 2 in the dataset (it's based on the Purch. Rcpt. Line table). When I display the query in the client the captions are "Shortcut Dimension 1" and "Shortcut Dimension 2". If create a page instead, the captions are taken from whatever is specified…
-
First bank reconciliation
hi guys! client is having their first bank reconciliation tomorrow. its odne
-
Is there anyway to set up a repeating reminder/notification to do something in NAV 2016
My client wants to be reminded each month to Bill out certain Blanket Orders or each year to bill an annual fee. Something like a recurring appointment in Outlook. I don't believe this exists in NAV2016 or even later releases, but I want to make certain. I know they can set up reminders in Contacts or use the Service…
-
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…
-
BC Service Tier CPU usage
Hi, is the service tier of BC 14.0.38650.0 on premise only able to use a single core? I know previous versions like NAV 2017 were using multiple cores. We as a end user have some performance issues and our partner blames the service tier by refering to…
-
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…
-
How do we register down time for machine or work centers? We work with Microsoft DynamicsNAV 2013 R2
Hello! We are learning about machine and work centers. One question that came up is -how do we tell Nav one of our machines(machine center) is down? before production orders are released or once they have been released. Also, does Nav auto allocate the capacity to another machine once we register the first one is down?…
-
Error when run customized report "Adjust Exchange Rates"
In Dynamics 365 Business Central OnPrem, when we try to run Adjust Exchange Rates report we get an error "The value "409*" can't be evaluated into type Integer". The report is not the standard one. We copied the standard one and add some changes. The problem is I cannot figure out where the error comes from. When I clicked…
-
How to link a dataitem with record variable and fetch fields of record variable.
Hi all, I am trying to create a report with dataitem trans.sales entry and record variable with trans. Infocode entry. I want two records "amount" and " information" from trans. Infocode entry. I have given filter of setrange of transaction no. on OnAfterGetRecord() of report dataitem trans sales entry. Please help me to…
-
Aged Accounts Receivable Print to Excel Should not show preview
I would like help in getting the Aged Account Receivables report to not show the preview when the Print to Excel option is selected. In the old versions it use to not show, because of the code in the OnPreSection. Any help would be very much appreciated. The version I am working with is NAV 2013.