-
Upgrade 2.6 to 3.7
I looking for some who has done an upgrade of Navission 2.60 to 3.7. We are upgrading a 25 gig database and it is taking 40 plus hours. Is there any way to speed this process up.
-
the relations between due date and ending date in MPS/MRP?
Now one end user complain the interval between due date and ending date of Sales Order and Forecast after MPS calculation. In our system, the interval are normally 1 week. But this time we found the interval for some forecast change to 3 weeks and the interval for SO keep 1 week. I read some document and realzie that…
-
Renumber keys
Hello, I have a table "files" with "No" as primary key. Here are a couple of records in it, which are assigned by automatic no. series. For Example EX/0011 - FILE 1 EX/0013 - FILE 2 EX/0015 - FILE 3 EX/0012 - FILE 4 EX/0010 - FILE 5 .... Now, i need to renumber the "Files" table depended on a new SETCURRENTKEY. So the…
-
Outlook Automation:MeetingItem
Hi all , how are you ? I am self training for outlook automations…. I try to use Outlook “MeetingItem” but I get error I cant find any help in MSDN VAR: OutlookApp Automation 'Microsoft Outlook 10.0 Object Library'.Application OutlookMeeting Automation 'Microsoft Outlook 10.0 Object Library'.MeetingItem CODE:…
-
Outlook Integration Expert Needed
Hi, I really need some help regarding our Outlook Integration. It behaves weird! We have approx. 5000 contacts, quite a lot but still....when synchronizing between Navision 3.70 SQL and Outlook it takes up till 13 minutes if it doesn't crash before that. We have Navison on Windows Server 2003 and we use Outlook 2003. The…
-
Date format
Does anybody know why navision does not accept dates in the format dd-monthtext-year. Example 20-Apr-03, 21-May-04, 30-Jan-04. Do we need to change the system date format ?? or is it to do with client executables ? To check this out go to any date field enter 21-May-03. the date will be accepted but returns a different…
-
help me on some basic things
Hai, Please help me in solving the following : 1. Navision Product is a ? Object Oriented or Object based one. 2. C/SIDE Environment is a ? Object Oriented or Object based one. 3. C/AL is a Structured programming? 4. Give me introduction with real example for the Finite Loading in CRP module ? with regards, Thrishna…
-
RecordRefs in Tables
Hi, I want to create a CodeUnit that opens a Word Template and checks it for special mark- keywords. Each keyword refers to a Row of a table, so everybody can write own Templates that will be filled with data. For better administration I want to write the references keyword <-> tablerow in a table instead of hardcoding.…
-
Drilldown with field filter
Hi there, I have 3 customer-specific drilldown fields on the Item Card. The fields operate like a structure. If you choose a value out of the first drilldown field and then you want to fill in the second drilldown field, you only may view the records that have the same value as the one of the first drilldown field. - the…
-
Output to CSV
Hello All I am outputting data from Navision to a CSV file. However, there is another product involved later down the chain and they want me to remove "" and all , from numbers. For example, I currently output 1,323.34 They want it 1323.34 I am using the following to write to my csv file etc.…
-
System commands
I need to update NAVISION table using a text file, for which, I use a Dataport . But then I want to write the no. of records, and hash totals of a few selected fields also. I want to ensure there is no duplication of the job being run . After the dataport is run, I want to move the text file to a back up area and delete…
-
How can I reprint a BOL after invoicing the order?
I'm responsible for removing unnecessary transactions and processes within our departments. One of these is matching invoice, BOL, etc. by the sales department and filing them for later use. I can reprint the invoice at any time, but as of today, I can't reprint the BOL. Any suggestions? :shock:
-
Credit Card processing
How do the rest of you do credit card processing today? We use a 3rd party app/company and the processing, etc. is done outside Navision and is very tedious. I'm looking for a more automated solution embedded in Navision. Thanks
-
C/Front and SQL transactions...
Hello, we have problem with C/Front reading uncommited (i think that it is "dirty read") data from MS SQL. Can I set C/Front to some issolationlevel to read only data that is already commited? :?: Thanks...
-
Picking a directory
Hi, I would like to be able to click an assistedit button and a form should open, allowing the selection of a directory path. I know there is an example of this on this site, but it uses an additional automation server to get the windows handle. It is not desirable to use components that are not windows/navision standard.…
-
I Heard a Nasty Rumor
I heard a nasty rumor that Microsoft is requiring that MS-SQL be used for new Navision installations starting with Version 4.0. Has anyone else heard this? I am hoping that it's not true!! Even with the limitations in the native database, it's still so much easier to set up and maintain than MS-SQL. Thanks!
-
using barcodes with navision
Could someone please point me into the right direction on where to get some info/documentation on how to implement the barcodes written from the Bar Code reader into navision...
-
MS-SQL and C/ODBC Problem
Hi all; Today I have problem… Our Company have C/ODBC,SQL,NAS and NAVISION SERVER License. But we are useing only Microsoft SQL Server Option for Microsoft Business Solutions-Navision on MS-SQL 2000. I know C/ODBC dosen’t working on MS-SQL. But My company want useing C/ODBC …. Plase Tell me more about how to connect MS-SQL…
-
Messages and triggers problem
Hi ! I need to explaine a problem that occurred on my Company Windows 98 workstations but not in Windows 2000 ones. I created 2 new fields in Sales Order Lines Table, that are: Sales person, Commissions % I declared, in Sales Order Lines 1 more function, that is: get_Commission: this is the implementation:…
-
Automation
Hi, guys! :D I have a stored procedure in MS SQL. I execute it from Navision by using ADO component. It takes a lot of time to execute it so i need something like Progress Bar. Any ideas how i can image progress while SQL procedure is running? Thanx in advance. :?:
-
Customer discount
:?: Hi In Navision I can give discount to a customer group for all items. Is it also possible to add for example 30 % to all items for a customer group? Thanks Jörg :roll:
-
Fixed Len Import Dataport Problems
Hi to all, I've created a dataport in order to import data from a fixed length ascii file into a table (I've created) in navision. There are two problems with this dataport that I can't figure out. 1. When I run the dataport it inserts ONLY the first record and discards the rest. 2. There is a description field (that has…
-
Convert Duration
Hi There, Can you tell me how to remove the milliseconds being displayed all i'm interested in being shown is the days, hours, minutes. Thanks
-
Protection of License file?
Hi. We are plannig to use Navision for courses at university and aren't yet too familiar with the administratrion. Since quite a number of students wants to work on the Navision system, here is what we are wondering: Navision puts an exact copy of the license (flf) file in the program directory (server AND client), where…
-
Form in color
Somebody could explain how i can have a report using color. for ex. i need to get negatives numbers in red.
-
Navision Training Materials
:roll: I am trying to get my Navision Payroll & Distribution Certification, but I can't find the training manuals, does anyone have a copy or know where I can find them. Thank you
-
msbonline.org
I'm missing my daily fix I need both mibuso.com & mbsonloine.org :shock: anybody have news on when it will be back up?
-
Can the clients process id be retrieved?
Is there a way to find out the Navision clients process id (PID)? By pressing ctrl+alt+delete you can, on the processes tab, see a unique PID for each process, that's what I'd like to retrieve. I think it could be very useful! :lol: Thanks Fredrik
-
Planning one item code, but managing more than one.
I've more than one different item codes.These codes are very similar so that for planning porpouses I want them to be just one single code. Suppose, for istance, I want to manage my invetory with a classic reorder point; I would like to set the reorder point for a "father" item , but to manage single operative codes. For…
-
Wanting to assign "User ID" to variable
Hi There, I have a form which is basically used to filter data in a lines table. On launching the form I want the form to display a default value in one of the filter fields equal to the current "User ID". The problem I have is that no matter where I place this assignment it either doesn't show the value or only does when…