-
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
-
Empty role center, detailed menu and pages after upgrading to BC24
Hi all, after upgrading from 18.6 to 24.3 I have an empty role center and the detailed menu is also empty, more or less. When running a page via url parameter like ?company=CRONUS%20AG&page=32 I only see No., Description and fields I've added with page extensions. When running a tabe via url parameter like…
-
Set If condition for Data Exchange Definition in Business Central
Hi All, is there a way that we set if condition for data exchange definitions? so for example with some criteria i want to export it as "V". other than that, i want to export it as "I"
-
Permission Error After Login - Docker
I setup a Docker container and install latest version. Everything went smoothly and service is ready for connection. Connected to http://bc23/bc and user name, password worked. Unfortunately, I am getting the following error. We used the client license W1during setup which was download recently from Customer Source. Do we…
-
License Issue on BC21 - posting purchase invoice
Hi, I have received the following error when posting a purchase invoice testing a customer license. I'm wondering is there is a specific granule I need to order, the system is BC21 on prem. "Sorry, the current permissions prevented the action (Codeunit WMDonald Subscriptions Execute: Base Application). Please see image…
-
Odata V4 & Odata Web Service Error but SOAP is working
Hello, on the web Services Page, when we click the URL under OData V4 & Odata URL, getting Message 'This XML file does not appear to have any style information associated with it. The document tree is shown below.' and no Data generated but when running the SOAP URL, we can see the details on browser. Anyone has this issue…
-
FET and Sales Tax
Hello- I have a client that has a unique requirement i have not come across. They have items that have a FET (federal excise tax) added to specific items. These items require this 12% tax ALWAYS. However, that specific customer might also be tax liable and depending on the area, have a 6% tax added. So this single item…
-
Extension dependencies
I have some trouble designing an extension in AL. My extension uses a field of a certain table in it's code (which happens to be in the OnPreReport trigger of a reportextension object) [App 3]. The field is defined in a tableextension object in a different app [App 2]. The table is defined in yet another app [App 1]. I…
-
how to solve field error in BC
Hello, I am trying to register a purchase order in BC, but I get this error,Shipping No. Series must have a value in Sales Header: Document Type=Order, No.=V-002. It cannot be zero or empty., I already filled out the fields and it still shows the error
-
Business Central Extension - Table not showing in CAL
Hi everyone, I don't know if it's possible, but my question is: Is there any way I can view a table created through an extension in CAL? (same question for viewing table fields in CSIDE created through an extension) The BC version I'm using is 14. Thank you very much.