-
Business Central 17 - D365 2020 release wave 2 preview
Hi All, I'm upgrading a vertical solution to business central AL from BC 14 C/AL. Does anyone know of a preview version of BC 17, maybe on docker that I could get my hands on please? Or do I need to use BC 16 for now? Regards and Thanks Roddy
-
Date Formula
Hi, I have a hard time figuring out what my date formula should look like on my items. Our suppliers deliver 2 times a week (tuesday and friday) so what I would like to achieve is that the customers would get the fastest delivery date. E.g. if a customer orders on a wednesday and our suppliers have 3 weeks delivery the…
-
Read image file by webservice in AL
Hi All, I hope somebody can help. Im trying to read an image returned from a webservice, however, I´m not sure much about it. This is what I´ve used for reading xml response which is fine, since is a text that I then parse, but as image, I´ve never done before. Any ideas? thanks a lot. RequestHeaders :=…
-
[SOLVED] Passing Data to JavaScript Addin
Hi Guys, We are starting with the Adding development and I was wondering what is the preferred way of passing a lot of data to JavaScript addin. Sure, passing single variables is simple, but what about something like an array? How about a record? Any help is appreciated. Thanks
-
Two Sales Order Workflows required
Hi, I have an issue with the workflows that have me confused and I cannot seem to find any solution for this issue. The scenario is as follows; We have 1 workflow that is setup under sales, MS-SOAPW where we have set certain criteria for this workflow. It is a custom field on our Sales Order for Gross Profit percent, and…
-
Can't "Print WHT Certificate" on page "Payment Journals"
I've tested and debug from different version, The result is still the same error, What should I do?
-
RDLC problem
Hello, I am creating a report in Business Central, using Microsoft SQL Server Report Builder. The report has a tablix where it iterates lines. The lines have a field called "Line category". There is a repeater and for every line I want to control if the line gets displayed or not. I therefore select a row and select the…
-
Can we use HorzGlue on a SubForm inside a TabControl in NAV 2009 R2
I have a Form1 with as Tabcontrol. Inside this TabControl, I have a SubForm which shows Form 2. Inside this Form2, I have a TableBox. Form1 : TabControl : HorzGlue = True SubForm : HorzGlue = True Form2 : TableBox : HorzGlue = True (same size that the Form2 -> Fullscreen if run directly) Why is HorzGlue on TableBox -…
-
Change Navigation Menu background color.
Hi Everyone, My requirement is to change navigation menu background color. could you please guide me, how can i change this blue color to other color. eg. from blue to green or red etc. thanks, Mani
-
Gap between header and detail
I have a gap between the header and the detail that I whant to delete, but i don't know how. Can anybody please hell me?
-
Boolean checkbox in factbox
Hey everyone, Is it possible to display a Boolean field as a checkbox in a factbox? It is not necessary to make the field editable. I just want to display the normal "Yes" and "No" as a checkbox.
-
Write and read Active Directory
Hi, I need to create or read users on active directory, anyone with experience with this? thanks in advance NS
-
Pass the value between pages
For example I have "Page A" and "Page B" And I have to pass the value from "Page A" to the "Page B" For this case I was created the function that takes as a parameter value(the value that I have to pass) on "Page B" In the body of this function executes next: parameter := globalVar (where globalVar - global variable of…
-
Join the webinar: How to effectively use Power Platform with Dynamics 365 Business Central
We are happy to announce that our Fall Webinar Series will start soon❗️ Do not miss the first webinar on How to effectively use Power Platform with Dynamics 365 Business Central by Aleksandar Totovic - an experienced professional in this field. Mark September 23th on the calendar, and save your spot here👉…
-
User interected fields in NAV/BUSINESS CENTRAL
Hi BCExperts, I need your valuable suggestion on below query!! Is there any way to get a user modified field through code? For example, I want to prompt an error to user if he/she modify a field that is blocked for her/him. For this i have subscribed OnAfterOnDatabaseModify event from GlobalTriggerManagement codeunit. But…
-
'TableData 2000000001' doesn't exist and ndo problems
I have just migrated my NAV4 SP1 database from SQL 2000 to SQL 2008 through an SQL restore. I' have windows authentication and various roles per user. Users with SUPER rights are getting the error that 'TableData 2000000001' does not exist. Users with other roles are getting the error that 'The Execute permission was…
-
Code coverage: time spent per object?
Hi, I´m trying to find some performance issues and as you know, it is tricky, specially when the code has a lot of bespoke and facboxes you are not aware of. Do you know if there is any tool that tells the amount of time spent in each object? This could ease the search between them. thanks.
-
Insert a line at the end of a table
Hello, I'm sorry if this question has been asked before but I couldn't manage to find an answer to it. I'm trying to insert a new line by pressing "Insert button" which is created in a form, that line I wanted to be the last line in a table(If other lines exist) The function Rec.INSERT would insert the line and it would be…
-
Print MediaSet (or stream) on business central
Hi folks, I have a kind of weird request. My customer made me save a .pdf file on the item record. I saved it in a MediaSet data type filed. I can save/delete/download it without problem. Now he is asking me to print it. I'm working in BC16 so I can't/don't want to use temporary path or whatever. I wish to print the file…
-
Connector for integration from PDMP to Navision 2017
Nav 17 integration with external system, want to suggest connector which connect both and having web-socket feature. Please suggest thanks.
-
Passing credentials through SOAP Header in XML to connect to NAV Web Service
Hello, Hoping someone has come accross this before, but has anyone connected to a NAV Web Service to create data in a table and passed the credentials through the SOAP Header section of the XML within the envelope? NAV Version: NAV 2017 NAV Authentication: NAVUserPassword I am using SOAPUI to Test and I can insert data…
-
How do i find the developer?
Have an add-on to an old version of Navision 3.6. The ID range is 14017060 to 14017065 "Posted Deposits". Version # BC.FCR.01.05 Is there anyone who knows which company owns this range or somewhere I can look it up? .. Would like to delete old Posted Deposits (Say 2003 to 2010) just wondering if it effects anything or does…
-
Employee Turnover chart report grouped by months
Hi am trying to create a report that should calculate the turnover(Total number of leavers in a period / Total number of employee in that same period X 100) and the report should also group the turnover per month. I was able to get the turnover for the whole period but not per ,month. kindly assist.
-
Can we apply OrderBy on any field in NAV Services?
I am fetching data on scrolling in a table. On each scroll it fetches 100 records. Now i want to apply sorting on each field so that when user click on a specific heading it sort data on fetch data on scroll. Issue what i am getting is sorting with scrolling is working fine for Date values and Invoice numbers but not…
-
How to call webservice which Require Json structure and XML as attachment using REST API .
Hi i am trying to call an API which require Param as Json file structure and xml file attachment as body .
-
How to Setup Service Module
Hi, what do i need to setup in the service module to get this desired functionallity... When an Item gets sold to a customer, sometimes a Service Contract (OHC) should get invoiced to the Customer as well... This Service contract will be a Contract for Maintenance of the bought item. So it should be something like this:…
-
I have not action "Open in Excel" on pages BC16.
We have two the same databases but in 1st database I have this action in 2nd - not. Excel version meets the system requirements of Microsoft. Permission sets include either the D365 Excel Export Action permission set or the system permission 6110.
-
Sort records based on Date
I am trying to sort the records of Item Ledger Entry to give me the expiration date as the earliest date relative to today(). If there are 2 records let us say in ILE Entry No, Item No, Expiration Date 1, itm01, 5th of October 2020 2, itm02, 10th of October 2020 3, itm03, 11th of September 2020 I want it to be sorted as;…
-
Adding a Tracking Spec Line through AL Code?
rec_trackingspec.init(); if rec_trackingspec2.FindLast() then rec_trackingspec."Entry No." := rec_trackingspec2."Entry No." + 1 else rec_trackingspec."Entry No." := 1; rec_trackingspec."Creation Date" := WorkDate(); rec_trackingspec.Positive := true; rec_trackingspec.Validate("Item No.", rec_SalesLine."No.");…
-
Clear All fields in a form
Hello, I'm sorry if this question has already been asked before but I couldn't manage to find an answer to it. a form has been created with a couple of fields, checks marks, and an "Add" button which will add all these fields into a table. My question is I want once that button is pressed all these fields in the form…