-
VS Code Target Platform Not showing Business Central 2020 Wave 2
Hi All, I have installed Business Central 17 Wave 2 and also the VS code. When i am opening VS code and on Command Palate Entering AL GO,The Target Platform is not showing Latest version. It is displaying Versions up to 4.0 Business Central 2019 Wave 2.My web client is working Fine and it is showing BC170. But VS Code is…
-
Sales invoice header and sales invoice lines creation via web services?
I want to create a sales invoice through the api and I'm wondering the best way to do this Do I need to create a sales invoice header first, and then insert sales invoice lines parented to the sales invoice header that I insert or is there a way to do this as a single web service api transaction? This is for business…
-
BC Database to BC Database via API
Can someone help me on transferring data from a BC database to another BC database with an automated process using API it should not be via config package. it should be a soap as codeunit will have a function with parameter for recordref so 1 database call the soap, a codeunit function, send a recordref and other database…
-
How to build a report - tree to consume components along with lot numbers
Hi to all. I would like to build a report - something like a tree to consume components along with lot numbers. There are several levels of semi-finished products in my production. I thought to exit the Item Ledger Entry table, but I don't really know how to build a loop. I think I need to change the entry type once in…
-
report 10412 "Check (Check/Stub/Stub)"
This following function in Report 10412 in Dynamics 365 Business Central is for setting Check Format for Employees. In this function I think instead of BankAcc should be BankAcc2. local procedure ApplyBalancingTypeOfEmployee() begin Employee.Get(BalancingNo); if Employee."Privacy Blocked" then Error(BlockedEmplForCheckErr,…
-
SystemId, SystemCreatedBy, SystemCreatedOn etc. - SQL
Has anyone found where the new system fields are actually stored in SQL?
-
Attaching a Buzzer for KDS print
Hello, we use LS Business Central version 14.02 and we run hospitality where we want to alrm the chef in the kitchen when a KDS slip is printed. to do this we have attached a Bixolon Melodist buzzer on the RT12 port (cash drawer port) on the Toshiba 6145 LAN OPOS printer we use. the challenge is to get the "open cash…
-
Add Open in Excel action to ListPart page
Hi all, Business Central provides the Open in Excel action as a built-in feature on some page types like List oder Worksheet. I am currently in the need of having this action applied to a ListPart page but this type of page doesn't provide it per default. Is there a way to add it manually to the action list by AL code or…
-
Get-NavServerUser for a specific user
Hi, Is it possible for Get-NAVServerUser PS Command be used to get info for a specific user? Jordi
-
RMS to RMH
As Dynamics RMS is being discontinued by Microsoft RMH is replacing Has anyone done upgrade from RMS to RMH or replaced or can anyone advice on Integration with NAV with RMH ? Thank you
-
Business Central Cloud, import large files?
Anybody here knows how to import large amount of records to Business Central Cloud, from CSV file? First i tried by Rapid Start with full amount of Customers (207000 records), not working. Then I tried with 5000, not working. Anybody here who can help?
-
Changing G/L account in Purchase invoice line reset unit direct cost
Hi, maybe it is a dumb question but can't find a setup or a way to avoid it. Navision 2017 I create a purchase invoice, as line invoice i used type: G/L Account No. : my gl accouunt Quantity : 1 direct unit cost : 100 then i realized that i wrongly choose the G/l Account . As soon as i change it , the direct unit cost is…
-
BC16 Onprem - Access REST API (secondary instance)
I have configured a second service on the server using NavUserPassword authentication. Created a self-signed cert, applied thumbprint. Created web server instance. Enabled API Services in config. Web Client login works fine. OData works fine http://server:7058/BCExt/ODataV4/Company(name)/svcName API, gives a 404 error when…
-
Previewing Report Data Sets (and reports in VS) in BC2020 (web only)
Hi All I'm spending a lot of time customizing reports and it's extremely unproductive without a) having the ability to view the data set's data (in RTC I could use Ctrl-Alt-F1) b) being able to preview inside VisualStudio, like I can with SSRS reports Anyone got a solution for either? Thanks mark
-
Can't find System.Data.SqlClient dotnet, do I have to install something?
I can't find the System.Data.SqlClient dotnet so I can send a SQL query to an external SQL server I have to install something? I'm looking for this groups of dotnets: System.Data.SqlClient.SqlCommand.'System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'
-
SAF-T localisation for portugal
Hi all, I am working for a software house integrating our software with Dynamics NAV for a client in Portugal. We were asked to implement a certified SAF-T (Standard Audit File for Tax) solution for signing our invoices. We asked first our NAV partner in Portugal, if it can be done in NAV. But he stated that there is no…
-
Put away in D365BC
Trying to understand what triggers a posted receipt to create a warehouse put away. I am using the latest version of BC 17.2, have have ticked Directed Pick and Put away and have setup a standard put away template and flagged the create Put away. I am stumped as to why the put away document is not being created when the…
-
I am trying to print an invoice in landscape, but it only prints in portrait
Using Nav2017, tried printing to several different printers, all print in portrait. change the settings on the printer to only print in landscape, still prints invoice in portrait. tried from desktop computer using windows 7, laptop using windows 10, etc. Can print to a PDF, this works fine...Landscape, directly to the…
-
Workflow Notification E-mails Not Sending
We are having an issue where the out of the box workflow notification is not sending the e-mails in BC. There is an error in the job queue - A call to MailKit.Net.Smtp.SmtpClient.Send failed with this message: No recipients have been specified. We can send a test e-mail successfully from the SMTP Mail Setup - to people…
-
How many CAL/AL developers do microsoft engage for NAV/BC?
Hi, This is something I have always wondered about, I'm also sure the number fluctuates. Approximately how many CAL/AL developers do microsoft engage for maintaining/developing NAV and BC? Regards & Thanks Roddy
-
Problem with updating BC V16.5 to V17
After Update from version BC16.5 to V17.0 Application Database Version is still V16. All steps from the documentation are done. After update the webclient starts, but from the development environment i cannot publish my extension because of the Application Database Version V16. Synchronisation is done. Navdataupgrade is…
-
Sending a report without attaching it
Hi everyone, I'm working in a customer with NAV2017. Is it possible to send by mail, a report (sales shipment for example) without attaching it? For example, sending an hyperplink in the mail body, and the receiver of the mail will click into that link, and download the PDF. Thank you all
-
BC365 - Error You do not have the following permissions on Page Customer Card: Execute.\r\n\r\n
Hi having a question we want to insert a record in BC365. Authentication goes well, (with AAD registrerd application) we can make a connection but when we want to insert a record we are getting the error message "code": "Internal_ServerError", "message": "You do not have the following permissions on Page Customer Card:…
-
Running report from Task/Job Scheduler
I'm trying to run a report that execute some SQL queries in NAV 2015 If I run the report manually it's working perfectly, but when I set it into the Task Scheduler it give error as it has an automation that is trying to load in the client. I've changed the CREATE parameters to (FALSE, FALSE) instead of (FALSE, TRUE) so it…
-
BC365 - Error calling Web Service
Hello, I have the following code and it throws an error when run, any suggestions that might help resolve the error? Thanks in advance Error: NavHttpClient Request Failed Code: codeunit 50401 ImportXMLMessage { procedure ImportXMLMessage() var SOAPAction: Record SOAPAction; OutStrm: OutStream; InStrm: InStream;…
-
Downolad file from SharePoint
Hi All, I am trying to download file from SharePoint Online to NAV 365 BC 130 and if run following code I get an error. Upload file to SharePoint works fine but download file not. Please, Does anyone have experience with this, or could someone advise what is wrong and how to fix it? I'm really helpless now :( Thanks a lot,…
-
BC17 - Changing Object Name - Translations
Hi! I have noticed that when I change the object name in my project in Visual Studio Code, by using F2, to also change references in whole project, I am loosing translations for this file. I have noticed that "base xlf file" is changing the "trans-unit id", but it remains the same in my translations file. Is there a way to…
-
Publishing a Base App from powershell, issue with adding a new field to existing table
Hi, I'm in the process of upgrading our vertical to BC17, this is a modified base app rather than extensions. I can add a field to an existing table and publish via VSCode and all is well with the world. However, when I publish via powershell, I run into a problem. When running a page with the new field, I've added a test…
-
Missing DotNet System.Linq.Expression assembly
Hi , I am trying connect NAV to SharePoint and i need dotNet Variable System.Linq.Expressions.Expression. I have figured that DotNet Assembly Subtypes System.Linq.*** are not available under the Assembly list in NAV 365BC 130. Please, Can someone advice, What should I do to get those assemblies? Thanks a lot, Dominik
-
ODATA API Select and Insert
Hi NEWBIE to API, I want to create a small API to list customer order header, customer order lines of that document and possible update. So, I created two entity pages one for header and other lines and published. Can access them via the browser. By passing the document number in URL…