-
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…
-
[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…
-
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
-
FlowField not calculating correctly in EDI
I am creating an outbound 810 EDI invoice in the lovely Lanham EDI module. It contains a FlowField in the Sales Invoice Header table. The FlowField sums the line amount with a where clause based on a field being checked. We will call this FlowField XField. I have mapped the XField into my 810 and generated an EDI file.…
-
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…
-
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…
-
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.
-
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…
-
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
-
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…
-
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
-
DateTime Data Types
Hi, What is the practical use of DateTime data type?
-
How can i integrate Navision,LS-Retail and Pebble-Stone???
Hi , I had one doubt. Suppose one Customer will use Navision,LS-retail & Pebble Stone. But my doubt is Microsoft will provide Nav+LSRetail and Nav+pebbleStone. these two Databases are different. Is Microsoft will provide combination of these three???? Thanks & Regards, Kishore.
-
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…
-
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…
-
Sales Header: text + "No."
hi guys, I am working something with Form 42 Sales Order and I have there one problem that I can not solve. On this form on Sales Header we have field "External Document No.". I would like, when I type in that field for ex. 'T' and press Enter, to see there T+"No." Example: Sales Header No. is 12345. I type in the…
-
do not type data manually in Text field on form???
Is it possible The person do not enter data manually in Text field on form. he use the lookup button on that text field. he selects the data through lokup button only. Thanks & regards, Kishore.
-
Prevent Export of Objects
I need to prevent a user from exporting objects from the Object Designer but the user needs to have access to the Object Designer to view code. Any ideas??? Thanks!!! Kimberly
-
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…
-
Export Excel
Hi Anyone who has the downloadable tool to export and import data to and from excel for Navision 3.6?
-
Navision Locking Up
Anyone had a problem with Navision 3.10 locking up when the Screensaver kicks in or when the user locks Windows?
-
Creating new fields and passing them to tables
i was wondering how i can pass a new field from one table to another. example, i created a new field in gen. line journal and i wanted to pass it to the G/L entry table. I created the fields exactly the same in each table with the same field #, name and settings. but when i post, the information doesnt show up on the G/L…
-
Menu Item & Hyperlink
I have a bunch of Crystal Reports that I now have on a request Form. When i check it , it will run the report. Anyway, just thinking about cleaning it up a bit so I was thinking about Menu Buttons and adding the report names as the menu items. An easy solution was if I could add a hyperlink code to the menu item but it…
-
Automatic Generation of PDF using PDF995
Hi Experts, I have installed PDF995 (orginal version). But I couldn't find the automation variable in the list. Can anyone please help me? Regards, KRS
-
Error when changing field length in Nav-SQL
Hi. My client is running US 3.01.B (3.60) with SQL 2005. He has suddenly decided after several years on Navision that he needs the Item No. field lengthened to 30 spaces. OK, using Object Designer to make the changes in table 27 Item and 28 Item Price was no problem. But when I try to do the change on 32 Item Ledger Entry,…
-
Hiding or showing column..
Using Navision 3.10. When I go into Inventory -> Items -> and then go into any Item Card. I hit the button that says "Item Availability By Color". In there I have columns, which I can show or hide. One of them says "Available Quantity" and another is "Available To Sell Today". When I am in Inventory -> Items (not in an…