-
Sales Invoice
Hi expert, I have lines of code for the sales invoice printing form. In the printout, I want to show the items which are charged for TAX as YES, but even though there are taxes charged, it still shows as NO. Below is the code. Thank you! If ("Sales Invoice Line"."Amount Including VAT" - "Sales Invoice Line".Amount) <> 0…
-
Functions has record paramters in codeunit is not working
Hi All, i have created a new codeunit with some functions has a record data type as a parameter. i have published the codeunit and i tried to open the web service. Its not working. Regards, Sathish
-
Page
Hi experts, when designing a page, how to add the previous and next buttons to the Actions menu. I found if the subtype is repeater, the previous and next buttons are automatically been added. How about the card page? Thank you!
-
XML file - Consume Web Service
Hi all, We have a client using XML to transmit their sales orders to a third party fullfillment warehouse. They developed a web service for us to use. Basically right after we create an XML file in Navsion, we have to link to the web service to consume it automatically, so their system can have orders right away. They…
-
Upgrade executable 3.0 to 4sp3
Good Day! Just want to ask if is it possible to upgrade the executable of navision 3.0 to 4sp3? does anyone who already did this? please share your experience [-o< what would be the challenges of doing this. Thanks in Advance
-
Sell-to Customer Name
Hi, I would like to know on how to add the sell-to customer name field that appears in table 112 (sales invoice header) to be shown into the customer ledger entry screen. I would like to capture this field into customer ledger entry table for new records as well as for old records. I did inserted a new field in customer…
-
Specific items visible to user
Dear Experts, Is it possible to restrict one user to view only specific items?? There is one field on item card, if that field is not equal to ''(blank). He/she should see only those items. Please advice if it's possible.. Regards, Fahd
-
Excise Structure
Hi, In sales order i have calculate the excise after posting the order excise Payable Account is credit and Customer a/c is debit in base system but users want that excise value is not reflect on customer a/c because customer not give the excise how can handle this problem. Thanks
-
Run Crystal reports for multiple companies
Hi, Can anyone please guide how to run multiple companies in Crystal reports ??I have made a crystal report for a particular company and its working fine,now i want to make it run for all the companies in the Database.How can we pass the company as a parameter ? Suggestions are welcome =D> Thanks!!!
-
Pass parameters from NAV to Crystal Reports XI
Hi, How can we pass parameters from NAVISION to Crystal Reports XI ?I have searched enough on the web but still in vain ](*,) .Can anyone please guide. Thanks!!!
-
Default Filter on report
I have a report and when I run it, it needs to display a default value in one of the fields on the first data item and the user may/may not change that. Does any one know how to program this? I tried using setfilter, setrange in Oninitreport, onprereport, onpredataitem etc but none works. Thanks
-
Code in Codeunit vanished (version 3.01)
Hi, everyone. I tried to find any information about it but failed. So, I found out that in one of the codeunits vanished all code. ](*,) Left only Documentation, names of functions and variables. This codeunit supposed to connect to SQL DB and take information form tables. I know it could sounds ridiculous, but codeunit…
-
SELECTSTR
Hi all, we use the SELECTSTR to retrieves a substring from a comma-separated string. NewString := SELECTSTR(Number, CommaString) Is there a function to retrieve a string from a tab-separated string? Thanks
-
username startup Navision
We are using scanners that makes a remote desktop connection to our Navision server. When the scanner login Navision starts automatic but have to fill in username(userid) every time. Is there a way to have the username filled in already? Thanks in advance. Rob Navision 3.10.A (5.0 SP1) Networktype: TCP databaseverification
-
Cannot Post Posting Date Not In Your Range
Today we got the strangest error (for us) at least. We got the Cannot Post due to not in the allowed range error. Our Dates are 05/01/13 to 05/31/13. And the posting date is 05/01/13. Debugging, I found in CU21 Item Jnl.-Check Line:IF ("Posting Date" < AllowPostingFrom) OR ("Posting Date" > AllowPostingTo) THEN…
-
corrupt native navision database
hi there we have a problem. one of our customers, a retail store chain, has a native navision database installed in each of it's stores. version 3.60 navision with landsteinar retail as an add-on last week one of the stores databases crashed. the size of the fdb file is set to 5 Gb and the average degree of usage is about…
-
Select a folder in Navision
Hello, I am trying to add assit button to select a folder in Navision. I search the forum and find the below download: http://www.mibuso.com/dlinfo.asp?FileID=169 The download is great ! But in order to run that, I need to register the dll file. Since the download was on 2003/Jan, is there any new method for folder select…
-
Totalling issue
Re-visiting an issue I have with Navision 3.10 totaling. When I go to print multiple copies of a Sales Order things are fine. If I go to Posted Invoices, not fine. Let's say an order is $200 and I want 3 copies. The second copy comes out as $400, third copy as $600. This issue has been here since they bought the software.…
-
Migration of Nav 4.0 SQL from SQL 2000 > SQL 2008 R2
Hi all. We're in the process of consolidating our servers and stopped using Navision some time ago. I'd like to move the existing Navision Attain 4.0 database from SQL Server 2000 to our new SQL Server 2008R2 platform. So far, I've run into problems with extended stored procedure xp_ndo_enumusergroups. I've managed to copy…
-
How to launch Navision thru Remote Desktop Connection
Hi, I have developed a small application in navision that automatically generates an email message to certain users. This email contains a link to a certain form in Navision. When the recipient clicks on the link, it automatically launched navision and opens the appropriate form. This link works fine if the user is logon…
-
Importing a file with a Codeunit.
Is their anyone who has an example of a codeunit for importing a text-file (ASCII) in navision. Just to know how to find the first record of the txt-file and how to find the next record. Without using a dataport so I would be able to call the CU with NAS to import the file. Thanks.
-
Cannot copy from form on Nav - Is there some setting?
Hi, We have a normal form (ie. not matrix) in Navision which pulls in multiple columns from a table to view. However we cannot copy data from this form into excel or any other application. Is there some setting I need to enable on the form to be able to do this - I have looked through everything twice and can't find…
-
Method to get the primary key from a table
Is there any function to get the fields that are part of the primary key in Navision Attain? Something like getcurrentkey ? Any idea of how can I develop that? Thanks.
-
C/ODBC - alternative to TOP / LIMIT / MAX() ?
Hi, First time poster, so please forgive any faux paus :) . I'm trying to add a record to the end of a table via C/ODBC. As far as I can see, there is no auto increment mechanism, so it looks like I'm going to have to determine the last primary key value, and do my insert with that value + 1. 'SELECT MAX(id)' gives me the…
-
Quantity on Item Card differs from Quantity when I go to Ite
Nav 3.10 I always forget.. does your Navision have a Variant on Item? This is where we put color. Without going into a detailed story, someone did an Item Journal (years ago) but forgot the Variant. Thus, on that item when you go to Item Card it shows Qty on Hand 0, but if you click Item Availability By Variant it shows…
-
Strange issues with Navision Attain 3.6
The following issues have just arisen in the past day or two. PROBLEM 1: Invoice for a customer we provide service for: -Under Service Management we use the Periodic Activity to create Contract Invoices function to make a batch of the monthly invoices at once. When I went to do that, one of the Contract Invoices showed the…
-
Executable only upgrade to 2009 classic
Hi, Need help on doing an executable only upgrade from Navision 3.6 to 2009. Is this possible? One of my friend told me that it could run into missing data issue and my only option on doing an executable only upgrade is to Navision 5! Is this true? Thanks, CouberPu
-
Problems with NAS 3.6
Hi! We have serious problem with SQL-version of NAS: "Application error nassql.exe, version 3.60.0.11353, module nassql.exe, version 3.60.0.11353, address 0x000745c5." I've checked objects by native-version of NAS in fdb-base - everything is ok. I've tried to login in Navision by this login - everything is ok. Environment:…
-
Flow one field from job planing line to Requsition.
Hi friends, I want to Flow one field from job planing line to Requsition.while calculate the requisition plan. Please suggest me.
-
Compatibility of Nav 5.0 with that of OS Server 2012
Hello all... Are there any Compatibility issues relating Nav 5.0 with that of OS Server 2012? Kindly advice.... [-o< Santosh