-
Security Table during NAV Restore
I'm trying to move our NAV installation to a new server. We're currently running on NAV 2009 SP1 on SQL 2005. We're moving to SQL 2012 on the new server running the same version of NAV. When I complete the restore, everything looks like it's there except the Windows Logins haven't been restored. All of the roles are…
-
service NAS stops at night
Hi guys, for some strange the NAS Service stops at without no reason. How can i check what is stopping this service? I look on the Event Viewer but i can only find the Startup events when i start the service again. Thanks for your help.
-
Check uniqueness of a field or declare an unique field
Hi all, Sorry for the simple question, but have been apart from NAV many years I can't find how to define unique field in NAV. ](*,) ](*,) ](*,) The case is Vendor table will have an additional field that relates to the company registration number. It can be blank though, as if somebody doesn't know the registration…
-
Apply Vendor Template in CSIDE
Hi I am trying to apply a Vendor Template to a new Vendor record programmatically in Nav 2013. If I debug the code the values in the fields configured in the Configuration template lines table seem to be applied however when I run the vendor card the fields are blank! I have a vendor record variable called recVend and I am…
-
Using Picture Transfer Protocol from within Navision
One of our clients is using a camera to take pictures of items. From the Item Card in Navision 2009 R2 (Classic Client) he can click on a button for this. What happens if he does this is the following: 1. delete all pictures on the camera 2. take a picture of the item 3. assign the picture to the current Item. These…
-
fields automatically retrieved when inserting other field
Hi all, I started NAV just a month ago so now i have self-task to make page connected to Customer List (I already done that) but now i must make this Description, Unit Price and Service Item Group fields automatically retrieved when inserting Item No please tell me how to do this in detailed way P.S It must be done without…
-
Backup failed from dynamic nav 2009r2 checksum error proplem
Hi guys i have proplem when i need to to make Restore Backup from dynamic nav 2009 r2 (tools-Restore) then ok it make Restore until it reach to 18% and give me error message backup failed(corupt checksum) what message mean and how to solve this proplem but if i take fbk backup of dynamic and restore it in another sql…
-
Multilevel BOM Report based on Version
Hi, Is there any standard report where User have the option to specify the BOM version from which he want to run report similar to Quantity Explosion of BOM. This report only runs for the active version.
-
What is processing when clickedon New Fiscal Year A/C Period
Here is the scenario. Accounting period is manually created for 2014 (January to December). User forgot to tick New Fiscal Year field. 2013 Year is not yet closed. Now they want close the year 2013. When clicked on New Fiscal Year for January 2014 to indicate as new start period system started processing items. Progressing…
-
Navision Mail Automation variable
Hello, I'm running an issue concerning the Navision Mail Automation variable. I've developed a mail functionality for our customer which works with the navision mail automation 1.00. Due to some layout issues in the mail and the possibility of defining a port, I installed the KB article which makes use of the Microsoft…
-
Any metrics of timing regarding Native NAV 2009 R2 to SQL?
Hi. I am testing a migration from native NAV 2099 R2 to SQL. The company I am migrating is primarily used for payroll only, with minimal AP activity. I am following the instructions in the Upgrade instructions from the 2009 DVD. I am running the first set of database tests and the process is running extremely slow. The…
-
Delete a year ?
The customer has a backup and is not interested in year 2006 .. 2010 Will this give problems? I don't see them yet but there is not a standard option in NAV to do this..
-
You cannot reset because the document still has one or more
You cannot reset because the document still has one or more lines. I have created a field in Sales Header called credit entry exist , with flowfield type exist, but whenever I used in the function and call that function I am getting above error You cannot reset because the document still has one or more lines. Sales Header…
-
CU406 not copying all Items
I am trying to copying Item master from one company to another new in the same database using "Setup Checklist" feature. The old company has some 15,000 items and only around 10,000 are copying. I tried several times and still the same. What could be the reason? Have anyone experienced this?
-
BOM and adjustment
Hi all, I wan to ask can anybody help with the following: while making Bill of Material the total cost from the negative adjustment is different from the total cost of the positive adjustment for the adjusted amount on negative adjustment: Item No. Document No. Entry Type: Adj. Cost Amount Actual 955900952 SOSTAVNICA…
-
Changes to Current Inventory Setup
Hi, Please can anyone offer some guidance on how best to approach this, we are currently in the middle of integrating data from one system into our navision system and have 2.5 million items that we need to A) Switch from using locations without the ''bin mandatory'' checkbox selected to with ''bin mandatory'' selected B)…
-
Internal Error 11 in module 112
I get this message when trying to post checks: Any ideas??
-
NAV printing error for certain user
Our users keep receiving the following error when trying to print any report. users are connected through remote desktop to server. Printer A is therefore brought (shared instance) from client PC to server. Whenever they try to print a report to printer A, it will always throw them that error. We know most likely it's not…
-
"Item Ledger Entry" - Entries not the same than Item Journal
Hi, we have a problem and we can't find the source. We have an temporary table where users fill in some data about items and quantities. Then, with a process, this lines goes to an Item Journal and Post it. In this Item Journal, we only put "Positive Adjmt." or "Sale". This process, the idea is, user want to convert an…
-
Client is in the displayed in the wrong / correct country
Hi I have a sales cube when i view the country and customer sales cube in my excel pivot , my customer is diplayed in the correct county and also displayed in the wrong country, Germany and Estonia the costomer should display under Germany only. When i change the budget name to 2014 and the posting date to 2014 the…
-
Payment Tolerance
Hi Everybody, I've got a problem using Payment Tolerance in NAV 2009 SP1. I've an Invoice with 1000,30 as Amount and a Payment with 1000 as amount. I configure the "Max. Payment Tolerance Amount" in the General Ledger Setup with the value of 1. When I select the Payment in the Customer Ledger Entries and Apply it with the…
-
Trigger camera and save photo from within NAV 2009 R2
We are running NAV 2009 R2 Classic Client. We are currently taking Photos of outgoing orders as documentation in case our customer reports items missing on receipt. The Photos are taken with a small digital camera and manually stored by date. Each date can contain many Photos which has to be searched for the specific order…
-
Using REPEAT after GET
I'm specifically using 2013 R2 and have not tried this in other versions: If you do a GET on a record it should bring back ONE record if it finds it. At least that's what I thought. If you then do a REPEAT on that record after the GET it will start at the Record it got and then repeat until the end of the table (using…
-
Invoices having service tax cannot be applied to another inv
Dear All, I am facing the below error message during Posting a Sales Invoice. NAV 2013 R2 IN Version Please help.
-
Navision Licenses and Connections via SQL
Hi, we have a web-based system which connects directly to our Navision server via a SQL connection using C#. How are licenses distributed when we do this? Is a new license used everytime a connection is opened?
-
C/AL caching question
Anyone has an idea about the following issue?: 'Which group of C/AL functions uses caching on the Microsoft Dynamics NAV Server?' A. SETRANGE, GET, NEXT, COUNT B. CALCSUMS, COUNT, FINDSET, SELECTLATESTVERSION C. ISEMP;TY, SELECTLATESTVERSION, COUNT, SETRANGE D. GET, COUNT, FINDSET, ISEMPTY D seems to be the correct answer…
-
account no not found in item journal proplem make negativead
I have 3 account in chart of account as 113401 this for spare part 113402 this for oil 113403 this for tires(car) When i make consumption as negative adjustment it go to spare partes cost to this account (113401) this account include (spare parts of car and oil and tires) from item journal Now i need to diviiding these…
-
IDs of the objects of the service module
Hi everyone, I want to know wht is the range of IDs for the objects of the Service module in NAV? I know that it starts from 5900 but I am not sure where it ends... Thanks in advance :mrgreen:
-
Line Discount Amount Field in The Sales Line Table
Dear Gurus I have come across another issue to which I can't find an answer. According to HELP, Line Discount Amount Field in The Sales Line Table is If we give any discount less than 100%, this field contains a correct value and posted as it is. But, in case of a 100% discount which our company sometime gives as free…
-
Sorting by Employee No on report
Hello, I have a problem with sorting on report in classic nav 2009 sp1. The Report is with DataItem: Dimension Value and indent table Employee. So it is group by Dimension and the Employees for every dimension are sorted like this: 1;10;100;2;21;3;300;4..... I want them to be sorted like this ascending : "No." :…