-
Shipping time and customized calendar
How can I set up a shipping agent which ships every monday of every week? I created a shipping agent, and defined a shipping agent service with a customized calendar. In this calendar all days are nonworking days except monday. Then I set the shipping time of the s.a.service to 0D, and Navision didn't calculate the…
-
Returning values from functions
Hello All I have created a function where i pass two fields into this. Once I have performed some calculations within the function, I want to send back a boolean variable that I will set within the function. How do I access this variable? i.e. I see there is a return value section when setting up the function but how does…
-
Optimise cache and database size
Hello all, Over the past year, there has been a general slowdown on Attain Clients on all PC's. We use Attain 3.01A. The clients are a mix of Win98, 98SE and 2000 SP4 machines, 300 - 450MHz and 128MB RAM, with IE6SP1 and all windows updates installed. Object and DBMS cache = 8000 The server: Currently the Database used is…
-
Print Report Total Page
Guys, Has any one ever tried printing Total Page on Navision Report? Is that doable? Standard Navision can only print the current page no. Print like: Page 1 of 10 Thanks,
-
Purchase Receipt Line
Is it possible to have an 'Eliminated Document' description in a Purchase Receipt Line? If it is can anyone help me in undurstanding what can cause the Eliminated Document description? Are all Purchase Receipt Line descriptions automatic? Thank you for your help
-
Increase field width for Item Description
Customer requirement is to increase field width for Item Description in the item card. Please let us know how this change would affect other Functional areas such as Bill of Materials, Sales Order, Purchase Order, Item Journal, etc., We would also like to know the no of places that need to be changed in order to accomodate…
-
How I transfer a value of flowfilter?
Hi, I do a report, and I want to transfer value of "Date Filter" from table "Acc. Schedule Line" to my Report's Request Form. I set a filter to table and when I debug my code a field "Date Filter" is blank. And when I run this table I don't see this field. How can I transfer a value of this field to my Request Form?…
-
Unable to enter night shift end time
In Capacity planning Granule, we are unable to enter night shift timings in the Calender. For example 10.00 P.M to 6.00 A.M, the system is not allowing to enter end time.
-
Outlook Synchronization
Hi all, I'm a new, just registered, mibuso ( :-) ) user... hello world! I'm in desperate need to use the outlook sync feature in Navision 3.70. Everything works well... but I'd need to expand Nav capabilities. My customer wants that a manager plan to-dos of type meeting for all the employees. The employees, then, will look…
-
Report Sections
Hello All I am working on printing a picking list that depends on the status of the shipping advice field within the sales header (partial or complete). Once that has been determined for each order, I need to check against the reservation table and only show order lines that currently have reservations against them. If the…
-
Printing a tickbox on a report
Hi, Is it possible to have a field that normally displays as a tickbox in a table/form to print as a tick on a report? I've added such a field to a report, but it only prints either YES or NO depending on if the box is ticked or not. Thanks.
-
SQL Server DB & Navision DB
Hello! Could anybody help me? I've a such problem: We have Navision 3.6 with database on SQL Server 2K. When i want to Write-off an item which i have on my warehouse, i get a message, that there is not enough quantity, but it's not true. In Item Ledger i have such operations: (Positive Adjmt., Quantity - 115, Remaining…
-
Price Rounding in Sales Order Form
I am having a small issue with the cents rounding to the nearest dollar for any given item. I went under General Ledger to Invoice Rounding Precision and it is set to 0.00 - I tried changing it to 0.01 and I get this error - Inv. Rounding Precision must be rounded to the nearest 1. Any help is greatly appreciated
-
SQL in C/Side ODBC
I'm trying to access Navision Attain through ODBC using SQL. I'm trying to use a CASE statement, but I'm getting an error everytime it runs. The error is: [Navision software a/s][Navision Attain ODBC Driver]Expected lexical element not found: FROM the sql i'm using is: select case "G_L_Entry.G_L_Account_No_" of…
-
Route to becoming a certified Navision Developer
Hi Everyone, I'm new to Navision and interested in becoming a certified Navision Developer. I've just commenced work on a project to tailor Navision to manage a companies supply chain, CRM and finance department, and while trawling through PDF's is fine for now, formal training and certification appeals. I'm sure there's a…
-
Including German/Austria/Chzech Payroll in German Database
Because it's a german System, there are only german solutions, so in german: [German message text removed by Administrator] Because this is a English only forum, your message was removed. Wow, very bright idea! So again in English (please answer in english, maybe otherwise it will also be deleted) is there someone outside…
-
How do I exclude lines with zero values in every column?
How do I exclude lines with zero values in every column in my report? I've tried to set PrintOnlyIfDetail Property to Yes but that didn't work... Thanks in advance...
-
Store Procedure
How i can call a Store Procedure of SQL from navision 3.70 Tanks
-
Blanket to Sales Order
Hi,Can any one help me out in this.Thanks in Advance. As per Navision Standard the system creates new Sales orders for every make order we do from the Blanket order.But we customized the system such a way that the system appends the lines to the existing sales order( If it Exists) so that every customer would have only one…
-
Security for Dimesnions
Has anyone written or is awhare of anyone who has written security for dimensions. Can you specify wheich dimensions may be entered on a transaction by a user, or restrict which dimensions are viewable by a user.
-
Where and when we could get MBS Navision 4.0 alpha?
Where and when we could get MBS Navision 4.0 alpha? Can anybody give some links to the information about this topic?
-
Navision Essentials exam
I have just passed Overview exam. Many questions dealed with subjects not included in Overview course-documentation, but from fact sheets and marketing presentations. 1. What about the Essentials exam? Is it focused on the Essential course or not? 2. I couldn't find any sample questions or simulation on the partnersource…
-
Navision 3.70 SQL and DSN setup
We have just converted to Navision SQL 3.70. With our previous Navision ODBC connections we were able to specify the Company we wanted to use for a DSN. We are trying to setup an SQL dsn for an application but we don't see any way to specify the Company in that setup - is there a way to do this in the DSN? Thanks, John
-
the annoying Modified flag
Hi Everyone, I just got a problem after localizing a Navision database. The Modified Field of each object is set to Yes after I imported the language files. What is the easiest way to erase this flag? It is really boring if I have to clear them one by one. :?
-
Anyone made a tool to find the best key?
Simply a codeunit that gets a RecordRef as parameter and based on filters and table contents tries to find the best key. I'm thinking about starting a small project where I try to find the best key while making limited db access. But if anyone already made it and is willing to publish the code it would be great. :-)
-
someone sales Application builder & Solution developer 2
Please comment....
-
Importing Problems
Hi all, I have a FBK file from my Sql database at office. Now I wold like to import it in a new, blank, just created Local Database. Everything is ok but, at the end of the importing procedure Navision says: Object name already exists. But the Database was blank!!! After that the import stops... The new DB works well but…
-
Internal Error 2 in Module 10
Hello Has anyone encoutered this error before? "Internal error 2 in Module 10 please contact your dealer" then Navision hangs. Basically you can not access anything, reports, forms etc please assist on how to solve this I have practically tried everything I could! Cheers Abu
-
How to set a new active Record in a form
Hi, can anybody tell me, how I can set the new active Record in a Form after the old one has been modified? I have a form in that not every Record can been changed and I want to set the Cursor to the next possible Record after it has left the old one. I've tried this, but it doesnt run correctly: OnAfterValidate() REPEAT…
-
Navigate showing unrelated records
I'm experiencing a situation where the Navigate is showing me a few records that do not pertain to my filter. Has anyone else ever seen this and if so, how do I correct it? Thanks!