-
Report creation using arrays
I have created a report which shows me the data for days vertically according to the range of dates that is established in the request page. However, I would like this report to be displayed horizontally, that is, each day is a column. for example: employee code | Department | hourly wage | Day 1 | Day 2 | Day 3 | Day4 ...…
-
Calculate Flowfield using other fields in the same table
Hello, I have a developing question. I want to create three fields in the Item table: - Astore: Flowfield that calculates how many items are in the A store. This is the Calcformula property: Sum("Item Ledger Entry".Quantity WHERE (Location Code=CONST(Astore),Item No.=FIELD(No.))) - Bstore: Flowfield that calculates how…
-
Testcodeunits AL: TableLocks when sugessting Reminder Lines
Hello everybody. As the title suggests, I have a problem with table locks during my small test application. I have set up a test codeunit in BC16, which should enter a customer on the reminder page (Page434, Table295) and then suggest lines by the action "Suggest Reminder Lines". This is a process that works very well when…
-
One Field is editable when I am in View Mode of page
Hi Friends, One field is editable when I am in View Mode of page, can anyone help how can I do it to behave like nav standards (the field is a variable)
-
Is it possible to create a RDLC layout with a picture besides the item extended text?
I would like to know if it's possible to display the image of an item besides the item extended text (see example below) in a RDLC layout?
-
Join the Webinar
Interested in How to convert Classic NAV report to RDLC and AL format? In this webinar, Simplanova Head of Sales Domas not only will show the whole process but also will share various tips and tricks on the conversion and tell the success story of Isatech. Save your spot now on 25th of November, 4:00 PM CET by registering…
-
Error when compiling codeunit 9010 (after upgrade from NAV2017 to BC13)
After an upgrade from NAV2017 to BC13 I get the error message below after compiling codeunit 9010, does anyone have any idea how I can fix this? (error message is in Dutch saying 'The found assembly manifest definition does not match the assembly reference')
-
Testcodeunits: Strange behavior when executing an action through invoke
As you can already see from the title, I noticed a strange behavior when executing page actions on a testpage through invoke(). I am working on BC16. I created a "Sales Header" in my codeunit and added a few "Sales line"'s. Then I wanted to load the page by a TestPage object and click the action "Post." Here is the code:…
-
NavContainerHelper modifying customsettings.config
Hi all, I want to override the web services authentication method in a service tier. I know the command that should be placed in CustomSettings.config: <add key="WebServicesUseNTLMAuthentication" value="true"></add> However, our development environment is Docker, and the containers are built using NavContainerhelper. Does…
-
How this work
Microsoft Dynamics 365 Business Central Version 14.0.40464 Cu 90 - "Purch.-Post" has code ItemApplnEntry.SETRANGE("Outbound Item Entry No.",TransRcptLine."Item Rcpt. Entry No."); ItemApplnEntry.SETFILTER("Item Ledger Entry No.",'<>%1',TransRcptLine."Item Rcpt. Entry No."); ItemApplnEntry.SETRANGE("Cost Application",TRUE);…
-
Purchase VAT Account Change for Purchase Line
Hi! Good afternoon! I would like to know if someone could help me with a situation. I need the Purchase VAT Account field to be changed for each line if it has different lines. For example, if line 1, your Purchase VAT Account is the account on line 1. And if it is line 2, the Purchase VAT Account is line 2.
-
Use variables in flowfield calcformula
Hello new here and new to AL. I was wondering. I have 3 fields in a table: field(1; Code; Code[20]) { Caption = 'Code'; DataClassification = ToBeClassified; TableRelation = if ("Status Object" = const(Customer)) Customer else if ("Status Object" = const(Item)) Item else if ("Status Object" = const(Vendor)) Vendor; }…
-
Is Business Central enough
We have a Customer running NAV 2016 today and we are discussing a fresh start in Business Central. One question that has come up is of Business Central is enough. In 5 years time they are planning to handle 50-100.000 sales orders a day. Any thoughts from You! who has ran large installations WorldShop be appreciated.
-
Dynamics NAV 2018/BC Default Instance Removal
Isn't there a way to remove the default instance completely from NAV 2018 or BC ? This got has got installed when we first installed both. Googled and looks like this cannot be removed. But, we have one installation where we do not see "DynamicsNAV110". It was either removed by someone or we had setup the proper name when…
-
Synch data from BC(Item Unit of Measure Table) to CRM(Customized Table same structure like BC table)
Hi Experts, I need to synch data from Business Central ("Item Unit of Measure" Table) to CRM (New Customized Table same structure like BC table). I used CDS setup for this but not able to synch this because of this table is not showing in Table Mapping in CDS. So, I go with AL Code level but NAV integration concept is not…
-
Licensing question
Hi, I'm a freelancer developer and would like to extend my abilities with programming for Dynamics. As I understood it has very diversified licensing system. Visual Studio Enterprise Annual subscription offers to download all kinds of Dynamics software. However I'm not sure if it also offers a development license for it. I…
-
Facturen in UBL XML
Iemand ervaring met het versturen van facturen met bijgevoegd een XML of UBL? Zie dat nagenoeg alle financiele pakketten dit standaard ondersteunen; helaas staat Navision niet vermeld in de UBL Ketentest
-
Validation of several fields
Hi experts, I use a Business Central wave 2 - fall 2020 on-premise. I have made a table extension for "Purchase Line" and a page extension for "Purchase Order Subform". I have added a few new fields in those two. I need to add some validation that depend on what item the user enter into the "No." field. So if the user…
-
Business Central: CurrPage.Update from codeunit - or get Line No. from subpages missing CurrPage.Upd
Hello Gurus. I am currently working on a solution, where a page pops up, after entering item no. on a subpage. On the popup page, it is possible to enter some quantity and new lines are inserted below the first line. I have made a codeunit, with an event to the subpage on the salesdocuments (quote, order, invoice, cr.memo,…
-
Flowfields in dropdown list
Hello experts, Is it possible to have flowfields in the dropdown list in RTC? I've tried adding the Inventory field to field groups in the item table, but the value of the field is always shown as 0 in the dropdown list. Looks like the field isn't being calculated.
-
WS authentication in NAV2009
Hi everyone, I'm trying to integrate an eSHop with NAV2009. I have published a CodeUnit as a SOAP WS. NAV has windows authentication by the way. If I connect to the URL fro ma browser outside the server, I must enter user/pasword. I enter the same ones I introduce into the rdp connection. I can get the WSDL from the…
-
Error: Business Central on-premises must be on the same major version as the online instance
During Cloud migration from BC17, after connecting Microsoft Integration Runtime.
-
Transaction that are created when posting a Transfer Order when posting a Transfer Order.
Hi Everyone Hope that everyone is keeping safe. First i would like to introduce my self. My name is Denys De Andrado and i am new to Microsoft Dynamics NAV. It will be a great help that if can someone explain to me that what are the transactions that will be created when posting a Transfer Order. Thanks and Warm Regards,…
-
Enum filter in Query API
Hi In BC V16 I have created an API Query and published as a web service. The query has a filter which filters an enum field in the underlying table. I will be consuming the oData V4 URL. When I test in Postman the filter is ignored. Does anyone know how I should implement the filter? Thanks
-
GETURL
Hey, guys. I am using Web client and it works well. I want to generate a URL for every Purchase Order. There is a GETURL function, but the problem is that for some reason the result of this function has 3 problems: 1. It has the 'http', not the 'https' prefix (why?); 2. It has 48900 port number and I have no idea where it…
-
Modern Lifecycle Policy implications
According to Modern Lifecycle Policy for Dynamics 365 Business Central since the relaease 15: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/terms/lifecycle-policy-on-premises the customer is only supported by Microsoft for the period of initial 18 months since the release date. Practically, it…
-
AWS SDK .NET for use within Dynamics Nav
Hi, For different reasons I would like to use the AWS .NET SDK within Dynamics Nav. https://github.com/aws/aws-sdk-net Is this possible? If so, how would one do? I guess you need a .dll to reference? Never developed any .NET extensions, so I am a rookie within this area.
-
Unable to connect to NAV2009 SQL after upgrading client server from Windows 2008R2 to Windows 2012
A client gets this error after having upgraded an old Windows 2008R2 server to Windows 2012: The following ODBC error occurred: Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" Status-ID: IM002 We have found several threads suggesting to re-install the Native Client for…
-
Multiple Service resource allocation
Hi all, in service mgt. module, in the service order allocation lines, it is possible to allocate only one resource at a time per Service Item Line. It is not possible to allocate two different resources with status Active to the same service order line. There is some standard code that raises and error if you try to do so…
-
Production order scheduling order
Hi team, We noticed that when we would Refresh the PRD, the Backflush would schedule EVERY item to end at the Due date and flow backwards even if they go through the same work center (see two lines below). However our Work Center Capacity is currently set at 1, which to me would mean that it would only be able to process…