-
Running a Loop
Hello All, I have a button situated within the sales quote subform. When I press that, I want to automatically insert a new record into a new table I have created called Quote Approval. There could be many lines within the sales quote subform and I therefore need to run a loop on the sales line table for this order number.…
-
Need to create a Purchase Order from a Sales Order
Hi everyone, I'm new to this and have been tasked to add a button to the Sales Order form which will automatically create a Purchase Order and populate it with the Sales Order field values but only if the SO has been confirmed(I've already added the boolean to the SO header). What would be the correct way to enable the PO…
-
MBS-Navision Developer's Toolkit 1.3 Error
Hi all A short time ago, my colleague discovered an error in Developer's toolkit 1.3. During automatic merge process, this tool does not merge request forms of report. It will leave only original controls from base version but it will not add controls from custom version. So watch out.
-
[REQ] Nice pix for Nice ppt !
Hi everybody, I'm looking for nice pictures and navision logos for our commercial ppt's. I didn't find anything on the MBS site. For example do you know where I could find a real Navision logo ? ...Am I really forced to take screenshots of the Navision splashscreen ? :lol: Thanx :wink:
-
Automatically populating another table
I need some advice. Once a user has input a quote, another person will need to authorise this quote before they can make an order. My approach is to create a new table to hold the approval records. Therefore, I have created a button called "confirm quote" within the quote form. I then need this to automatically populate…
-
Importing a file.
Hello, Does anybody know a way to import a file in Navision without opening a navision client. This import needs to be done at one of our clients every night at 01:00 AM. The client hasn't got the sql-server. If anyone can help me out with this I would appreciate it. Thanks. Chris.
-
Company notes
Hi :roll: :?: On our database we have to companys. One in Switzerland and one in US. Is it possible, to make the company notes for german and english users? Regards Jörg Frey Navision Attain 3.70 W2K Server
-
A better C/AL editor?
Greetings people, I wanted to ask about the %subject% - are there any? Dunno about you, but I find the built in editor *very* inconvenient, inflexible, and so on, so forth.. So are there any better ones? I saw there are syntax files for EditPlus, but can it access db and allow me to edit code directly? Thanks.
-
Object Usage
Hi, We have recently taken over a project from another NSC. We want to know which objects (tables, forms, reports, ...) are used on a regular basis and which aren't. This is because the licenced objects are all used and we do not want to force a licence upgrade on our client (not yet). Does anybody has an idea how we can…
-
Navision With Java And Openldap
hi., Let me tell you the whole scenario, we are implementing navision for an company. it mainitains its user details on OPENLDAP server. now my task is that i have to fetch the user details such as mailids,name,etc., if need some modification also in NAVISION 3.1 as far as i know , OPENLDAP is compatiable with jdbc dirver…
-
C/ODBC problems
Hi, I'm setting up a System DSN ODBC to a Navision database. When I get to the setup screen I enter the following: Data source: Navision Description: Navision Connection: Server Server name: Our_server_name (the same as in the Navision File/Database/Open dialog) Net Type: tcp Use id: UserName (with admin rights) Password:…
-
Disable Button in Navision
Hello All, Another task I have been given is to disable a certain command button in a form if the status of a field in the Sales Header is of a certain value. What procedure should I take to do this? Thanks
-
Form Design Navision
Hello All, I have been given the task of allowing a user to add multiple comments against a sales quote line. As we know, standard Navision only allows the user to add comments against the sales quote header. Any ideas on how to approach this? One idea is to add a field to the sales comment line - being sublineno. Add this…
-
Suppress/redirect error messages
Hi, I'm working on one of my first major Navision projects which is an ASCII interface from Navision to my companies core Warehouse Management System. I'm running this from a standard client, but the interface needs to run unattended at timed intervals. The interface works, but I start getting problems with standard…
-
xml to navision 3.10
hi all... i'm new to navision and currently working on navision 3.10 version... i could not load and open an xml document in navision 3.10(i used load and loadxml properties)....plz help me on the same... and plz give me details regarding where i can find the solution for the same.... with lot of thanks Ganesh
-
Navision to Microsoft LDAP connectivity
hi , can any one tell me how can i esatblish the connectivity between Navision Attain 3.10 to Microsoft connectivity. Thanks in advance.
-
UserPortal error on Win 2003
Hi all, I am installing User Portal (Navision 3.7) on Win2003. But when I open my web: http://localhostname/factory/, for each web part, I have this error: "Script Execution Error: Object required " I am considering that error because of operation system or not. Because my User Portal is OK when I installed it on Win2000.…
-
Delete a record
Hi I create a new order with F3 and fill out some fields. Then I by accident hit the F4 button, but I anser No to delete. When I do that, the whole form is cleared. Does anyone have a solution to how I can keep the data in the form? kr Lars
-
Navision 2.6 Commerce Portal
I have a client running navisino 2.6. They want to run commerce portal, but do not want to upgrade. Is there anywhere I can find informatin regarding Navisin 2.6 and the commerce portal for it? Mike
-
Excel automation
Hi, i'm working with excel automation and i should format a cell. i have already done this without problem but now i shoul change color of cell depends of sign. I used this code but in run time the sistem retun me an error : Sheet.range(....).numberformat := '###0,00;[Red]###0,00'; the error is : impossible define the…
-
codebar with epson
I WANT TO MAKE A CODEBAR WITH EPSON PRINTER. THE PROBLEMA THAT I USE A FONT EAN39 TO MAKE A CODEBAR BUT PRINTER (EPSON) PRINT VERY SLOWLY SO I HAVE TO USE THE FONT OF EPSON. I MAKE A PROVE FROM WORD AND PRINT VERY WELL BUT FROM NAVISION DOESN'T PRINT NOTHING. DO YOU SOMETHING ABOUT THIS? THANKS A LOT.
-
connectivity between Microsoft LDAP and NAVISION 3.1
HI Can anyone provide me with the information..how exactly we can establish connection between LDAP AND NAVISION regards chandru
-
Restricting 'Entry Type' selection on item journal
On the item journal you have the 'Entry Type' option of 'Purchase', 'Sale', 'Positive adjustment' and 'Negative adjustment'. As we only want our users to use the 'positive/negative adjustment' options, could the system be set up to give an error message if the user selects one of the other options? Many thanks.
-
Codbc - Isa Error
Connecting a Navision Database Server from an Excel sheet, using a CODBC connection I am obtaining a message that says "ISAM ERROR", and connection fails. Does anyone knows what is it about, and what am I doing wrong? Thank You
-
Tables definition
Hi, Where can I found documentation about what is each table in Attain's 3.60 database ? I want to create P.O.s from a web application, what tables do I need to fill ? TIA
-
Outlook integration error
Hey all, This is about the one where you have to register a different version of the application handler. I used to get the error that says 'cannot load...blah blah', so I unregistered the dll, registered the one from the product cd, and now I get another C/AL error: This message is for C/AL programmers: This automation…
-
E-mailing a report from Navision and embedding images
Hello, I'm an Attain programmer in Spain looking to solve a problem. It is that if I send want to send a report, e.g. Sales Invoice, by e-mail (File/Send/Report by E-mail) to a customer then the Outlook integration works perfectly but (BUT) the graphics in my report are not embedded but are sent as separate attachments. So…
-
Difference between W1 and PH
Hi, Does anyone know the difference between W1 version and Philippine Version of MBS Attain 3.7? Is there any demo version for PH that I can download?
-
A bug?
Hi, I created a Flow Field, the CalcFormula is: Sum("Item Ledger Entry".Quantity WHERE (Item No.=FIELD(item No.))), where "Item No." is a field in my table. If i run my table - Navision completely crushed with a message: "finsql.exe has generated errors..." bla-bla-bla If i delete my FlowField - it`s OK. What`s wrong?…
-
Intercompany Transfers
Hi, Im currently faced with a prospect seeking multiple companies and inter company accounting.This prospect has a peculiar need. The prospect is an export house and has two business units (say A and B.Both export houses). At times, A procures materials and processes it. However,due to the law of the land, business unit A…