-
Change Log / Setup Log permissions
We have a new 3.70 installation just about to go live but during testing we get permissions errors on the Change log and Setup log. We are running on an SQL db and I'm not sure if we need to to tweak something in SQL or Navision. The user getting the errors has the "SUPER" role at the moment so should not have any…
-
Latest Hotfix
Hi, Is there a way to find out the latest hotfix that is being applied to a database instantly? Regards, Spy..
-
Solution centres & upgrades
Hi all, Is it entirely necessary to maintain a support contract with a solution centre to keep on upgrading our system when new versions come through? Could our company receive the upgrades direct and try and implement them? OR What about changing solution centres? Are other centres willing to take on some other centres…
-
Prevent unit price from updating on Credit Memos
Hi all, On a Credit Memo, whenever you update one of the fields on a line the unit price is automatically updated from the Item Card as well - is there a way to stop this? Most of our items don't have unit prices stored against them, so the prices are often getting blanked out.
-
Importing Serial no from text file using dataport
Since this is my first visit - hi all! Problem: I'm importing a text file with Orderno;Lineno;Itemno;Qty;Serialno If there's a serialno, I want to assign that serialno to the item on the sales line and then the user should Post (Ship or Ship/Invoice) the order. I've come so far that the serial no is assigned to the line (I…
-
how to run a report for all companies
hi if anyone knows please tell me how to go about executing the report for all the companies..we can change the company..but how to rerun the same report..pls help me out regards chandra
-
Navision and .net
I am getting an error message when I am trying to connect to Navision Database using ODBC in .net. It says the ODBC driver does not support that command. I have a feeling that the ODBC driver is not compatible with .net for some reason. Anyone else have this problem? Resolution? Is there a better way to connect, i.e. using…
-
Displaying textbox borders in reports
I want to draw and display borders of textbox and labels in my applications reports. They are really necessary because these reports must have legal templates and they must contain this border shapes. But when I set Border property of controls it changes nothing.
-
Navision Attain 3.1 SQL crash on printing bitmap
Hi, I´m using Table Item to store a bitmap that I want to print on each invoice. It keeps crashing, I´m not exactly sure when the crash occurs (Navision doesn´t display en error, just exits.) The same report never crashes if I omit the bitmap. I calcfield the bitmap and use a PictureBox to display it. Any ideas ? Hreinn
-
Gen Bus Posting Group =;
We are having some real probs with Attain 3.6A. We are unable to post invoices, or create sales orders or even post payroll. The error we keep getting is: "The Tax Posting Setup does not exist. Identification fields and values: Tax Bus. Posting Group=,TaxProd.Posting Group='' These items are setup yet Attain doesn't seem…
-
Using multiple variables in email body
Hello All, The following text creates an email. I want to add multiple variables into the LtxtEmailBody variable. (the body) I could put one variable for example Description directly in there but I want to add Quantity, Unit Price, No. etc. I have tried using LtxtEmailbody := Description, Quantity but obviously I get…
-
Dataport ques-how to skip the header line when import?
Hi all, I have a text file in csv for import. However, the first line of the text file is the headers for the fields. Is there a way to skip the first line when I run import in the Dataport? Thanks!
-
Changing a flowfield creates records in the underlying table
Hi Everyone: In Table 168, Job Budget Line, there is a field number 9 called "Quantity". This field is a flowfield, which Sums up some records from the Job Budget Entry trable. The Calcformula is: Sum("Job Budget Entry".Quantity WHERE (Job No.=FIELD(Job No.),Phase Code=FIELD(Phase Code),Task Code=FIELD(Task Code),Step…
-
Navision Developers Toolkit
Hi Everyone, As a beginner on Navision Development issue I want to discover Development Toolkit. My question is "Is there any way to use Development Toolkit with SQL Server database ?" I have checked Developers Toolkit Guide twice but I could find nothing. I will be greatful if I can find any answer on this stuff. Thanks.
-
Problem creating new customers (Bill-to / Pay-from codes)
Hi all, wonder if someone could help with this. When you create a new customer and enter the Bill-to code, the Pay-from code that is assigned to that Bill-to customer does not get entered automatically in the Pay-from field on the new customer card. Is there a way to do this? Many thanks!
-
How to make Navision user hold the multiple unpost journal?
Dear all, I found that Navision don't like another ERP/accounting system, it don't provide the "batch number" for user can hold the any "unpost journal", for example one: Journal Template: GENERAL Batch Name: Default Document Number: G0001 (Hold this journal) "the problem must force user post the journal first than can…
-
Using the Timer on a form
I want to use the timer property of a form but only when I have pushed a button. Ans I want to stop the timer when I've pushed another button. Is there a way to activate and/or deactivate the timer of a form.
-
Problemas de rendimiento (i'm sorry my english is true poor)
Mi problema es de rendimiento, resulta que tengo 2 Compaq DL380 G2 (Pentium III a 1,266 Mhz, con 1 Gb de ram cada uno y 2 discos de 18Gb en Raid 1 para sistema que es el W2000 Advanced Server), todo ello unido a una Smart Array de 6 discos de 36 Gb en Raid 10. Hasta hace unos meses estaba instalado con MSCS y utilizaba los…
-
Navision database server and Active directory
Hi, I am installing Navision Attain 3.60 with HF 1-28 database server under Windows 2003 server with Active directory. As documentation states, Active directory schema must be extended for all users to see that server, and Navision gives that tool, schemaxt.exe. But when I run it I get an error like "LDAP://somewhat was…
-
Navision Application Server
Where can I find any information about NAS. Can I use Delphi Frontend to execute codeunits in Navision?
-
HELP - Cannot access main menu
Hello All, I have something extremely stupid somehow and locked only log-in out of Navision - and this holds all of my development for the last few weeks. I have no other log-in to use. All I get now is "cannot access main menu" How do I access my forms, tables etc? HELP Please...... David
-
Outer Join
Hi all... Very cold weather lately, isn't it? Anyways - just wondering if this is possible. I have a field called Sector that has values A .. Z in one of my tables that appears if another field called Group gets filled in with an 'X': eg if Group B001 gets an X, then Sector B gets printed on my report, if Group D123 gets…
-
problem with License
Hi All, We are at a client location for implementation and facing a typical problem with client license. We used developer license with client database initially and later replaced it with client license. Now whenever we restart the server, the service is not started automatically. It looks for developer license. We…
-
PO gets deleted
Is it the normal behavior of Navision that the Purchase Order gets deleted after it has been invoiced completely? Is there anything like Posted PO?
-
Update a line i Item List to font bold
Hi all! Maybe this is a piece of cake but I'm stuck. My client wants the line in the Item list (form 31) to be marked with font bold as he steps up and down. I've tried to many different options but without succes. Do you guy's have any pointers? Have a nice week end!
-
Compare text in single string
can anyone point me in the direction of how to compare text inside a single string. What I need to achieve is if the same wording appears more than once in the same string I then need to be able to shorten that string by taking the replication of the word out. i.e. 'the cold weather is cold' Shorten to : 'the cold weather…
-
Filters Problem
hi friends., I am facing peculiar problem in which, i am applying filters for the users based on their status. it is working fine. but the user always have the option to remove the filter by pressing showall button or removing filter. is there anyway that i could restrict the users from removing filters by pressing showall…
-
Disappearing Buttons in Toolbar
Running Navision Attain 3.60A After working a while in a session as a client (On PC under Win98 2nd ed) the Buttons in the Tool Bar start disapearing when I mouseover. The Functionality is still present but I cannot see the Buttons. A log off/Log oncycle will fix that temporarily. It seems that the more I edit forms or…
-
Adding Dates and Skiping Non-Working Days
How can I add to a date and skip non-working days? When I add 2D (for example) to a specified date, it skips over weekend days, but doesn't skip holidays.
-
Debtor date back aging statement design
Dear all, I would like to know is there any debtor date back aging statement in Navision. Thank you for your sharing Anderson