-
Security problem
Hello, when I try to create a sales order, I get the following message: Please make sure XYZ has the business permission User XYZ has the SUPER role that (in my humble opinion) should have all permissions. Where can I grant this business permission. Thilo
-
Restoring a CSIDE in SQL
Hi Folks, I am restoring a CSIDE database into SQL and there is a date difference. I am getting a error message. "G/L entry table contains a field with a date value that cannot be used with SQL server' Record No :'232323' Field Docuement Date=03/09/0040. Anyone know how do i convert the date. Regards Suresh.
-
Data Director licensing
Hello all. I'm trying to understand all pros and contras of using Ladnsteinar's Data Director. Primary question is following: is number of distributed locations in Data Director a subject of licensing or it isn't? I guess that answer is "yes", but it would be great to hear response from an experienced person. Thanks in…
-
CREATEDATETIME Filter Problem
Hi, i was wondering if anyone could help me. I want to be able to give the user the choice of what year to enter in order to give them a summary of that particular year. From the integer they enter into the text box i want to create a datetime and then filter the report on this. Trouble is the field i want to filter on is…
-
Reservation Entry
Hello! I have Reservation Entry table with to many errors (in a 3.60) :( Can I delete all records and reconstruct these table?
-
Security permissions
I am working on project that has a very simple requirement. I want to allow a User to assign security to other users. The drawback is due to a guideleine that the user may not have permissions to the tables that they need to assign to other users. I have tried several variation of how to get around this, but still have not…
-
Printer system table.
Hi there. We are running hosted solutions using MS terminal services. We are mapping the local printers at the server, for use by our customers. The problem is that the printer mapping at the servers is to slow, which results in the printer systemtable beeing outdated since the printers hasn't been mapped at the server…
-
Another field filter question..
I was in Purchase & Payables - > Vendors in Navision 3.10. I noticed there's a lot of entries in there with just a name, but no address, phone number, etc. Is there a way to filter just the ones with nothing listed for city for instance, so I can easily delete all those entries we don't need?!
-
Synchronize in Navision 3.01 SQL Server
Hi all, Just want to find out something, if anyone can answer this will be cool! Something happened today at my client's. The superuser accidentally clicked on Synchronize button, and after that some of the users were not able to log in to Navision anymore. They were only able to login after we reset their password in…
-
fin.exe
Hi, I have searched the forum for this error, but only found topics that had to do with printing. One of our users has been getting this error after she opens Navision Attain 3.6 in the morning. She opens a Sales Order, then goes to the main menu, and opens a Purchase Order. As she tries to switch back to the Sales Order…
-
Migrating from C-Side to SQL Server on Navision 3.6
Hello everyone, Been lurking in the forum all morning soaking up as much information I can on migrating the native database to SQL server as possible. Is there some document, or some resource that can provide me a detailed explanation of the process? While there are several advantages, our main reason for moving to SQL…
-
error (87): The parameter is incorrect
I m new to Navision. After I completed the client installation successfully, I tried launching it. Then it gives the error dialog: "The operating system returned the error (87): The parameter is incorrect. OK?" and of course nothing was launched after I press OK. :( I tried uninstall, reboot, clean-up the directory, 100…
-
Stock out warning to reflect actual vs expected availability
Does anyone know if this scenario is standard Navision? I have a sales order for an item that is not on inventory, but it is on purchase order. The expected receipt date of the purchase order has come and gone, and therefore, the item does not come up with a Stock Out warning when entered on a sales order. I want the stock…
-
Convert From Fifo To Standard Costing
I am working on a Project that will convert our costing Method from FIFO to STANDARD. the process that i am looking at doing will involve - A Physical Inventory that will set my QOH for all Items to Zero. - A process Only Report that will cahnge the costing Method from Fifo to standard, and set the current Standard cost…
-
3.10 speed?!
Any way to optimize Navision databases?! We're running 3.10 for years now and when people are posting there's a slowdown on everyone's machine. What factors would help out: ram on that machine, etc?!
-
Customer cards.. is this possible?!
Okay I edited this.. I found out what I needed to know before, but this brings up a new problem. Running Navision 3.10. Go into Sales & Receivables and then Customers. When I am in there under General it has fields for: Shipping Agent Code Shipping Agent Service Then going under the tab for Shipping and Other it has a…
-
Sales Shipment Header & Lines
I have two tables 110 - Sales Shipment Header 111 - Sales Shipment Line These are huge and I don't need 2003 & 2004 info. Does anyone see problems with deleting these two years from these tables? Quickly thanks - I have an ichy finger on the delete button =P~ Thanks.
-
3.10 and XP?!
Will Navision 3.10 work with Windows XP Professional?! It looks like it works with Windows Server 2003.
-
Database Service stops with event 7023 Incorrect Function
Hello everyone, have an issue... 2 nights in a row now, my database service has terminated in the middle of the night with a pretty vague error: Event ID 7023 The Navision Attain Database Server XXXXXXX service terminated with the following error: Incorrect function. I manually start it up again and it works fine..if I do…
-
Dual processor
Hi I have a server with dual processor. Will Attain 3.6 utilise the features of dual procesor or not? If not which version will support? regards,suresh
-
Go negative with Lot Numbers
Hi, I have a question. Is it possible in Navision to go negative in Inventory by using LotNos? If not, has anyone made a solution for that? Any replies are welcome! Thanks. Roelof.
-
NAS & Job Ledger Entry
Hi there, I have a problem, which I can't seem to solve and was hoping someone out there can help. I have written a codeunit to run reports 1213, 1214, 1294 and 1295 all consecutively. The reports are the four batch jobs "Calculate Job Recognition", "Calculate Job WIP Value", "Post Job Recognition to G/L" and "Post Job WIP…
-
Need help with report & group totals
Hi all, I need to create a report that takes the Item No.2 field and gives a group total on a flowfield called "Total Sales". Part 1 No.: A-CTB2010/5LL No.2: A-CTB2010 Total Sales: 2 Part 2 No. A-CTB2010/6AA No.2 A-CTB2010 Total Sales: 6 I need the report to simply show: Part No.______Total Sales A-CTB2010______8 How do I…
-
Track user orders in [Sales Header]&[Sales Invoice Heade
Hi All, I would like to know if it is possible to track which users have entered orders into the [<prefix>$Sales Header] table, and also the [<prefix>$Sales Invoice Header] table once the orders have been posted? Can you track this? Is this possible and how? Thanks David
-
I cannot execute SHELL('C:\ActiveBarcode\BarcodeImage.wsf')
i have Navision 3.1 i tyr to execute SHELL('C:\ActiveBarcode\BarcodeImage.wsf') and system return me this error: "Your operating system cannot execute program c:\ActiveBarcode\barcodeimage.wsf" I'm sure my program is at that PATH, i have executed it from prompt. The problems seems to be the extension wsf (Windows Script…
-
Navision Server 3.60 to SQL Server Option
Hallo. I'm a new user in mibuso.com. I have to migrate an installation from Navision Server (3.60 version) to SQL Server Option. I have Migrate.fob object to check some features: dates, for example. Is there any document with an explanation to work with this object and any document to do the complete migration? I have…
-
Pitfalls of schemaXT
I'm thinking of running the schemaXT utility to extend my Active Directory and get rid of the annoying warnings in my event log. Navision is functioning fine for my application, so I want to proceed very carefully since the purpose of extending the schema is secondary. I've been unable to locate any source documentation…
-
Rename company
Our client requested an update of their test company and also to rename it. We backed up the production company and renamed it over a VPN connection. It seemed to work fine. We are trying to rename the production company back to the original name and are experiencing some seemingly odd things. It appears to be stuck in a…
-
Nav 3.7 Sales Tax
Hi All. It appears that the Max Amount/Qty in the Tax Detail table applies to the entire Invoice Amount. I need it to be based on each individual item amounts. Example: Tax Detail: Tax Below Maximum = 1.00 Max Amount/Qty = 8000.00 Tax Above Maximum = 0.00 Sales Lines: Item 1 Amount = $7999.00 Item 2 Amount = $100.00…
-
Field Filter..
Our office uses Navision 3.10. I want to know how to filter a field. Here's my scenerio: I go into Sales & Receivables, then Customers, then pull up the list of all our customers. Some of our customers have a name like "Target Corporation" for example. Others are designated like "Target Corporation *****". Some are "Target…