-
xRec and Rec have same value in sales line OnAfterModifyEvent (automated tests)
We are using the Microsoft Sales Test Library to create sales lines. We have an extension where we need to log certain changes to sales line fields under certain conditions (change log won't work for what we need) We have a subscription on sales lines that works fine when we use the web client with keyboard and mouse…
-
Assign multiple values to 2d Array
How can I assign multiple values to an two dimension array and not one by one _matriz : array[2,10] of Text[100]; { {""," uno", " dos", " tres", " cuatro", " cinco", " seis", " siete", " ocho", " nueve"}, {" diez"," once"," doce"," trece"," catorce"," quince"," dieciséis"," diecisiete"," dieciocho"," diecinueve"}
};…
-
Field locked for editing
Hi, I want to edit the last modification date in the Item Card after adding or modifying the Unit of Measure records but I have not succeeded and I suppose it is because the field is blocked I have tried it this way: [EventSubscriber(ObjectType::Page, Page::"Item Units of Measure", 'OnInsertRecordEvent', '', true, true)]…
-
Auto import file from folder (Job Queue) - Cloud BC
Hi all, for cloud BC, are we able to auto import file from certain path or folder? 3rd party will export file to the certain folder.. then BC need to auto import from this folder. Thanks.
-
FIFO Unit Cost with lots
Hi all, For what i understand NAV allows the item to be batch(Lot) tracked Purchases: Posting date = 01/01/2021 Item code = A Qty = 1 Item cost = 1000 Lot No = A1 Posting date = 02/02/2021 item code = A Qty = 1 Item cost = 2000 Lot no = A2 When we make a sales order : Posting date = 03/03/2021 Item code = A qty = 1 Item…
-
Retrieve value from XML file with <
Hi I am trying to retrieve values from a retrieved XML file after making a POST webservice call. The structure of the returned XML file is - <?xml version="1.0" encoding="utf-8"?> <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"…
-
External Tables and distributed transactions
Hi all, I am a fan of External Tables. I prefer them to the linked objects for their flexibility and no mandatory use of views. I have a problem with this scenario. I have the SQL instance of Nav on a server while the external table points on a server on another instance SQL. I have to write in the external table some…
-
Problem with jobs in the work queue
Navision 2018. Created a job in the work queue. Registered the schedule. The validity period is not limited. Everything works, but from time to time the task stops working. No error messages. What could be the reason for such strange behavior?
-
Export to Excel
Hello, a user have to connect to navision using RDP. When she tries to export Vendor ledger entries to Excel, a blank Excel sheet opens. When she tried to copy the lines from Navision and paste it on the Excel installed on her Laptop, the format of the amount changes. For all 4 figures amount, the formatting is as Text and…
-
Zetadocs Express Addin unable to open docs without Internet Explorer
As Internet Explorer is being discontinued later in the year, we have started disabling it in pcs. An issue we discovered though is Zetadocs Express addin is unable to open any documents without IE. Nothing happens. We raised it with Equisys, who informed us of the below KB.…
-
Debug Onprem with AAD Authentication
Hi! We have a customer that has a onprem envrionment with AAD authentication. Is it possible to debug a user session that is connected with AAD? What I can read it isnt possible which is really awful if that is through. "AAD authentication is supported only for Dynamics 365 Business Central sandboxes. AAD authentication…
-
Webservice with table datapercompany=no
Hello, Business Central Spring Edition, We have Table1, with datapercompany=yes. this table has a field with a relation to table2 table2 is datapercompany=no. Via webservice, we add a value to table2 and after, add a line to table 1 => Error : related info in table1 doesn't exist ... If we look into the table with classic…
-
Illustrator Tech Pack Fashion integration NAV
Hello, I would like to discuss a possible project to implement and i would be open to read some ideas. Designers fashion use Illustrator or speadsheets to make their tech pack fashion. Imagine a scenario where designers build their tech pack in illustrator and the goal here is to intregate with nav's manufacturer so that…
-
SetRange in Dataport
Hi, Primary: Boolean Item: Code 20 I'm trying to import a CSV file using Dataport. This CSV file has multiple records. I want to check if there are any records in the table before importing the CSV file, if so, then if their Primary field is true, then before importing the CSV File I want to set that Primary field to be…
-
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…
-
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!?…
-
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…
-
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.
-
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…
-
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…
-
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.