-
Windows PowerShell ISE - New-NAVCRMTable
Hi people, i would like to execute this script by PowerShell: New-NAVCRMTable –CRMServerMyOrg.Crm4.Dynamics.Com –EntityLogicalName systemuser,campaign –ObjectId 5340,50001 –Name “CRM Systemuser”,“CRM Campaign” –OutputPath c:\CRMObjects but it can not find cmlet New-NAVCRMTable. Any suggestion? I imagine i have to import a…
-
Field #99 VAT Base Amount in Sales Shipment Line
can anyone tell me in which cases field #99 of table 111 (sales shipment line) is valued?
-
It is possible to hide "Clear Filter" action on List page?
I want to hide "Clear Filter" action. How can I do this?
-
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
-
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…
-
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…
-
Create a new user from the "job queue".
I am trying to create a new user from the job queue in Dynamics NAV 2017. And having the service tier user do the creating. I have created a codeunit that to create the users. But when the service tier user executes the job queue entry (and the codeunit), the following error occurs when the execution of the job queue entry…
-
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.
-
The remote certificate is invalid according to the validation procedure
The customer created a new test server. We installed Dynamics NAV2017 CU28.10.0.28682 version that connects to the existing test database. We are using a webservice to send files to external party "HL". First we try to establish a connection by using HttpWebRequest with the HTTPS url of HL and with an…
-
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'.…
-
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?
-
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 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…
-
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?
-
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
-
How to add a Api Web Service
In NAV2018 we have standard Api Web Service supporting REST and Json. I want to add my own webservice using a customized page. Anyone know of any how to do this?
-
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
-
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…
-
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…
-
Import XMLport: error the attribute is not declared
Hello, While importing an xml file using an XMLport I get the following error: I do not understand the reason after this as the attribute has been added to the XMLport: The properties of this attribute in the XMLport: Snippet of the xml file I am trying to import, I have marked the attribute that fails: Does anybody now…
-
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?
-
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?
-
Dynamics 365 Business Central App not working on Android: 'Server connection timeout occurred'
Hi everyone, I am trying to launch the Dynamics 365 Business Central on Android via Azure server but I kept on getting the error message 'Server connection timeout occurred'. I did install the new self-signed certificate on Android but it seems that the Business Central app doesn't recognize the certificate. I checked…
-
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!
-
Find Dynamics NAV/BC actual build number.
Hello! I'm working on webservice code in BC14 (C/AL). Is there a way to find actual Version/Build Number from code that's universal to all NAV versions with SQL, and maybe works in AL. The way i've found that's the PRODUCTNAME function, but on BC this does not provide information about the version, all of them are called…
-
PingPong usercontrol for BC cloud version
Hi all, Did anyone success to substitute pingpong user control to work on web client? Thanks