-
Insert / Update Fails with ADO.NET
Hi, I am very much new to Navision. I'm trying to update a table from my windows application (.NET 2.0). I'm not able to insert or update, But I'm able to select the values. I get an error stating Driver does not support this function. This is the code OdbcDataReader objdrRecCount;strSql = "Update Currency_Exchange_Rate…
-
Expected VS. Automatic Cost Posting
As many know, sometimes the Vendors invoice does not arrive until a few weeks after the merchandise has arrived. This causes havoc with the Unit costs - some items show really crazy costs when the invoice has not arrived yet. Even when we run Adjust Costs & post to g/l reports there are always about 100 or more items…
-
Modifying Report..
We have a report #10048 Customer/Item Statistics. It let's me filter a certain customer and see the sales break down by item. It doesn't have a field for Variant Code, which is where color is. I'd like to add one, and in the future add more to that report. Is it fairly simple to modify a report if I get the company to give…
-
How to Get the values
Respected sir, I have 2 tables - Tabel1 and Table2 Table 1 has 2 fields -- Barcode No. and Item Desc. Table1 is filled with values. Such Barcode No. Item Desc 123 abc 235 sdf 124 uww Table2 has 2 fields -- No. and Desc. And only No. field is filled with The Barcode no but not orderly as Table1. I have to do some…
-
Protocol
Respected sir. My question is that when a client uses SQL database of the server it chooses NETBIOS protocols and when uses Navisison database it chooses TCP/IP why? Plz send me detail about Those type of protocols. Thank u
-
Illegal Operation
Hi There, My customer is using Navision 3.60 with hotfix from 1 to 20, dabase used 84%. However, some of the PC will get the illegal operation error message occasionally. Below is the frequency for the message occurance : 1) 21 April 2005 2) 27 Aprial 2005 3) 26 Sept 2005 The message prompt during : 1) Printing invoice 2)…
-
Scheduling backup task
Hi for all, How to schdule Navision C/SIDE backup task for the database ? Thanks in advance.
-
Navision 3.60 upgrade
Hi I want to upgrade a 3.60 database to 4.0 SP2. I must first upgrade it to 4.0 and then to SP2 or is it possible directly? Can you please tell me what steps should I follow to to this by the book?
-
setup table
Hi again. I want to create new company with same setup with the previous one, unfortunatelly, i have make transactions in the previous one. What should i do? Delete all transactions tables ? Create new setup ? Any tools to copy all setup tables ? Thank you.
-
milos
Our 3.10 native db tends to slow down and eventually crash (once, twice a month). Rebooting the db service 'solves' the problem. The eventlog on the Db-server registers the following event when de db performance is slowing down : Event Type: Warning Event Source: FRU Event Category: None Event ID: 109 Date: 6/26/2006 Time:…
-
Problem with COGS. Inventory Value zero on Item Card
Hello.. I've got a problem with the calculation of the COGS. I've got some different items where the inventory value zero is checked. So when creating a purchase order for this item, it automatically values inventory increases at zero cost. (after running the Adjust cost - item entries batch and Post inventory cost to…
-
Identifying customized objects without the version list
Hi, Is there a way (an easy way ?) to determine if an object has been modified from the standard ? WITHOUT using the version list :(
-
Internal error 100
I have encountered the follow pop-up error when operating Navision 3.6SG. What could be wrong? The error happened on two seperate computers so the problem might be on the server side. Thank you in advance! Internal error 100 in module 11. Contact your dealer if you need assistance.
-
error 1190 in module 19
Hi I have a 3.60 Navision standard db which I have to upgrade to 4.0. When testing (even minimum) and also when trying to make a backup i get the following error message: There is an error in the database structure. The error (1190 in module 19) may have been caused by the computer or a program. Table: User Role Company:…
-
Print orientation of output PDF
Hi all, I see a lot of references to PDF995 on this forum, so I have tried to use it in our application, with success - except for 1 (not so) small problem: The problem is that the PDF995 driver doesn't seem to identify that a report is designed in landscape mode when run from within the NAS, so it prints the report in…
-
How to call from subform function of a form.
Hello all. Our developer is now trying to make "interactive statistics" in sales order, so he made a subform in the header of a sales order with some statistics in it. But to updait statistics you have to press button on a form. And I would like to have values changed in statistics subform when I changed values in sales…
-
Costing White Paper for Navision Attain 3.60
Dear All, I would like to ask you about Costing White Paper for Navision Attain 3.60, where could I possible obtain it..? could you please send me or tell me the webs that I could download it..? any answers from you are welcome and thankful. Rgds, JOhnson
-
Dialog Box - CANCEL button
Hi All, While posting(Sales/Purchase order) routine, one Dialog window appears with showing the posting process. This window has a CANCEL button. This is not a form since it's a dialog. Can we disable the CANCEL button on this dialog box???. The purpose is, user should not be able to CANCEL the posting process due to any…
-
Ordering by Date-part of a Datetime
Hello everybody, I just started C/AL programming. Besides the usual comments on the editor, i really like the way Navision works. Thanks to the intuitive design and this forum i was programming the first day at the job. But i've got one question though. I've got a number of items in a table, with among other things, a…
-
Table Searching out of control
If you use a primary key field in a secondary key, is there any potantial problem? I have a table that has the following primary key: Document type, Probill (essentially Document), Line We have a secondary key: Probill, Line, Manifest, Client, Carrier, Carrier Service, Origin, Destination This causes searching hell and…
-
NAS service won't run Adjust Cost-Item Entries routine
I have a problem getting the Nas Service to run the Adjust Cost-Item Entries (report 795). I'm running NAS-SQL V3.6 The NAS service runs a timer and calls various routines at different times(eg Batch Post sales orders). However when it runs Adjust Cost-Item Entries I receive an error 'You do not have permission to modify…
-
How to filter using OR in DataItemTableView?
Hi there, I am writing a report to display records from General Journal Line Table whose "Acc Type" = 'Bank Account' OR "Bal. Acc Type" = 'Bank Account'. But, my problem is, WHERE(Bal. Account Type=CONST(Bank Account)|Account Type=CONST(Bank Account)) gives me error during compilation. It keeps saying that an ")" is…
-
SQL restore error
When I restore a Navision backup into SQL, the restore works properly, but I get the message: "The Payment Terms table does not exist as the required object name of nav40sp1.dob.SPSI$Payment Terms in this database." When I go into SQL and look at the tables, they have a different prefix (just "SPSI$Pay Terms" for example).…
-
Problem with transactions - controlling commit
We are trying to create a procedure that will undo a shipment and automatically post a corrected shipment. We are using standard Navision functionality by calling procedure that calls the following CU: CU: Undo Sales Shipment Line & CU: Sales Post The problem is when somebody else is using Sales Line table (table locking?)…
-
navision 3.6 / capturing bar codes / Item tracking module
This is actually a repost question that was already answered under the forum subsection for navision >=3.7 but I need to rephrase to apply for 3.6 version. http://www.mibuso.com/forum/viewtopic.p ... m+tracking Are there any issues or restrictions (or lack of required functionalties) with Navision 3.6 that will need to be…
-
Navision Attain 3.60 on SQL 2005
Has anyone tried to create a database on SQL server 2005 with Navision 3.60? Has anyone tried to run a Navision 3.60 on SQL 2005? Any reply appreciated!
-
Problem in the Sales Header
Hi we have created a sales order, made some shipments from the sales order. But one of the user deleted the Sell-to-Customer code from the header after the shipment is made.Is it possible? when i try the same thing in a dummy database, the system did not allow me to change or delete the sell-to customer code. but it…
-
New BUG when running report
I don't know if this is a bug (NAV 3.60) or just weird coincidence in my report but here it is: I run my report from Sales & Receivables -> Reports and it runs fine but when I press the Lookup button on the report the look of the report changes - just the body section remains :?: Now, every time that I try to run that…
-
OCX, Microsoft Common Dialog Control
Hi, i tried to use the "Microsoft Common Dialog Control" (comdlg32.ocx) via an ocx variable. If i try to save my code i get the error message, that there is a designer license missing for the ocx control. Could this be? Do i need a special developer edition of the comdlg32.ocx file? Has anybody an idea? Regards Matthias
-
grouping on a variable
is this possible?! I have created a report that creates a sub string from a string, and i wish to group on this sub string.