-
Problem with a sum field
Hello, I have a table in where I have defined a Decimal type field and like Flowfield that makes the accumulated sum of another field. Soon there is another Boolean type field that blocks or unblocks the line. I want that when the line is blocked the field does not sum the amount of this line. I have tried of everything…
-
How to block a filled field
Hello, I'd like to know how I cant block a filled field; I mean, I have a field on a table, and I want that that field let me fill it only one time, after that it should not let fill it again. What code have I to put?. Many thanks in advance.
-
Update Sales Line Qty with PO Qty
I was thinking about this when I read another post about updating a PO Qty when you updates a sales line qty. http://www.mibuso.com/forum/viewtopic.php?t=17518 I want to do the reverse. We receive orders and the merch is not currently instock. I altered the Req worksheet to pull just the OUT items and create a po for them.…
-
From Nav 3.60 to Nav 5
Hi all, We have the version 3.60 of Navision, can we pass directly to the version 5 ? Thanks
-
Insert a number automatically
Hello, I want to know if it's possible that a table field can be auto-number. I have a list form and I want that every register that I put the line get a sequential number automatically (1,2,3,etc...). Is it possible?, How I can do it?. Thankyou.
-
Hyperlink
I have created a field which contains a file location, and I have then assigned HYPERLINK(File) to a button. This works fine, aslong as the path is a mapped drive, but when I put it in as a network location \\server\documents, then IE tries to load it as a http, which then gets messed up.. Is HYPERLINK the correct function…
-
release sales documet
Hello, I am trying to calculate Balance Due in Release Sales Document codeunit to restrict releasing sales documet by user, but it calculates full Balance(not DUE) I have tried with date filters but iT does not help. Has anyone encountered same problem or has a tip for resolving this? Thanks in advance.
-
Archive tables
In 3.60, there are few archive tables like 5107 Sales Header Archive 5108 Sales Line Archive What is the purpose of this tables? I know that there is a copy of Sales header, when you change something in it but, what with that? Can I rollover to previous version of SH and if I can, how? (besides that I can copy/paste…
-
Access Navision from other location?
Using Navision 3.10a We have a showroom in New York City. Is there a way to install the Navision client there and have it access our database here in the office? Our Sales Rep there wouldn't be using it that often, but it would be helpful.
-
ODBC not Displaying all Table Fields
We have a (very badly designed) Navision 3.6 system running currently on the native database. I am trying to link a table to MS Access but the table contains about 280 fields (I told you it was badly designed!) and C/ODBC seems to only allow 255 fields. Anyone know of a way around this? Apart from redesigning the system!
-
Posted invoices not showing S&H..
Using Navision 3.10a When going into Posted Invoices and printing a Sales Invoice it will show me the Subtotal, Shipping & Handling, and the Total for that order. I have a printout in front of me that shows Subtotal: 408.00 S&H: 49.00 Total: 457.00 When someone went in to make another printout of the invoice the S&H…
-
Convert a html report in pdf format
Hello, yesterday I've asked how to send and e-mail automatily whithout confirmation. Still with the same, I'd like now to know how to send the a print report in .pdf format automatily. Now I send by mail a purchase order in html format automatily using the codeunit 397 in a button. I've installed Acrobat 5 that convert a…
-
[solved] Changing Report Caption
We have set our PDF "generator" to automatic; which has now prevented us changing the name of the generated file. Instead, the PDF name is being generated from the caption of the report.. ie report name. Is it possible to have the caption as a variable in order to automate the filenames? edit : there was the functionality…
-
Reverse Charge VAT and the VAT Statement
Could someone possibly shed some light on the following: Ive setup up reverse charge VAT in the VAT posting setup for purchases made in the UK, the client is based on Ireland. When I post an invoice and View the VAT Statement, the entry shows in VAT Due on EU Purchases and Value of EU purchases. To my understading this is…
-
Indent Chart of Accounts
Could someone please advise me regarding the following: The chart of accounts has previously been setup by another consultant without any indentations. I am now wanting to create indentations. Are there any serious implications in doing so now, since the customer has went live with Nav 8 months ago already? Thanks :?
-
Special Characters
hi all, how do i insert special characters like č,ě,ň,ř,ů in navision from an excel file thankx
-
How to send the mail automatily
Hello to all. He've created a Form using the Codeunit 397. This form send e-mails and runs correctry, but when I run the form the e-mail opens and I've to push the button "send"; I want to know how to send the mail automatily, whithout confirmation pushing the Send button. Thanks in advance.
-
Printing problems..
Our office runs Navision 3.10A. We've been running Windows 2000 up until a few days ago, but with the Daylight Savings Time issue/Microsoft no longer supporting Windows 2000 we've decided to install Windows XP on all our machines. All our machines came with XP to begin with, some idiot who was here years ago decided to buy…
-
Array Report and Totals
I have taken the customer/item sales report and used this to create a report which shows a comparison of sales between two periods. This works OK. However, I wish to put a grand total for the report and I have put a customer footer and tried to create the grand total using createtotals, grand := amount etc etc When doing…
-
ODBC - Multiple Companies Issue
If you open an ODBC connection to a particular Navision company and then close that connection and try open one to a different company, the second connection is refused, even if all the handles are closed and the connection objects destroyed. If you then quit the application/vbscript and try the connection to the second…
-
Value Entry Table
Can someone please give me a brief description of the purpose of this table and how it is used?
-
dataport
Hello, I need to make a filter on fields in a dataport, its fields I declared them as variables to be able to export the data in a single line, because I am going to export the data of two tables and I declared only the only one. Thank you in advance
-
4 digits long Year in Date field on all forms (date format)
Hello can anybody help me with this problem? We are starting to use NAV in these days in severel countries. And we urgently need to show 4 digits long year in date-fileds on all forms and for all years, because of many mistakes in data entry. Is it possible to set same data format for all users e.g. "d.m.yyyy"? Regional…
-
CFront compilation problems
I'm new in C/front and I'm having trouble compiling the sample program (sample.c) that comes with the Navision CD. I have C/Front for Navision 4.00 and I try to compile with C++ (Visual Studio .NET). I get many errors like the one that follows: error C2664: 'stricmp' : cannot convert parameter 1 from 'DBL_U8 *' to 'const…
-
Unable to reference a function in a codeunit
help! strange problem. running SQL 4.0 SP1 I am trying to reference a function (GetUnitCost) in a codeunit (SalesPrinted) from a form (Y). The codeunit is CU313 to which I have added the function GetUnitCost which has a parameter of ItemNo and returns a Decimal value. I have compiled the CU. I have added the codeunit…
-
Insert and get the number
Hi all If I use SH.INIT; SH.SetHideValidationDialog(TRUE); SH.VALIDATE("Document Type",SH."Document Type"::Order); SH."No." := ''; SH.INSERT; Where SH = Sales Header, how do I get the "No." that was just inserted? Its Attain 3.10 Regards, Brian
-
set up column layouts
How can I set a comparison Date formula to get the initial balance at the begining of the year no matter the Date Filter period . thank you
-
Get Current ForeColor
Is there a way to get current forecolor of a form? Or get the default system forecolor? I have set the forecolor on a list and sometimes it is black, forecolor=0. However I have a visually impaired user who has set Windows to white text on a black background. He ends up with black text on a black background, which he finds…
-
Can a Purchase Order be attached to a Sales Order?
Dear All... As the question asks for itself, can I attach my Purchase Order to a specific Sales Order? The purchase order is made manually and not from planning routine.. Thanks.. Amita
-
Accessing Navision table name with spaces from .Net via ODBC
I am trying to accces a table called shipment lines from .net via odbc in Nav 3.10 A .I am writing a insert query as Insert INto [shipment lines] VALUES ('test') It is giving LExical element Values not found