-
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?
-
MS Dynamics NAV 2015 / LS 2015 - Replication issue - Job Queues always stop
Good day! MS Dynamics NAV 2015 / LS 2015 - Replication issue - Job Queues always stop - every time we turn-on or restart the client computer Job Queues always stop, we need to start it again OS: Windows 10 Pro 64bit and Windows 7 Pro 64bit MS Dynamics NAV version: Thank you.
-
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.…
-
Not able to connect to SQL server from NAV 2009 R2 in Windows server 2016 (Server cannot be found)
Working on a new migration of NAV 2009 R2. So, now we're using a new environment such as Windows Server 2016 and SQL 2017 and NAV 2009 R2. For now NAV client, NAV server and SQL server are all in the same machine(Windows Server 2016) for my troubleshooting. I've installed NAV 2009 R2 but when I go to NAV database open and…
-
Crystal Reports in AXAPTA
Hi Experts, Can Crsytal Reports v.11 be used in inside axapta through x++. FOr example I will make a sales invoice in crsytal reports. How can it be called using x++; IF yes. Can you give me a sample code. Thank you very much. MIKE
-
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…
-
How to increment a field value if it has same another field value
In Nav 2009, I am creating a dataport export where I am taking values from g/l entry table. My question is For suppose if we are having document no as 'qwerty123' I need to keep '1' in another field 'numbers' and again if I have the same same document no in next line the field 'Numbers' should be incremented by 1 and…
-
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…
-
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?…