-
Danish letters in subject on e-mail using Lessor Payroll
Hi experts, I use Business Central version 13 on-prem. When I make a new codeunit and use codeunit "SMTP Mail" to send an e-mail, everything works fine. But when I use Lessor Payroll codeunit 6000802 to create an e-mail with the payslip using codeunit "SMTP Mail", then the "Subject" of the e-mail is changed from…
-
VAT check by VIES returns an error
Hej Guys, i've searched through the threads, but didn't find anything. So maybe someone faced the same problem and can help ? Since some time (about 2 weeks) we face the problem, that the vat check via VIES returns the message "error by exceuting System.Xml.XmlDocment.Load with following message: unexpected token ">". The…
-
POST request fails: Could not create SSL/TLS secure channel
Dear Experts, I am trying to post data to some https endpoint of our partner from NAV2018 When I am sending the request from NAV (i tried AL variant with HTTPClient and C/AL variant with HttpWebRequestMgt), it fails with the following error: "The request was aborted: Could not create SSL/TLS secure channel." When I do test…
-
BC: Service tier generating alot of errors
Hi, In our environment, one of the service tier for our BC are generating alot of error messages in the event log. The following SQL error was unexpected:
Cannot insert the value NULL into column 'id', table 'Database.dbo.$ndo$cachesync'; column does not allow nulls. INSERT fails.
The statement has been terminated.
SQL…
-
Are we able to hide selection before posting?
Hi all, for cloud bc, are we able to hide selection before post? I want to allow user only has "Ship" but hide "Ship & Invoice" my idea is duplicate the standard code, and then hide Ship & Invoice. any other better and efficient way? Thanks before
-
Prevent the post warehouse shipment to invoice
Hi All, when we do the warehouse shipment posting , it allows us to choose "ship" and "ship and invoice". i don't want to choose one of that , i just want to ship it, for example. where can i find the code that should i mark it, or comment it, thanks,
-
This item ledger entry has already been revalued with calculate inventory function
Dear Experts, im facing issue in using revaluation journal that i want fix a cost for an item but its gave this error: “This item ledger entry has already been revalued with calculate inventory function, so you cannot use the Applies-to Entry field as that may change the valuation.” i there to fix the posted item ledger…
-
BC: how to see the code of a codeunit
I'm new to Mibuso, so I'm confused why we put BC discussions in NAV Three Tier, but everyone else does, so I will give it a try :-) I'm also new to BC developement. I have with VS Code AL created a few test extensions from tutorials, but now I have a real task. I have a process in BC that has looong runtime and it creates…
-
How to fix WordHelper Error
Hey ho, We export a Word document from a BLOB field in NAV2018 and open it with Word. This works fine on several client machines except one which throws an error regarding WordHelper. Office was uninstalled on the PC and then reinstalled. After that, opening the Word document worked for a short time until the error…
-
Overdue Customer Balance - Workflow Condition
Hi Group, I hope this finds you well and you are enjoying your Friday? I have a question for you all. Have you ever tried to create a workflow in Business Central with a condition associated so that the customer if it has an overdue balance can be responded? I’ll try to put the narrative down on where I'm up to. By the…
-
Can I create a receipt/ticket printer report like in shops/supermarkets?
I want to print receipts like this: So there is no "new page jump" and it's a single page but it will have it's length as long as required Is it possible? I'm trying to do in Business Central
-
How to build a menu in BC?
Hi guys, can anyone guide me to show the menu on the BC, I want to group all of my pages from the extension. Very thanks for your support!
-
Multiple Companies in one database
Hi, For one of our customers we need to create many companies. Currently we have 27 companies on 5 databases. We plan to increase the number of companies rapidly. So my question is : Is there a limit on number of companies on a single database? Does the performance of the system decrease when number of companies in a…
-
Display website in classic client 14.4
For a Business Central 14, CU 4 we are creating an extension that needs to load some js and display a website. Inspired by the https://simplanova.com/blog/step-by-step-guide-to-javascript-control-add-in/ we have created the components, and it works as expected in the webclient. However in the classic client that some of…
-
REP 10083 Export Electronic Payments - Remittance Advice grouping, page-breaks (NAV 2015)
I modified this to support another bank export format - but didn't touch the layout. (Just added calls to a custom codeunit for the export bits.) But the Remittance Advice output has issues when the journal was populated using Suggest Vendor Payments WITHOUT Summarize by Vendor. (Part of requirement - cannot use that…
-
Missing column When "Send to" Excel
I added a new column to a report and that new column is showing properly when previewing the report as a PDF. On the other hand when I try to "Send to" Excel, the new column is missing as if it's not been added Any advice on why this could happen and how to resolve it? Version: US Business Central 19.2 (Platform…
-
Error: The request was aborted: Could not create SSL/TLS secure channel- In nav 2016
Hello Experts, Error Message: A call to System.Net.HttpWebRequest.GetResponse failed with this message: The request was aborted: Could not create SSL/TLS secure channel. I am facing this error while working on E-Invoicing integration.I have doubt in Security Protocol Type but used others also like…
-
How to filter a lookup in a worksheet page
Hi everyone. I'm very new to c/al coding and am struggling to set a filter on a lookup in a worksheet page. The lookup field is 'account no.' from the gen. journal line table. The table itself has a filter on this field which populates the lookup according to the entry in 'account type' and if type is 'Customer' all…
-
How to move a file between two SFTP directories In Business central Online?
How to move a file between two SFTP directories In Business Central Online? I have tried to move a single file to the SFTP directory but is transferring all the files to another directory. Can anyone help with this? Thanks in advance.
-
OAuth 2.0 Client Credential Grant for Dynamics 365 Business Central
I am attempting to connect to any of the Business Central Web Services via postman using the grant type client_credentials. I can receive a token from the call below ok: Images removed as contained sensitive Data. However, if I attempt to use this token in the call below I receive error 401. Images removed as contained…
-
Persistent User Sessions even after restarting the service
Hi, We have noticed that some of the sessions are left idle on the session list from many days ago and we cannot manually stop them (we have a mod to stop them from sessions page, using the STOPSESSION command). It normally works but for some particular sessions it just won't work. Even worse, they'll stay even after…
-
Permission to modify entry
Hi experts, I use NAV 2016. I need to change a few fields on a single Item Ledger Entry record. I have made a new codeunit that would do the trick, if only I had the permissions to modify Item Ledger Entry. I am SUPER. When I try to add the Modify permission to the properties of the codeunit, it says that I do not have…
-
Replication issue
Dear experts: I got this error message when i ran the job to replicate items from store 1 (HO) to store 2 (branch) "Cannot forward to host ******* Data Director License has reached the max limit [SubNets:1] and cannot send the data to the host. Contact your LS Retail Partner to get updated License file" What does this…
-
Multiple nodes with same name
We have XMLPort in NAV 2017 with following snippet: Node Name Prefix Node Type Source Type Data Source Id Element Text MsgIdB OrgId Element Text MsgOrgIdB BICOrBEI Element Text MsgBICOrBEI Othr Element Text MsgOthrB Id Element Text MsgOthrIdB PrvtId Element Text MsgPrvtId Othr Element Text MsgOthrC Id…
-
Purchase invoice with 0 cost and valid vat
Dear Experts: If I got items for free from a vendor, but he requested only the vat suppose 15% of the real cost. How to deal with this issue in dynamics nav 2017? Best Regards
-
Ls Data Director
Dear Experts: How can i get the license of Ls data director for more than one subnet??, the current i have it is a demo license for one store (one subnet). Thank you
-
[SOLVED] Report extentsion - RDLC layout modification
Hello, I made a report extension from the base app to add some logic and fields. How can I manage the RDLC-Layout. Is there a best practice? Or do I simple copy the the rdlc file from base app and then change the layout there? regards, Markus
-
GuiAllowed - stop pop up message for dimensions when creating Job from AL
Hi All I'm still struggling to stop pop messages when creating a Job from code, where a user clicks an action button on quote screen and it creates a Job. Pop up message appear as usual for copy dimensions to tasks I've initiated the Job and written below codeJob.Validate("Global Dimension 1 Code", SalesHeader."Shortcut…
-
Replication from HO to a store
Dear Experts: I am trying to replicate the data from HO store to another store (another location) using VPN connection, i got this error: Cannot forward to host ******* Data Director License has reached the max limit [SubNets:1] and cannot send the data to the host. Contact your LS Retail Partner to get updated License…
-
convert pdf file to base64 string
I have a pdf file stored in the TEMPORARYPATH on dynamics nav 2017, how can i convert it to base 64 string ?