-
NAV BC Planning Worksheet Page (99000852) - Column Sorting
Hi Everyone, Is there a properties field where I can allow column sorting for the user so when they click on the column it will sort? It was by default in NAV 2013 and now it seems users can't sort on this and other pages. Thank you
-
Sales Document with Wordlayout and various tables
I hope, somebody here can help me :) I want to design a sales document with a word layout. The most of all works fine, but I have a problem to print 2 tables which are in a relation Example Sales Line 1 - Additional Line 1 - Additional Line 2 Sales Line 2 - Additional Line 1 Is this possible to do in word? I don't found a…
-
Get the Number of the day eg 150
Hi, How in Business Central code can I get the current day in it's number equivalent. So for example 1st February is the 32nd out of 365. Thank you.
-
NAV 2017 - Prevent NAV from converting a backslash to a CRLF
Hi everybody, Is somwbody knows how to prevent NAV from converting a backslash to a CRLF ? I created a we service that return a JSON as a text and I apply a Json.Encode(myJsonText) to escape all the special characters. The problem is that the Json escape the special characters by adding a backslash and in place of return…
-
Can we post Transfer Orders in Job Queue just like sales and purchase orders.
Hi, One of my client is facing locking error when posting of Documents so I've implemented posting of sales and purchase documents in job queue using background posting functionality present in "Sales & Receivable Setup and Purchase & Payable setup", but to post the transfer orders in the same way i cannot find the setup.…
-
Error in USPS (Address validation API)
Hi, I implement a function in VSCode to use USPS API to check customers address. But I have this error Someone can help me ?
-
Sorting column in ExcelBuffer NAV2018
Hi everyone, I'm new with dynamics NAV and I'm currently working on an Excel export using ExcelBuffer. I would like to know if it's possible to sort data in ExcelBuffer based on a specific column. My problem is that I need to process data from several sources and have calculated data on which I have to sort. So I can't…
-
Display Object virtual table on Page for BC
Hello I am traying to disply the content of the "Object" vertual table on a page (table number 2000000001) we are using business central 15 wave 2 on Prem. It would be nice if i can get an answer here. Thank you Best Regards. Firas My page looks like page 51160 Vtable { Caption = 'VTable'; PageType = List; ApplicationArea…
-
How to import all type of files in a page in business central
Hi i'm new to nav , how we want to import files in page by clicking action or assist button of a field in business central Thanks in advance.
-
Extensions permission set not coming up after publishing
hi All, I hope some1 can help. I´m running D365BC on premises. For some reason extensionsPermissionSet.xml does not come up as a new permission set after publishing. The other thing I´ve realised it is not including table extensions on the permission sets? I´ve got another extension and this one works fine. I tried as a…
-
[NAV2017] Drilldown page on flowfield not showing
On the sales order subform page (displaying Sales order lines), I've added the flowfields Item."Qty. on Purch. Order" and Item."Qty. on Sales Order". They're showing up just fine, with the correct values. I now want to show the pages Purchase Order Lines respectively Sales Order Lines with the lines corresponding to the…
-
Please anyone with idea on how the below screen shot error message can be resolved. Kindly assist!
-
Task recorder for BC ?
Hi, in D365 Finance you can use the "task recorder" to capture a process and this integrates with Business Process Modeler within LCS. Has anyone come across a way to replicate task recorder within BC? Thanks.
-
How to set the Accounting Periods for the inventory stock not at the last day of month.
My NAV ERP system use the monthly weighted average cost. Usually, we will inventory stock at the last day of month and create the next fiscal period. if i want to inventory stock not at the last day of month, how could i set the Accounting Periods for the inventory stock not at the last day of month?
-
Configure Live Metrics from Azure Application Insights
**Apologies if this is in the wrong category** Hello, I'm trying to connecting application insights to my SaaS BC server and take advantage of the live metrics. I was hoping someone has done this in the past and would be able to give some advice. I've never messed with the actual code of BC so Im not sure if these links…
-
NAV BC - Missing Columns not visible
Has anyone experienced this in BC? We just noticed that this page (39) General Journals is missing 2 fields even though in the properties everything is equal to true for visibility and false for not hidden... We noticed early on that we had to hit Show More Columns in order to view more columns that were not originally…
-
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…
-
OK button on StandardDialog page
How to prevent closing page after clicking OK button if error occur?
-
JSONBuffer
Dear all, I'm trying to read a JSon File withing the JsonBuffer table. The structure of my Json is the following : What i'm trying to achieve is getting the coordinates out of the Json file to store into database fields. I'm trying to achieve this by the following code : codeunit 50112 HttpGeoCodingMgmt
{ procedure…
-
Blog Series Part 8: Combine Sales Document and POST in AL for MSDYN365BC.
This will be the Final post of development in this Blog Series which will describe how can we post the lines created in the Insurance table and update the Insurance lines based on the posted document. If you haven’t read the earlier article Blog 01 – Customer Requirement for AL Development Blog 02 – How to Develop ……
-
Create xml signature in a Secure Envelope in NAV2017
Hi. I would like to create an xml file, and in the Signature there is a tag called DigestValue. The content of this file is calculated based on Method in the feild DigestMethod. My problem is that I cannot find a description of how to calculate the content of DigestValue. Thankful if anybody could point me in the correct…
-
Manufacturing Finance Assistance required
Hello, Some bad bespoke has resulted in Inventory WIP still being present in Finished Production Orders. We could Create a General Journal to migrate the WIP Value from the WIP G/L to the Finished Goods Adjustment G/L Code set up. This however still leaves the Value Entries in WIP and therefore an unbalance. How is it…
-
How to rename the error?
For example I have an error And I have to change text in this error: "Unit Price LCY" to "Unit Cost" How can I do it?
-
services module functionality
Hi experts!! NAV2018 I have a new project for a company that rents machinery. The machinery it rents is the company's fixed assets, not products. I am looking at the services module but I do not see anywhere how it can be rented a fixed asset, only products of services and products. I have thought about creating service…
-
Unexpected or wrong xRec in OnModify
Hello there, (I'm using NAV 2016 (9.00.47838)) I got a strange problem by using xRec in OnModify: I want to do something only after OnModify if a boolean field is changed: Ensure that only one record is the Default record. IF Rec.Default AND NOT xRec.Default THEN BEGIN The problem is: Sometimes are Rec and xRec equal! Yes,…
-
SAVEASEXCEL in old format
Hi there I have client which is working on Dynamics NAV 2017. There is one function which is creating one of the reports in excel and send on their customer e-mail. The problem starts when some of the customers use old xls formats and they can open only xls formats. When I'm using SAVEASEXCEL function the format by default…
-
NAV BC - Grey Area on Sales Order
Hello Everyone, Is there any way to make the ship-to address section 'ungrey' in order to add 1 time info. We would just like to make this editable after selecting the ship to code
-
NAV 2016 - scanning barcode/QR using Android phone and camera?
Hi everyone, does anyone has experience with scanning barcodes/2d codes using Android phone and rear camera? I tried to use standard NAV functionality to take picture, save it to server and then feed picture to ZXING.net library which has capability to decode barcodes/2d codes. But my solution is not reliable. I tried to…
-
Cash Receipt With Different Customer Name
Good day, Our NAV system is integrated with an online payment system that exports customer payment transactions into NAV. In turn NAV would automatically generate invoices and cash receipts for our customers. However, there is something wrong since one of our customer's cash receipt is generated with a different name (NAV…
-
BC13 - Copy company
Morning, Is anybody familiar with the error message: tenant numeric id must be set Im trying to copy a company in BC. But when i try to do that the client closes with above error. In the past the database was part of multitenancy, but migrated back to single tenant. I cannot find a solution for this