-
Creation and Export of BACS Files NAV2018 using Data Exchange Definition
Following the removal of the feature "Creation and Export of BACS Files" from NAV 2018, I have been investigating how to create a new Data Exchange Definition based on BANKDATACONVSERVCT to create a payment export file for the UK BACS file. The BACS file consists of a csv file containing the following fields: Payee Sort…
-
NAV2018 - UK BACS Export with headers and Footers
Im currently working on the HSBC BAC Export for a customer in NAV 2018, which has had all the BAC's functionality removed by MS. The BACS file is a standard 18 file format as shown below : VOL1000024 801014 1 HDR1A801014S 180101400002400010000 10243 102450000000 HDR2F0102400100 00 UHL1 10244999999 000000001 DAILY 000…
-
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…
-
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…
-
Reversal transaction G/L Entry No. and Vendor Ledger Entry No. are not the same
I'm trying to reverse a transaction in business central, but when i do it i get the error "Reversal found a Vendor Ledger Entry without a matching general ledger entry." The codeunit 17 "Gen. Jnl.-Post Reverse" It is based on G/L Entry No. and Vendor Ledger Entry No. will always be the same but in my instance they are not…
-
Intercompany Module
Hello please i create a function where using from bottom to send to Company partner in the same instance , from Posted Sales Shipment This my code for the sales line is not generate correctlly i dont why not inserted Unite of measure codeunit 90110 TTMgt { TableNo = "Sales Header"; Subtype = Normal; Permissions = tabledata…
-
Commit() in Page Extension Action button
Hello Experts. I have a few questions regarding Commit() function and would appreciate some clarifications. 1. is Commit function in a page extension action button risky? I have an action button that modifies a table column and right below that a preview posting function. (GenJnlPost.Preview(Rec)). it's returning an error…
-
.net Insert Null Date with SOAP WS (Nav 2018)
Hello, With .net (vb) wich date i have to use to set it null in Nav. SqlDateTime.MinValue or 1753.01.01 are not accepted by the ws and do an exception.
-
Double Purchase Invoice for Intercompany Transaction
Hi, I got this message after I post sales invoice for intercompany transaction "An invoice with number xxx has been previously received through intercompany. You have an order and an invoice for the same document which can lead to duplicating information. You can remove one of these documents or use Reject IC Document." My…
-
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…
-
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
-
Export Navision Table Data PRO
Export Navision Table Data PRO Quickly export desired Navision data from any table to TXT file. http://www.mibuso.com/dlinfo.asp?FileID=350 Discuss this download here.
-
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…
-
What’s new in Dynamics 365 BC version 2024 Wave 1
Dear Dynamics Community Members, As the new version of Dynamics 365 Business Central is coming, Simplanova is organizing a webinar with Stefano Demiliani, Microsoft MVP for Business Applications. During the webinar, you will hear detailed information about What’s new in Dynamics 365 BC version 2024 Wave 1. Register now…
-
Email encoding
Hi, Cannot figure out why the Navision has started to sending the emails with wrong text encoding for German characters. The server settings are all set to German, anyway no changes were made. Any suggestions what should I try? Thanks, Toni
-
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…
-
How to setup SMTP Mail for Outlook in NAV 5.0 SP1
Hi, We are running NAV 5.0 SP1 and I need to setup SMTP Mail for Outlook through T409, F409, CU400. I cannot get it to work, get error: Failure sending mail. Authentication failed because the remote party has closed the transport stream. I have installed and registered Microsoft Navision Mail automation v. 7.3, am using…
-
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…
-
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
-
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?
-
SMTP for Outlook 365 NAV 5.0 SP1
Hi @ftornero, I am trying to implement sending emails through smtp.office365.com from NAV 5.0 SP1, cannot get it to work. On 6/3/14 you provide link to a hotfix that is no longer available. Do you still have it or another link? "It works in NAV 5.0 without a problem, you need this hotfix…
-
Business Central Docker Container not working with hostname?
Using Docker Desktop I have created a new BC container. I am able to access it through 1XX.XX.XX.1/BC (example IP) but not through stefan/BC (which is the name of the container). My hosts file has the correct values (it updates whenever I run the container) and I have read permissions on it. Whenever I publish an app from…
-
Business Central 14 The remote certificate is invalid according to the validation procedure
We use the ECB (European central bank) exchange rate service. When i add the URL in BC, https://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml, i get error "The remote certificate is invalid according to the validation procedure". I've checked that the root certificate for the issuer Entrust is there and if i go to…
-
Control add-in error
Hi, I have a problem with control add-ins in a new on-prem BC23 NZ installation with db upgraded from BC17. Some of the control add-ins don't work. The weird thing is that it's specifying public key token a4af7ee0f073bc1a instead of 31bf3856ad364e35 Also the OAuthIntegration Control add-in is not working The control…