-
CHANGECOMPANY won't work?
I'm currently developing a report with the following DataItem-structure: Company (BDRF)Intercompany Posting Setup (IPS) Company (BDRF2) For each BDRF2, I need to execute the following code: GlaRecGlb.CHANGECOMPANY(BDRF2.Naam);GlaRecGlb.GET(IPS."R/C account");GlaRecGlb.CALCFIELDS("Balance at Date"); These lines should make…
-
Dataport conversion characters
Hi everyvbody, I am exporting 3.000 articles via a dataport to an csv file. Everything is running fine exept the special german "Umlaute" which are not shown. I know this is a problem ASCII <=> ANSI, but unfortunaly I am a Navison starter and have no idea what to change where. The only thing I thing can work is a the…
-
Export Data direct to MySQL Database
Hi everybody, I am very sure, that this question is asked quite often. But unfortunaly I found nothing which can help me :cry: I need information on products (for a webshop) in a MySQL database. Currently I am creating a txt file using a dataport. An than load the txt file into the database. This causes me a few problems…
-
Connectivity Problems
Ok here is the scoop. I run Navision Sql option. Server 2003, SQL 2000 SP3 and Navision attain 3.01.B. About three days ago we moved the sql servers physical location to another room and ever since then my users have experienced dissconects. They will be working in any module and in the middle they will get a navision has…
-
How to make a HMS2TIME?
I need a function like the DMY2DATE, just for TIME variables. There is no problem in just making a simple function like this:Function:HMS2TIME(Hour : Code[2];Minute : Code[2];Second : Code[2]) Time : TimeEVALUATE(Time,Hour+':'+Minute+':'+Second); But how do I insure that it works for all imaginable reginal setting? It…
-
Position in the Form
Hi Forum, i want to create in the form the position of the cursor to a new line with Type :: Item. for exampel: in Sales Order add a new line with type::item. the item has item text lines, they automatically inserted in the form. if i leave the item line, then the cursor should position in the first (new) line after the…
-
FM Exams
Hi, I am taking the Financial Managment exam on Navision Attain next week. Can someone help providing me a few sample questions? My e-mail address is vaggelis75@in.gr Thank you!
-
Automated switching of users into Navision
Does anyone know how to switch users in Navision without leaving the application, or by providing an automatic login. Windows authentication is not to be used, because it requires logging off and on to the system again.
-
Job scheduler bug?
Is there a bug in Navision 3.10A for the Job Scheduler function? It seems so... the following code in the job sched mgmt form is... IF (TIME - LastCheck) / 1000 < JobSchedMgtSetup."Interval Check (Sec.)" THEN BEGIN The problem is that when the time changes over to the new day the left side of the express turns into a large…
-
Filtering like in Reports also in MS Access???
I'm Navision-Attain programmer and now have to write a little agent management system in MS Access. The problem i have could be solved with navision and its great filter-functions in reports VERY EASY, because this is the heart of my little management system. ->With "filter-function" i think of the functionality (in…
-
How to determine the size used in a BLOB field?
Does anyone know how to determine the size used in a BLOB field, in a native Navision environment? I have been searching the Help, documentation and virtual tables, but without result :(
-
Using Array in CALCDATE
Hi There, Wonder if you can help with syntax want to calculate StartDate from WORKDATE - value of array M. StartDate := CALCDATE('-i'+'m',WORKDATE); So if array i =4 will perform the following: CALCDATE('-4M',WORKDATE); Thanks
-
CodeUnit guidence
I am first time programer for Navision and need some guidence I have two tables in the Navision Sql database one is navisions own table and the other one is a new table created by me. Now on a scheduled time every day I want to transfer rows from my new table to navisions table and delete rows in my table after the…
-
Values into FilterFields if a report is being printed
Hi, I need to fill out some requested filter fields so that they contain values if the user is opening/starting the report. This works if the report is being defined as a local variable and is started with RUNMODAL. But I need to fill in these values if the report is being printed from the form 282, "Report Selections". Is…
-
How to Create a word Document with Information as in Reports
Dear Friends, I want to save my report output in a word document. as we save it as an html file. is their any possibility to store the same data in word format. plz let me know. Naresh Nune.
-
Filtering to achieve seperate results in report
Hi There, Wonder if you could help, I am writing a report and wish to calculate the sum of values within a date range for a period of time for example January February March April 2000 9088 43434 4555 The above is an example of the report layout and the values shown beneath the headings will come from same table, so the…
-
Automation Variable Issue
We are working on a project that is taking data out of Navision and dumping it into a xml format. The issue that we have is that we have an "Autmation variable has not been instantiated" and no matter what I change in the CAL Locals to point it to the MSXML it will not get past. Any suggestions?
-
Printing PDF-files (without dialog box) from Navision Attain
Hi, I'm working on a project and the customer asks me to print PDF-files from within navision. Because he doesn't want to see a dialogbox each time, I'm working with /t instead of /p. I do the following: AcrobatPathName := 'C:\AddOn\AcrobatReader\Reader\AcroRd32.exe'; FileName := 'C:\document1.pdf'; PrinterName :=…
-
training material
hi people, does anyone have any kind of preparatory tests, with questions and answers like the ones they have on the certification exams Overview, Essentials and Development? i'm taking the Overview exam on Monday and then i'd like to proceed with Essentials and Development exams but all the documentation i have cosists of…
-
Navision 3.7 Hotfixes (World Version) - Urgent
Hi, Could anyone please help me with the most recent hotfixes? I have installed hotfixes 1 to 11, but am aware that there are actually 16 hotfixes. Could somebody please let me know if they have these. We have tried downloading it from PartnerSource, but have only been able to download the US Version. I have a problem in…
-
How to get OK button back?
Hi guys, I added a new command button on a form, and the orignal OK and Cancel button are gone, how can I display all the buttom all the time? Thanks!
-
Impotring a .csv file
Hi I have a comma saperated file containing shipment information of goods shipped against a particular sales order. This file is generated as and when the goods are shipped at warehouse. the file looks like this DateOFShipment, salesOrderNo, ItemID, Quantity There are several lines like this for different sales…
-
Refernce site for navision
Hi all, I want to know about the sites which are usefull in having refernce for navision and even for exams too . Can any one send me the site addresses. Please send me it to the following address. rajufss@yahoo.com some of the sites which are usefull for exam point of view according to my knowledge:…
-
Partial Sales Invoice
Hi all, Before, sorry for my English! I have a problem: I want to create a sales invoice with "Fonctions/Extract expeditions lines" and to invoice witn % method for items with serial numbers. Example: I have an item with quantity = 7 and 7 serial numbers. I want to invoice for my client 40% on quantity, so i have qty =…
-
Help Creating Active Vendor Labels
Help! Recently I was asked to create an active vendor labels reports that pulls all active vendors using Vendor and Vendor Ledger Entry table. The report uses Post Date to filter for the most current Vendors, and create Labels for our AP Department. I started by using the (10105)vendor labels report, Renamed it: Active…
-
Creating Instances problem
Guys I got the following code to identify between USA and MEXICO company. But I am getting an error message, the problem is cause because the instance but I do not know how to fix it. This is the error message I am getting: "There is no curency exchange rate within the filter". Filters: Currency Code:1, Starting Date:…
-
Lockings with Messages!?!?!?!?!
Ever heard of the followling...... To simplify the Warehouse process, I've made some customizations in which I've placed several standard functions after oneother... From a Sales Order, with one push on the button you can create a Warehouse Shipment, release it, and place the Warehouse Shipment Lines in the Pick Worksheet.…
-
help!!
hi everyone, would anyone be so kind as to give me a clue how can i print on the invoice report for each line on the posted invoice the serial no. of the items listed... thanks a lot...
-
GL integration
Navision has it's own way to post tranzactions to General Ledger. I am interested if there is a document which describes for every type of tranzaction (purchase, sale, reevaluation etc.) what happens in GL - which accounts are used to obtain the result. (eg. in a sales we can haze 2 entries: acc receivable=sales COGS=inv)…
-
error when posting an invoice
hi everyone... i encountered the following problem : when i try to post a sales invoice i get the following error message : "Reference to member CheckCOGSDimValuePost of the variable could not be solved" can anyone tell me where to look for the problem? thanks a lot Mada.