-
Converting Average->Std. Cost
Hi, We have parts that are average cost but would like to convert them to standard cost (there is already activity against these parts). Is there anyway to do this? Can the inventory be reduced to 0, then the costing type changed programatically, or will we be damaging our database? Thanks for any input. Mega
-
Questions about Lot No.
Hello, I have two questions: - What is the "lot no." used for? - How is the field "lot no." filled on the sale and purchase documents? THANKS AND HAPPY NEW YEAR 2007
-
Price List explanation document of Navision W1 2.60 needed
I need the Price List explanation document of Navision W1 2.60? The oldest version I have is titled "Microsoft Business Solutions–Navision® Price List Explanation - Release W1 3.70 (June 2004)" but I need one for version 2.60. Is there anyone around that still has this document on his PC?
-
keey having database corruption error
I am continously having the following error: There is a corrupted area in the database. This type of error occurs if the database file is changed by another program or if the device driver does not function correctly. Warning! This error MUST be corrected before you can continue. Do not use any type of disk utilities on…
-
Export date where year has 4 digits
Hi, Does anyone know how to export a date field where the year consists of 4 digits? thnx
-
Import of invoices from other database
Our firm is a container terminal and we have recently implemented Navision for our Finance department. We would like to start with a billing project while the calculation of our invoices is pretty comlex and we are currently using an excelfile where a lot of manual adaptation is neccesary. We are growing very rapidely and…
-
Server
Hi everybody, I hope all are fine. I need one clarification. Suppose in my server i have a database named (Nav.fdb) and it is connected as the default database.It's an Database server installation If i try to create the new database in the server,it's showing only the client. Is it possible to create another database in…
-
Updating Sales Lines form from Quote Subform
Using menu button on sales header and Sales line subform withfiltering "Sell to customer no" and "Item No." Call subform using sales line function showquotes The above is easy and this works fine using Navision function Showquotes displays another sales line form (quote form) filtered with "quote no., item no, sell to…
-
dataport: importing data into table failure
Hi, I'm trying to import data into an empty table but after import it's still empty. e.g. Table G/L Entry. Why doesn't it import properly and how can I slove this problem? Thanks in advance, JBeck Merry Christmas :P
-
Error importing "Body" Property of an e-mail (Outl
Hi, I have troubles when I try to handle the text included in "Body" property of an e-mail, using Outlook Automation. The system always shows me an error telling something like buffer is full (actually the error message is an internal error, but I have tried it in Attain and the trouble is that the type of "Body" is BSTR,…
-
changing data in a table with a batch
Hi, I was wondering if I could manipulate de data of a table with a batch. e.g. can I multiply the amount with a factor? Thanks in advance J.Beck
-
Sales Invoice Rounding
Dear All, I want to book a sales invoice in a foreign currency. When I select the foreign currency in the sales invoice document, the program calculates the amount in foreign currency as well as local currency. The problem is that I don’t want to round off the amount calculated in foreign currency however I want to round…
-
empty editor - no trigger
Hello everybody, I have a 2.60 DB of a customer. If I want to edit the code of the objects (F9), I only get an empty editor with triggers???? I got a developer license, so it should be no problem. In other DBs there is no Problem. Do anybody know about this behavior? Thanks. redStripe
-
Report 1401
Hi, To Everybody. When I run the report to display the Amount, example Amount = 20000 I need the Amount in words so I used the report (1401) in my report and it's working fine. It displays the Amount in words as TWO THOUSAND RUPEES AND ZERO PAISA ONLY But, I don't need to display this Zero Paisa in my report. In case my…
-
Fund Flow
Hi In Navision can we have fund flow report or we need to develop Satya
-
Balance Sheet using Dimension filters
We are creating a new Business Unit to support three other separately reporting Business Units. Within this new Business Unit we wish to create divisions using filters so that we can break out a division and link to it's offsetting Business Unit that it is supporting when desired. For External Reporting we finish with four…
-
Superscript, SubScript and Greek Char Set.
Has anyone come across a method, or fonts, that allow subscripts, superscripts and the Greek character set to be used in Navision?
-
About Table relationship
Hi, I hope all are fine. Suppose if i have 5 Master tables which is linked to 5 or 10 supplemental tables. I have to create one form with the following fields. Table,Linked table,Relationship(that is Keys). with the process comand button. By selecting one of the master table, When I click the process button, it must…
-
Exclude Items from the Menu bar
Hi Everyone, Can anyone please help me on how to remove menu items from the menu bar. For example, I want to exclude users from getting access to the File, Database, Delete function or File, Company, Delete function. Thanks and Regards, Beatrice.
-
Correcting Mistakes
Hate to ask this, but is there anyway to unreceive or uninvoice something in 2.6? Right now it looks like we have to use credit memos to back stuff out. Thanks, CK
-
Navigate through posted invoices and Shipments
hello, can anyone help me with a (little, I think) problem? is there a way to see which (posted) invoice a (posted) shipment belongs to? or - the other way 'round - which shipments belong to a particular posted invoice? would be very kind if someone of the experts could help me ;-)) thanks angelina
-
Upgrade Product Group Table
Hallo, maybe someone can assit my work!?!??! I want to upgrade the Field "COde" in the Product Group Table from 10 to 30 Strings. Is there any Posibility to search vor other reference fields in the DB, so that i can upgrade these to. I think the most developer understand my Problem. thx
-
Ascii code in nav 2.6
Hi, Is there a function within Nav 2.6 that converts char code (0 - 255) into ascii code? Thanks in advance JBeck
-
Navision 2.60F on Windows Server 2003
Hi. I am new to the Navision Circle. The company I work for now has this installed and running on Windows Server 2000. The server is about 5 years old and needing to be replaced. I have a new Windows Server 2003 running next to it and have moved almost everything off the Win 2000 Server and all is ok now, but I would like…
-
Navision Server Installation
Hi Everybody, Hope all r fine. I have installed the Navision Server in my Local machine . When I try to connect to the server, the following error is displaying The TCP/IP connection cannot find the correct host in the host file(TCP/IP Host_not_found) I doubt whether my OS must be 2000/2003, then only server will connec to…
-
Programmatically Deleting POs
Hi, We have some very old purchase orders that have been partially received, but not invoiced. The system will not let me delete pos where the quantity received <> quantity invoiced. Our CFO does not want to post these pos if possible. I was thinking of writing a routine to delete the pos programatically, but am worried…
-
Need help with SQL syntax - Navision Financials
I am working for a client who uses the Navision system. I am connected to the system via the Navision ODBC driver and am using a simple ODBC tool (ODBCTest) to run queries. I need to query the data to return transactions that have a Date within a certain range. This is not hard normally, but I am getting errors when…
-
Where to find Financials CD's ?
Hi there. I need an array of Navision Financials product CD's. (final versions of 1.30, 2.0, 2.01, 2..50 and 2.60). Is there anywhere I can find these available for download? I'd prefer the danish versions, but the World Wide versions will do just fine. I think that I have been up and down every alley on Partnersource.com,…
-
Copying header & lines
Hello, I need to copy a record in a form that has a header and some related lines but my code is not working fine: it copies the header very well, but lines are ignored. Note that "No." is the primary key. // Copy headerrecHeader.INIT;recHeader.TRANSFERFIELDS(Rec);TempNum := recHeader."No.";TempNum := TempNum +…
-
Enter Outstanding Cheques using dataports
Hi! I have created a dataport for importing the outstanding cheques in the payment journal. My question is whether I should specify the Company Code as well for my journal lines. What is the importance of specifying the Company Code? Thanks & Regards, Beatrice.