-
Queries on Manufacturing and Warehouse
Hi Guys I have a few queries. Pls help me out. 1. How to freeze the period when Month End? – Lock Bins 2. How to make a Non-order stock in or out, for example, receiving a pile of goods to warehouse, with no order before it? 3. In a pick document, how to distinguish the take line and pick line? How does the program know…
-
ODBC/c/front connection
well first post after searching the forum for a week :) In the company we have a Navision server (c-side). The database is atm 5.5GB. A lot of users use Acces and Business Objects to gather info from the database (reports/forms) and use the ODBC driver given. But the problem is that it takes 30sec to do 1 SQl statement. We…
-
hotcopy grief...
Am I glad I've found this forum! I'm having a bit of grief trying to get hotcopy to work, here's the scenario: single server, running Navision Attain Database server NAVLIVE & NAVTEST services as domain admin (I recently changed from localhost following documentation I read somwhere on hotcopy) Ports in use for NAVLIVE &…
-
Does navision backup lock access to tables?
Does anyone know if navision locks tables while making backup? I know it does while making restore. I am asking becaues I plan to make backups while users are still working on server. Thanx for answer. :roll:
-
Copy value from flowfield to normal field?
I want to have the same value in flowfield and normal field so I can use that normal field as SumIndexField. Can this be done? I tried but I can't get it to work :(
-
print in fanfold on to a OKI matrixprinter
Is there a way to tell navision 4 to print in fanfold? I know that you can select a PaperSize in de Report properties, but there is no fanfold available. Which PaperSize should I use?
-
Nested loops + MarkedOnly
Because of some circumstances I have to use marking as ONLY solution for my filtering so it comes down to this:...SL.MARKEDONLY; SL.FIND('-'); REPEAT Flag := TRUE; SL1.FIND('-'); REPEAT IF SL1."Document No." <> SL."Document No." THEN SL1.MARK(FALSE) ELSE SL1.MARK(TRUE); IF SL1.MARK THEN Flag := FALSE; IF SL1.NEXT = 0 THEN…
-
Payment Tolerance in 3.60
We have a problem setting up the payment tolerance functionality in Attain 3.60. According to the helpindex, the field 'Payment Tolerance Warning' in table 'General Ledger Setup' should be marked to activate this functionality. This field seems to be the problem, because we can't find it anywhere. Has anyone encountered…
-
Navision backups - 145Gb database
A technical question now regarding performance and Navision Client Backups. I have a 145Gb database on the server. There is no free space on any disk that will allow me to store a Navision backup. Therefore, the backup files - totalling 40Gb - need to be stored on a different machine. I need advice on the most efficient…
-
"... cannot close because the system is currently worki
Can somebody, please, help me. I have this message that is really driving me crazy. Full MESSAGE text is : 'Get Shipment Lines' cannot close because the system is currently working. The 'Get Shipment Lines' is FORM 5708 I figured out that this is happening because I added some code that calls my function that uses…
-
Licence autorisation
Hello I have the following problem. Each time I connect to Navision the licence is requested. I have the following message: "You don't have the autorisation to execute database system licence. Contact your system administrator". Does anybody already have this problem ? Regards
-
Business Analytics configurator problem
After starting BA configurator the next error message appears: The file name "C:\...\BAConfigurator40.exe" -tSQL -s...... contains a character that may not be used Does anybody know something about this?
-
Return orders for closed Item Ledger Entries
If I post Purchase Return Order with "Appl.-to Item Entry" omitted (because original positive entry is closed) I will get wrong cost amount of returned items (because decrease is then applied to some other positive item ledger entries with cost usually different from original) (no matter is it FIFO or Average). Is it…
-
MSMQ problem (The stream returned a read error)
I am using the Navision Communication Component and the MSMQ bus adapter to read messages off a message queue. The problem I am experiencing is that the following code: InMsg := InMessage; StreamIn := InMsg.GetStream; CREATE(XMLDOM); XMLDOM.load(StreamIn); // THIS LINE RIGHT HERE :evil: causes a message to pop up that…
-
NAS and Access Automation - CLIENT.EXE ok NAS.EXE ko
Native DB V360 - The developped code unit uses Access Automation Control to create periodically an Access DB. On the server, the Code Unit runs perfectly when started from the Client (CLIENT.EXE and Run by Object Designer). When started from an NAS (NAS.EXE) the Access Automation Control doesn't work. The Event Log shows…
-
Completely Invoiced must be Yes in ILE Entry no.='XXXX'
Hi Friends I am facing a new problem while receiving the transfer order. Completely Invoiced must be Yes in ILE Entry no.='XXXX' Have any one had this problem.
-
DataBase Size...
Hi, The company I'm workin for is using SQL Navision + Infostore (POS Management) for Retail. This Add-on transfroms all sale tickets taken from tills into Sale Orders, then Posts them creating an Invoice and a Posted Shipment. No need to talk about the size of the database. let's just say that it's HUGE! We are actually…
-
Export/Import All Pics
Here's the plan. I have 1000 item pics in my system. I can create a Picture Item book with Crystal Reports. Problem is the report after a few pages generated crashes (just closes the program). I've played with the C/odbc setting with no luck. I believe it's due to the size of the BMP's installed in Navision. (between…
-
Add embedded commands in Navision report
I need to send automatically a Navision 3.1 report by email , pdf format. I use Zetadocs pdf product. I don't know how to add in the report an embedded command like %%[email:<<email address>>] Can you help me please ?? Thanks a lot
-
Newbie: Problems Showing Purchase Header Date
I'm trying to show the Order Date from the Purchase Header table in a form based on the Purchase Line table. Using the following code I get an error: "The expression Code cannot be type converted to a Option Value" If PurchaseHeader.GET(PurchaseHeader."No.") THEN HeaderDate := PurchaseHeader."Order Date"; If I tryIf…
-
Windows 2003 Active Directory
Hi All, Does Navision 3.60 supports windows 2003 Active directory ? Many thanks, Tarun
-
aling left
Hello. I'm making a report to export information to a file. In this file text fields have to be left aligned but I don't find any function that makes this. Can anybody help me? Thank you very much!!
-
Navision 3.60 Server and 4.0 Server on the same server
1. Is it possible to run Navision Database Server 3.60 and Navision Database Server 4.0 on the same Server Machine? 2. Is it possbile to run Navision Application Server 3.60 and Navision Application Server 4.0 on the same Server Machine. I know you can have more than one Application Server, but can they be different…
-
Errors of Navision syntax
Hello, I have a very strange situation:I get an error when i write for ex. FORM.RUNMODAL(FORM::"Customer Card",Customer) saying that "The variable is not a record.'Variable.Field' is invalid".The error refers to "FORM.RUNMODAL". Can somebody tell me what can i do????? :(
-
Filed Filter and Serial Nos.
Hi, If I have a Serial Nos. on a primary key on a form with manual option for this series. I have problems if the users press F7 to search for a specific no. If the number is not found the system try to create a new one and from this moment the system creates blank records every times a search value is not found. I do not…
-
ODBC Settings - DBDesigner
Hi Has anyone managed to connect DBDesigner to Navision by editing the ODBC settings to point to the C/ODBC driver? If so what values did you use for things like getdriverfunc, libraryname, vendorlib, etc?
-
Coloring field in a form
There is the possibility to dynamically change foreground color of a field at the "OnFormat"-Trigger using the syntax "currform.updateforecolor( <numer>)" (e.g 255 is red, 65280 is light green) :-k Does someone know how to calculate the number e.g for a little darker green that the one you can select from the menu. So long…
-
Error 1190 in module 19
We are running Navision 3.6 with data on SQL server 2000. While making a Backup in the Tools section we get "Error 1190 in module 19" on a table. This error points to data data has been incorrectly inserted in the table, so that the data is incosistent with the type of the field or there are illegal characters, like spaces…
-
navision 3.6 sql autentication
Hi, i yust begunn working in an new company the work with navision 3.6 and sql 2000 database. the navision license autentication will be done by sql server. (i presume this, no documentation abaout this, but I did not found any license files on the clients. Problem is the server crash and I reinstalled again the sql server…
-
Hotcopy - can you omit DBTEST?
Hi there, I work as the Development Manager for a large Navision user. It is a heavy retail environment with 60+ stores, 2-5 tills per store, all replicating to Head Office every 10-20 mins. We use the Native Database Server and the current database size is 145Gb, split over two files. We use ExpandIT to run a backup, but…