-
Help- how to use a substring of a file name to find a file
Here is what I need to accomplish: I only know part of the file name, I need to find the file from the local file directory, how can I do that?
-
Urgent - NAS issue
Navision 3.70 Application Server produces me the following event and just stops working. We need to restart the service in order to continue working. Event Type: Error Event Source: Microsoft Business Solutions-Navision Event Category: None Event ID: 1000 Date: 2004.11.29 Time: 09:35:31 User: N/A Computer: ZVTERM3…
-
CALCFIELDS using DateFilter in report
I have created a flowfield that uses a Date Filter: Sum("Job Ledger Entry"."Remaining Amount" WHERE (Global Dimension 2 Code=FIELD(Code),Open=CONST(Yes),Chargeable=CONST(Yes),Posting Date=FIELD(Date Filter))) I need to check the total remaining amount for the date selection from the Sales Invoice/Get Job Usage report. Is…
-
Eship USB001 vs LPT1
Maybe I'm just crazy but I'm getting no response from my system when I try to print labels using a USB type label printer. Works just great if on the Packing Station setup I set UPS Label Printer Port to LPT1. If I try to change it to USB001 or USB002 - I get nothing. Most updated label printers are using USB now and the…
-
Delete entry after insert
Hi, I have an issue i've been wondering about quite some time now. It's like that: I have a table filled in with several records: for example : (v = true)Linenr Waybillnr Boolean Status Status date Status time 1 1000 2 23-02-2010 08:12:292 1100 2 23-02-2010 08:16:143 1000 v 5 24-02-2010 12:10:04 When I have my form based…
-
Item Ledger Compression in Navision version 3.6 on SQL 2000
We currently use 3.6 (modified quite a bit) on a SQL 2000 database. We will be upgrading the executable to 5.1 and will be using SQL 2005 Enterprise in the near future. However, we have also wanted to compress entries as part of our housekeeping and started (in a test environment) with the Item Ledger Entry. We compressed…
-
Closing a store - Value Entry Unit Qty=0 Unit Costs<>0
I have a customer who has been up for 3 years and he uses average cost. He recently closed a store, and all skus have a REMAINING QTY of 0, but they show an inventory value of not 0 (usually + or - 2.00). These are obvioulsy the summing up of the transactions created by the adjust cost batch job which they run every month.…
-
Problem With Matrix Form While using With Date Table
Hello Every Body.. I have problem with matrix form , i am using matrix record as date record for defining months and base record is customer record. it is running well , while i make a lookup on any field is show correct data but when i leave the control . all record is matrix window is clear. again when i pass the year it…
-
how to go to the next line without pressing ENTER key?
Hi nav ppl here what I am dealing with... I am working with barcode scanner to simplify importing of serial numbers. Everything is going fine except going to next line. What I mean is, I use the scanner, got the Serial No., auto add quantity, but I can't find out how to go to the next line without pressing ENTER.…
-
Attain 3.10A GB CRONUS database
Hi! I'm looking for a standard Cronus unmodified GB database for Version 3.10a does anyone know where i can find this? I checked partnersource but to no avail. Also the one posted on this forum is related the the W1 version. Thanks in Advance, ddegas
-
Chart of Accounts
Hi Experts, As i am new to navision and wat to persue the functional side of navision i wanted to know more about chart of accounts.I realy want to go into core of what COA contains and all the other stuffs. Please Help. Thanks.
-
Creating a new company with Blank DB
Hi Experts, I am new to the world of navision and want to go on to learn Functional side of Navision. So to begin with i have created a new company with a blank Db.And then tried to raised a PO and SO. While doing that i got different messages which specified what setup is missing for eg.Setting up different Posting…
-
Inventory Adjustment - Code Unit
Dear All While trying to open Inventory Adjustment code unit, navision application is closing on its own prompting a error "fin.exe has encountered a problem and needs to close ...". please help me if any one has solution for this. Thanks satish
-
Still can't figure out totals..
Navision 3.10.. Still can't figure out how to get totals to work properly. I'm trying to make a new report, which is a combination of two reports relating to inventory. On one report I want to use "Qty. on Sales Order" and QtyAvailable. on another report I want to use "Sales (Qty.)". I've taken the first report and saved…
-
Navision 3.10.A install media
Hi Everyone, My company has recently purchased a company that uses Navision 3.10.A for their accounts process. I have been asked to duplicate the environment in a VM, and to migrate all the data across to the new VM, however I do not have the installation media for 3.10.8. We have no support contract that I can find, and i…
-
Developer's ToolKit compatibility
I have been searching for an overview of which versions of Developers Toolkit (NDT) will work with which versions of NAV, with not much luck. This post is an effort to map what works with what. I'll start with my own experiences. I have tested by creating a blank DB with the corresponding NAV version, and importing the…
-
NAV 3.01B - unable to run date compression
Hi, Happy New Year.. \:D/ I m using NAV3.01B from 2002 until now and i would like to do a "Date Compression" but i failed although i m a SUPER user with SA rights. Can anyone help me to solve the mystery? The error message pop up was, "You do not have permission to run Analysis View Table" I have copied my co. license…
-
Modifying Quantity to Receive in P.O's
Hello: Is there any way that I can restrict receiving users to post and receive but DO NOT modify the Quantity to Receive in a Purchase Order?? Nav 3.6 Thanks.
-
Not Equal filtering..
Nav 3.10.. Awhile ago I modified a report. All my inventory cards have new fields "Catalog", and "Year" (and "Page" too, but I'm not concerned about that for this topic). On my report it now shows those and you can output a report to only contain items from a certain Catalog or Year. I have applied the Catalog and Year to…
-
I dont now which DLL i shall use
In Navision 3.60 in CD 5067 'Navision Contact Search 1.0' Can any help me ??
-
Shipping Agent Service left blank defaults to DHL Intl...
If we forget to put Shipping Agent Service on a Sales Order and print it (or Packing List), it will default to DHL Intl. Is there any way to fix this? I went into the C/AL Code for Sales Header and found the following: IF "Shipment Method Code" = '' THEN CLEAR(ShipmentMethod)ELSE ShipmentMethod.GET("Shipment Method…
-
Item tracking lines in BOM journal???
Is there any update for BOM journal? When I go to BOM journal in NAV version 4.0 or above, when I go to "Line" menu I see "Item Tracking Lines"...How can I have this same thing in version 3.6...is there any update or I have to develop things myself? (And there is a lot of development:) Thanks!!!
-
Interaction between Parent Page and Child Page
Hello All, Merry Christmas to all. I have created flowfield "Sub Total" in the "Sales Header" table, which calculates the running total for the particular "Sales Order" by summing the "Line Amount" column of the "Sales Line" table. I am using NAV 2009 RTC. I know how to send message to the Parent form when a Subform is…
-
All customers EXCEPT..
Is there a way to filter customers to not include any with a + in their name? I've tried something like <>*+* or <>*"+"* with no luck.
-
Virtual table 2000000022 - File - Which keys?
Hello, how do I know the keys of virtual table 2000000022 - File. Is that possibile order the file by date? Is it possible to see the structure/design of virtual tables? Thank you
-
More than 99 Top Customers..
Nav 3.10.. Report 10062 Top ___ Customer List limits me to a maximum of 99 customers. Is it possible for me to make this do more? I only have so many Christmas cards, so I'm going to mail Christmas Cards to our top 300 customers, and this report is nice and small sized. I can print it out with minimal paper usage. This way…
-
Performance Client computer slower then Terminal server
Dear all, I am wondering why a client is quicker on a Terminal server than a workstation. ](*,) Does anyone know? #-o The hardware specs are almost the same. The CPU is not noticeable used, also the HDD system and memory. The only noticeable difference is that I see a longer network traffic (with the same bandwidth…
-
Sorting Sales Lines in Sales Order.
Hello Friends, In one of the projects, I need to sort Sales Lines of the Sales Order based on the No. of the Item. I tried using the DataItemTableView property to sort the Sales Lines as soon as they are inserted. But it doesn't work, it seems that the Line No. is causing the problem. :| Please let me know if there is any…
-
Deleted Purchase Line, Footer by accident..
Nav 3.10. I copied a report and saved it as something else. Modified it as needed. I wanted a total at the bottom, which it did not have before.. I have it CREATETOTALS, but they come out as 0.00. Am I only allowed to put my total in the "Purchase Line, Footer" section? If so, I deleted that earlier to save space.. is…
-
Maybe everyone missed this?
Posted this awhile ago on here and newsgroup as well.. nobody answered.. thought maybe instead of bumping the old topic I'd start a new one. Not usually the way to do things, but I figured maybe there's a reason the old went unanswered. Maybe nobody knows the answer which is fine. viewtopic.php?f=14&t=37511