-
Why does BC pick VAT Prod. Posting Group from GL Account Card for Prepayment Invoice?
If I am posting a Purchase Prepayment Invoice, and do not have a VAT Prod. Posting Group on my Advance to Supplier GL Account Card, I get no VAT Line in GL Entry during Prepayment Invoice Preview posting. Even the VAT Entry has a line with 0 VAT Amount. But if I have a VAT Prod. Posting Group in GL Account Card, I do get…
-
Merge PDF with Bullzip PDF
Hi everyone! I'm struggling with merging different PDF documents into one. I'm working with a NAV 17. My code is almost the same as the example they use in their page, but the merge part. While they use:// Merge with other PDF files. pdfSettings.SetValue('MergeFile', mergeBeforeFileName + '|.|' + mergeAfterFileName); I use…
-
Notification test
Hi, Does anyone have experience with notification testing? I'm currently writing tests and while using handler (https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/attributes/devenv-sendnotificationhandler-attribute) I manage to check if the notification message is what I assume, I can't test…
-
Partner license
Hi, I want to use power shell to export objects to text file from the customer Production license, any work around? Thank you
-
Approval Workflows - validation instead of just applying new value
Hello. I want to create Approval Workflow for Unit Price change on Sales Order lines. I got this using standard 'Revert the value of Unit Price field' and 'Apply the new values' responses from Workflows Templates. Unfortunately - it is just applying values without validation. After change Unit Prices approval requests is…
-
Processing CDATA with DotNet variables in NAV2013
Hello I've been searching the forum all afternoon reading about how I can handle CDATA in an XML response from a web service I am consuming in NAV2013 (yes, I know, it's an ancient version, lol). I've found some threads that show how to handle it with XMLDOM, but I prefer to handle with system.xml due to the msxml.dll…
-
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…