-
VAT
CASE: VAT is not included in the Invoice. It is calculated manually and entered in journal together with the payment from customer. VAT should not be reflected in Account Receivable and only reflected in VAT account. Problem: When we do this, not VAT entry is created ! Let say: Invoice 1000 without VAT (10%) Credit Account…
-
Navision Database and Oracle DB under Linux
I need a solution to bring Datas from a Navision (native) DB to a Oracle DB under Linux (and back) - Does somebody know a solution? Thank you for help
-
"Open Company" window
We are offering NF 2.60 as a hosting solution, but wants to restrict the user's "open company" window, to only show the companies that the user has access to, and not all the copanies in the database regards. Michael
-
Realize and Unrealize Gain / Loss
In the General Ledger ( Setup - General - Currencies ), there is a coloum called " Realized Gains Account ", " Realized Losses Account ", " Unrealized Gains Account " and " Unrealized Losses Account " So ..... is there anyone can telling me when the content of that coloum will be used in the Navision Financial ? Or ....…
-
Tick Mark in some field
If we drill down the field "Inventory" at the General Tab in Item Card, then we can see that there is a field / coloum call " OPEN " The question is what does it mean when there is a tick mark in that coloum and what does it mean when there is no tick mark in that coloum ? Thanks for the coorporation Best Regards, Mei
-
Account Schedule
How I can make the comparison coloum in my account schedule ? Thanks for the coorporation Best Regards, Mei
-
Launching Navision automatically
Launching Navision automatically. We need to automatically launch Navision from another application at a particular Customer, maybe using an ocx. Has anybody got any ideas?
-
Dataport to existing file
I have written a dataport to fill the Navision Customer table. WHre a record already exists in the Table, I would like for the dataport to change fields common to the dataport and table but leave fields that exit only in the table alone. I have tried combinations of auto-save, auto-update and auto-replace but can not get…
-
SQL and ODBC
Has anyone else seen this, and is there a known work-around? We're trying to open a Navision SQL database using ODBC in Access. It seems to have trouble with Navision's table and field names. Some tables open without difficulty but those with "No." fields fail. The usual error message is "Syntax Error Near ','". With the…
-
Bitmap Resolution Convertor now available
As discussed in this forum a couple of times already, the best way to use bitmap pictures (*.bmp) is to set the pixel resolution of the picture. Navision is then capable of displaying the picture in the correct size on screen and when printed out. Only a few graphic programs are storing the resolution, and fiddling with a…
-
Dummy Customer - Cash Sales
I created a dummy customer and set the posting group to the Cash G/L account. Then in the invoice I can do a cash invoice. But the problem is the invoice is open where it supposed to be closed. What I intend to do is doing some of ammendments on coding just to close that particular customer ledger entry. This solution may…
-
Navision 2.5 and SQL Server
Hello, can anyone tell me the hardware and software requirements for Navision 2.5 and SQL Server ? Have anyone some statements about this, bugs, features, .... ? Sorry for the worse english ;-) Best regards Alex Schubert ERP & Navision Dolphin Communication Technologies GmbH Otto-Hahnstr. 1 c D-69190 Walldorf <A…
-
how to get data from different place?
if I in town A and my navision financial in town B, What I should to do with my computer in town B to be recognized by my computer in town A for dial up because I want to entry data and get data in town A ? What software I need and how set it up ? Thank's
-
Navision backup in SQL db?
I have a customer with using the Navision SQL server option. We want to be able to do standard Navision backups of the database (especially for testing on the initial implementation). But the standard Navision backup fails on any shared tables with data in them. Does anyone know why this is? Is there a workaround for this?…
-
Cancel Job Usage
I found that no reverse entry can be done in job journal. what if I wan to cancel the posted job usage using Account G/L - Salaries ?
-
Locking Periods
We want to lock invoicing & GL transactions after a certain date, but allow users with privileges to still receive & ship goods back past that date. Posting Date security applies to all transactions not just GL. What is the best way to maintain ability to move goods but lock GL transactions after a certain date?
-
Navision and ODBC
I can sucessfully open a recordset and fill web pages with Navision data, but as soon as I attempt to create a new record and update it I recieve a Navision ISAM error. Any suggestions to resolve this?
-
Navision Solutions 3.0 beta
I work for a dutch solution center and would like to get my hands on the Navision Solutions 3.0 beta version. So we can do some early research on what kind of consequences this new release has on our future development. Aldo van Amersfoort aldo@fitinfo.nl
-
stock valuation
does anybody know the best way to identify the correct stock valuation figure based on the reoprts produced in NF?
-
Payment in others currency
I want to ask about apply different currency in Navision Financial : I have an opening customer ledger entry in LCY (IDR) but I want that entry to be applied (to be paid) with other currency(USD) (I have set up a bank account in USD currency ), could I do that ? Because when I tried in Cash Receipt Journal with bank…
-
Script Programming FAQ
Can u give me URL of script programming syntax FAQ? I need to write the script with tables strings pair-equation for accordande of cell groups and other parameters, how can I learn to realize it? Where can I learn to write true scripts?
-
Information web shop ?!?
We have several bookeeping companies running Navision. We are also considering putting up a web-site to provide the customers with financial information. Security between each company does of course need to be tight. The access to the information should be on individual or group base for the customer companies employees.…
-
BOM with Serial No.
How to produce Bom Item with Serial No. because item with specific cost method is not allowed in bom journal ? How to fill in opening balance for BOM items with Serial No.?
-
Tabular-Type Form
Has anybody a hint for filter a „Tabular-Type Form“ which is filled only by the values of a table. The Filter should work like if Field 1 of the table has exact the same value of Field 2 it should not disappeare. I tried it on trigger "OnNextRecord" but it won´t work. Thanks. Ralph
-
Start a Report/Dataport/Codeunit with a external program
Hello, is it possible to start a report/dataport/codeunit with an external program ? Why i ask ? We have a webshop running. If a customers orders something i wan't wan't to execute a small program that indicates to Navision that there is a new order in a File. For example: startreport 12345 ORDER001.txt This starts Report…
-
Marking a large number of transactions
In Bank Reconciliations is there a quicker way to mark a large number of transactions other than one by one with the mouse? - Jeff Phillips
-
Retention
Is anybody know how Navision handles retention for customer or vendor ?? case: Let say when I invoice customer. 90% will go to Account Receivable while 10% will be debited in Account 10%. As I see, Navision is not designed for retention.
-
change field length
Hi, We are considering changing the field length of the customer name field in the customer table. As I understand it's limited to 40 chars, we would like it to be (at least) 60 chars. I guess it wouldn't be enough just to change the field property? How severe would the result be in forms, reports etc? How much work can we…
-
Mail sent with Lotus Notes
Since classical Mail Codeunit with MAPI in Navision does not fully support the Notes Mail(ResolveName error !). I am trying to use Notes Automation. Everything is going well but when it comes to Attach a file into mail, I get "The Data type is not supported by C/SIDE" message. Function is; EmbedObject(EMBED_TYPE lType,…
-
Running Navision via Remote Access
We have a customer who would like to run Navision with Payroll Over a wide area Network. They are using a single leased line connecting multiple locations and getting very slow response on any Navision activity. We are looking for a solution that we can recommend to our customer which will significantly increase their…