-
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…
-
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'
-
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?
-
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
-
Intercompany invoices for different coutries there is calculated VAT
Hi, there is something wrong in intercompany postings... When posting a sales invoice in a company (LU) to another company (BE) with a line with an amount of 1000. When posting between different countries there is no VAT. When posting it is coming into the handled outbox transactions. So for so good. The purchase invoice…
-
NAV2015 C/AL - How do i pass parameters from a table to a user function
Hi all and a happy new year :-) I'm by no means new to NAV but i'm just beginning with application development and as such i am 'fighting' with C/AL. :-) I have an easy question which i cant seem to solve no matter what I do. I have a function 'Addnums' that has two parameters 'NrIn1' and 'NrIn2' and a result 'NrOut'. The…
-
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…
-
Error "you cannot correct this posted sales invoice because item" when correcting posted invoice
Hello, when trying to correct a posted invoice by using the correct-button I get the above message. This happens, when combined shipments for the invoice exist. The error is thrown by CU 1303, due to the fact that threre are sales shipment lines, connected to the sales invoice lines by the Shipment No.-field in Table 113.…
-
Can we select multiple dimension values for the same dimension in single journal line.
Hi All, One of our client is asking for selection of multiple dimension values for the same dimension in single journal line. For example: In JV of Travel Advance for 2 employees say X and Y the finance person given amount of Rs.5000/-. So, he need to select both X and Y dimension Values for Employee dimension. please…
-
Importing orders from XML (exercise)
Hi all, I'm doing a practical exercise for my enterprise where i'm making my stages for my software programming studies and I have to import from an XML sales orders with their headers and lines. The XML only passes me the Customer No, the Order Date for the header and the sales line type, the item no and the quantity for…
-
dynamics nav windows client hyperlink not working in gmail?
Hi Dears, dynamics nav windows client hyperlink not working in gmail.but working in outlook.Why?
-
Allow Sales Credit Memos to blocked Customers
Hi, i'm a rookie searching for assistance. I have a codeunit where I set to All the field Block from Customer when its credit limit is up to 120%. Now i need to allow blocked customers to do sales credit memos. How can I implement this? Lots of thanks!
-
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…
-
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…
-
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…