-
Outlook Integration in 3.10 after upgrade???
Hi. I would like to know if it is possible to upgrade navision 3.10 for using the Outlook/Exchange Integration?? With 3.60, 3.70 and 4.00 i had no problems to use it but i need to use it in a 3.10 database or 2.6. Anybody experience?? Thanks for your help!
-
Calculation Average Cost (LCY)
Hello! Navision Attain uses value entries for calculating average cost("Cost Amount (Actual)/"Invoiced Quanitiy"). Entries are taken into consideration, if "Expected Cost" is false. After an upgrade from an old version (2.0), the calculated value for old items are often too high. Has anybody a good idea, how to correct…
-
Deleting External File within Navision
Hi Folks, Does anyone know how to delete a external file within Navision. Everytime i run a dataport to export records and if the file already exist on my C: drive system gives a message 'File already exist. Do you want to overwrite'. I want to delete the file evertime i run the dataport. Has anyone done this kind of…
-
Pageno on Reports
Hi, i´ve got an report that´s first page is blank. --> no problem showoutput >1.... but when the report is printed the pageno begins with 2! how can i modify pageno 2 --> pageno 1 pageno 3 --> pageno 2 pageno 4 --> pageno 3 .................and so on?? thanks for your anweres. george :roll:
-
Another Problem with the Outlook Intergration
Hi, When I want to synchronise Navision 3.60 with Outlook 2000, I get this error message so I can't synchronise: "invalid assignment. It is not possible to assign a _OApplication to a OApplication". If I synchronise Outlook with Navision 4.00 it works all fine and I am not getting any error msg. Does someone know why I get…
-
How does Navision 3.60 compress BLOB data?
Hi I'm inserting bmp images into Navision BLOB columns using an external tool. I do this by inserting raw BMP data into the BLOB cells. However, I'd like to insert the data compressed, so it takes up less space. Do you know what algorithm Navision is compressing/decompressing the data with? Or do you have another idea…
-
reading materials on Navision Manufacturing
Good Day! Can anyone be kind enough to send me a softcopy (PDF or Word) of Navision Manufacturing? Thanks!
-
Calculation Field On Table
I have a new table, in which i have a field called Controlled which is an option No, Yes. This field is then used in table 2 as the USED Field. Quantity, Used (Count = YES, Flowfield) and Remaining. I have set on the onvalidate trigger of remaining a caculation Remaining := Quantity - Used The remaining figure is not…
-
Excell worksheet
Hi, I make one report to export Item Inventory and Consumption to Excel. It shoud be enter in one Workbook, one File but two different Worksheet. I've tried many ways but it always created 2 Files ](*,) Can you help me? Thanks. Here is my code: If I don't use Createbook in my second function, it would cause an Error 'No…
-
How to make normal cursor in the TextBox in multiline mode ?
I've made the TextBox with property multiline=yes, made size of it for entering several lines, but when I enter something, string become single and cursor size is very big. Is anybody who have an idea how to make it normal like in other TextBoxes ? Thank you all.
-
Report repeat line
](*,) My report repeat the second line after the register when the register overtake two lines. I don't know where clear varible??? Rollo
-
EDI Integration
Hi, We are implementing the EDI solution for Navision. We spoke to lanham associates and e-bridge soft who also provide EDI solution for navision. Can any one tell me how long does it typically take to implement EDI for all the process and with about 20 trading partners? Cause the solution providers are giving us an…
-
Modify 'table relation' property of a table field at runtime
Hello I want to narrow a table relation that is defined in the table field properties. How can I change this table relation at runtime ? thanks.
-
Check security filter defined in a role
Hi ! I have defined a security filter for a table in a specific role. It sets a filter on Global dimension 1. In certain areas of Navision, I would like to test the value of that security filter so I can use that value in another filter on another table. Is there a way to retrieve, at runtime, the value of a security…
-
Unknown Automation Server in subtype of variable
Hello. I have a report that shows information by ms-word. I have Navision Attain 3.01. I have upgrade the operating system to Windows XP. After this, in the C/AL Globals definition of that report the variables of type automation in subtype appears: "Unknown Automation Server.Application" "Unknown Automation…
-
How to now the server name
Hi, I need to now the name of the server when in Navision. It would help me to now to witch personne to send a email, when I am in developpement or production? Can I get some help. I have tryed EX: string:=ENVIRON('ComputerName') but it gives me the computer name not the server name. Is there a environmental variable to…
-
selectlatestversion
can someone give me an example of using the function SELECTLATESTVERSION in the CAL Code.
-
Lanham EDI
I don't know how many of you use this but... I have a partner set up that works, 850 POs 865 ASN's 810 Invoices All Work Beautifully~ Now I have another customer that wants to be set up EDI and just to make things easier they use the SAME templates!!!! So all i did was copy the EDI Templates from 1 customer to another. All…
-
Exce automation when Data Item is the same but it has Loops
I got report 50011 Cash Applied. Report Designer looks like this DataItem Name Cust. Ledger Entry <Cust. Ledger Entry> Cust. Ledger Entry FirstLoop Cust. Ledger Entry SecondLoop Cust. Ledger Entry ThirdLoop Integer <Integer> My question is when I try to send it to Excel how can I choose SecondLoop information. Paco
-
Sending E-Mails in Navision -> Unknown Automation Server
Hi, what must I install to send E-Mails in Navision ? Klaus
-
Form Permissions
There are some users that I would like to give permissions to the Job Ledger Entries, but exclude any payroll related entries. I created a new JLE form that filters these items out. I figure that when they select Job Ledger Entries from the Job Card, I will have it check their permissions are run the appropriate form based…
-
Change field values
Hello, I need to fill a temp. table with lots of fields gathered from a few tables. I´m talking about 40 fields. I guess my code will look like: field1 := table1.field1;field2 := table1.field2;field3 := table1.field3;field 4 := table2.field;... I bet there is no better way then typing a procedure like this? I think of…
-
Phantom BOMs
In Navision 3.6 when using phantom BOMs and an item card exists for the phantom, The item card "Where-Used" functionality doesn't see where in the BOM structure the phantom exists. Can someone advise of any solutions or fixes to this or advise of the logic behind not being able to see where a phantom belongs in the BOM.…
-
C/ODBC numeric Scale Problem
Hi All, I have some script that uses ADO 2.8 / C/ODBC to extract data from Attain 3.60 to a flat text file. Server1 is the Navision Server, Server2 and Server3 are servers I execute the script on. Both have same language settings, and same C/ODBC version and settings. They both connect to the same data on Server1. My…
-
get a record based on two values
Hallo, I need to select a value from a database with getRecord. The problem is, that I have to select a warehouse code from the report header to use this code to select later in the line the right sku to get a record identified with the item number. this could be the code to get the Record:IF getLocation.GET ("Item No.")…
-
Extended texts in reports
Hi, I need to put extended texts from G/L account in reports and make them works within selected language. What have to be done in order to make them working ? Thks
-
Access to Navision Attain 3.60 native db with Visual Studio
hi, i have to access to the navision attain 3.60 native database (no sql) with visual studio .NET 2003. i found two ways to do this: c/odbc and c/front. so my question is now, what are the advantages/disadvantages of c/odbc or c/front, what should I take to access to the database or is there another (better, easier) way to…
-
Validate request form input in Report
Probably this is a verry stupid question but i can't see to figure out how user input on the request form of a report can be validated before the report is run .. #-o The problem is when i put testing code in the OnPreReport trigger and generate an error the whole report closes :roll: After validation of user input in the…
-
Undo Fixed Assets Receipt
Hi all, I have to undo a receipt for a fixed asset. The receipt is made from Purchase Orders and has generated only an entry in Purch. Rcpt. Header and Line tables. The Invoice wasn't generated. I cannot solve this issue. Thanks in advance.
-
Illegal Operation
Hi All, Anyone has any ideas about the illegal operation during sales invoice posting?what is the causas for this problem? My customer is getting a system error message and can not perform the invoice posting. My customer has reintall the OS and also navision, however still getting the message when perform the invoice…