-
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…
-
SQL 2008 vs AutoIncrement
Hi I' ve a SQL Table which contain a field IDREC as primary Key with property Identity = yes When I try to open the table in Nav 4sp2 I receive the following error : "The Table xxxx contain a field which Autoincrement value daesn't match IDENTITY status of SQL Server : field IDREC" Navision AutoIncrement property is set to…
-
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
-
Importing Excel File From C/AL Side.
Hello guys, I want to import excel file from C/AL side in NAV 2009 version. Windows window should appear and let me choose the excel file I want. In newer version, it's easy using Codeunit File Management, but here in this NAV version there is not one. I searched for other ways but zero progress. Can you guys give me a…
-
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…
-
Event OnAfterDocumentPrintReady is not raised during printing in Business Central 18
Hi Everyone I'm trying to subscribe to the OnAfterDocumentPrintReady event to define what happens when a user chooses to print a report. The problem is that this event, in Business Central 18, seems not to be raised. Even using the "Event Recorder" I can't find it in the list. (Event Recorder BC18) I think that the problem…
-
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 ?
-
how to add a QR code
How to add a QR code NAV 2009 R2 Thank You
-
Change LCY in a company
Hi, Our customer is using NAV 2009 R2 and in one of the companies in the database, the (blank) LCY code should be changed from th national currency to EUR. As we see it there are 2 options: * Use "Euro Conversion Tool". MS has a tool for NAV 5.0 but we have never used it before and the database is highly customized. *…
-
HideDialog When background process create pick list
Hi All I'm struggling to hide the dialog box (nothing to handle ) when creating warehouse picks from code unit. The aim is to create a process that can be run using job queue that process warehouse shipments and create warehouse picks. When there is inventory or no prior pick list for the Whse Shipment the code works but…
-
Changing cursor start position in a page
Hi everyone, I have a custom page with two text box filters and then a repeater. When I open the page, the cursor is by default in the first line of the repeater. I want it to be in the first text box filter. How can I achieve that? Thanks in advance :D
-
Business Central version 15 (On-premise) - Long Running Queries
Statement: BeginTransaction IsolationLevel=65536 I am seeing random occurrences of the above statement noted as "long running SQL statement" in the service tier's event viewer. I sent this to MS and all I got back was the definition for Repeatable Read. I know what that is. What I'm trying to dig into is shy these take so…
-
Nav 2016 - Installation problem (SQL Server instance exists but....)
Hello, I'm facing problem with nav 2016 installation. I've just installed new SQL Server and next I wanted to install NAV 2016 on that. The question is about Server Instance, I don't want NAV to install Sql 2014 express just use that server which I installed previously (2016). I'm leaving the Sql Server Instance field…
-
How to install eksisting Dynamics NAV 2009 R2 on a single client..
Hi. Hope that somebody could guide me in how to install our eksisting Dynamics NAV 2009 R2 on just a single client.. Reason for this is that it runs on a server today, but as it is only used for looking up old data as it is not used anymore we want to take and just have in on a client instead. It is version DK 3.70.A…
-
Introducing Simplanova Chatbot for BC Customer Support
Simplanova invites Dynamics partners to join the free webinar "Introducing Simplanova Chatbot for BC Customer Support". This webinar will demonstrate the main QnA, issue logging, and knowledge base building features of Simplanova's Teams bot. We will demonstrate a provisioned example, and attendees will be invited for a…
-
Deployment of app file to Dynamics BC OnPrem
hi, In BC Online, you could upload and install app files. But this is not possible in OnPrem. Does this mean all changes to OnPrem installations have to be deployed via VS Code only?
-
Swiss QR Bill Management for NAV 2018
Does this exist anywhere?
-
User-defined views crashes client.
Hello, one of our customers has reported the following problem: An employee has created a user-defined view for pre-scheduling delivery notes, which are documents from which the actual delivery notes are created, refer to Table 36, the document type has been expanded here by an option. This view included filtering for a…
-
Copy Files to BC Docker images
Hi, I have created BC docker and it all works. How do I copy files from local host to docker? In this blog --> https://simplanova.com/blog/how-to-start-using-dynamics-365-business-central-docker/ there are detailed steps on how to do this. It says that I have to stop the container to copy files using "Docker CP" command.…
-
Dynamics BC Online Production environment Upload Extension Error
I face the error below when attempting to open "Extensions Page" in BC Online Production environment. What is curious is, I can open this same page in a SandBox environment. I just cannot do this in Production environment. And I am logged with the same user with the same permissions. Permissions assigned to the current…
-
Parameters in the cloud
Hi experts, In an old NAV, I have a solution where some code is added in the middle of codeunit 80, procedure PostItemJnlLine. The code must only be run sometimes. It is controllede by an extra parameter on the procedure. So depending on where PostItemJnlLine is called from, the extra parameter is set to true or false. How…
-
Adding parameter to Report 292 Copy Sales Document
Hello, I am facing the need to add some parameter to use it in events of codeunit 6620 CopyDocumentMgt I therefore made and extension of the report 292: requestpage { // Add changes to the requestpage here //DOC @001 27.06.22 sis.mk - layout { addlast(content) { field(WithTechData; WithTechData) { ApplicationArea = All;…
-
NAV 2017- Positive Pay Modifications
Hi. I need to modify the file output of one of the two "stock" positive pay definitions. In past versions I just edited the simple code that spit out the file. But in this version it's all wrapped in configuration stuff. I can't find any real documentation on the specifics of the field definitions - and I'm hoping I don't…
-
HTTPWebRequest error handling vs PS Invoke-WebRequest
Hi, In Powershell, if you use Invoke-WebRequest, and if there is an error, you will get the full error message. e.g. However, in NAV when I use HTTPWebRequest, I only get the error message: I tried using Codeunit 1297 to return the webexception, and tried all the properties in websexception, but I could still not get the…
-
SQL License Question
Sorry, forgive my ignorance. I could get this right in my mind. Customer will have 50 NAV2018 users in an On-Prem environment. One SQL2019 server on Windows 2022 server. Another separate Windows server 2022 for Navision Application Server. Only NAV accesses the SQL using a single windows domain user name. May be one or two…
-
Business Central - check internet connection
Hi, Is there any way to check if the Business Central OnPrem has access to the internet? Some method like IsNetworkAvailable():Boolean ?
-
US Sales Tax
I am asking for help from any members who are experts on US Sales tax. When you tick the Expense\Capitalise field in Tax Details, the system calculates tax, but posts it to the same account as the cost, but seems to stop creating tax entries? Is this correct? Is it because that by saying you are expensing it, you are in…