-
LS retail : text file transfert from server to pos
Hello, I want to transfer a txt file from the server to the pos. I followed a procedure and activated the "Old DD support" and check "Allow File Transfer" option. I set up a scheduler job with "job type" = Custom, codeunit 99001465 and text option "SRC=c:\temp\test.txt;DEST=c:\temp\test.txt". But it doesn't do anything.…
-
The record is already open ?
I have a page with area faxboxes, part attached documents, but I get an error, "The record is already open". It is in all companies in this environment. The same code works fine in 25 other environments. Customer Card works fine in this environment, so where to look for the error? Regards Maria Code: area(factboxes) {…
-
BC on prem V22 upgraded from V20 dreaded An Error Occurred OpenID issue?
I am working on an upgrade from V20 to V22. The V20 uses AAD and works fine. Moving to V22 means that we have to change to OpenID. I worked thru https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/authenticating-users-with-azure-ad-openid-connect?tabs=singletenant,admintool this now…
-
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
-
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…
-
Decimal number format
Hi everybody! I tried to format a decimal number to get "76543.21" using: FORMAT("Credit Limit LCY)",0,'<Integer><Decimals><1000Character,.>') This is the Navision help file syntax, but not working... the result was: "76543,21" (comma instead of dot). And if I have "zero", the result is only "0" but I need "0.00". What's…
-
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'…
-
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…
-
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…
-
This SqlTransaction has completed it is no longer usable
Hi folks, I am facing this error for days and I still can't find a solution. Here is the error: I have multiple services that connect on the same sql server instance and obviously on the same database. Our IT Managers did this for balance computing, or at least this is what they said. This is part of the stack trace,…
-
Browse a "network" folder and import files (pictures) - NAV 2016
Hi First - i'm not all that familiar with the 3-tier yet and therefor I struggle a little on different development issues. One thing i'm working on (and struggeling with) at the moment is how to do the following We have a lot of items (fashion clothes) and needs to attach pictures in NAV to these. In the old NAV (2-tier) I…
-
User take a long time to access Dynamic NAV client 5.0 when i changed AD (hostname and IP address)
Dear ALL, I'm using Dynamic Nav 5.0 client with SQL2008 option and using Windows authentication (AD 2012R2). I upgraded to AD 2022 with a different IP and hostname (still keep old DC off not destroyed yet), then our NAV users take a long time to access Dynamic NAV app (10-15mins). it just took 5s before. is there anybody…
-
Excel Buffer Import Date Issue
Hi, I am using the Excel Buffer functions to import data in NAV from an Excel Spreadsheet. The functions are ReadSheet and ParseCellValue. The issue I am finding is that it reads the date column and somehow it always ends up 1 day earlier than the actual date. So if I have in Excel 05/08/2012 it will bring in 05/07/2012. I…
-
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…
-
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 :)…
-
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>…
-
Join the webinar: AIM with Simplanova: Earn up to $5k for each Upgrade Assessment
Dear Dynamics Community Members, Simplanova is a Microsoft Modernization Center under the AIM program and will help Partner organizations migrate end-customers to the cloud with future-proof solutions. So, we invite Dynamics Partners to join the webinar "AIM with Simplanova: Earn up to $5k for each Upgrade Assessment".…
-
Move Multitenancy
Hi Guys, Im settings up multitenancy (move to) on 3 tier setup So NAV and SQL are seperate. I have the scripts so far and now i want to move several companies to new databases. I have tried the script: NAV2017 CU2.1\WindowsPowerShellScripts\Multitenancy\NAVMultitenancySamples.psm1" -verbose and from there:…
-
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
-
Can't populate user name on a report header
Hello! I have looked into this issue for a good time and can't seem to figure out what is going on, I'm hoping someone can shed some light. One of users is unable to show her user name on the header of the report. However, there are 2 of her team members that are showing correct, with a name. We have looked at permissions,…
-
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
-
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…
-
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?
-
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…
-
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
-
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…
-
Default Views in Filter pane
Hello, I have a List page and it has a field named "Open". Also, I have Open and Closed views written in code for the page to filter on the field "Open", so that the user can click on each view to filter the records. I can see three views on the page "All", "Open", and "Closed". I have a Role center Cue to view only the…
-
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.…
-
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,…