-
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 ...…
-
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?
-
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);…
-
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…
-
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.
-
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…
-
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.
-
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…
-
Add a Base64 encoded PDF as an attachment to a Sales Order in BC
Hi, I receive a Base64 encoded PDF through a webservice in BC16. I managed to deencode the PDF. My question is what the best way is to attach the PDF to a Sales Order? From the Sales Order I want to be able to open the PDF.
-
Purchase Tax on Expenses / Costs
Hello! I want to thank many who take their time to support many. On this occasion I would like to ask you for support in which you illustrate where I can go to do this. On this occasion, I would like the amount of the tax to be in their respective accounts. That means that the first line would have 517.50; and the second…
-
Cannot see media and mediaset fields on card page
Hi experts, I have made my own extensions for Business Central Cloud (Sandbox): One new table and one new list page. Using the list page, I open a new card page, I have made. I am trying to find out what is possible with images in BC and therefore I have a few questions regarding the table and the card page, that I show…
-
Codeunit 131007
Hi All, Where can I find Codeunit 131007 “Library - Report Dataset”. I can't add it as a variable in my extension?
-
Controlling Cursor/Focus on Phone/Tablet/Web Client while Scanning Barcodes
Hello, some of our customer needs to use NAV with mobile devices in Warehouses. They want to make processes with bar code system. We have a problem on Mobile clients which is even you disable other fields, making false of editable and quick entry property of the page, after scanning the bar code, the cursor goes away or…
-
Access Microsoft Dynamics NAV 2016 SOAP Web Services via Azure Application Gateway
Hi, I have a client with a NAV 2016 Server instance hosted on an Azure VM. I have configured a SOAP webservice that should be accessed externally, via an Azure Application Gateway. I am able to access the WSDL page for this SOAP webservice over the internet. The problem is that when I try accessing any of the functions…
-
Business Central on Cloud (SaaS) - Export company from Production and Import company to Sandbox
I will appreciate if someone can help with explanation how to export specific company from Production environment on Cloud, and then import the same company into Sandbox on Cloud. Or, what is the "new way" to do that when client must test new development on Sandbox (development environment) with more/less real data from…
-
Purchase Invoice Extra unfilled line error while posting
I'm getting this error when i post only the filled purchase lines in the invoice. The lines from 100000-150000 are filled correctly.But when I post its showing:- No. must have a value in Purchase Line: Document Type=Invoice, Document No.=EXP/CMUM/20-21/00161, Line No.=160000.It cannot be zero or empty. Although, line No.…
-
NAV Upgrade Tool-Set
Hi NAV community. I would like to bring your attention to the tool-set designed and was used for internal use in NAV upgrade projects. It was successfully used and adjusted in 200+ NAV Upgrades from Classic to RTC and BC. Since the fact, that our company SWP was acquired by bigger MS partner, the tools are not used…