-
SELECT * FROM
Hi, I have executed the following SQL query on a NAV Database for two different companies and I surprise to see the column sequence. It differs from one another. SELECT * FROM CompanyName$TableName; What is the reason behind it? How do I fix that ? Thanks, navuser1
-
Trying to openEdit a General Journal TestPage
Hi, I'm trying to test the Post Action in TestPage General Journal, but when i use the OpenEdit() it always returns an error saying that i can't open the page. If i don't put this option the returned error is "This Page is not open". Here is my codevar
LibJournal: Codeunit "Library - Journals";
GenJournal: TestPage…
-
Migration 2009 to 2015 - Error Object name already exists
Hi, I started a test migration from 2009 SP1 to 2015 CU 6 by using the guide from http://blogs.msdn.com/b/nav/archive/201 ... eased.aspx Now I get an error during step 11: "Open the old database with Microsoft Dynamics NAV 2013 development environment and convert the database." Error message: "The object name already…
-
How to sent notification in business central?
Is there a way to send a notification to a user when his scheduled report finish? My purpose is to send a dynamic notification to the user who scheduled a report in wherever page he is. How this notification bar works? Can this be used to diplay a counter and different notifications? I know the existance of the…
-
Page running slow / Index
Hi all, I have different companies running on same database. Problem: Running page customer list with some flowfields: In one company running the customer page it runs perfectly. On other companies it runs very slow and even closes NAV. I think it's a index problem missing those table of different , but can't figure out…
-
Save Whole Operation in Barcode
In Production Order Routing user can slelet setup time in and setup time out with an action button. How can I save those actions in barcode, so that user can scan that code instead of clicking on action button.
-
Batch Report
Hi everyone, I'm trying to create a batch report/routine that automatically updates all open POs that contain items that have had their purchase price quotes updated. This batch report will update the relevant cost/etc.. information on the purchase order lines from the item card Can anyone please help me with such a task!?…
-
Insight works shop floor
Does anyone have experience with Insight Works shop floor for BC and is willing to share
-
Silent installation Nav2016 Server failed with config xml file: error 1603
I have created a config with the following parameters: <Parameter Id="NavServiceServerName" Value="localhost"/> <Parameter Id="NavServiceInstanceName" Value="DynamicsNAV100TST"/> <Parameter Id="NavServiceAccount" Value="<administrator account>"/> <Parameter Id="NavServiceAccountPassword" IsHidden="yes" Value="password"/> I…
-
Change Image Resolution
Hi everybody, I try to change the resolution of the images imported in the field Picture of the table Item.(NAV 2017 CU 30) The different steps are: 1. Import the file into a folder located in a server (I know that the standard NAV already do this my problem is not here but in the next point) 2. Change the resolution of…
-
How do I use Job Queue in Attain?
Hello all, I see that Job Queue is not available in Nav Attain(3.6). Is there any alternative that will allow me to run a specific codeunit periodically? Thank you!
-
alternative material in BOM
Hi everybody, we recently implemented BC and one of our major issues is the use of alternative material in BOMs, so for example BOM says 2mm Aluminium sheet 1000x2000 but in the moment we have just Sheets of 1500x3000mm (which can also be used for production), so we prepare the list of required material for warehouse, but…
-
MS Dynamics NAV 2015 / LS 2015 - Navigation Pane replication
Good day! MS Dynamics NAV 2015 / LS 2015 - Navigation Pane replication; - we added new menu/group in Navigation Page called "NEW GROUP" * is it possible to replicate Navigation Pane using Jobs Replication MS Dynamics NAV version: Thank you.
-
Unable To Merge My Microsoft Accounts Into One Account?
Hello everyone. I have a lot of Microsoft accounts. It has become very difficult for me to use all the accounts separately. I want to merge all the accounts into one account. Guys, is it possible to merge all the accounts into one account? Please help me with the proper guidance.
-
High CPU load when starting NAV service tiers
After a reboot of the server I start the NAV service tiers. After the service tiers has status Running, the CPU load is 100% for about 10 a 20 minutes. I have no clue what the service tiers are doing. Anyone?
-
Report calls report and output to PDF
I created a report (A) that calls another report (B). A report has an option to print to PDF so that it shows on screen as a PDF format. But when I run report A with the PDF option, report B is not taking that in consideration and prints straight to the printer. Is there a way to transfer the PDF output option to Report B?…
-
Warehouse management
Hi all, If I need to restrict shipments (only direct shipping) from a particular BIN, which setup needs to be activated? I know there is a setup on Bin "Block Movement" for inbound/Outbound/All, but that doesn't work correctly. Thanks in advance!
-
BC 17 CU2 New Price Calculation implemented, how to import prices via interface-buffer table?
Hello, I've been trying to understand the new price calculation that has been implemented, but some things don't make sence no matter how hard I search for answers. As far as I understood for the new price calculation and management, the new Price List tables are being used. If I look into the table Sales Line in BC 17 CU…
-
Join the webinar👉 What's new in Dynamics 365 Business Central version 18
Join the online webinar on What's new in Dynamics 365 Business Central version 18. The following topics will be explored during the online webinar: - What’s new for administrators - What’s new for the client and the application - What’s new for developers - Q&A session Webinar Date and Time: Wednesday, 7th of April, 2021,…
-
UseWindowsAuthentication for SaaS
Good afternoon. I have an App working for OnPrem with this line: HttpClient.UseWindowsAuthentication(User(), PasswordF()); I need to migrate to SaaS, and then I get this error: The type or method 'UseWindowsAuthentication' cannot be used for 'Cloud' development. How can I replace HttpClient.UseWindowsAuthentication for…
-
Description formula in Recurring Journals
hello, is there a way to have something like "payment 10 out of 20" in recurring journals? Obviously, the next one will be "11 out of 20" etc etc Is there a way to make this work
-
Job Queue Report Date Format
We have a NAV server servicing different users across users from different countries. Each country is a separate NAV tenant. The problem is that if we run a report with Job Queue, the resulting report always uses the regional setting of the NAV server to display date format and decimal formats. I have tried changing: 1)…
-
HTML Parse
I have a problem with the HTML editor, my editor doesn't read the special characters like ö and ü etc. correctly. can tell me where the error is please.
-
HTML Speces in XML Document
How can I read in HTMLSpecs from XML document and save them in a table?
-
how to read blob data from c#
As you knows , NAV could store big Text string data type to BLOB data type in sql server. It works fine in NAV read and write. //---write CLEAR(Ostream); myTestRec.INIT; myTestRec."No.":='SO123456'; myTestRec."Line No":=10000; myTestRec.Comment.CREATEOUTSTREAM(Ostream,TEXTENCODING::UTF8); Com.WRITE(Ostream);…
-
How to handle errors for HTTPWebRequest.GetResponse call?
When HTTPWebRequest.GetResponse is called and no proper response is returned from the server, the code stops executing and returns some random error. I want to implement proper error handling, so the code keeps on executing without stopping here and a proper message is displayed to the user. Like we apply checks on status…
-
AL: Lists and Dictionaries
I've been looking for a good way to use the new variable types List and Dictionary to replace the use of temporary tables. If anyone here has code snippets to share on how to implement those new buffering tools in more complex ways it would be very welcome! So far I came up with this: // Welcome to your new AL extension.…
-
Transfer user accounts to another database
Is there a way to transfer user accounts and permissions (NavUserPassword Authentication) to another database with their passwords? Dynamics NAV 2018
-
Sending request body of more than 1024 characters with POST request in NAV 2009 R2 Classic version
I have a solution in NAV 2013 where i Create a request body in JSON format for a POST request. In the solution i store all the body text into a Text variable. Now i have to implement the same solution in NAV 2009 R2 Classic version, but here the Text variable can store only 1024 characters. I have tried using String…
-
permissions for receipt but not for to invoice in purchase order
Business Central. Hi experts!! I need some users to only be able to receive and not invoice purchase orders. However other users should only bill and not receive. I've created a new permission copied from "D365 PURCH DOC, POST" but I can't separate these two features. you know if it's posible?? Thanks in advance!!