-
failure codeunit 21
Hello experts! I have a question about an error that I get often about the posting date; NAV 2009 SP1, spanish date format dd/mm/yy Allow posting from: 01/05/16 Allow ponting to: 30/06/16 Purchase Invoice, posting date 09/05/16 that invoice is impossible to post because of this error Codeunti 21…
-
Send xml data from Nav 7 version to Nav 6 version
How can i send xml data from one database that is in 2009 and other database which in in 2013 ,both are at different servers
-
FlowField filter from Source Table
Hello Everybody, I want to create a Flow Field in the Sales Price Table which gives back the Cross reference no. only for Customers from the Item Cross Reference. For this I user the following in CalcFormula: "Lookup("Item Cross Reference"."Cross-Reference No." WHERE (Item No.=FIELD(Item No.),Variant Code=FIELD(Variant…
-
Filed modification only by Super users
Hi friends, Version: NAV 2009 (Classic Client) I need your assistance in the following issue. I have a report in which a field in Request form can be modified only by SUPER users and SUPER users group. A message needs to pop-up saying "Can be be modified only by Super Users". Can anyone help me to solve this? Regards, Aarvi
-
Narrowing of G/L permissions possible?
Investigating the possibilities to narrow regular user permissions in Nav 5 I got a little bit a nasty feeling in my stomach. Does anyone know wether it is right that users who must be able to post (for example) purchase orders must have at least Indirect Read permission for Table 17 G/L Entry? I would very much like to…
-
Phantom BOMs and/or Kitting
Hi, We have a manufacturing environment where we have several make to order items. The make to order items have production boms with several standard components. For example, a bike is the make to order item and has components of tires, a frame, and a seat. However, there are also "optional" components that can be selected…
-
How to register Navision Dynamics for hyperlink.
Navision code has a Hyperlink(url) and is returning an error to check logs: and the event log indicates "The Microsoft Dynamics NAV client is not registered for hyperlinks. Hyperlinks are needed for the taskbar jump list, thus the jump list will not be enabled.". How do I resolve this? If I have to reinstall Navision, what…
-
Risks of Deleting the Item Ledger entry
Hello Community - This is the situation Our customer has not been using inventory inside NAV, they were managing it using a third party software. They never cared about locations or inventory costing, they only had the items setup so they. With time and multiple sales and purchases going on, the item ledger entry table was…
-
Problem with some non-Latin text characters stored as "?" question marks in the system.
Hello, I have a small problem. Some special characters (from non-Latin languages) are stored as question mark in the system. An example is ồ (copied from Hồ Chí Minh) is stored as "?" in our database. Is installing language packs the only and direct solution to this? If it is, when multiple language packs are installed, do…
-
Avg unit cost showing greater than MRP in item table
HI i have a query in item table Avg unit cost (LCY)is showing greater than tha the MRP in some of the items. for example: Costing method:Average MRP:2000 AVg unit cost(LCY):6600 why it is showing?? please can any one help me in this scenario,why it's happened. Regards, Anji
-
Inventory Costing
my client has an requirement like For example, we have an item that costs $5 with 5 on hand and when we run the inventory valuation report on 2/28/2016 it shows $25. The cost goes up to $7 on 5/1/2016, we have 10 on hand, and when we run the report on 5/31/2016 it shows $70. However, if we run the report on 5/31/16 using…
-
how to stop post in bank receipt voucher if line and voucher narration is blank?
I want to give an error message when trying to post if either line and voucher narration is blank till now I have written this code by which if either of the narration is present then it is posting (GenJr is the record variable of table for line narration and voucher narration page as both of them go to same table)…
-
Reference to the member Abbreviated Name of the variable could not be solved.
Dear All, While data transfer after running form "Upgrade - Old Version (104001)", I'm getting below error. "Reference to the member Abbreviated Name of the variable could not be solved." I'm upgrading db from NAV5 to NAV2013 R2. And this error is coming when I'm migrating data from 2009 R2 to 2013. Can anyone help in…
-
Init Value As Current Date / Time
How can I Assign the Init Value as Current Date / Time on any Table....? I dont have Access to the code.
-
Tool Tips Word Wrap
Hi Mibuso.com World In Nav 2009 Classic Client - ToolTip Property - is there anyway to force the text into multi-lines as oppose to a really long text line? Tried the trick with '\\' that works in messages, i.e., MESSAGE (‘Line\\Split'); Thanks guys!
-
Job Costing WIP methods
In NAV 2009, is there a way to create custom WIP methods? Basically the existing WIP methods only allow to calculate Cost WIP or Sales WIP and not both in one job. There could be a scenario where it could be required to create forexample accrued cost and accrued sales on one job but at the moment its not possible, what is…
-
Job Cost Accrued Cost/Sales
Hello, Has anyone used job module? I want to know or achieve a scenario to calculate Accrual costs or sales on a job and I am clueless doing that. In Nav help I get below descriptions. I do not understand how to achieve invoiced value of the job greater that posted usage to calculate Accrued cost? any ideas? Sames goes for…
-
NAV ODBC Driver
Has any body used ODBC driver for NAV 2009. I am trying to set it up first in ODBC Data Source Administrator in Windows. I got the ODBC driver installed but when I am trying to setup the 'database name' box is greyed out no matter what I do. After setting it up , how many ways I can use this?
-
Startup POS Error
Hello Everybody, When opening the POS, the code shows an error. The code where the error is thrown is located in codeunit 10012720 "EPOS Control Interface", function SubmitDataSet, line pPosCtrl.UpdatePOS(LSDataSet.SaveToXml(TRUE), FALSE). How to resolve this ? Thanks, Suphonchai
-
[NAV 2016] ReportViewer Problem
Hi experts, For whatever reason, ReportViewer always reselects the "First page" button continuously, making it basically impossible to adjust zoom via the menu bar, or printing to Excel/PDF/Word. It's not just happening on my machine. Even in my Demo Database this problem occurs. Is this a known bug? Is there any way to…
-
NAvision 5.00 W1 grid problem
Hi, my client has a Navision 5.00 W1 install on SQL. Recently all their client pc's have been suffering a weird grid problem. Go into a Sales Order and go to the Sales Order Line. When you click (or hover the mouse) over an empty cell in the first empty row the mouse switches into column splitter mode. This can't be…
-
Format date to MM/dd/yy
I am modifying a report in NAV 2009 report writer to be used in RTC. I am trying to format the date in the page header to look like 01/01/16 and it is not working for me. The field contains the following value: =code.GetData(8,3). I put MM/dd/yy in the Format property, but it is not working. It does work in reports that…
-
Job Queue Entry stays in progress
We are using a codeunit in the classic client of NAV5 SP1 which scans a folder for files. When a file is found it is read and checked for a specific content. Then the file is moved to another folder. When running the codeunit manual everything works fine. When using an open client to run the codeunit through a timer form…
-
Use TableFilter field in SETVIEW
Hi, I've created a new table with rules to apply on the Customer table. The new table includes a field of data type TableFilter which I have named Customer Filter. As a property I have set the field to link to TableIDExpr 18 (the customer table). If I run the table and set a Customer Filter value of: Customer:…
-
Citrix session issue
Hi, All, We connect NAV5.0 through Citrix. There is an issue for few weeks. The session doesn't exit from Citrix server when user log off from Navision. We can see many instances of fin.exe running on Citrix server for one user. It causes the no. of user reaches the license limit. We have to manully delete fin.exe on…
-
Saving DateTime as integer no longer works
As of today, we have a problem with the datetime as integer. It still fits in a variable, but when we try to use this in an integer table, we get the following error: Integer Number '1000026000' does not exist. Up until sept. 6, 2012 it all works, but from sept. 7, onward it errors out with the corresponding integer value.…
-
Question about report behavior
Hi to all, I need some help to identify a problem running a report. We have only one user that, trying to open a report faces a strange behavior, the client always tries to Count the lines with something similar to an infinite loop (once reached the finish the line count seems to start again). Trying the same operation…
-
NAV 2009r2 classic compatibility with Office 2016
I have a question from an IT company for a mutual customer. They want to deploy Windows 10 and Office 2016 on a new round of workstations, but the customer still runs NAV 2009r2 classic. Of course they want to know if NAV 2009r2 will work with Excel 2016. I can't say without doing some testing, but wondered if anyone has…
-
Code Logic help
Hi I have a piece of code which I don't understand fully. recSO.COPYFILTERS("Record 1"); SETRANGE("Order No","Order No"); FIND('+'); SETRANGE("Order No"); "Record 1".COPYFILTERS(recSO); What does it do? I mean, what happens when you clear the filter after a FIND('+') ?
-
ADCS and miniforms documentation
Hello I am looking for documentation about Automated Data Capture System (for handheld devices) and miniforms (needed for ADCS). The only thing I can find is some general information about ADCS and miniforms. What I really need is documentation about how to write codeunits behind miniforms, etc. Any clue where to find…