-
Info needed
Hi everyone! I've got a situation : There's not enaugh data in my help file .For example no info about Find('-') - what does it mean ('-') and what difference with ('+') and so on . Can anybody give me direction on actual Help ?
-
Blank Item No.
After fighting with this problem for 3 days, I finally post on here for some help. My very next attempt fixed that problem. Edit: I can't delete the post so I removed my silly question.
-
Determine if table keys are being used/still required
Does anyone know of any free utility that can be used to determine if keys are still required ?
-
List companies in a Navision 3.7 c/side database
We develop a .NET application that retrieves information using ODBC from a Navision 3.70 database. When i create the DSN to make the ODBC connection i have to specify the company, otherwise i can not create a connection to the database. In order to specify the company i would like to retrieve a list with the companies that…
-
Attain .fbk file size
Hi.. I have the following observation to share and would need some advice: I'm trying to restore a backup of a database from a customer of mine that is created using Attain SQL Server Option to do some troubleshooting. The .fbk file size is 2GB and the filename is Requested.fbk. While restoration to about 75%, Attain…
-
Mbs Partner Methodology Modeling Tool
Hi, Did somebody already use this modeling tool and do you now if there is some book to use it because it seems not very easy... Thanks Jean
-
How to restrict access records ?
Hi, How to make few users access only certain records of a table? regards, Sarukai
-
get sub form record from main form
I have a main form (card form) and a subform(list form) and in the code behind the main form I am trying to find out which record in the subform has been selected. Say for instance I need to get the primary key of the record selected on the subform when the user clicks a button on the main form and then use this to do some…
-
Can Nav Backup/Restore perform by coding
Is anyone know how to perform/call the Navision backup or restore by using coding? I need to do a design to call out backup/restore function by using coding.
-
Automatic Multiple Export
I have 4 dataports I am running that exports to CSV. Is it possible to creat a form with a button which will automatically run all 4 dataports with the specified file output name and location. Kind Regards
-
Adjust Cost - Help Needed
I seem to be in some trouble: a customer of my company was supposed to run the "Adjust Cost - Item Entries" report on 31/12/2003, but didn't, now i'm have to filter the prossess so it only applies to entries before said date. I checked the report and all it does is call a code unit: 5895 - Inventory Adjustment, which is…
-
Please help newbee...
Hi I just started to learn navision and came across one problem. I'm trying to add a control (checkbox) on a form and specifying the following in the properties: Caption: 'Blocked' SourceExpr: 'Blocked' ShowCaption: Yes When I compile the form, I'm getting this error message " The control () has an invalid data type…
-
how to get a record from other database using Find?.
hi all do any one of u know how to use the find function to select a paricular record present in other database(say PostGre)
-
sending mails through esmtp
hi all please help me in sending mail from navision through esmtp... please...
-
Need a tool to search for specified field in all objects
hi all, is there any tool to search for specified field in all objects' code
-
How can I find out if record exists in table?
Hi, I import any data from txt file to table. And when record already exist it's not possible to import into table. Exist any procedure which say me the record exist and then I have to modify this table? I do it with recordref and fieldref. Thanks
-
Filtering a LookUp
I am trying to modify a lookup to automatically filter the records on the lookup form. A fair example of what I'm trying, would be to take the typical sales order form (subform for the sale lines technically) and change the lookup on the "No." field. Upon lookup the user would still go to the "Item List" form, but all…
-
Saving Navision report as word document
Hi all, Has anyone developed an utility to save navision report as word document? or send as a word document email attachment? I am saving a report in HTML and the formatting gets distorted. (It doesn't support horz/vert lines in the report). Thanks Rohit New Delhi
-
Restoring Navision on SQL I receive error 1204
Hi to all! I'm trying to restore a Navision Attain 3.60 Database backup in SQL server running Win2k Server with SP4, but I receive the following error: Microsoft Navision AttainSi è verificato il seguente errore SQL Server accedendo alla tabella Setup Relationship Management: 1204,"HY000",[Microsoft][ODBC SQL Server…
-
What means field EU 3-Party Trade in table Sales Header?
Hi. I have a small :D question. Our company started to implement Intrastat due to entering Czech Republic in EU. We discovered :shock: field 75 EU 3-Party Trade in Table 36 Sales Header. We do not know :oops: (nobody in our company :oops: :oops: ) , what is purpose of this field. If anyone knows, what this field means,…
-
How to make columns mandatory?
Hi, How to make few columns in the form mandatory? regards, Sarukai
-
Type "Automation" not available in Locals
Hi, why can't I use a variable-type "Automation" because it is not available in the Drop-Down-field in the locals (of a form e.g.)? Our Navision solution-center told me, that a not present licence (1750-ocx) could not be the reason because they can insert a variable with our license and it seems to work. Are there any…
-
Unpack a PUP file
Commerce Portal Samples are in a file type of "PUP", what program do you use to unpack these files? -David Sheesley
-
help with poor quality images
If you are using an image box for the image on the report, there is a size limit of 32k which could be causing this. Is "jpeg view 2.107" a Navision add-on?
-
Hybrid Attain Configuration: 3.10+3.70
Hi. Someone has tried this hybrid situation? -Client & Server Navision Attain Ver 3.70 -Navision Code ver 3.10 (database converted to the version 3.70) I want to take advantage of the improvements of stability of the new version (above all in the designer, the client it often crash) and to send back the passage to the…
-
Navision 3.6 vs Terminal Server
Does someone used Navision (Navision Attain 3.6) with Terminal Server. If so, how does it work? Thanks
-
Set barcode
How to set barcode for Navision......... Thanksssssssssss
-
range setting in Flow field
Supposedly For an example, Customer and item code is the key for the flow filed quantity. I could able to filter customer and item inorder to know the quantity of the particular item purchased by a single customer. Can i apply range to customers and items which are part of flow field keys. ultimate is i need to know how…
-
MBS 3.7 - Importing data with German umlauts
Hello everybody! I have problems importing Data because of German umlauts (äöü) in a certain Field ('Suchbegriff' == 'Searchpattern(?)'). The errormessage I get is in German, that's why the translation might not be correct. German: "Die Tabelle ... enthält in einem Codefeld einen Wert, der nicht mit Microsoft Business…
-
Timber Companies
Has anybody worked with a Timber Company using Navision? Do you know of any special requirements that Navision maybe able to help with? Any thoughts will be usefull Regards Edward