-
On-the-fly Picture Convertor available for download
There seems to be quite some interest lately in having separated collections of pictures. Many clients have a library of pictures, stored as JPG and/or GIF pictures on their server. In Navision you can only store Bitmap pictures, which means tedious conversions and less efficient storage. But now there's a little tool that…
-
SQL Server 2000 uses not more than 1.8 GB of RAM
My database Server has 3 GB of RAM but uses Max 1.8 GB of it. it runs on Windows Server 2003 i already inserted the /3GB switch in the system start file. does anybody know something about this problem? :|
-
Phantom BOM
Can any body explain me about the Phantom BOM.
-
SETRANGE over SETFILTER
Hi All, Is there any main benefit of using Record.SETRANGE(Field [,FromValue] [.ToValue]) over Record.SETFILTER(Field, String, [Value],...)? Would one be correct to assume that SETRANGE() limits your result set to the requested range....for example: say you have the following records Entry No. Name 1 Big Bill 2 Roger Hill…
-
Difference between Production BOM & Item BOM
Hi, Can anyone explain the difference between the Production BOM & Item BOM? Regards, Bhushan Teredesai
-
Importing csv file
Hi to all members of the forum. I usually only read your posts but now it's time for me to ask your help.It's my first attempt to run a dataport. I would like to import in navision a csv file which was in xls form before with type text. I don't use request form. When I run the dataport I get an error message: 'The text…
-
Transfer BLOB from one Table to other
Dear All, Can anyone tell me how I can transfer the BLOB field value from one table to another table. I tried assigning the value - not happening... I tried doing a transferfield - not happening... any other way?? lemme know... tushaar
-
Quarterly average posting
Dear all, I am researching costing methods of navision which one of them I focus now is average costing. Could I adjust the average costing quarterly and then will see if there will be a change in the unit cost of items ? How can I do that ? Could I select quarter in automatic cost adjustment field for that ? or there is…
-
Retention and down payment
Dear all, I really need a solution to my problem from you all. I have a task to implement navision financial for a company that have to do a project from a customer, e.g. 2 unit of multistage comprossor project with total proce/unit : 10000 USD. The payment sequences from buyer : 1. DP 10% from total price of project (1st…
-
Difference in the Direct Cost Applied Account
On posting of Purchase Invoice the accounting entry passed by the system are: 1) Inventory/Stock Account - Debit Direct Cost Applied Account - Credit 2) Purchases Account - Debit Creditors/Vendor Account - Credit However the amount of each individual entry does not match. The correct amount belongs to Entry No 2. (In…
-
Item Category & Product group
How I can make use of these two fields? Can someone explain me with the example please? Regards, Bhushan Teredesai
-
afterInsert trigger ?
When I enter a new record via a form, I need to copy the record in another table in a specific format. I created the code and it worked with some test values. The problem is that when I run the code in the onInsert trigger, the record isn't inserted yet and then I can not lookup values of the record. Is there something…
-
Drop ship with serial number only on PO side but not on SO
We have a client who is still on Navision 2.5. This problem involves items with serial number. When drop ship PO is recieved with serial no it posts the sales shipment at the same time without the serial no. They tried going to sales side to enter the serial no before posting the PO receipt but could not because it's not…
-
Apply Vendor Entries Posting Problem
this is on US Navision Financials 2.01b we have an incorrect posted vendor invoice...so to correct it...we create a new credit memo...and click functions->copy document select posted invoice as the document type and enter the invoice number...also check the boxes to include the header and recalc document lines. this…
-
Different C/ODBC Versions on 1 PC
I need to use C/ODBC to read different NF version databases (from 2.1 to 2.6). The 2.6 C/ODBC driver isn't backwards compatible. Does anyone know how to install the 2.6 C/ODBC driver so that it doesn't overwrite the 2.1 driver and so that it appears as a separate driver in the ODBC Data Source Administrator? Ideas much…
-
Vorsprung payroll
Hello, Can anyone out there tell me what the latest version of Vorsprung payroll is? Thanks,
-
NF 2.01b Inventory Value Zero
Hi I make a new item (FIFO), enter 100 in unit cost and sets Invevntory Value Zero to Yes. I then receive 10 pcs with 100 as purchase price. Afterwards I remove the 10 pcs from inventory by posting an inventory journal. I now have negative stock value of -1.000 which is exactly the same result as if I had not used…
-
Search files with a timestamp over system table
hallo, i need some help!!! i want to import multiples files like: import_kunden_%timestamp%.csv here my cal code: timestamp := FORMAT(TODAY,0,'<Year4><Month,2><Day,2>');datei_import := 'import_kunden_'+ timestamp+'*';CLEAR(explorer);explorer.SETRANGE(Path, "webshop einrichtung"."Pfad Import/Export");explorer.SETRANGE("Is a…
-
Valued qty in value entries table
Dear all, I have a problem that relates to FIFO costing method in navision especially to understand some fields on the value entries table of a purchased item that has FIFO costing. the item itselfs is included in the product item's BOM. The value entries table is as follows (but it's only the fields that I can't…
-
execute dataport like available files
hallo is there any possibility to execute dataports where the system can found files?? this is the code in the dataport: explorer.SETRANGE(Path, "webshop einrichtung"."Pfad Import/Export");explorer.SETRANGE("Is a file", TRUE);explorer.SETFILTER(Name,datei_import);IF explorer.FIND('-') THEN BEGIN REPEAT timestamptemp :=…
-
G/L Account relate to interim
Dear all, I need your help to solve my problem relate to term "interim" in G/L. My question is when it will be used by the system ? I find it in the inventory posting set up either in finished or raw material. rgds, Johnson "Christiansen" Alonso
-
Read Microsoft Access Database
Is it possible to read records from a Microsoft Access database within Navision? I've tried to use the Microsoft Access 9.0 Object Library but i can't seem to make it work! (Or do I have to use the Microsoft DAO 3.6 Object Library) I hope someone can help me...i'm probably not the first one with this problem... Thanks.
-
Navision 2.50 Server Install
My customer just purchased a new server they are going to dedicate Navision 2.50 to. Their database now has 2 FDBs. When the server was installed, the customer specified the first FBD as queried by the Navision server installation. The Navision server was installed just fine and it started. When connecting a client,…
-
Need Navision Financials 2.6 Versjon c (2.60c) Norwegian
Hello everyone! I`m in need of a standard not modified Navision Financials versjon 2.6 c database. I`m only able to find 2.6 a on the partnersource, is the versjon c a special fix of some kind, if that`s the case, someone knows the fixs name, so I can find it? I need this in Norwegian. Thanks alot!
-
Problem with testing database with navision 2.60
While trying to test relation between primary and secondary keys the test process of the database doesn't continue succefully; it stops at 17% when it's testing table "item entry". What could be the problem?
-
HELP please - Creating a new Company
Hi I´m trying to create a new company in navision, but I want that company to have the same objects of the other companys. Problem Sample: One of the problems is when i create the new company, in the 17 table, the field caption of global dimension1 is "global dimension 1" in the other companies it's "entidade cod" . I´m…
-
f.READ
Hi All, Probably a really simple question but does anyone know of any method that is built into Navision that deals with reading lines froma file in an easy way. I'm not a seasoned Navision programmer and I'm a little lost. I'm looking for a method that will allow me to read separate lines from a file. I've tried f.READ…
-
[solved] Error 183 in module 1
Hello, I am creating new database in 2.50 and I have problem that after creating the file (2GB), the client freeze and in the folder with the database is created file dbms_err.log with text Do you know solution? I know, what does it mean (net helpmsg 183 etc...) but I do not know why....
-
inventory valuation-WIP report in manufacturing
Dear all, I've got a problem to define the calculation of cost posted to G/L column of a particular item in inventory valuation - WIP report. I mean I don't understand how and why. I define the calculation formula as follws: Cost posted to G/L = Consumption posted to G/L - Output qty posted to G/L + capacity cost / unit of…
-
Navision 2.60b 2.60e Login issue
I get error "You cannot use the file D: \Navison\Server\database.fdb because it is already in use." I have it on server 2003 with windows 2000 pro workstation. Help ](*,)