-
How to call a procedure in Business Central from Power Automate
Hi experts, I would like to make a Power Automate, where the user can enter some fields (date, text, image from camera) and then send the values to my procedure in Business Central cloud. How do I do that? I cannot find any description of unbound actions - except for making a simple codeunit and make it public in the "Web…
-
<solved> Passing parameters to a request page from another object (in AL)
Hello, We've been asked to make some processes automatic. For example running the Adjust Exchange Rates process every first of the month. My idea is to create a codeunit that calculates automatically the parameters of the request page (starting date, ending date, document number, etc.), passes it to the standard report,…
-
send email with pdf attachment Business Central Cloud
Hello, ContractRegister : Record Contract Register (184 records) TempContractRegister : Record Contract Register temporary (5 records) When I run the report, it has 184 records instead of 5. Please help me. Thank you.
-
Intercompany Invoice and Payment in BC
Hi Experts, I want to map intercompany process for my client. Below is my scenario 1. Master Company 2. Trust Company Invoices related effect should happen in Trust company (Expense account, Payable Account) Payment to be done from Master Company Bank Account. Where should I create my Vendor Invoices so that account should…
-
How to install mutiple versions of Business central demo database on the same sql server?
I am trying to setup another BC environment using the same SQL server . Anyone know how to install database components ?
-
HELP: A 'S' was expected here Error
Hi all HELP!!! ](*,) ](*,) ](*,) I am trying to login with windows auth in sql server 2000 with nav 4.0 sp1 in an existing database and server that a few minutes ago used to work and I get the message "A 'S' was expected here." and returns to the database connection dialog... Users already connected in the database and…
-
Adding new field to Base App Drop down field group view
Hi All I want to add a new field to a drop down such as sales order selecting item field group, I can only use addlast with existing field group. Is this a limitation so I cannot say set a custom field appear next to the Item No when selecting items for example?
-
How can I handle exceptions in Robotic Process Automation (RPA) workflows ?
How can I handle exceptions in Robotic Process Automation (RPA) workflows without stopping the entire bot? I'm currently developing an RPA workflow using UiPath to automate invoice data entry from emails into an ERP system. Occasionally, some invoices are missing fields like the invoice number or date, which causes the bot…
-
EURO Conversion Tool
Hello, we are working on NAV 5.1 and will need to convert our Croatian company to EUR soon. Could someone please share the latest available EURO conversion tool? Unfortunately we do not have access to the partner source. Thank you! laulas
-
"all of your selections were processed" BC message
Hi All, Has anyone seen a message like this one? It seems hard to debug, I haven't found any info. I suspect is some piece of code doing something and then BC when finishes shows this message a few times, so you have to click several times. Any ideas? thanks. Edit: it was the batch posting codeunit, there was a piece of…
-
How to implement OIOUBL 2.1 in NAV 2017 (codeunit 13609)
Hi experts, It seems to me that the newest version of OIOUBL has a lot of changes. Do any of you have the code in NAV 2017 codeunit 13609, so I (and everyone else) don't have to write it myself? Or can you please help me in any other way with this huge task? Best regards, Morten
-
Missing Codeunit 9998 and 9999 of Upgrade Routine NAV2017 to BC 14 Spring 19
Hi, I have to codeunits as part of the Upgradeprocesss. Codeunit 104000 UPG.DE and 1 Codeunit 104100 UPG Local Functionality. When I compile the objects I get the Errors: Codeunit 9998 does not exist. Coduenit 9999 does not exist. Where can I find these objects to to compile succesfully? These cu are not part of the…
-
How can I change my Mibuso E-mail address in my user profile?
I have tried to go to https://mibuso.com/account/user-profile then change the "E-mail adress" then type the "Current password" then click "Save changes" But nothing happens and I get redirected to this url. https://mibuso.com/account/user-profile?recaptcha-failed
-
Barcode 128 with fonts + sample
Barcode 128 with fonts + sample With this font and encode function you can create a barcode in Navision. The CODE 128 barcode is an alphanumeric barcode with a checksum. It is widely used an can be read by most scanners. The TTF is freeware. http://www.mibuso.com/dlinfo.asp?FileID=405 Discuss this download here.
-
How to Access XML Nodes and Retrieve Attribute Values After Loading XML into InStream Variable?
In the context of an AL extension for Dynamics 365 Business Central, I have a scenario where I need to select an XML file using the code provided below and then parse its nodes to extract attribute values. Here's the code snippet for loading the XML into an InStream variable: if UploadIntoStream(DialogTitle, '', 'XML…
-
How to import data from an XML file to BC tables?
Hello everyone, I already have the data from the XML file in InStream, I need to access each node to obtain the data and insert it into a BC table. XML has several levels, in addition to being very extensive. How can I do it? I have seen a method (y2u.be/x8AOo9j-ifE), however I have not managed to access the nodes. This is…
-
Amount on Check Ledger Entry does not match amount on Bank Account Ledger Entry
I have a situation where the amount on Check Ledger Entry does not match amount on Bank Account Ledger Entry. The are off by approximately $7000. The amount on the check ledger entry does match what was printed on the check. However the Bank Account Ledger Entry and the corresponding G/L Entries are off. The Vendor Ledger…
-
GST calculation issue
Hi, If any item is having sales price lines with price inclusive of tax then gst is getting calculated & if not that gst is not calculating on statistics & nor gst ledger entry or detailed gst ledger entry is getting created. Business central on prem version is 23.4 Thanks in advance.
-
Deepinserts not working
I have been trying to create an api page with subpage that allows deepinserts, but have failed in doing so. I have seen many other working examples, but could not get mine to work. I have been looking at https://github.com/manjusree16/AL-Demos/blob/master/CustomAPIorderExample/Table/Call_API.http and was able to duplicate…
-
To provide Vendor Payment Bank upload file
Hi Everyone, I would like to export payment journal lines in a format accepted by our bank. I have the required file format and have tried using Data Exchange Definitions, but I’m not getting the output as expected. Could you please advise how I can customize the export format? Are there any recommended approaches for…
-
To Change alternative address automatically
Hi, In Sales Order page, I woul like to change the address option as Alternative Address when user validates the posting date and want to select available ship to address and apply to SO. Is there any ways to do this customization. Thanks in advance.
-
consume an external web service from navision
Hello, I would like to consume an external web service from navision, my current version is BC 14 and i try to do it using codeunit. thank you in advance.
-
Codeunit.Run no working when triggered from event subscriber
Hi All I have a requirement to copy fields from one record to another - not a simple copy so cannot use transferfields. Something like sales order to Sales Invoice transfer of fields. I'm finding it difficult find a trigger for below [EventSubscriber(ObjectType::Table, Database::"Service Item Line", OnAfterValidateEvent,…
-
BC 365 cloud use VPN to access OnPrem webservice
1. Is it possible to configure VPN (or use existing Azure VPN) access to local webservice? 2. If it is possible, how to do that? Our customer want to POST and GET data to/from local web API. Customer has already configured VPN tunnel in Azure platform and migrating Dynamics NAV to BC 365 Saas. Any help needed. Thanks in…
-
Rollback in bulk Insert using API calls
Hi, Inserting multiple records into the Business Central database using API calls is possible. We can also combine several operations at a single request. However, if any part of the request fails, I may need to roll back the entire operation. How can I achieve this? Additionally, how can I test it in Postman? I attempted…
-
How can I automate work order creation in Dynamics 365 Field Service based on IoT sensor alerts?
Hi everyone, We’re currently using Microsoft Dynamics 365 Field Service and exploring ways to improve our preventive maintenance process. We have IoT sensors connected to equipment that can detect performance anomalies (e.g., overheating, unusual vibration levels). What we want is to automatically generate a work order in…
-
Connecting Copilot to Microsoft Dynamics 365 Business Central On-premise
Hello, I am looking for a solution to integrate Microsoft Copilot with Microsoft Dynamics 365 Business Central On-premise. I would appreciate your guidance on the specific steps required to establish this connection. Your expertise and detailed insights on this integration would be greatly appreciated. Thank you in advance…
-
Error in BC cloud migration when defining SQL database connection
We would like to know the reason of getting this error sometimes in the 1st steps of the BC Cloud Migration Setup (OnPrem to Cloud) ,when trying to establish connection to origin DB, after providing the SQL Connection String and the Integration Runtime Name. It seems to be completely random and related to the failure of…
-
E-Mails gets send but not moved to table Sent E-Mail
Hi, We have encountered a peculiar issue with one installation. It's a German BC 20 installation. From page 13 (Email Editor), the user sends an email. The body content is visible and is an MS Word document. The email is added to the table Email Outbox, sent to the customer, and then moved to the table Sent Email. The…
-
How to save an ANSI file from Business Central?
Hi experts, This is regarding Business Central cloud. When I make a file, I can set the encoding to Windows, UTF-8, UTF-16 and MSDOS. Our customer need a file with ANSI encoding. How do I do that? Hope, you can help. Morten