-
User interected fields in NAV/BUSINESS CENTRAL
Hi BCExperts, I need your valuable suggestion on below query!! Is there any way to get a user modified field through code? For example, I want to prompt an error to user if he/she modify a field that is blocked for her/him. For this i have subscribed OnAfterOnDatabaseModify event from GlobalTriggerManagement codeunit. But…
-
'TableData 2000000001' doesn't exist and ndo problems
I have just migrated my NAV4 SP1 database from SQL 2000 to SQL 2008 through an SQL restore. I' have windows authentication and various roles per user. Users with SUPER rights are getting the error that 'TableData 2000000001' does not exist. Users with other roles are getting the error that 'The Execute permission was…
-
Code coverage: time spent per object?
Hi, I´m trying to find some performance issues and as you know, it is tricky, specially when the code has a lot of bespoke and facboxes you are not aware of. Do you know if there is any tool that tells the amount of time spent in each object? This could ease the search between them. thanks.
-
Insert a line at the end of a table
Hello, I'm sorry if this question has been asked before but I couldn't manage to find an answer to it. I'm trying to insert a new line by pressing "Insert button" which is created in a form, that line I wanted to be the last line in a table(If other lines exist) The function Rec.INSERT would insert the line and it would be…
-
Print MediaSet (or stream) on business central
Hi folks, I have a kind of weird request. My customer made me save a .pdf file on the item record. I saved it in a MediaSet data type filed. I can save/delete/download it without problem. Now he is asking me to print it. I'm working in BC16 so I can't/don't want to use temporary path or whatever. I wish to print the file…
-
Connector for integration from PDMP to Navision 2017
Nav 17 integration with external system, want to suggest connector which connect both and having web-socket feature. Please suggest thanks.
-
Passing credentials through SOAP Header in XML to connect to NAV Web Service
Hello, Hoping someone has come accross this before, but has anyone connected to a NAV Web Service to create data in a table and passed the credentials through the SOAP Header section of the XML within the envelope? NAV Version: NAV 2017 NAV Authentication: NAVUserPassword I am using SOAPUI to Test and I can insert data…
-
How do i find the developer?
Have an add-on to an old version of Navision 3.6. The ID range is 14017060 to 14017065 "Posted Deposits". Version # BC.FCR.01.05 Is there anyone who knows which company owns this range or somewhere I can look it up? .. Would like to delete old Posted Deposits (Say 2003 to 2010) just wondering if it effects anything or does…
-
Employee Turnover chart report grouped by months
Hi am trying to create a report that should calculate the turnover(Total number of leavers in a period / Total number of employee in that same period X 100) and the report should also group the turnover per month. I was able to get the turnover for the whole period but not per ,month. kindly assist.
-
Can we apply OrderBy on any field in NAV Services?
I am fetching data on scrolling in a table. On each scroll it fetches 100 records. Now i want to apply sorting on each field so that when user click on a specific heading it sort data on fetch data on scroll. Issue what i am getting is sorting with scrolling is working fine for Date values and Invoice numbers but not…
-
How to call webservice which Require Json structure and XML as attachment using REST API .
Hi i am trying to call an API which require Param as Json file structure and xml file attachment as body .
-
How to Setup Service Module
Hi, what do i need to setup in the service module to get this desired functionallity... When an Item gets sold to a customer, sometimes a Service Contract (OHC) should get invoiced to the Customer as well... This Service contract will be a Contract for Maintenance of the bought item. So it should be something like this:…
-
I have not action "Open in Excel" on pages BC16.
We have two the same databases but in 1st database I have this action in 2nd - not. Excel version meets the system requirements of Microsoft. Permission sets include either the D365 Excel Export Action permission set or the system permission 6110.
-
Sort records based on Date
I am trying to sort the records of Item Ledger Entry to give me the expiration date as the earliest date relative to today(). If there are 2 records let us say in ILE Entry No, Item No, Expiration Date 1, itm01, 5th of October 2020 2, itm02, 10th of October 2020 3, itm03, 11th of September 2020 I want it to be sorted as;…
-
Adding a Tracking Spec Line through AL Code?
rec_trackingspec.init(); if rec_trackingspec2.FindLast() then rec_trackingspec."Entry No." := rec_trackingspec2."Entry No." + 1 else rec_trackingspec."Entry No." := 1; rec_trackingspec."Creation Date" := WorkDate(); rec_trackingspec.Positive := true; rec_trackingspec.Validate("Item No.", rec_SalesLine."No.");…
-
Clear All fields in a form
Hello, I'm sorry if this question has already been asked before but I couldn't manage to find an answer to it. a form has been created with a couple of fields, checks marks, and an "Add" button which will add all these fields into a table. My question is I want once that button is pressed all these fields in the form…
-
Can´t Undo Shipment - got error There is not enough space to insert correction lines
Hi, Then I try to Undo Shipment on a Sales Shipment I got this error messages "There is not enough space to insert correction lines" I am using NAV2016 Kind Regard Mats Gustavsson
-
Trying to find a codeunit to help me automate posting shipment.
I am trying to write a Job Queue codeunit that will at an interval try to post sales shipment from Sales Order. I have looked into Sales-Post (Yes/No) and Sales-Post codeunits and could not find a procedure that I can use to Post a Sales Shipment from a Sales Order document. What codeunit is available that will assist me…
-
How to copy data from multiple table from one DB to other DB in sql server where Timestamp is used.
I need to copy a set of tables from one DB to another DB, the tables structure is the same but the problem is when using Import/Export wizard I'm getting error that for table. Timestamp is used as column for all the set of tables which we cannot use for copy, so some one please suggest how to copy the data from db to db.…
-
Table locking on approval with Workflow Step Instance table
Since moving to NAV 2018 (R1) and now using the newer Workflows for approvals, we have a lot of locking that occurs. For example when users send for approval from the sales order, they receive an error due to the Workflow Step Instance table being locked. It is intermittent. I have looked through the code around the…
-
"Schema of the file is not supported."
Hello everyone, I'm getting this error when trying to open navision through citrix "Schema of the file is not supported." Any one got this before?, anything to check ?. Please help me with your suggestions. I found only the below post , when I googled with the error.
-
Nav 2016 Json Page Api Postman Issue
Hi, I am using Nav 2016 CU1, in which i have created a List Page-50000 on table Item Ledger Entry and have used 3 fields (Item No.Remaining Qty & Location). When i publish this page in web service, the ODATA link is working nav server & on my local machine (i.e; on public network). But when i run the same in POSTMAN, it is…
-
Creating Report DataItems via VS Code
I have gone through the tutorials and trainings on VS Code. I think by far, the most difficult part of it all, is creating report data items via VS Code. Even using the standard snippet, this gets very cumbersome. When I tried creating a very complex dataitem (e.g. a BC Sales Invoice), I ended up switching to the classic…
-
Is NAV 2015 compatible with SQL SERVER 2019?
Planning for SQL Server upgrade, I would like to know if NAV 2015 is compatible with SQL SERVER 2019? If not, what are the other version of SQL Server available that are compatible with NAV 2015
-
The connection to the server was suspended
Hi, I am getting "The connection to the server was suspended" from NAV 2017 web client. Your help will be much appreciated. Regards, Evyn
-
Displaying field from a form into a table
Hello Everyone, I'm new to Dynamics NAV, but I created a form with two buttons("Add" and "Exit") and some fields. These same fields already exist in a Table. What I'm trying to do is after filling the form's fields, then I need to press the "Add" button so all the values from the form's fields needs to be added into the…
-
Going to a job list crashes the system.
Just one computer crashes NAV (it just disappears) every time you go to the job list (<company name>/Home/Jobs/Jobs or N050 Job List-Advanced (11014549) -- yes, we have ToIncrease installed ). I uninstalled NAV, stripped out every registry entry, every appdata entry and deleted all C:\Programs* NAV folders that remained. I…
-
Error while opening sales order in Nav 2016 equiped with SQL 2014.
Hi All, Below is the error while opening Sales order. Error: Microsoft Dynamics NAV Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "Latin1_General_100_CS_AS" in the equal to operation. Statement(s) could not be prepared. Page Edit - Item must close.OK Thanks in advance, Srinivas.
-
How to create a Reservation Entry?
Hi experts, I'm using NAV 2015 and have created a purchase table with some purchase lines. Now I need to register one or more Serial numbers and/or Lot numbers regarding one of the lines. How do I do that using C/SIDE code? I have tried this, but it doesn't create anything: // I have found the purchLine doFullReserve :=…
-
Incorrectly Posted Invoice
Hello all, I am completely new to this program. I am replacing a woman who left very suddenly and has given me almost no guidance. I made a mistake and posted an invoice and did not also receive the shipping. How can I fix this? If anyone can please help I would appreciate it so much. I feel very lost in this program and…