-
Paid realisation, Unrealized revenues & expences
Hi all A company needs option to recognize the expences & revenues in the moment when they are actually paid and not at the moment when they are invoiced. I know that there is a feature for Unrealized VAT in Nav but we also need option for Unrealized revenues / expences which will be recognized when paid. So, at the moment…
-
Need Help after converting navision database very slow,
Need Help after converting navision database very slow, hello , i am agung from indonesia, i have problem with my navision, after upgrading my server from nav sp1 to nav sp3 , all my client going to slow when posting something and slow when priview report adn print, is there any solution for this, my server spec is intel…
-
Tax Forms Details
In the Form, Tax Forms Details(13782) when the boolean Issued gets True??
-
Req Worksheet-create 1 worksheet per vendor
Just asking if someone has info on this before I look thru CU333 is it the Order counter line here what's causing multiple po's for a single vendor? *More Detail* if I create a Req Worksheet for a number of orders, The req Worksheet creates a sperate po for each Sell-To Customer Number even tho it's all for 1 vendor. What…
-
I can't evaluate decimal value to decimal FieldRef
I have a problem with evaluating decimal value into a decimal fieldRef. Everything works ok , but when i try to evaluate values smaller then 0.0001 in tables it shows like '0' and i can't understand why. For example if i evalueate digit 0.00001 to decimal field via fieldRef it shows zerro. :( this is my code:…
-
Sales Price
Hi all Not all the user are authorized to change the Item Unit price in the sales invoice, in user setup we have a column price change those authorized check box is checked. my question is I want to make a similar setup in another company though user setup in GL I could able to in the new company but while raising the…
-
Fin.zup
Fin.Zup is a temp file witch save all your settings under navision, when users use citrix, the file is saved on citrix server under c:\program files\user name\application data\fin.zup you must delete the file, if the problem persist, rename the user folder as .OLD and create a new one
-
Create a report similar to an old one?
Is this the correct way to do this? I wanna take a current report, and make a new report out of it, modifying it a little. I just export the current report, rename it, and import it again? Then I'm free to edit it? Currently we give inventory to our Sales Reps. We do this once or twice a month, sometimes more often…
-
How To Add Option String In Runtime
Hi., i am new to the C/AL PROGRAMMING and trying out few things..can anyone tell me how to add option string during runtime using CAL PROG.,. thanks in anticipation bye,chandru
-
Prevent report being run depending on BOOLEAN/Posting Dates
Hey everyone, I have a report where the data for certain customers before a certain date is redundant. I would like to prevent it from being run on or before Posting Date/s (usually in a range) 30/06/2009 for customers where a boolean field called 'NI Customer' is set to Yes. I have a warning message to inform users, but…
-
Change System Printer
Hi all, I've been searching the forum for a solution to my problem. I have a report, I would like to print with a PDF-printer. I do not want Navision to prompt me for a choice of printer. I want to change the System Printer to the PDF-printer, print the report without request forms or other user intervention and restore…
-
HYPERLINK changes URL-address
Hi all, I have a problem with hyperlinks. I've written a very simple codeunit with the following code: OnRun()HYPERLINK('http://www.mibuso.com'); When I run it, a browser opens with the URL: http://www.mibuso.com/%20"http://www.mibuso.com/" Every time the HYPERLINK function is used, this happens. What can be the reason…
-
Cannot get licence to change
Hi We are running Navision Attain 3.60 (and can't upgrade at the present) on a 10 year old server. Unfortunately no-one knows a great deal about the technical side of Navision. I have been tasked with moving the software and database to new hardware, which I have done. My problem is when a user logs in they are told that…
-
Word Automation-Export Decimal Keeping Trailing Zero's
I'm trying to export a customers Balance to a Word Template. It all works fine but I can't seem to figure out how to keep the decimals showing. I'm using this: wdRange.Text := FORMAT("Balance ($)",0,'<Integer,7><Decimal,2>'); But if the Customer's Amount is $500.10 what get's exported is only $500.1 (no Last Zero) And if…
-
add Option string at run time
Dear all, I want to add Option string at runtime. I tried to assign a new optionstring value to one of my option field.But system is showing error that 'its not an option'. How can i add option string values like 0,1,2,3 at runtime.
-
Checkboxes pre-checked off..
Navision 3.10.. When I am entering items on my Item Card I have to check off three boxes every time.. Buy-Pack, Sell-Pack, Modifyable. What do I enter to make a Checkboxes already pre-checked off for me when I go into their properties in the designer?
-
Application Management question
Hi, I'm trying to do the following: Let a Windows user (fe: administrator) open a navision client and let it run automaticly a report via a Scheduled Task. Therefor I added the administrator to the windowslogins, added the ST with administrator to run it and adjusted the CU 1 with the following code: IF USERID =…
-
Automatic Generation of PDF using PDF995
Hi Experts, I have installed PDF995 (orginal version). But I couldn't find the automation variable in the list. Can anyone please help me? Regards, KRS
-
Can not create Posting group!
Hello to all. I am new in Navision Attain.We have a 3.6 Version of navision, After we created a new group of bill series that was like this. NR-BOLLETT 80000 03/04/09 B7-000000 B7-999999 1 B7-678427 07/17/09 For this series we can't make the bill payments. for the grops before we can make the payments . We have this number…
-
How to format duration type variable?
Hi there. Anyone maybe knows how to format duration. I have the case where duration is difference between two datetimes, and would like to have displayed just days and hours, without minutes and seconds. Thanks for any suggestion.
-
8104, 42000 Error in Post Dated Line Check
Please help. I have a problem when entering Post Dated Line Check. I encountered the following error messages: "8104, 42000 Microsoft ODBC SQL Server Driver Error. The current user is not the database or object owner of table %. Cannot perform set operation." If I make the Navision User ID a db_owner of Navision SQL DB…
-
License Expire
Hi, Is the developer license has expiration? It always prompt once I open a NAV."WARNING! PROGRAM LICENSE EXPIRE IN 15 DAYS", I read some conversation about it here, but there's no explaination why is this happen? Hoping for your reply? Thanks
-
Bank rec - suggesting lines wont pull open items
I have items marked open in the ledger entries, but they wont pull in as suggested lines. i think they were on a bank rec before but the rec was deleted before posting....i think its from somoene starting and deleteing to restart a rec. where should i look to get these items to pull back into the rec?
-
Referring to Cells in Excel by Using Index Numbers
Has anybody managed to refer to cells in Excel in any way other than by Range (A1 notation)? To be precise, I'm interested in referring to cells using index number. I tried to use WorkSheet.Cells(2, 3).Value := SomeValue to put SomeValue into cell B3 as it is stated in VB help but id doesn't work in Navision because Cells…
-
Generating bills in Navision
I have this error
-
External Commands from POS, eg calc.exe
Hi Folks, Hoping someone can help me here, I want to run an external command from one of my tills, something like Calc.exe for example, or services.msc. I think i need to use a shell command but how do i do this from the POS menu? regards NeilC
-
compare setups in 2 companies
Hi, I have a navision DB with with a company, i will have to create a new company from a backup(restore it as second company in same Db). after that I would like to compare whether all the setups in both the companies are same. Is there an easy way to compare these 2 companies. Thanks, Shiva
-
How can we upgrade Nav 4.0 SP1 (SQL) to NAV 2009 (SQL)
Hello, Greetings for the day, Could anyone please help me in getting the solution regarding: How can we upgrade Nav 4.0 SP1 (SQL 2000 Version) to NAV 2009 (SQL 2005 Version). Can we directly do the compare and merge process for the Modified objects of 4.0 SP1 along with our modifications and customizations with the…
-
Create service Credit memo
Hi all, I'm using NAVFR 5.0 Do you know how to create a Service Credit memo from a posted service invoice ? Something like the 'Copy document...' in Sales Invoice, (and it should create reversed service entry when posting). Should i develop my own ? [-o< Many thanks, dkone. From previous (unanswered :-k ) posts : In this…
-
Extract Data from NAV 2.6 Native
Hi, How do you export data from NAV 2.6 native version? Data such as master files and ledger entries too. thnaks