-
Sales order report print issue.
Hi Everyone, I have created a sales order report, in which I have used Tablix in the body part. I need a divider between the fields up to the footer, whether the data is 1 line or body is empty or 10 lines are there. I have attached two images: in the first image, I have shown my issue, and in the second image, I have…
-
NAV 2013 R2 - Absolute Drop-Dead Date
Hi All, I know it's a vague question, but I'm trying to draw a line under the "we absolutely positively MUST be off NAV 2013 R2 by.." conversation. We've passed 'out of extended support', and the sky hasn't fallen. What's the 'next thing that will kill us'? Assuming we want to remain reasonably current on hardware/OS; is…
-
Publishing Extension from VS Code for BC 2024 wave 1
Hello experts. I recently updated my environment to BC 2024 wave 1 and I am having a weird error when publishing from VS Code. Can someone help me fix this because I am just publishing the sample extension provided in AL: Go! Here's the error message: The request for path…
-
Production Order Component - Unit Cost
Good day, We use standard cost and the unit cost for some of the items of the production order component lines is $0. These components (purchased items) have a standard cost in the item card. Does anyone know where it is getting the unit cost of the items in the production order component lines? Thank you, Rudy
-
[Solved] SMTP Mail and TLS
Hello, One of our customers wants to switch his email delivery to Exchange Online. However, when sending the test email in the SMTP setup, he received the following message: "The mail system returned the following error: "Error sending mail. Authentication failed because the other party closed the transport stream." After…
-
Values are not shown in RDLC Report
Hello, It seems to be very simple, but for some reason that I don't know, the values of the variables are not shown in the report. The process enters the condition and assigns value to the variables, in fact I added a Message so that it would be displayed on the screen, which it does. Variables:…
-
BC creates strange date filters
In an environment we get a strange filter when we use a filter shortcut. When entering Y, we get the year 2023 to 2024. When entering P1, 01.01.23..31.01.23 appears. We could not find a setting to correct this. Do you know what the problem is?
-
enable / disable options on report request page
Hi, I want to enable or disable options on a report request page regarding to values coming from record objet, the fact is this options are only handled in OnIntReport trigger and in this stage the record objects are not yet loaded. please to help me to perform this task. This is the options i' m talking about :
-
Dropdown field width
Is there any way to customize or handle wide fields in the drop down list ? Have a client that made their no series very wide... so the fill number isn't visible on the drop down window. Would love to make the 1st column wider.. but not sure its possible ?
-
Changes to record cannot be saved because some information on the page is not up-to-date
When i try to change the unit of measure code in the sales line it always throws me this error and i dont know how to fix it?
-
Upgrade to BC21 (OnPrem) - error when syncing TableMigration
Has anyone come across this issue below, all the tables cannot be located. I can see them in SQL. This occurs when syncing the table migration app (the empty one): - Task 14 of upgrade to BC21 Sync-NAVApp -ServerInstance $ServiceBC21 -Name "TableMigration" -Version 1.0.0.1 (this is the empty version) I then get the…
-
Posted No. Series
Hello everyone. we use dynamics BC14 and we have a requirement to have different posted sales invoice no series than the originally defined one in sales & receivable setup. we can do this manually buy changing the posting no. series in the sales invoice, but we are looking to automate it by validating the no series…
-
Dynamics NAV (on-prem) to Infor WMS (cloud) integration
Has anyone integrated Dynamics NAV to Infor WMS? We're looking at the possibility of doing this and was wondering how other people have done it.
-
How can FINDSET fail after NOT ISEMPTY
I've been seeing a very weird issue in our BC14 CU19 code where the following fails: [...]
IF NOT ItemAnalysisView2.ISEMPTY THEN BEGIN ItemAnalysisView2.LOCKTABLE; ItemAnalysisView2.FINDSET(TRUE, TRUE); [...]
END; ItemAnalysisView2.FINDSET(TRUE, TRUE); fails with the error that no record has been found within the filter.…
-
Data Exchange Definition for simple BACS export
This is in fact a very similar question to this one: https://forum.mibuso.com/discussion/75127/data-exchange-definition-export We are trying to set up a DED that would export multiple headers, detail lines and footers. The problem is that Payment Methods only allow linking 1 line of the DED, so you can either export a…
-
BC to Get Value from Redirect URL
Hi All, I am using cloud bc to do integration with external party. from BC --> External Party for login --> redirect url back to BC. it will open anothr web page with this link --> https://businesscentral.dynamics.com/sandbox?code=6c4ebcd6a63522731674e761ac27554b98de474c My question is : 1. I want to use this…
-
Table ext field not being reference in the page ext object
I have added field in a table extension to the User setup table but when creating the page extension, the fields are not being referenced. the table extension is as below the page extension is as below
-
Continia Payment Managment Error 1003 when Import Status From Bank-ClickOnes Client
NAV 16-ClickOnes Client Helle Experts the user gets an error when click on mport Status From Bank , dose any one know why i we get this error ? the certificate and the licens key have been upgraded three months ago. Thank you Best Regards. Firas
-
http requests to https endpoint with invalid ssl certificate
Hey guys, I'm communicating with a web service on a test system of one of our partners. This endpoint uses a self-signed ssl certificate for its https connection. When I browse to it using a browser, it gives me a warning that the certificate's issuer cannot be validated, but I can proceed ignoring it or creating an…
-
Business Central Version 22 and Microsoft ARR
-
Send to Excel
I have BC22 Cu3. When print Trial Balance and send to Excel it create two sheet in workbook. Why??? There is reason? come, can I avoid it?
-
Getting "Invalid Date" on Item.Get() or Item.FindFirst
This issue was resolved. I missed one of the date fields when I did my tests on the Item record. It did indeed have some kind of corrupted date. updating that date with SQL resolved the issue. Thanks, Michael Hi, In Business Central 14 (we are using the C/AL version with windows client), Today we started to get the error…
-
Make list part expand fully when in a group with a field?
I have a list part in a separate group on a page. I need to add another field in the same group. When I add, it looks like this: I need the list part to fully expand, not be half and half like this. I tried adding in subgroups to the field, to the list part and to both at once but no matter what I do they are divided half…
-
Cloud BC to get Location Name instead of Latitude, Longitude
Hi All, understood that Business central is able to get Latitude and Longitude but is it possible to get the location name instead of Latitude/ Longitude ? Thanks.
-
BC Dimension Issue BC 22 On Prem
We recently moved to BC 22 on Prem. We are noticing a weird issue. In Purchase Line and FA GL journal , we have to enter short cut dimension ( 2, 3,4,5,6,7,8) before shortcut dimension 1 . If we enter Shortcut dim 1 before other shortcut dimensions, somehow it does not recognize shortcut 1 dimension. It says that the…
-
Cannot edit the description on Sales Quote Line.
One of my user cannot edit the description on Sales Quote Line and got "We have no further details about this." but she has a Super Permission and Dynamics 365 Business Central Essential License. Could you help me to solve this case?
-
Error Updating 'Requested Delivery Date' Field Automatically Upon Item Insertion in New Record
Hello, After inserting the item I want to automatically update the 'Requested Delivery Date' field (it is a new record), however, the field value shows empty in the record. It is worth mentioning that while debugging the code, I entered the filter of the line 'if SalesLine.FindFirst() then begin': In addition to that, when…
-
Erase an unused company in BC20
Hi All, In /My settings/ in my BC20 sandbox i have tried to create a new company which failed at the end of the proces. The name of the new company is created but it is not possible to select. Now i want to erase this company. How can I do that? Best regards Bent Dalsgaard
-
Set a Delay on sending emails (Outlook) possible?
Hi, In BC 23.4.15643.15715 (cloud). This is probably more a question for Outlook, but any creative solution would be welcome. We are using the customer statement report to send emails in bulk. We were wondering if there would be an option to set up a delay in the emails so that we can review the emails sent in BC (from the…
-
Nav 2017 Web Client/APP - Certificate Error
I've been trying to set up a web client to work with the Android NAV app and through web, and the error I've been getting is that the certification SSL key is incompatible. But first, I have been able to log through other PCs within the domain, and although it works, the https is crossed out red in color and says it is not…