-
Dealing with Amazon MP Date Formats
An Amazon Marketplace VAT Calculation report no matter in what language you download it, lists dates as "30-Jan-2020 UTC" which cannot possibly be EVALUATED into a NAV 2015 Date or Datetime in a German settings computer. I suppose I have to do string processing with the month names in a CASE statement and all that. Just…
-
Automatic import file in BC 15
Hello , I have to create a drag and drop file factbox with the addin control. (BC 15) in the old version I use the "TempBlob" table, , but table 'TempBlob' is marked for removal. so I used codeunit 4100 "Temp Blob", but I did not find a solution to create a blob from a text, before using the function…
-
Extension Performance Issue
Hi guys We are using Business Central On Premise. The fields that used to be on the item table are now spread across 8 different extensions using TableExtensions. We're hitting a weird performance issue when a user open up an item Card Page or List Page i took 8 seconds for the item list to appear. there is no flow fields…
-
How to remove this error ? #businesscentral
Hello everyone, I am trying to publish my solution for hello world as a creating a pageextension 50100 CustomerListExt extends "Customer List" I am getting this error , suggestions would be appreciated. thanks in advance!
-
multi dataitem word layout report in business central
Hi, Just wondering how can we implement multi dataitem reports like 'Customer - Order Detail' in business central. If I specify WordMergeDataItem as 'Customer', report shows the records for all the customers. But it adds a page break. I would like to know if there is any other way with which I can get the list in the same…
-
Custom Report Layouts RDLC doesn't work in Business Central
Hi! It works for previous Nav, but not in BC. I added a new RDLC layout for my report. Running it, I got an error "Write operations in the database (INSERT, DELETE, and MODIFY) are not allowed for the selected transaction type." But I didn't update the tables,I just filled in a temporary table and output it. Is there a…
-
Newtonsoft JToken.Children Ambigouous Call Error
Hey, I'm currently working on a Dynamic Json Reader. For this I use the DotNet Class JToken from the Newtonsoft.Json DLL (Version 11.0.2). But when I call the Function Children from the JToken Class I get this Error Message: When I look into the Class in Visual Studio, I see that there is a overload of the Children Method.…
-
Nav 2017 - GDPR & MTD
Hi, I can see online the MTD features for 2017 were adding in CU25. Does this include all the GDPR security features too? Also is there any security updates between cu 4 and 25 / 38. Thank you.
-
Objects added on the Department menu distorts the tab of the role center page
Hello, I had developed some new objects which were added to the Departments menu suite of Dynamics NAV 2016. Once the FOB was imported, all these objects came up in a distorted manner on the tab of the role center page. Is this a common issue? Thanking you for your answers. Liizz
-
How can i change amount in words for example one lakh four thousand -> one hundred and four thousand
Nav 2016 - How can i change amount in words for example one lakh four thousand -> one hundred and four thousand
-
Unknown Excel automation in AL code inside VSCode
Hello, I'm trying to migrate report from version 2018 to BC, but the thing is that Visual Studio Code doesn't support those Excel automations. I'm struggling with that problem from a while, does anyone have idea how we are supposed to convert reports with export to excel option ? I guess there must be some kind of…
-
Move companies to tenants in BC
we have a three tier environment and i'm trying to move companies from a single tenant to multiple tenant, but when running this command on the NAV server: HowTo-MoveCompanyToTenant -ServerInstance 'BC140' -FromDatabase 'Demo Database BC (14-0)' -CompanyName 'CRONUS 1.1' -OldTenantName default -NewTenantName CRONUS1…
-
NAV close period/year
hello. when you close a period/year in NAV, does this apply for all GL accounts or you can choose?thanks
-
getting error during sending mail through SMTP.
Hi Everyone, i am sending mail through smtp in server, its working fine but when i am sending through local machine its showing error. like: the temporary file does not exist. what should i do for temporary path so that from both server or local machine take the path from server only. Thanks in advance, Mani.
-
Nav 2013 Edit Emails
Hi All, I believe the feature to edit emails before sending was introduced in Nav 2016 or 2017. This is using the Email Dialog functionality. Is it possible to implement this into a 2013 database? Thank you.
-
How to: Join Data Items to Define the Query Dataset in Microsoft Dynamics 365 Business Central MSDYN
Hi All Query objects can also perform calculations on data, such as finding the sum or average of all values in a column of the dataset. Business Central query objects enable you to retrieve records from one or more tables and then combine the data into rows and columns in a single dataset. As an … Continue reading…
-
How to add a Api Web Service
In NAV2018 we have standard Api Web Service supporting REST and Json. I want to add my own webservice using a customized page. Anyone know of any how to do this?
-
Drop Ship Purchase orders being released by warehouse shipment
NAV18 with Advanced warehousing - If we have a sales order with 3 items. A, B, & DropShip Items A & B can ship from our warehouse, today. The sales order gets released, the DropShip PO is generated through the requisition worksheet and is now on a PO. For wherever reason, the buyer has not ready to release the purchase…
-
use tax
can I use 'use tax in stead of credit memo to correct incorrect things
-
can you filter table for closing entry?
Hello! I am doing something which includes excluding all closing entries from GL Entry table. Can someone help me, please?
-
The remote certificate is invalid according to the validation procedure
The customer created a new test server. We installed Dynamics NAV2017 CU28.10.0.28682 version that connects to the existing test database. We are using a webservice to send files to external party "HL". First we try to establish a connection by using HttpWebRequest with the HTTPS url of HL and with an…
-
Development Environment - old 'Server Name'
Hi, Do you know how to change the default Server Name in NAV development environment in the window 'Open Database' (File->Database->Open)? This is my old server that doesn't exist anymore. It is quite annoying as I have a few NAV dbs on the same server and I have to type Server Name manually every time I open development…
-
job queue no rights to start the queue entries
hi, we just upgraded from NAV2015 to NAV2018. we get the error, the we have no rights to create or execute the planned tasks if we want to change the status of an entry from hold to ready. not even as superuser or windows admin. we are desperate ... is this a bug?
-
Docker New-NavContainer using external SQL server
Hi, I'm experimenting with NAVContainerHelper in Docker. I'm getting a docker image running of any NAV/BC version build or cu now. That's nice! But now I'm trying to get it running using a sql server instance and database outside of the container. I just want to update the parameters in the NAV service to do that, and…
-
RDLC Report layout for report 1322 purchase order - Does anyone have a copy?
Does any one have a RDLC Purchase order Report layout they could send me, as the default Word one isnt great..... Kind rgds
-
Report designing
I modified a report named Simulation Order report.This report is used for displaying the details of Work Order. My client need some additional details in this report .they need to view all the bin details of each component item No under each work Order component Lines. I modified the report and getting the correct result…
-
Session expired when logging on
Hello, We are currently upgrading from NAV2017 to BC14 (CU8). On a handheld scanner (Datalogic with Android 6.0.1) we use the NAV app. This works fine in NAV2017, but with BC14 we immediately get the message "Sorry, your session expired. Please refresh to continue" after log in. The App is updated to version 2.6.9101…
-
D365 BC versions comparison matrix for developers (for on-premise)
Hi guys, Hope you are well. AFAIK, there is a big difference in development process for different versions of D365 BC (13, 14, 15) - C/SIDE was retired as well as C/AL, new classes were added etc. Does anyone maintain comparison matrix for developers for D365 BC on-premise? Or maybe any blog where I can find such an info?…
-
Business Central On Premise Installation on Three Servers
Hi, we're trying to install Business Central On Prem on different servers but we're getting these errors: - when trying to open the client: "Microsoft Dynamics 365 Business Central Server is currently not ready to serve requests. Try again later, or contact your system administrator." - event viewer of the nav server: "The…
-
Table lock issue after upgrade to the NAV business Central
Item Ledger Entry table is locked always . When we checked this no user is entering data to the system but system is locked. Inventory setup has already adjusted by ; * Automatic cost posting - No * Automatic Cost adjustment - Never Please help me ASAP.