-
Upgrading 3.10A to 5sp1/6.00
I'm in the process of upgrading a customers DB from 3.1A to 5sp1/6.00 and i have a few questions. I'm aware that i have to go through 4sp3. Now isn't it possible to do the upgrade in the following manner without loss Only add any customized fields to standard nav-tables. Ignore code attached to these fields, that is i…
-
checkboxes and double sections
ok guys, here is what i am dealing with... i am working with a report and the situation is next. i made on a request form two checkboxes named "credit" and "debit". when i check "credit" i would like to see on the report only entries where i have Credit Amount values, also, when i check "debit" i would like to see only…
-
NAS ignores Report-Orientation
Hello! We want to printout some of our reports automaticly with the NAS (E.g. Fiscal Invoice). Now we've noticed, that the NAS ignores the orientation of the reports, and prints them out in portrait, though they are set up in landscape (in manual printout, they were landscape). Is there anywhere a standard setup for the…
-
Item Tracking Problem
I have problem about Item Tracking which tracking by Serial&LOT. The problem is :- User would like to issue Sales Order with this item, let say ItemA. When she select this item on Sales Line and try to select LOT/Serial on the Item tracking Line. There's something quite surprised. On the Item Tracking Summary of this item…
-
How to dispaly a report in two different ways depending on t
Hi everyone. Hope you are all well How to dispaly a report in two different ways depending on the filter selected. I have created a report in NAV and want it to filter in two different ways. First if I select a boolean called "SortByVendor" then I would like it to sort by vendor and place the data in vendor groups.…
-
COUNT Issue
I have noticed that the COUNT function in Navision is not returning the exact count always. Based on the recommendation in some of the other posts regarding this same issue I have optimized the table in Navision and then I got the correct count. We are using Navision 3.6 on SQL database. I have 3 questions. 1. Are there…
-
Cannot copy from form on Nav - Is there some setting?
Hi, We have a normal form (ie. not matrix) in Navision which pulls in multiple columns from a table to view. However we cannot copy data from this form into excel or any other application. Is there some setting I need to enable on the form to be able to do this - I have looked through everything twice and can't find…
-
Form Focus
Hello, I hope I will explain my problem. I have a from that has a button.When you push the button , Another form opens. The focus in the 2.form is not on the 2.form,but on the toolbar.(If I arrow-left , I movetrought the menu's) How can I solve this? Thank you
-
The TAB Base does not Exsists
Hello! I have this problem. I have no idea what this could be. If you like you could take a look at the picture I don't know what to do. Regards Thanks for everything !
-
RMI Rental Advantage 5.0 SP1 upgrade
I am working for a company that uses RMI's add-on Rental Advantage. Has anyone had any experience with upgrading to Rental Advantage version 5 SP1? Thanks.
-
Another User Has Modified the record for this ...
Hi Im new to Navision Development. I not to clue'd up with nav as yet and still getting used to the code but I have a slight problem I get the following error and I dont know how stop it. Another User has modified the record for this Sales Line after you retrived it from the database. Enter your changes again in the…
-
Exporting XML with some filters
Hello, I want to export the records . A Xml file must be created for every record. But it doesnt work. I created a function on the XML file(GelAllFilters). Firs I call this function after that I export xml file.. Do you have any suggestion about this ? Thank you XLabel.RESET; XLabel.SETRANGE(Resend,TRUE); IF XLabel.FINDSET…
-
Report selection
When I run an orderconfirmation-report in a salesorder, the report must select automatically the salesordernumber from the salesorder. How to do that?
-
Error:: Item #### is not in Inventory
Hi All, In one of clients who is using NAV 3.6 whenever I am trying to Post a Transfer order of a item, it says the item is not in Inventory. The ledger of the items displays enough balance to make the transfer. Has anyone came across such error or has the solution of the same, please revert back. Regards Diptish
-
Navision Integration
How to integrate Microsoft Navision in php
-
hotcopy newbie
hi experts, I tried to backup db using hotcopy...but unfortunately dunno wher to start from. after read the w1s1ism.pdf i created a cmd file called bak.cmd Inside bak.cmd containing below lines: hotcopy source=C:\Documents and Settings\teckpoh\Desktop\customer.fdb destination=C:\Documents and…
-
Suggest a book..
Daniel had recommended reading Programming Microsoft Dynamics NAV book by David Studebaker. It says 5.0 on the cover. Is there a similar book recommended for 3.10?
-
Linking field from one form to another..
Using Navision 3.10. I've went into a Table and added a field called "Standard Discount" which is text, with a maximum of 3 characters. I've then went into my Form for Customer Card and added a label and textbox to make the above Standard Discount show up. That part works fine and will save us time. This way we can easy…
-
How determine what database process.
Hello, We have two Navisions applications running on the same server. They both connect to the SQL Server database via Windows Authentication, so hence the database shows two connections by the same NT Login name. I would like to be able to identify which database connection (process id) belongs to each of the two…
-
Form opening to wrong tab
I have made some modifications to my client's Customer Card. I have added one or two tabs and repurposed a couple more. Now when the form is opened, it opens to one of the new tabs instead of the General tab. My client is vexed. I have tried placing CurrForm."No.".ACTIVATE in the OnOpenForm() and OnActivateForm() triggers;…
-
Method to get the primary key from a table
Is there any function to get the fields that are part of the primary key in Navision Attain? Something like getcurrentkey ? Any idea of how can I develop that? Thanks.
-
First time setting up a server - Can't get NAS to run
Hi, I am installing 3.60 and have a database setup. The DB I have used is a copy of another server so has all our scheduled jobs setup. The service "Navision application server classic" is running from services.msc and I have configured it via the MMC console to use the same parameters as an existing working server we…
-
Consignment or Vendor Managed Inventory
The distribution Co. I work for is trying to warehouse $1,700,000 of constantly changing consignment inventory. They have used the same "Item No."s for the consignment and Co. owned inventory. Now I have to figure out a way to isolate the consignment inventory and manage it without anything showing up on the G/L until…
-
Apply doc id and Apply doc type
Hi Gurus In a sales Invoice or Sales Order before a user Posts the same System must check the Amount Paid by a Cash customer. In my sales invoice or order i have added Apply doc id and Apply doc type but in this process i can only check if the receipt number exist or not but i am not able to compare the amount of invoice…
-
How do I add sequential numbers to G/L register table
Ver 3.1 I have created a new field in the G/L Register table, "Period Trans. No." and need to populate it with a sequential number based on the posting date range (another new field).. However, the code below is not doing it for me, I get one number for each date: 01/01/08 = 1 01/01/08 (next record) = 0 (not assigned a…
-
Ocx directprint
I've installed the dll without any problem, made a report in navision that creates an ascii-file with the necessary escape-codes and now I want to print my label with the next command pathtxtFile := 'c:\textNav.txt'; PrinterName := '\\FIPRI\PR36--BP1344'; NaviPrinter.DirectPrint(PrinterName, pathtxtFile); But this doesn't…
-
Dataport Add Header
Is it possible to do a dataport export and add description headers to the export file? Example the first line for the Sales Header export would read: "Document Type", Document No.", "Sell to Number", "Name", "Address1", etc. etc.
-
Ignore fields with the same value
hello all, I have added the sale invoice line as a data item indented under the TempCustLedgEntryLoop to the Aged acc report, so if an invoice is found to show the "Job No." on the invoice lines for that particular document and a few extra fields from the job table, as there can be several invoice lines with the same job…
-
Using older databases with newer clients.
I have a situation where I need to run an older database (ver 3.01) with a newer client (5.0 SP1 or maybe 2009) for a short period of time. Likely 1 or 2 months. We are talking the native database. I have a number of sites running with databases as far back as 3.60 but nothing this far back. I'm looking for…
-
Uninstalling 360 disables Windows Photo Print Wizard
Hi! We have a client who is migrating from 3.60 to V5. They have discovered an issue with some of their XP Sp2 machines they have uninstalled 3.60 on - That this has the side effect of damaging the inbuilt Windows Photo Printing Wizard so it no longer works properly. They have tried repair/replace of the Windows Photo…