-
Error - The Posting Date doesnt lie in Tax Accounting Period
Validation Results - "The Posting Date doesnt lie in Tax Accounting Period" Any Clue on this error while creating Bank Receipt entry with TDS Section having Parameter "Calc Over & above Threshold" set to Yes Business Central Online - India
-
After BC upgrade from 14 to 20 on-prem, can't install Email - SMTP Connector and other apps on DVD
Hi all We upgraded version 14 to 20 and it went smoothly. We can run the web client and the data is there. Everything looks fine. Now we want to publish additional apps from the Applications folder, but when we run the Publish-NavApp in Powershell it appears to not be published because we can't install it and if we run…
-
"Internet browser is not installed" error message BC13
Using Business Central 13 CU 6 users who have upgraded to windows 11 are now receiving the message "Internet browser is not installed" when attempting to open a document via the attachments fact box. I can see in NAV 2018 this was fixed as a platform update in cumulative update 48:…
-
Version 20 debugging, always breaking on UserPreference.modify
Since upgrading to version 20, every time I run the debugger from Visual Studio it breaks immediately on standard code in the Rolecenter Selector Mgt. codeunit, 1485, shown below procedure SetShowStateFromUserPreference(UserName: Code[50]; State: Boolean) var UserPreference: Record "User Preference"; begin if…
-
How to execute functions in codeunit across multiple database
Hi, We have four databases ( and some companies on each of them) , and we want to write the codes of functions in only one of the database and execute functions( as job) on all of them. Is there a way to do this? Our aim is having the code in one place so that we can ensure that it is same for all databases, companies.
-
Change Tax Amount on Purchase Line by AL Code
Hi All, I'm trying to build an integration to an external system to sync purchase orders and lines. There are small rounding differences between the two systems. Tried setting rounding on general ledger setup but the reality is it's never going match 100%. What are the options to set tax amount on document lines? Couldn't…
-
Creating empty container (CSIDE)
Hey, I am looking for the best way to create container with c/side version that would contain only those objects that are present on some client environment. The easiest way that comes to my mind would be to create container with no objects inside (no standard) and then import *.fob with desired objects. Is this possible?…
-
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…