-
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…
-
Can a payment be applied to specific invoice lines? Can you query for that if it is possible?
I'm using Navision 2009 R2 and querying in SQL Server, can I find if a payment was applied to specific invoice lines (assuming that's possible)? Here's what I'm currently querying:SELECT pmt.[Entry No_] , inv.[Document No_] , d_inv.Amount , sil.[Line No_]
FROM dbo.[<Company>$Cust_ Ledger Entry] pmt -- payment entries
INNER…
-
The number of keys specified in the URI does not match number of key properties for the resource
Error: "The number of keys specified in the URI does not match number of key properties for the resource" while exposing Business UnboundActions using Odata V4
-
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.
-
Dynamics mobile templates
Hello everyone! I wanna change and switch templates for dynamic mobile but do not know where to find the templates. Do you have any ideas? Please give me a hand, I very much appreciate your support.
-
Links
Hi there, I created a codeunit to insert links where I use ADDLINK etc... when I try to open the link in Nav it says "Link address is not valid" but if I add it manually the same link is OK. When I look at the Link record (See pic) the entries added by my codeunit looks exactly the same as the one added manually except…
-
NAV2017 float Feld?
Moin Moin, ich häng aktuell bei bei der Erstellen einer Schnittstellentabelle und Verknüpfung einer Externen Tabelle (.dbo) fest... Mein Problem ist, dass ich zwar die float Felder in der Externen Datenbank mit den NAV Datentyp BLOB in einer Page anzeigen lassen kann. Aber bei einem erstellen eines neuen Datensatzes…
-
help this issue The request for path /v2.0/Sandbox/dev/apps?tenant=5ab57dbe-56d1-42be-a34a-e8cddae9
-
"No active message processors listening on the message queue." Troubleshooting
This is a prompt that my clients get from time to time and restarting the service tier fixes it, but I don't know how to find the cause of the message. Especially when the service is running. Does anyone know of any tips for looking into this particular prompt further? I have a client asking and I'm not sure what to tell…
-
Add new field in the form from other table to be used as storage once data is posted
Hi, I would like to seek help from all experts here. In the Warehouse Receipt Header form, I wish to use one of the fields of the Purchase Header table into the said form so that I can input remarks and these remarks can be seen in Purch. Rcpt. Header table upon posting. Thank you in advance experts.
-
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…
-
Can't connect to sql server via NAV 2009 classic
Hello, everyone. Here's the story. I've created two machines on HyperV, "Client" and "SQL-Server". On "SQL-Server" I've installed ubuntu server, and mssql on this server. Restored company DB, set sql authentication. I've got access to DB via SSMS, sqlcmd, Azure studio on all machines, but in NAV 2009 classic client, I…
-
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…
-
How to create and send an email message in Business Central 20 using replaced
As you probably have noticed, the SMTP module was replaced by “Email – SMTP Connector” and “Email – SMTP API” apps in the Business Central 20 version and will cause an error if you use the standard SMTP module. Read the latest post on the Simplanova blog, where you will find possible SMTP mailing usages and learn how you…
-
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,
-
Link with external database / float Field
Hi Guys, I am currently working on an interfacetable and am stuck on a problem where there seems to be no search results. I have already succeeded in linking and can see the data from the external table in a NAV page. Also the advertiser works up to a point. This starts to jam when it comes to the data type "float". I…
-
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…
-
Report layout - afbeelding in tekstvak
Goedendag, Ik gebruik Report Builder voor het aanpassen van de layout van een report. Het is een brief die op basis van een klantnummer meerdere regels ophaalt uit een tabel. (geen standaard NAV tabel) De layout heeft een body en een footer Ik wil in een Textbox in de body afbeeldingen toevoegen (embedden) maar dat kan…
-
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…
-
Workflow Events Predecessors not showing up in top of the workflow events and not showing up in bold
Hello, I am facing an issue in not displaying of Workflow Events Predecessors in top of the workflow events and not showing up in bold either.. We have designed the workflow as per the base General Journal Line Workflow. We have developed the functionality as per the Microsoft's standards. We have created and added -…
-
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