-
Remove a record based on a filter from a CSV file
How can I delete a record from a table based on the item No that exists in a CSV File? I have 3090 Item Nos For example, I would like to SetRange("Item No.", 'Item #1 from the excel sheet') IF Findfirst() then Delete(); and then SetRange("Item No.", 'Item #2 from the excel sheet') and so on
-
How to save an excel book with Microsoft.Office.Interop.Excel
I am trying to save an excel file as xlsx. I tried to add Local:=true but the file is open but not saved (with no errors): XlFileFormat DotNet Microsoft.Office.Interop.Excel.XlFileFormat.'Microsoft.Office.Interop.Excel, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'…
-
SMTP with OAUTH 2.0 - BC22 OnPrem
Hi all, Configured a BC22 instance with Credential Type = AccessControlService. Created an Email Account entry, Account Type = STMP: * Applied Office 365 Server Settings * Email Address & User Name = support@<domain>.com * Sender Email Account = Specific User * Authentication = OAuth 2.0 * Completed the "Set Up Azure…
-
Building a "Generic" lookup function
I have a table that references multiple fields from other tables (similar to Config. Template, although Config. Template Line is limited to one “external” table.) Each one of these fields has a “unique” lookup based on the table Relation on the field, or may be a Boolean (in which case the lookup should be Yes/No) or an…
-
Inconvenience when trying to obtain information in a report
I created a custom report in BC, information is obtained in the header, however I cannot obtain the records for the lines. I have already confirmed within Microsoft Report Builder that there is no visibility condition, so I think the problem is in the .al code but I have not been able to detect the error. I share my code…
-
Update page from subpage
Good morning, my question is simple, (maybe). I have a page and different subpages into it. Each subpage is connected to the previous subpage and i want to automate the data selection in the subpages in this way: 1 - I open the main page. 2 - First subpage shows the records i decided using the "SubPageLink" Property. 3 -…
-
Modify data inside "<cac:PaymentMeans>" (Peppol)
How do I modify the data inside "<cac:PaymentMeans>" when generating PEPPOL BIS XML? <cac:PaymentMeans> <cbc:PaymentMeansCode>Change value from 31 to 30</cbc:PaymentMeansCode> <cac:PayeeFinancialAccount> <cbc:ID>Set bankgiro value</cbc:ID> <cac:FinancialInstitutionBranch> <cbc:ID>Set to SE:PLUSGIRO</cbc:ID>…
-
Fixed Assets
Hi We have been left with an amount on a Fixed Asset below .01. Does anyone know of a way to clear off this final balance. This is in NAV2017
-
Business Central- Update Listpart Page
Hi, can anyone tell me how can I update listPart page from another ListPart Page? for example, in Bank account reconciliation page there are two part pages, 'bank account statements' and 'bank acccount ledger entries', can i i update view on Bank account ledger entries part page from Bank account statement part page ? Is…
-
Docker and HTTP send
Hi, I've set up docker with a type sandbox and I have to test some HTTP sends to an external URL (it is a government test URL for submitting tax details). However, every time I try a HTTP send I'm getting an error code 0. Is there additional setup for docker to handshake with the outside world? I am running BC22 :)…
-
Webservice <Key> Tag
Hi, In NAV SOAP web service the Read method will return a Key value. E.g. For Chart of Accounts, the Key value returned is: <Key>20;DwAAAAJ7BDEAMAAwADA=7;52265190;</Key> Do you know how the value 52265190 is derived? Is this some sort of time stamp?
-
This is actually a question for Business Central
I am trying to setup the smtp / email account to send out notifications on workflow approvals on cloud and I cant get it right. Has anyone done this and can you share how you have manage to get it working please
-
How to group with a query?
How do you group lines (i.e. purchase lines) based on fields such as location code, posting group using a query? These lines would be grouped later when the document is posted and the grouping would be split into the separate documents
-
Non Business Central tables in BC database
Hi, Someone knows if having non BC tables in the database and use them via SQL stored procedure to save additional info can affect to the Business Central performance and locks? The scenario is that, just as there are tables like "dbo.CompanyName.Table," there are other tables created, such as info.OrderLog, and many of…
-
PDF Files Error (109) when opening in Adobe Acrobat Reader
Hi all, We have noticed that some of the PDFs generated by BC, that are attached in emails, won't open in Adobe's Acrobat Reader with the error "There was a problem reading this document (109)". They'll open fine in other applications such us Microsoft Edge. The scenario is sending email statements for customers in bulk.…
-
OAUTH Token Request using Azure AD
First off, I was able to create a working call in Postman and received back a token, however, I can't seem to make it work in NAV2013. In Postman, I can use form-data or x-www-form-urlencoded, but neither seems to work in NAV. I either get a Bad Request (400), or connection forcibly reset by host error. Any tips? OAuthReq…
-
Unable to select layout! Cannot build the page 9660, the metadata object was not found.
Hello all. I ran across a very weird problem that was bugging me, and after finding the solution I wanted to share it with everyone, it may help someone else. On production environment, client was unable to "select layout", whether from the "report layout selection" page, or by running the report directly and choosing…
-
Outlook Integration - Prefers SaaS to OnPrem
Hi, Our config is completed according to Microsoft documentation. However, we have a SaaS Sandbox environment but using OnPrem for Production. We downloaded the outlook add-in files from the OnPrem installation and added them to Outlook. If you open it up, you can see everything is pointing to the OnPrem instance. However,…
-
JSONPath SelectToken Problem
Hi community, I'm struggling in JSON parsing :s - I have the following JSON { "properties": { "cmis:creationDate": { "cardinality": "single", "id": "cmis:creationDate", "type": "datetime", "value": 1673529791000 }, "cmis:name": { "cardinality": "single", "id": "cmis:name", "type": "string", "value": "" }, "cmis:objectId":…
-
App Version number: best practices / guidelines
Hi, I'd like to ask for some advice on the version number for the apps (the parameter "version" in the app.json file). We are currently using the below convention: 22.5.20231011.7 Being: - "22" for the BC major version - "5" for the application version - "2023" - year - "10" - month - "11" - day - "7" - version within the…
-
Loading Posted Sales invoices to IC Outbox
Hello all, One of our users generated a sales invoice for an intercompany partner in Microsoft Business Central. However, due to the user’s restricted access to the other company, the invoice was successfully posted but is not showing up in the other company’s purchase invoices. Typically, I can locate such invoices from…
-
Business Central - Data Exchange Definitions - Documentation?
Hi. Apologies if this is in the wrong area. I am fighting with a data exchange definition to export an EFT file. Maybe I've missed it, but is there ANY documentation about these that is more then just a skim over the surface as in MS Learn? Thanks in advance!
-
Text lines "Multicurrency" on Statement
Hi I have seen some lines with the text "Multicurrency" on a statement i a NAV2013R2 client. The lines are not a part of the customer records. Where are the lines from?
-
BC OnCloud : Deployment failed : check the country and version availability in the extension market
Hi all, I have one simple extension, and when I try to install it via Visual Studio, works everything fine, but when I try to install the extension as PTE in the TEST-Sandbox I'm getting the following error message: Deployment failed. Errors: App ID Message : { The app (or one of its dependencies) is not available for your…
-
Assist-Button not shown in Listpage
Hello, I have a somewhat strange problem with a newly created page. The page displays all lines of sales offers and sales blanket orders. The customer would like the map of the respective document to be called up when clicking on the document number. When I now open the page via the menu, the Assist button is not…
-
Include caption not working on report?
I am trying to "include caption" for a field on a Business Central report. I have added the property to the field in the dataset: The field has a caption in the table and it is translated: I have added it to the layout like this: But it just prints the raw text: Can anyone help?
-
CANNOT DELETE FIELDS FROM TABLE EXTENSIONS (Onprem)
Leaving this here for those banging their head. You cannot delete table fields from table extensions in BC23 (cu0). The workaround is to change the field to flowfilter, build, then delete the field and build again
-
Custom Lines Page Show Open In Excel Top Right
Hi All I have created a customer subpage similar to the sales order lines. However I cannot see the option to Open In Excel on top right as below (option appears as a drop down on the left). How do you add a similar open in Excel function on custom page?
-
Issue with creating a new record when filters are set on a page - Business central
Hello, I have noticed a problem in Business Central in that when I want to insert a new record on the page, there is a "reload" and the first record is selected/highlighted instead of a new blank record in which I can put the new values. The problem appears in BC15 and higher when there is a filter set on the date type…
-
Endpoint for "Item Charge Assignment"
Endpoint for "Item Charge Assignment" A requirement for an OData endpoint to fetch all the data of the "Item Charge assignment" table for integration with other software. Because the standard BC page does not return any data without the purchase or sales document context. Please see below the screenshots of calling the…