-
Currency Revaluation
Dear all, First of all, Happy New Year to everyone. Just a question on the GL/periodic activities/currency/adj exchange rate batch process. My client currently implemented GL module without payable and receivable module. Hence, when they run the currency revaluation batch job with option 'Adjust customer, vendor & bank…
-
NAS - Event Log Messages
We are trying to use the event log to monitor whether or not the MSMQ is functing at all times. I have a test process that sends a message to Attain through the NAS and then does a Message statement which in turn writes a message in the Application Log of the server. Here is the problem. After 20 events are put in the…
-
error 1 : incorrect function on starting server service
hello all, ive just stumbled accross this site and it looks pretty good. i was wondering if anyone can help me out ive searched for my error code but it returned about 17 pages of results, after the first 6 i decided there was nothing there to help me. i have a database backup delivered to me from hong kong every week and…
-
Rename a table linked to a form
Hi there, I have created a number of forms linked to a tables that need to be renamed. When I rename the table I can not go into design mode to change the source table (because it gives an error that the old form is no longer valid). So I open the forms (and code units) in the designer before I rename the form. Then I…
-
shrinking SQL database in version 2.6
Hi all, I am busy cleaning up our development SQL server by altering our development databases to simple recovery model and autoshrink. I've been able to free up about 200 GB already. As it turns out, the recovery model is not available for set up in Navision 2.6, the way that it is available in file/database/alter in…
-
about adjust cost for BOM journals
Dear all , happy new year! i have a problem need your hepl about adjust cost. i run ad just cost - item entries.it update the item value,but i had run Bom journals to assemble some items to a product. adjust cost can not update the item value for the product assembled from these item?so the product unit cost is error,it…
-
Many Delivery-Adresses
Hi all, i have a Salesorder with for example one Line to sell an Item with quantity 3. Now every single item should be delivered to a certain address. So, in this case, i have 3 different delivery-addresses for my Salesorder. How can i achive this??? Thanks in advance. Regards, Frank
-
Navision Attain Ver 3.60
how can i upload/transfer or enter opening balances of GL accounts in Navision.
-
How to display "CompanyInformation.Picture" BLOB
Greetings, I'm as green as they come when it comes to Navision. We're currently implementing Navision Attain in our organisation. Unfortunately our manuals are stuck at the Canada/US border so I don't have them as reference, as well as the Online Help refers to the manual. What I'm trying to achieve is to place the…
-
Urgent: Help needed for migration 2.60 fin to 3.70A MBS
Hi, I'm currently trying to migrate data from fin 2.60 to MBS 3.70A and encountered several prbs: I followed the migration document and finished to upgrade the objects as well as datas but the final version of 3.70A database does not contain any detailled cust. ledger entries nor detailled vendor entries nor value…
-
One Vendor with 2 posting group
Hi, One of client has this scenario. There are fixed asset creditor and inventory purchase creditor account in COA. They assigned one inventory purchase creditor A/C in vendor posting group to a vendor code in vendor card. This creditor may sell them FA and inventory items in one invoice. Subsequent to that, when they try…
-
Download Navision 3.60 AT - Version (Austrian Version)
Hello everybody, Is there any possibility to download a Navsion 3.60 Austrian Version? Or it is possible that someone may send me this version? Thanks for helping regards Curdin Pfister Implevit AG Zürich
-
URGENT!!! Problem with installation on w2k3 server
I have a problem....I was uninstall navision 3.60, and after that I was started setup again on ms windows 2003 server. The setup was rolled back and that's all. I don't know the reason for that situation, because everything worked fine. I was looked in EventViewer(which is also was out of order - fixed with "regsvr32…
-
Report sections on the same page
Hi! Maybe someone could suggest me how to print section header and section body on the same page. Example: Header1 body line body line ... body line Header2 --New Page-- body line body line I want it to be like this: Header1 body line body line ... body line --New Page-- Header2 body line body line p.s. i've tried to use…
-
Installation and permissions
We have installed Navision 3.60 SQL on MS SQL 2000. We have installed Navision 3.60 Client on a PC with MS Windows XP with SP2 under administrator's rights with the option For all users. When a user without administrative rights logs into Windows on that client and runs finsql.exe, Navision is trying to install something.…
-
second server
I want to install a second server for Navision Attain 3.10 but it doesn't work. Everytime I startup the serverinstallingprogram it returns with the repair/uninstall mode. Does anybody know how to install the second server on the same machine? (Windows 2000) Thanks
-
Set up posting groups for Persons/Labor in ABC
I am not a cost accountant by any means. Does anyone have any ideas on how to set up the labor resources to the correct GL accounts?
-
CustTask.dll
Hi everybody.. Has anyone met with a setup problem of navision. While installing navision client, it gives an error message about Custtask.dll.. Does somebody know something about it?
-
Migrate to MS SQL Server 2000
Hi, as you can see I have a problem with migrating to sql server 2000. I'm a newbie and I need as soon as possible response from you. I want to connect with SQL server from navision 3.60(still have a demo version). What I need to have to do that??? Navision Attain Database server??? Or just sql server and navision client?I…
-
Subform vs. Parent form
Does anyone know a way to force a parent form to update all displayed flowfields on screen from within a function/trigger of the subform? My problem is basically that I'm displaying a sum flowfield in my header that is based on the subform lines and I need this figure to update every time I update or insert a new subform…
-
Hyperlink 4.0
Hello, In 3.70 I used HYPERLINK also to open the windows explorer. for instance: The field Homepage I filled with C:\Customer. If I pushed on the hyperlink button windows explorer opened in the directory c:\customer. In 4.0 it doesn't work! Who can help me with this problem?
-
How to inc a string? (A->B->C->etc.)
Hi. What i need to do is a report for excel. Something like: REPEAT xlWorkSheet.RANGE( incStr +'1' ).VALUE := FORMAT(Table.Field); // yeah i need as much colums as are rows in the table UNTIL Table.NEXT=0; My own idea is that I can use a array of strings (static will be ok, because there are never more than 50 rows in that…
-
Need help with cfront ocx and assignfield
When i try to write data to navision using the assignfield: int newRec; Object t = (Object)"Some text"; newRec = this.cf.AllocRec( hTable ); this.cf.AllowRecordExists(); this.cf.BWT(); this.cf.InitRec( hTable, newRec ); this.cf.AssignField( hTable, newRec, 1, ref t ); if( !this.cf.InsertRec( hTable, newRec ) )…
-
see different charachters on clients on different op.system
I have Navision Database Server installed on Windows 2000 Server (English Version) and Navision clients installed on Windows 2000 (Italian Version). I write some special charachter (as ø or o with dieresis and others) in a Navision Client form a workstation (not on the server). When I open the same form on the server I see…
-
User Log On
Hello all, I need to log on one user to be used as one agent to do parallel tasks such as to import files and other stuffs, but i need to log on that user together with the first person to log on on the application in the morning. Have anyone did something like this? Many thanks, Afonso
-
stuck window
how do i get the item journal window from behind the tool bar ? i can escape but when i open the window again it is still behind the tool bar. i know this is more of a windows question but i will have many more relevant navision questions soon ... MANY. thanks for your help ! this is how it currently looks:…
-
printer selection based on document location
I want to print for example the delivery note on a printer that is automaticaly selected based on the location on the sales header. In my situation, an employee prints the document in different warehouses (the printer selection does not work in this case). Problem: The function findprinter (cu1) is called before the…
-
Formatting Dates in Reports
Hi folks, Im trying to figure out how to display all dates in certain reports ( just reports relating to our Irish site) in the following format dd-mmm-yy...but im new to navision and haven't a clue. I found a post saying to use something like the following: textVariable := format(datefield,10,'<day,3>/<month,2>/<year>');…
-
Authorizing POs
I know somewhere there is a setup that determines a dollar amount for the POs a user tries to authorize, but I cannot remember where. One of my stores is trying to post a PO but it reports that it is not authorized and then tells the user that they cannot authorize it. Any ideas?
-
Quote char in odbc query
How can I escape the quote charachter in a ODBC query? I tried to double the quote: 'o''hara' and the backslash char: 'o\'hara' but none works. Marco Morreale