-
Reports assigned on RC
Dear All Is there any table holds records of reports assigned to each RC. Report settings list is not helping me because some reports are attached in RC without entry in report settings page. Going to each Role Center design and pulling from the property list is taking lot of time due to large number of RC pages. Kindly…
-
BC SaaS : Importing Multiple Files from OneDrive Folder
Hi all, We are trying to come up with a solution where we can import multiple CSV files stored in a folder in OneDrive into Business Central SaaS. We do not have the option to map the OneDrive somewhere locally since even Business Central is cloud based therefore no VM or server. Scenario; We have an external system set to…
-
Run cmd line as admin
Hi Expert, Am trying to run net stop && net start for restarting NavInstance but I always encountered error "Access is Denied". Does anyone tried doing this successfully? Here are my codes: Process := Process.Process; Process.StartInfo.UseShellExecute := FALSE; Process.StartInfo.FileName := 'cmd.exe';…
-
BC15 - more than 5 decimal places for a currency
Hi guys, we've come across a first large issue with the newest version of BC. I need to set a currency to operate with 8 decimal places (Bitcoin). So I did the usual trick with "General Ledger Setup"."Amount Decimal Places" and "General Ledger Setup"."Amount Rounding Precision" in code, which was successfully set to 2:8.…
-
NAV 2018 BC - CueGroup number showing 999+ instead of actual number
Hello Everyone, We have a user who would like to see the actual number of current Released Prod. Orders instead of the "999+" number he is seeing. Is there a way to change that to display? I see the page is on 9038 and the field is set but I don't see anywhere you can change the format. Thanks
-
It is possible to hide "Clear Filter" action on List page?
I want to hide "Clear Filter" action. How can I do this?
-
Issue with filter groups when inserting new record
Dear Community, If certain filters are applied (e.g. by a view or a link) and the user creates a new record, then the fields affected by the filter are filled automatically. So far so good. More specifically, the following case is at issue: The user creates an extended text for an existing item. He opens the extended texts…
-
GRN reversal
Is it possible to reverse a posted purchase receipt? The amount on the GRN differs from the posted purchase invoice. Please assist.
-
Outlook Add-In: Web Client Stored Credentials
I have a client I was help testing out the Outlook Add-in, by which I mean Contact Insights and the Document Links (not the Outlook Add-in for Sync -- can we get better naming?). We set it up with NavUserPassword logins, and when we logged in, it worked OK. Now he's changed his Nav password, but the stored credentials…
-
Generate Empty Row
Hi, i'm building a report with Sales Invoice Header as a parent dataset and Sales Invoice Line as child dataset. I want the report to generate 10 rows before page break. 1st. If the records per document no in sales line is less than 10 records, for example only 6 records, then it will generate 4 empty rows. 2nd. If the…
-
Object of type Query with ID # could not be found.
Hi! I'am trying to publish 7 Queries (Object ID 70540-70546) of type API but I get the following error message as soon as the client opens up. The strange thing is that it is Query number two it complains about, deleting that one and publishing just ends up with an error for the next query. help with a solution or thoughts…
-
How to limit the item display in drop down list by user
I want to control the items in drop down list by user. for example: in Item Journal (Draw)-Apply Page, we use a Gen. Bus. Posting Group column(Drop Down List) . I want hidden some items by user. Is there any way to do this?
-
AL extension version for Visual Studio Code cannot be used with the specified server.
Hi all, maybe someone have an idea what can be reason for the error receiving when try to connect BC15 (Sandbox on local Docker). "... [2020-02-17 16:15:34.32] Publishing AL application using launch configuration 'Your own server'. [2020-02-17 16:15:34.89] Targeting server 'http://172.22.160.178' and server instance 'BC'.…
-
Error: You do not have permission to create table
I have tried to create table with different IDs of different range of numbers but this error has occurred again and again: "You do not have permission to create table Contact your system administrator to have your permissions changed" Does anybody have the idea how can I solve it?
-
Open up sales lines into full screen when in sales order?
What is the shortcut to open up the sales lines into its own screen? using 2016 and you can only see 2/3 lines when entering products on a sales order, which is really annoying when entering 10-15 items.
-
How to avail 50% GST on purchase in NAV
Hello Experts, Can anyone please advise me how to avail 50% GST in NAV for all the service purchase. Like: If suppose I have taken service from Registered vendor and he charged me 1180 inclusive 18%. and I have paid accordingly to the vendor. now while doing to claim setoff I need to claim only 90, instead of 180. please…
-
From Node.js connect to Navison with Webservice
Hello, does anyone of you have an example of how to access Nav from Node.js using a web service. Would need the connection to the pages (with filter) and to the codeunits. thanks stony
-
I am getting the following error when i am trying to process a Assembly item on a sales order
'you do not have the following permissions on table warehouse shipment line execute' This occurs when i select the post function. I am using NAV 2018 starter pack. I have check my warehouse, and inventory setting.
-
Error message in NAV Web Client
Hi everybody, Sometimes when opening a page in the NAV Web Client we get the following error message: "Server file access by C/AL functions is disabled. Contact your system administrator". I checked the setup in the administration NAV tool for each server (there are 4 servers for the web client) and the option is checked…
-
How to calculate Sales from 'Item Ledger Entry' table
Hello, Could somebody clarify how to calculate Sales starting from the 'Item Ledger Table' to e.g. provide proper Sales Amounts and Qty per Customer and Item for a period. I could see that criteria could be as 'Entry Type' = 'Sale'. Would it be enough or I'd need to add e.g. the 'Source Type' = 'Customer'. How about the…
-
How to import Business Central Custom Report
As I understand it, you create a custom report by exporting via finsql with a new command and then convert that text file to al code using txt2al. Once you have generated the rdlc file via Visual Studio code, you can now make modifications and publish the report for Business Central client usage. Let's say I exported Sales…
-
The text 'generatesymbolreference Database=xxx ServerName=xxx' is too long
hi, I'm trying to run the below command .\finsql.exe Command=generatesymbolreference, Database="Demo Database BC (14-0)", ServerName="xxx" but i'm getting the below error Microsoft Dynamics NAV Development EnvironmentThe text 'generatesymbolreference Database=Demo Database BC (14-0) ServerName=xxx' is too long. Text can…
-
OnPageOpen event in CU1?
Good morning, I´m looking and looking, I can´t find it. Is there any event that would raise on page open in CU1?
-
Get-NavAppRuntimePackage in App with dependecies error AL1024
with command Get-NavAppRuntimePackage,i can succesfully create apps with no dependencies, but when I try to use it with a app that has dependencies the command throws a compilation error like below. did anyone know how try to generate runtime package apps with dependencies?
-
Create table from C/AL in Nav 2017
Is it possible to create a table from C/AL, not data but the "real" table with fields and keys.
-
NAV easy security light over NAV 2015
Hi All, I hope some1 can help. Has any1 tried NAV easy security in versions over 2015? http://mergetool.com/products/easysecuritylighthistory.html it says it doesn´t work but these are the things they say so you don´t use it usually so I wanted to see if someone tried in 2018 or other versions. thanks!
-
How to add new field to a report in SaaS using extensions
Hello, In Business Central 365 SaaS, how do I add a new field to a report using an extension? And once it is added, how do you reference it in the generated rdl file when it is exported?
-
How to ignore "DataPerCompany" property?
I have a page that show info from table in which "DataPerCompany" property set to 'Yes'. But I have to get data from all companies for my page. So how to get data from all companies but do not change "DataPerCompany" to 'No' ? may be it could be done by code or some other way
-
Error: The page type xmlport is not supported in Microsoft Dynamics 365 Business Central MSDYN365BC
Hi ALL, While running XMLPORT in business Central i came across an error “The page type xmlport is not supported in Microsoft Dynamics 365 Business Central” You can ref my blog on Creating and Running XMLPORT Import and Export Data in Microsoft Dynamics Business Central (MSDYN365BC) You are getting this error because the…
-
PingPong usercontrol for BC cloud version
Hi all, Did anyone success to substitute pingpong user control to work on web client? Thanks