-
Interpretation of "Production Order - Shortage List" report
Hello All I am trying to understand the "Prod Order - Shortage List" report. In particular the data shown in the last columns. I have tried to match the data for various items on the report by comparing the report to the associated items cards and prod orders without success. Please can someone explain how these columns…
-
Change Log
Does anyone recall in which version Change Log started tracking record changes made thru code? Early versions of change log only tracked changes made directly by a user. I'm thinking this was NAV 2009 but not sure.
-
propoer item configuration for both sales and production
Hi, we are sales company, that started small production of goods item "03L". Previously it was only sub-manufacturing, so product was configured simply as "goods" because we bought it from contractor. Now we would like to continue purchase it from subcontractor, and start produce of "03L" in our factory. Our partner says…
-
C/AL code function for Array search?
Is there an C/AL function to search an Array for a value and return the Array index if found?
-
How to print a report without user interaction directly to a specific printer name ?
The customer import some orders through EDI and after that the realising it is done automatically. After releasing they want to print also a report direclty to a specific printer. The printer name it is set up on sales person table, so it is a different printer per sales person. How can I accomplish this ? Should I use…
-
Convert Classic Report to RDLC Report During NAV 4.0 to Business Central Upgradation.
Hi Everyone, I have to Upgrade Classic report to RDLC. How can i do? If i don't want any paid-up tools. How can i proceed? Please guide me.. Thanks, Mani.
-
SSO
Hi, we are still using NAV 5.0 (with file database), yeah quite lol these days, but it still works nicely. We use windows domain accounts for signing, but the corporation now pushes SSO and Azure for all apps and my question is- could this be possible? Anyone experienced in such scenario?
-
NAV2015 Could not load file or assembly 'Microsoft.MSXML'
Hi, We recent installed NAV2015 (CU63) on a new Windows server (VM). In f.e. invoices we get the error message "Could not load file or assembly 'Microsoft.MSXML'". I see that in directory c:\Windows\system32 and in c:\Windows\syswow64 the msxml3.dll and msxml6.dll are installed. I have register both dll's, but still I get…
-
Cloud environment
Hi, I have a question regarding permission on report designer. We have Microsoft Dynamics Nav on cloud environment. Our license is allowed to have access to report designer, form designer etc. area from development ,to change or create some reports. Now with changes made from the server provider , we can't have access to…
-
How generate file txt in Navision?
Hi, good afternoon I am new in the world navision and I have question's My buddie has me asked creating a file txt from navision but the example shared is a txt with algoritm what is the most recommended way to do this process? best regards, Javier.
-
How to exchange files between SFTP and Nav 2009
I got an project that, we are using Navision 2009, we are about to exchange some files with SFTP, how should we do? Is there some sample coding I can refer to?
-
Developer's Toolkit function "Where Use" didn't find call of function
Hi guys, I used NDT v3.01.410. Today I tried to find all of some function calls (function at form). I know one place where it is exactly called - the function is located in the subform and is called from the main form. I wanted to know if the function is being called from somewhere else. But when I call "Where Use" on this…
-
Display all sessions under Database information
I'm running NAV 2009 R2 (Build 32012) classic client under SQL-2008 R2, simple security model, no traceflag. I can't manage do display all sessions for a non-sysadmin sql-database login with traceflag 4616 set off (with traceflag set on, it works). My database login TEST has got "VIEW SERVER STATE" permissions. (Each sql…
-
how to calculate planned Receipt date for POs?
Hi, Please share the calculation behind Planned Receipt Date in purchase Order lines with requested receipt date? I think Planned Receipt Date must be same as requested Receipt date. But in my PO's , it is not coming as true. in my PO's planned receipt date is always equal to expected receipt date. Why So? Please help...…
-
why my coding some times can't locate the records?
hello I meet a issue based on the Virtual Table: file in Navision 2009,can I discuss with you? I am doing the code like: (the ImportFile is the record based on File Record) ImportFile.RESET; ImportFile.SETRANGE(Date,WORKDATE); ImportFile.SETRANGE(Path,ImportPath); ImportFile.SETRANGE("Is a file",TRUE);…
-
Calculate derogatory depreciation quarterly instead of yearly ?
Hello everyone, One of our client wants to calculate his derogatory depreciations quarterly instead of yearly, but the calculation doesn't seem to work. To be a bit more specific, i have here an example with a linear depreciation calculated over 15 years and a derogatory depreciation calculated over 10. As long as i use…
-
Security Filters on Reports
Dear all, I am experimenting on Security filters and how those are going to work with Report Objects. The case is : 1) I have a customer table , and i have set a security filter on this tabledata because the users to see only some of the entries which are stored inside this table. 2) This table , comes as a dataitem on a…
-
Cycle Count Calc Qty
Dear All I am trying to assess the accuracy of our inventory obtained during Cycle Counts. I am able to pick up the adjustments made to Items using the Ledger Entry Table but I need to know the Calc Qty (expected bin qty) to enable me to determine % errors. Is the Calc qty at the time of the Cycle Count held anywhere.…
-
Upgrade Permissions Error
Hi, after upgrade BC17 started complaining that fields xx from table xx are missing. If they are super users however, everything seems fine. Any ideas what to do/where to look at?
-
Cannot send an e-mail.
Hi There is a function that can create a invoice PDF document and send the document via e-mail functionality. But I got this error when the function is called. The function can create PDF document but not start the mail program. The error is some think like automation error. But I have checked the Codeunit 400 "SMTP Mail"…
-
Can you create a lookup that populates a field if a partial entry is made?
Can you create a lookup that populates a field if a partial entry is made and still be able to do a manual entry? Is it possible to have functionality where when the user partially types, it filters to those options e.g. blue/green/white and populates with that option. And for the user to also manually be able to enter…
-
VAT Statement Line - Column amount calculation
Hello to everyone, I don't know where to post this thread, because I am new on forum, and I am posted here. I used Business Central, and added two new fields on VAT Entry table: TOTAL = Base + Amount, TOTAL UNREALIZED = Unrealized Amount + Unrealized Base, and on VAT Statement table field "Amount Type" (Enum) I aded two…
-
XMLPORT:Skip Empty Tags
Good Morning. does anyone know how to skip empty tags when exporting with a XmlPort? I tryed to do that setting the MinOccurs property of the element to zero but does'nt work. It's a great problem form me because my commitment don't accept empty tags. Can somebody help me? Thanks for all.
-
How Lot no tracking works for a component in Work orders?
Sir/Madam, How lot no tracking Works at various stages of Work order process? While creating a work order, whether it is placed in any table...? Also while creating a warehouse Pick (not posted) where it is stored ? Where it is placed in order to check how much quantity is reserved for one component while creating a pick…
-
Item Ledger Entries - Cost Amount
I wish to import the Item Ledger Entry for an item in to Excel, using SQL and the SQL database as an External data source for Excel. When I do this the 'Cost Amount (actual)' does not pull through as it is not kept on the Item Ledger Entry table. Which table holds the financials that I can 'join' to the Item Ledger Entry…
-
Pegging Report
Is there a way to obtain a 'pegging' report for an item after MRP has been run? Nav 2009
-
Cycle Count History
Hello All I am looking to assess our daily cycle count accuracy. As such I need to determine how many items / bins from each days count required an adjustment compared to those items / bin locations that did not require any adjustments. My question is how can I determine how many items did not require an adjustment? I am…
-
Problem with .NET XMLHTTPREQUEST
Hi everyone, i have a problem with this script to make an api call (Get) to the google maps web service. In this way it releases me a status other than 200. Through this script i would like the responce to be loaded in an xml witch i then pass to functions that decode and populate fields in the table. Thank you in advance,…
-
How to remove Microsoft Dynamics NAV name in Menu bar
Dear all, One of my customer wants to remove the Microsoft Dynamics NAV next to company name in menu bar in top in navision 5.0. If anyone knows how to do this , please let me know. Thanks in advance. Regards, Sekar.
-
Item tracking issue
Hi, We have a problem with one item that is on inventory, but when we create the sales order, item tracking for this item is not available (i.e. we can't select serial no.). We tried to insert serial no manually into Tracking Specification table, but again we get "Item Tracking Serial No xxxxx Lot No. for Item no xxx…