-
E-mail Vendor Remittance from Payment Journal
Dear Friends, Need you help in sorting out my issue that I am facing. I have few payment entries in Payment Journal for few Vendors (Account Type is Vendor in PJ). Say, VEND0001 VEND0002 VEND0003 VEND0004 VEND0005 Requirement: I need to send email to Vendors and Vendor Remittance report as attachment in it. I have placed a…
-
Handling Internally printed labels - Business Central (14) (on Prem)
We have a range of labels that we internally print from a plain label, that are applied during manufacture (which may be to order or to stock) To ensure we know which label to print we put it in the BOM, so a prod order will call for Label-0901. Label-0901 doesn't physically exist. We print a Label-0901 from Label-0001 and…
-
How to modify Factbox width in webclient?
Does anyone know the secret how to modify the width of factbox area in webclient? I have a control-add displaying a PDF using pdf.js - works very nice in Windows Client, but I can't get it to work in web-client, as it's seems locked to it's default width no matter what I try with my control-addin. I know the CSS parameter…
-
PowerShell: Get-SqlLogin
Hey there, maybe someone who is more into PS can help. I want to use the Get-SqlLogin command on powershell (see: https://docs.microsoft.com/en-us/powershell/module/sqlserver/get-sqllogin?view=sqlserver-ps). But it seems like i am missing somethin: I cannot find out which "Import-Module" command allows me to import the…
-
The best way of Creating a Webservice while installing Extension in MSDYN365BC.
Hi Readers, Once we have created our Extension, we might need to auto Publish the web service when we install the Extension in Microsoft Dynamics Business Central. Continue reading
-
Create webservice in NAV2018 to use in external app, return JSON with item information
Hi All, I need to create a webservice in NAV 2018 to be used in an external app. The webservice is called for a specific item number, the webservice should return a JSON with some relevant information of this specific item. I have a hard time finding a good example which is covering this issue, can anybody provide me a…
-
Error in event log for Business central 2020 Wave 1
I'm getting the following error/warning in event log. Unable to find defining app group for table with ID 2000000120, when initializing query from app group 2. Anybody know what it is?
-
BC14 Upgrade til BC16
Hi all Im looking for a guide for upgrading BC14 to BC16. I tried to use the BC15 guide, but without success. Anyone who knows howto or the guide? Best Regards /Erik
-
NAV WebClient, unhandled rejections
Hi We are experiencing some issues with unhandled rejections, but with a little less information to give: Error accessing Website Unhandled error occurred on a browser or device client: { "clientInfo": { "platform": "Win32", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko)…
-
How to install microsoft dynamic 365 business central on cloud?
I have an subscription on azure and i want to install MSD365BC, anyone know how to do that? Thanks :blush:
-
Export NAV Objects without language/translation
Hi Community, Is it possible to export objects from development to txt without language? Mergin objects with translations is pain in the cheek. Thanks
-
how to use textattribute in BC
Does anyone know how to use the textattribute in an xmlport in vc...?
-
How can I add lookup to a report field?
I am working on Aged Accounts Payable Report and I want to add a lookup to the Name field just like the other fields have. How can I accomplish this without adding a table relationship?
-
Business Central web client Login
I want to know if it's possibile configure BC to use Login page to authenticate users using Credential Type Windows and not NavUserPassword. Trying windows Credential type configuration, when non domain user tries to connect to BC, popup window is shown for insert username and password.
-
On-Premise object id range 50000-99999
HI All. For SaaS, 50000-99999 is 'free' meaning you can use any object number for any object type in that range for any app. Is this range also free for on premises? Or we need to get the object in customer license. Could someone explain this. Thank you.
-
how to copy records from one company to another company using configuration worksheet without excel
Hi everyone i need to know how to copy records from one company to another company in business central thanks in advance.
-
How to learn .NET?
Hi Guys, Does any of you know of a good resource to learn how to use .NET in a Dynamics NAV context? Any advice is much appreciated. Thanks, Thomas.
-
Business Central - purchase line - update shortcut/global dimensions
Good day, I am looking for a hint on how to update shortcut dimension codes on a purchase line, after an update to line dimension values. Here is the code I use to update the purchase line dimensions with values from external system: procedure AssignLineDimension(DocumentType: Integer; DocumentNumber: Code[20]; LineNo:…
-
ODATA - Adding header and lines in one call/round trip
Hi :) Hopefully someone here can help me with this, I'm finding useful documentation and examples for ODATA in Business Central hard to come by. I have custom tables ("Inbound Job" and "Inbound Job Task Line"), the usual page (InboundJobQuotes) and subform (serviceLines) setup for ODATA web services. Using Postman I can…
-
Powershell: Use Users full name of windows account to create NavServerUser
Hey there, I am creating a new local Windows User with a full name this way:New-LocalUser -Name "User03" -FullName 'testname' -Description "Description of this account." -NoPassword Works fine. Now I want to create a new NavUser and use the full name of that windows Account. Hardcoded it looks like:New-NavServerUser…
-
Upgrading Business Central Spring 2019 On premise to CU4
I upgraded a BC 14 version to cumulative update 4. All went well and the application runs, but... when i open extension management in the converted application, I find the standard installed extensions still being in the 'old' version. For example the 'Paypal Payment Standard' extension has version v.2.1.29537.0. When I…
-
Mobile App - How to make the list scroll automagically
Hi Guys, We have a list form with the a single field above it for scanning. User scans Item Nos in that field and list below is being populated. When it is being run on the computer the newest items are always on the top (list auto-scrolls to show top most item). When the same page is opened on the phone app, the list does…
-
Account Type or Bal. Account Type must be a bank - FIXED
hi all, im doing a payment import and getting the following message.
-
Usage of CurrPage.SetSelectionFilter()
Hi, I have got a question about this standard C/AL code. It is in Page 132 (Posted Sales Invoice):SalesInvHeader := Rec;
CurrPage.SETSELECTIONFILTER(SalesInvHeader);
SalesInvHeader.PrintRecords(TRUE); What is the first line of code doing here? It kind of looks like its selectiong only the current record. But if so, why not…
-
Mobile app something went wrong "unable to localize service.."
Hi Mibuso, I try to connect to a BC Cloud with domain "blabla.onmicrosoft.com". The BC mobile App cannot connect to the tenant. If I connect using a browser it works like a charm. (same login information) Where is the problem? (I supposed it's something with the ..onmicrosoft.com) The error [translation from french] on the…
-
Extension Download Symbol Error
Hi all, I have upgraded database from nav 2009 to bc 14 but when i use visual studio code to download symbol it's error. FYI, I already done this step cd C:\Program Files (x86)\Microsoft Dynamics 365 Business Central\140\RoleTailored Client finsql.exe Command=generatesymbolreference, Database="Demo Database BC (14-0)",…
-
The Sales Header does not exist
Good day, I have a job queue that would automatically generate invoices and receipts for your customers. Unfortunately it is now giving errors: The Sales Header does not exist. Identification fields and values: Document Type='Invoice',No.='INV-00555459' and no more invoices or receipts are being generated. Could someone…
-
DotNet passing "Missing" parameters
Hi experts, I'm trying to use the DotNet variables in NAV2009R2, the Microsoft.Office.Interop.Word assembly to create some automated document creation. Looks like it works in the beginning but I have a little problem. Almost all of the methods require parameters as "ref" - wordApp.Documents.Add(ref object Template, ref…
-
Something Went Wrong - WebClient external access deployment in Azure VM
Hi experts, My problem is I'm having problems granting external access to the NAV webclient and there is no much info I can get from the error (all I get is "Something went wrong") or from the event log (the most meaningful message I get is "ThreadPool.MinworkerThreads…"). I don't know what else to look at so any…
-
Updating Excel without losing formatting
Excel Buffer provides a functionality to update worksheet - but the trick is: it is forcing new cell Decorator during update - function WriteCellValue looks like this: [External] WriteCellValue(ExcelBuffer : Record "Excel Buffer Advanced")
WITH ExcelBuffer DO BEGIN GetCellDecorator(ExcelBuffer, Decorator); CellTextValue :=…