-
Uploading file in WebClient
Hi! I am developing some functionalities in BC17 for Cloud. I am currently working on a report which is going to open an excel file and analyse its rows. Done this before in C/SIDE versions. The problem is when I want to use UploadIntoStream function. The function takes: FromFolder and FromFile parameters but as Microsoft…
-
Work description field not visible on sales order page in Business Central
Hi experts, When our customer uses his Business Central Cloud (production), the field "Work description" on the sales order page, is not visible. There are no extensions or personal changes to that page. When he try to make personal changes to the page (add/remove fields etc.) the field "Work description" is NOT on the…
-
[BC 365] The wsdl of my web service is not complete
Hi everyone, I'm having issues while trying to install web services on business central. I've developped a web service on dynamics nav 2018 and I can't post it on a BC version. I used to create my web service on the web service window, and to verify if my web service was correctly posted, i used to follow the soap link…
-
A qüestion concerning a sales invoice report layout with BC and Report Builder
Hi mates: I want to implement the possibility of reseting the page number and the total pages for each DocumentNo in my report of Sales Invoice. I found the functionality to reset de "Page Number" field in this article: https://docs.microsoft.com/en-us/dynamics-nav/how-to--reset-report-page-numbers. The fact is that it…
-
BC 14 CU11 SignalR Queue and CU1 Error
Hello Everyone, Client is using Web Client for BC 14 CU11 on premise version. We are getting error of CU 1 in event viewer even though there is not reference for Codeunit 1 in any objects. Also, event viewer has "SignalR: Large Count of message in the queue" warning. I have noticed users start to have more errors when this…
-
Show Dimension value name in the Posted Sales Invoices
Hi Guys, may I ask, if it is possible to show the dimension values in the list of posted sales invoices? Specifically I only need the Dimension value names of all transactions in the list. with the dimension codes : AREA and DEPARTMENT see image below for reference. thank you for those who is gonna answer
-
How to Delete NAV Company on SQL Database
Hi, We're using NAV 2018 and we have multiple companies on our database. We want to delete a certain company including all data on it, we've already deleted it on NAV RTC but when we look on the SQL database all tables and views are still there. Is there a way to delete a company and all of its records in a simple way?.…
-
Navision 2018 CU 35
We have noticed that when printing reports from NAV 2018 on dot matrix; it actually changes the report layout to landscape. We've tried all possible items mentioned in articles mentioned. Anyone can hint us how to fix this issue.
-
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…
-
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…
-
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…
-
launching a business central page with parameters filled in?
I need to launch a page in Business central and change the company through the URL, launch the create purchase order (page 50) and have one of the required dimensions pre-populated I am thinking it would be nice to be able to launch the following URL https://mybcinstance/Live/?company=CompanyName&Page=50&dimensionParam=123…
-
help with how to create a purchase order with a shortcut dimension pre-populated in the right compan
I need to launch a page in Business central and change the company through the URL, launch the create purchase order (page 50) and have one of the required dimensions pre-populated I am thinking it would be nice to be able to launch the following URL https://mybcinstance/Live/?company=CompanyName&Page=50&dimensionParam=123…
-
JSON Nested Array
Using a website such as https://jsonplaceholder.typicode.com/users how would I iterate through the Address array within this json text? What would my Selecttoken path be if I wanted to retrieve the City of all available users? Thank you.
-
How to replicate Sales order as now one?
Hi I try to create Sales Order Change page for the situation : When user makes sales order change they must entry data in the page (Sales Order Change) and waiting approval by team leader. For the purpose ,I replicate the Sales Order include Table (SO Line Table ID 37) / Page as new one for Sales Order Change table (SO…
-
DE language package for NAV 2013
Hello, Someone can help me to find the DE language package for NAV 2013 CU11 (v7.00.36.076) . I searched everywhere on the internet without result Thank you
-
XML to JSON forcing XMLNode to be an Array
When using XMLPorts and NewtonSoft to create a json message where we have nested nodes these should be converted to a json array. But when such a node only contains one "record" it will not convert to a json array. How to get this working is explained at the newtonsoft website…
-
Planning worksheet, no join
Hey guys, maybe someone can help: Do you know how to make the planning worksheet calc function not to join supply orders for sales orders even if they have the same item no and due date? The customer wants to see a clear picture about the source of demand, it is very annoying to click order tracking on each plan line.…
-
Credit Memo Inventory Adjustment
When you process a Credit Memo it will automatically bring this item into stock. It has been requested to control this behavior to either continue as standard or allow for the Items to not come back into stock. Reviewing the options we have would it be best for me to let Standard Nav handle the Adjustments as standard…
-
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;…
-
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…
-
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…
-
Confirmation Dialog if field value is greater than certain amount
Hi, I am looking to add a confirmation dialog box to my Sales Order Header page if a user inputs an unexpectedly large amount. For example, if a user enters in a sales order with an amount of $50,000 I want a message to display in the RTC that asks the user if they would like to proceed. I have written the below C/AL code…
-
Adding new field in 'Value entry' table, to sync the data from customer table, territory code.
Hi Everyone,[NAV 2009 R2] I am trying to sync data of the field "Territory code" from customer card to the new field(Custom field) in "Value entry" table. I have written below code in new field on validate trigger, but after posting sales order; my new field is not getting update in Value entry table. New field- onValidate…
-
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,…
-
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
-
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…
-
Generic List and x-www-form-urlencoded REST API
Hi, I what I need to do is call REST API using x-www-form-urlencoded body to get a token that I can use calling other services, I'm using Http Client but what I can't figure out is how to create a list of the type <string><string> in NAV. Edit, I'm trying to use Dictionary to achieve this…