-
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
-
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…
-
General Journal Post via Job Queue?
I have been researching a bit but really haven't found anything definitive. I am really new to Nav, we are using Dynamics Nav 2018, especially on the backend/development side of things, but essentially we have users going into General Journal, picking their employee Batch name, then putting a bunch of entries in here, then…
-
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…
-
Employee Portal Web part design
Dear All I have designed a card form in sharepoint using a webpart for employee portal now I want to arrange the controls in a sequence just like we does with navision form using drag and drop facility, how can we do so with web part form? Please guide.......