-
How to check if Outlook is running - NAV 2016
Hey there NAV gurus, When sending mail trough NAV mail doesn't get sent if Outlook isn't open (create mail window pops up, if the user clicks 'Send' mail goes into 'Outbox' of Outlook. Mail gets sent only after the user starts up outlook. We're using CU 397. I've come up with a code which opens Outlook (see below). Is…
-
Insert new line on second List Part - The view is filtered, and the entry is outside the filter
Hi Guys I have created a second list part on the Service order screen to show service item worksheet table rows, second list is filtered by the service item lines . same hierarchy such as sales lines and item tracking lines. all works when viewing records however I cannot insert a new record to the second list part (items…
-
No. Series settings don't update on card page
Hello, friends! I have an issue with No. Series. When I make a change (for example, enabling manual entry), it doesn't reflect on the corresponding card. As you can see from the screenshot, when I open it from the three dots (AssistEdit), the "Manual Nos." option is disabled, even though I have enabled it from the No.…
-
Filter lookup list
Hello, friends! I would like to ask for your assistance. To explain the situation I'm in, I'll try to give an example using a page from the Base Application. Let's think about a Sales Order. We have two tables: Sales Header and Sales Lines. I want to ensure that the lookup list, meaning the list that shows up when…
-
Error :- Completely invoice must be yes
Hi All, While receiving transfer order I'm getting the below error. The transfer order is successfully shipped. But on receiving the below error pop up:- "Completely invoiced must be 'yes' in item ledger entries: entry no:****. Current value is no" Also every time I try to post the error show a different item ledger entry…
-
Changes to record cannot be saved because some information on the page is not up-to-date
Hello, In the "Item Variants" page we have a customized field "Packsation" - "Packtisch". By validating or changing this field, the new value should also be updated on the "Packstation" field on the "Sales Line" table. The error occurs in the Item Variants page and not in the Sales Order Subform page Therefore, I have this…
-
Change log entries retention policy
Hi, I am wondering if the retention policy for all BC accounts is locked for change log entries. The retention period is locked and set to NEVER DELETE by default. How I set it, to delete my Change log entries.
-
Problem writing a handler for a report with a request-page
Hi! I'm testing MS Dynamics Nav (https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-testing-application). I have a problem writing a handler for a report with a request-page that is run before the report starts to execute. On the request page need to specify a parameter for the…
-
Selecting a specific report layout in code based on table field? [BC24]
Hi all, I have a single report to display technical details of five very similar but different items, and five different layouts in the rendering section. Is there a way I can specify which one to use through code based on a Report Layout field in my record, rather than having to get the end user to select the report…
-
Prepayment Sales Amount reporting - Not possible? - Business Central Online
We are not able to do item reporting from the item ledger entries and value entries for prepayment sales, We have a client that does a 100% prepayment After the prepayment has been posted, and the sales order is then shipped and invoiced, the system does not reverse the pre-payment and post the invoice, rather it posts the…
-
Table 'Tenant Media' is missing
I would like your help with the tableTenant Media' is missing when I create a record variable. thanks TenantMedia: Record “Tenant Media”; is missing
-
Call an API using Power Automate to Import sales Order(Business Central Codeunit)
Hello All, we are using Business central(SAAS) and have 3rd party extention. A text file is generated by some process for sales Order outside BC. How can we write something using POwer automate to use that 3rd party API import sales Order API when the new file is getting generated.
-
BC 24 - Current User OnPrem
We are currently upgrading from BC 22 to BC24 On Prem. We send notifications based on current user (in Email Accounts). In BC 24, it is not recognizing the Current User. When we add client id and secret in "Email Microsoft Entra application registration" and click "verify registration", we get an error. Steps to…
-
When can we download the next On-Prem version?
ON-PREM Is there a fixed link to know the exact release date of BC versions or releases on-Prem? I think it is better to delay installation by few days if a new version releases soon. What do you think?
-
nested web tiers
Hi, Can 1 nav 2017 web tier talk to another nav 2017 web tier? I need to setup a web tier in our dmz, but want to have it talk to an internal navapp tier server rather than connecting direct to the db server. Thanks, Baz
-
Change profile based on Client Type
Client wants to use a different role centre / profile (i.e. a heavilly simplified) etc when connecting via phone ( mostly to do approvals ), but have a full profile via the web client. This didnt sound like it would be hard to do... but I am struggling. Code like the below works on a normal action... but I want it to…
-
Cannot Download Symbols in BC24 On-Prem
I am trying to download BC24 (On Prem) Symbols. I am getting an error. I checked all the dependencies. It looks correct. I have all the dependencies in .alpackages. It is not recognizing any base nav objects. I am getting missing objects for all base nav tables, Version: US Business Central 24.3 (Platform 24.0.21458.0 +…
-
Adding Shipment Date to sales order list page in mobile view
Hello everyone, I'm using Business Central Cloud and I would like to add 'Shipment Date' to the sales order list page in the mobile view. Can anyone suggest how to do this, either with code or other functions? Thanks in advance
-
Install w1 and GB versions of BC on same machine, business central v24?
Usually we do all developing on w1. I need to do something specific to GB now. How do I go about creating a GB instance on the same machine? Please don't suggest docker, the damn thing won't work for me.
-
Email Attachment
Our customer is using BC23.1 When I am trying to send an email with attachment (PDF), I am getting this error "The Tenant Media does not exist. Identification fields and values: ID='{00000000-0000-0000-0000-000000000000}" The error is generated in this line when I do the attachment: EmailMsg.AddAttachment(FileNameForEmail,…
-
Determine which SQL Server version to restore from Bacpac file
Hi, So I already export my BC database to azure storage, and download the bacpac file. How do I know which SQL Server support my bacpac file? Thanks
-
FindSet deprecated?!?
Fired up VS Code with runtime 11.0 and got this little varning. What should we use instead?
-
Executing cURL from NAV
Has anyone written C/AL in NAV to execute a cURL command? I'd love to see that. Many thanks
-
Error 'Optimize_For_Sequential_Key' when upgrading a BC140-C/AL to BC220-AL
Hi there! I'm running through the upgrade steps for migrating a modified C/AL BC140-solution to BC220 (https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/devenv-code-conversion). Im stuck at step 6: "Create a new application database for development". In the administration shell of BC220 I run…
-
Business Central
Does anyone know of any extensions which adds jobs to the inter-company functionality? Any help greatly received
-
AL Base APP export all objects
Hi All, Is there any way to export all base APP objects into a text file? I'd like to continue using something like "where used" tool as Prism is paid and expensive. I've found this link below but the command doesn't seem to exist.…
-
How to create Document Signature in JSON File for Cloud BC?
Hi All, I want to generate JSON file with document signature. anyone know how to generate p12 file to become signature? like this
-
How do I get all my variants from the API? The query only gives me 250 and not the 1300
How do I get all my API variants? The query only gives me 250 and not all 1300. I have a problem with my code in AL for Business Central. What I am trying to do is to get from the shopify API all my variants that are a total of 1300 and insert them into a table created in Business Central. When I run the code if you do the…
-
NAV Service start error
We're facing a issue that NAS Service doesn't start. System events error: La sesión Microsoft Dynamics NAV Application Server para el inquilino 'default' tiene un error permanente y no se reiniciará. Motivo: Type: System.ArgumentException Message: Ya se agregó un elemento con la misma clave. StackTrace: en…
-
Importing a Google Sheet into NAV
Has anyone written CAL in NAV (2017 for example) to read data from a Google Sheet? If so, I'd love to see that. Many thanks