-
Database structure error
Hi to anyone, I have encountered a msg 'there is an error in the database structure.' I already identified the corrupted data in the G/L entry table. Everytime this particular entry is accessed even just by 'find', the msg always appears. So i have come up with a codeunit to identify the exact entry and a dataport to…
-
Posting Inventory Cost to GL
There is this function Named as "Posting Inventory Cost to GL" under Inventory module. My is Question is, how can i improve its performance because its extreamly slow. Regards.
-
Database - Current Sessions
Hi All I am finding a strange problem with Navision 3.6. When a new user trying to log in its shows message as license has reached the limit. when I check the Database Current sessions I can see one user name showing in multiple sessions. Ex. Satish user shows 2 times or 3 times. like that.. now I hve to restart that…
-
USPS Api's
With USPS being extremely competitive now for small shipments I have been looking into the Postal Services API's to get: -Calculate Rates -Find Zip Codes -Verifing Addresses -Track & Confirm http://www.usps.com/webtools/welcome.htm I finally got my USPS registration Username & password but i was wondering if anybody has…
-
[solved] Error after uninstalling Navision 3.6 client
We had a strange experience last week after uninstalling Navison 3.6 client: Some application didn't work anymore and there was always an internet explorer script error. Also problems when printing from Outlook and when using mmc. Quite similar to http://www.mibuso.com/forum/viewtopic.php?t=21371 By the way, reinstalling…
-
NAV 3.6 Shortcut Keys
Hi all How do i find list of short cut keys that i can be used in Ms Nav 3.6 version. i hv been to the help but its different keys in different modules. is there any help document listed with all the short cut keys. Pls help Thanks & Regards satish
-
Deleting a list of items via a report called from a dataport
I am working in Navision 3.6 (SQL Server Version). Our customer has a list of 14,000 obsolete items that they want to delete due to lack of activity. I want to read this list and delete the corresponding record from Navision. I understand that you cannot delete from a dataport so I am passing the record to a processing…
-
[S] When did Microsoft stopped providing support for NAV 3.7
I'm running around with google, but it seems hard to find precise date. Maybe anyone of you remember? Thanks.
-
printing reminder
hi there... is it possible to do this somehow? i have added one check box on the Sales Order form. what I would like to do is, when I push the button Print (for the first time), that check box should change it state to checked, and stay like that, just like reminder that this document is printed, nothing else. (i should be…
-
Report to pull up no sales customers..
Using Navision 3.10. What report is used to pull up a list of all customers (with as much information as possible, ie: address, contact, phone number) who have not have sales since 06/01/07? We want to pull up a report of everything who we haven't done business with in awhile and contact them. Thought I've done this…
-
Is it ok to dataport sales records?
We are using Navision 3.10A and we want to transfer our existing sales orders to a newly created database. Is it ok to simply use dataport with all field validation off to do this? I will be transferring all fields with their contents anyway so I figure there's no need to validate the contents. There are quite a lot of…
-
error during undo shipment
Today one of user posted a Sales Shipment but after posting he get to know that by mistake he has selected different Bill to customer and it should be same as Sell to customer. Now he wants to post undo Shipment. When he is trying to do Undo Shipment He is getting foloowing error: Item No. must be 1050018 in Reservation…
-
Problem with Ctrl+F
Hello, we have a problem with the search window (CTRL+F). if we open the window and search with the option "from the beginning of the field" or "only the complete field" the search works fine and we get a lot of results. But if we search with the option "part of the field" or with placeholders like *med* we don't get any…
-
Exit
Hi, i am an apprentice in the first year of apprentice and i have only a very small problem i have to check a code and i found something like this: exit(true) or exit(false) i havt never seen it before and i didn't found anything in the internet i hope someone can tell me, what this means
-
field missing in table
Hi I have a problem in my Nav 3.60. I have a form (form 41 Sales Quote) which I can not compile (the compiler states that field 25 is missing in table document). If I try to export, design, compile, you name it ... same answer. The subform is OK and can be compiled. I can not add a "dummy field" in table as the Id is…
-
MMC Snap-in - Navision Database Server
Hi, I've successfully setup a Navision Attain 3.60 native database service and everything is running fine. However I'd like to be able to use the MMC snap-in to configure the settings but I just can't get the snap-in to work. It allows me to add the Navision snap-in to the console window but it doesn't respond to any mouse…
-
Hide/Show columns..
Using Navision 3.10. Let's say you go into Inventory -> Items -> and then once you're in an item card goto Item Availability by Color. In there we choose to hide or show a column. Everything works fine on all our computers except one. The one computer will hide a column, but randomly it seems later on the column will show…
-
Filtering at FORM level
Our item price table has a high volume of entries in, which is becoming a litte user unfriendly. As we require to keep the prices, I am thinking about controlling this at FORM level. Similar to the statistics forms, I thought about putting 1,7,31,12 buttons, where when pressed, will cause the form to show the entries from…
-
[solved] Shell parameters
Hi folks. I am calling from Navision out to a program that I wrote in VB.NET. The VB program takes 2 parameters. The VB code that accepts the parameters is as follows: Dim MyStartupArguments() MyStartupArguments = System.Environment.GetCommandLineArgs When I call it from Start > Run with the following syntax it works…
-
unknown automation server in CU 5072
Hello all, There is an unknown automation server in Codeunit 5072 Outlook Application Management, and we just can't figure out which one it should be. Does anybody know? Kind of weird that the Navision installer obviously doesn't come with all the necessary dll's... We had the same problem with the biztalk codeunits, but…
-
DataItemTableView vs. SETFILTER
Could someone tell me which is quicker when selecting records from a table: a. DataItemTableView=SORTING(Job No.) WHERE (Type=CONST(Usage)); OR b. SETFILTER(Type,'Usage') Thank you.
-
Navision Partner In Michigan, US
Hi, An old colleague of mine has asked me if I know of any Navision partner companies located in Michigan who they could transfer their company's support and development to as they are not happy with their current partner (won't mention names!). Can anybody list any? Any help appreciated, Jonathan
-
Item Ledger Entry not created on Shipping a Sales Order
I have a client who have begun experiencing a problem when Shipping/Invoicing sales orders. They are running v3.10A C/SIDE. We have not modified the sales line table, or sales posting. In the last month they have noticed a problem with Sales figures from their Item Ledger not matching the G/L. I have tracked the…
-
Sales Order - <Status>
Hi... Could someone, please, help me to understand the function of the field "status" in the Sales Order Form. I can not find any help about it, and can't understand the meaning of that field. I know, when the status is Released that I can't modify the Sales Line (qty, etc...), but what else...? thanx
-
Accessing a file on the database sever
I am trying to import a picture on the fly into a picture box on the item card. If the file is on my client it works fine. I don't want to put the file of pictures on every client. I would like the file path to point to a file on the server that runs the database. Is there any special way that navision can bypass the…
-
Read an external bitmap file
I have item pictures for 20,000 items. What I want to do is store the pics in an external file and read them into the item card on the fly for display. I thought I could use an instream, but I am hung up on how to read the bmp file with the instream I created from the Item.Picture.CREATEINSTREAM(). I would be very thankful…
-
Job Scheduler on Server
Hi, I developed an interface using the Job Scheduler. I have a Navision client running on the Server. In this client the Job Scheduler is running. However this customer is rebooting this server every night. There for the Navision client gets down. Does anybody has an idea how to solve this problem. Is is for instance…
-
how to Integrate Navision to MS project???
Hi, I created one task table. In the task table fields are same in MS project 2007 Task fields. Now i want to export the data the data to MS project. how can i do that??? Thanks & Regards, kishore.
-
Menu Item
Hi all, After import client license. I cant view customize Menu Item which is added in standard in MENU eg: Purchase Management. But i can view other customize menu item which insert in Customize menu. eg(Purchase- Branch) menu. FYI: Client license include Solution developer & granule 1410 to assign use permission for menu…
-
[solved] Grouping in output text file
I have created a text file which export data from a customized table (similar to shipment lines). The output file is fine, but for some of the entries there are mulitple lines - in the file I just want to show the document and total weight. egdoc no date qty 1 01/01/01 20 2 02/01/01 10 3 03/01/01 30 3 03/01/01 50 4…