-
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…
-
3.60 Client on Windows 2003
Hi, I am looking for a way to install a 3.6 client on a machine that runs Windows 2003 Server. The install can't be completed, and in Microsoft's knowledge base this issue is mentioned, however there's no solution offered (see below). Thanks, Hans Microsoft Knowledge Base Article - 816598 SYMPTOMS When you try to install…
-
Days between 2 Dates in C/AL
Hmmmm.... Anybody know how to do the eqivalent of the SQL DATEDIFF function in C/AL Code? Seems like a dead easy one - until you try and find a function :? Basically it's a date comparision with the result being the integer number of days between date1 and date2. Thanks (in advance) Rob.SELECT * FROM users WHERE clue > 0 0…
-
mass unit price change
How would I change all the unit prices from $ xxx.95 to xxx.99 but i only want to change the prices ending in .95 ? All other prices would stay the same.
-
Application Server details?
Greetings, I would like to know where could I find more information about NAS. E.g., when it starts and fires 99 trigger, and it finishes, does it quit? If not, then what does it do? I'd like to know how exactly does it work, cause for now, it's causing me alot of problems.. :( I have it starting via task scheduler by now,…
-
Cancel Lot Numbers system on Items with entries
Hi, I have a database (V3.60) from a customer within Items are handled with Serial and Lot Numbers. I would like to cancel the items from using Lot Numbers no more. So I have deleted the field "Lot Nos" for an Item on wich there are already entries. However I get an error message when trying to post the Item from a Sales…
-
Transfer Order
Hi, I am facing following problems in Transfer Order. 1.While ‘Receiving’ a transfer order, that is already ‘Shipped’, the system gives a message saying that "item is not in stock".On checking, we find that there is enough stock at the transit location. Further investigation reveals that in such situations the system is…
-
Dataport Export (add to existing file)
I thought ther was a flag to determine if an export will add data to an existing file or give the 'file overwirte question', but I can't find it (or I'm wrong). Any other idea to add data with an export dataport to an existing file or is it the hard way with file create or open, and so on?
-
Outstreams
Hello, I want to append some information from recordset to an existing ACII-file. To test it I used some dummy text. WRITEMODE is true. But it doesn't function. The message I get is that there is no permission to write on this file. The drive, directory and file are in r/w/update-modus for anyone. Below I will show my…
-
Add decimal to time variable
Hi, I have a decimal value that hold a duration like: 1h 30 min = 1.30 50 minutes = 0.50 I also have a time variable, now, i want the duration added to the time variable, how can i do that?
-
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…
-
Naviflow?
I am looking for an ISV program called Naviflow (or I think that's what I'm looking for!). Can someone point me to the ISV?
-
ADCS problem
Hi, I'm want to use ADCS on attain 370 server [W2k Server SP4], to use a wireless device, but the ADCS service no conect. When I try to connect with hyperterminal, the screen still blank. No errors in event viewer, the company is correct. If i no use start miniform a event is generated in event viewer so the connection…
-
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…
-
Outlook AC - appoinment´s Start parameter wrong data type?
:-k Hi everybody, I´m using Automation Controls with 3.6 and every day I´m trying to find new posibilities what one could do with the MS scripting DLL´s (for all type of file functions) or the AC´s for office. However I found one severe problem, where I can neither find a solution nor a workaround. Let me explain with an…
-
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…
-
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…
-
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?
-
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…
-
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…
-
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
-
How to add online help.
Hi Folks, I need to add some help text to the standard online help on some of the new fields that i created in a table. Is there any i can do this or should i use some external tool to do that. Any help is highly appreciated. Regards SB.
-
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…
-
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…
-
Navision Blocks
Since we start to work with navision, we have had a lot of problems with blocks... We are using MS-SQL Server that it is supposed that it does not block tables, only registers... There is not an unique table that it's blocked... it could happen while making an invoice, or while changing an item from a salesperson to…
-
Navision Attain Ver 3.60
how can i upload/transfer or enter opening balances of GL accounts in Navision.
-
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…
-
Changing costing metod
Heja! Costumer wants to change costing metod form Average to FIFO. Does anybody have any expiriance with this? This change is planed at th end of the year. My plan is: 1. Create Item journal to negative adjust all inventory (and create a copy as positive adjustment). One line per item & location combination. Maybe also per…
-
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…