-
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…
-
BC365 An Internal Error has occured
Hello Guys. Im currently working on BC365 and still newbie. Im trying to publish my work to a remote server. see error below Any idea ? Thanks and God Bless
-
Business Central BC180 On Premise / Test environment
I am a (junior) developer in a Business Central development team, we want to set up a test environment to unittest our .al solutions. Via a Mastering BC book we find out that you have to include the following .app packages in your .alpackages folder: Microsoft_Any.app Microsoft_Library Assert.app Microsoft_Library Variable…
-
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…
-
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 =…
-
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
-
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…
-
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…
-
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…
-
First bank reconciliation
hi guys! client is having their first bank reconciliation tomorrow. its odne
-
Bank balances
hi! how do you do bank rec on a new implementation
-
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..?
-
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…
-
AWS Signature Version 4 - BC Cloud for AWS API
Hi all, This question is for latest BC cloud implementation. Has anyone had experience with calling an AWS API which requires a signing key for Signature 4 without using a .net dll? It needs to use an algorithm of HMACSHA256. Which is fine, as it is possible to do this via the GenerateHash function within the Cryptography…
-
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
-
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.
-
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…
-
Install apps from MarketPlace on on-premises environments
The option is there, so I feel it should be possible... If I start an on-premises web client, I can go to the Extension marketplace and select an app. I fill out my data, Then, when I want to start installing it, the system gives me the following message: "Installation of extensions from the marketplace is not supported…
-
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:…
-
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?…
-
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…
-
Save report as pdf and send as e-mail
Hi experts, On Business Central cloud, I have made my own report in my own extension. I need to add an option for the user to select, if the report should be printed as normal or if it should be sent as an e-mail with a pdf document attched. I don't want the user to select, where the pdf document should be saved during the…
-
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
-
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…