-
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…
-
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…