-
Partial orders
Hello Is there any possibility to make partial orders? The scenario is like that: I'd made an offer that was converted into an order. The quantity on the offer is 10 pieces with Direct Unit Cost = 13. That give us 130$. Now at the end of the month the vendor gives me an invoice not for the whole order but only partial. The…
-
Item Card: How to show the customer of the item?
Hello to all the experts, i would like to have a link on "item card" to show the last customer of the item wilth amount and price like the history on the "Sales Order Card". Has anyone an idea or a complete solution??? With greetings from germany! cosch :D
-
Blank Sales Invoice?
Is there a way to make a blank invoice in Navision 3.10? We used to have MAS90 and there was a way to do it easily I'm told. We're going to do business with a large European chain of stores. They want an invoice with no items on it. I'm gonna print someone else's posted invoice to PDF and edit it in a graphic editor to…
-
Combine report with Posted Invoices?
Do you think it would be possible to combine a report and add the corresponding Posted Invoices into one? I have a Sales Report, "Daily Invoicing by Salesperson". I run that with the previous week's date and a Salesperson Code. It spits out a report for me which shows all the sales that week for that Salesperson along with…
-
Posting a Sales Invoice
Could any one pls list out the tables that gets affected in Navision when sales invoice is posted?
-
not able to load data from file into table
Hi, I am not able to load data from a file into a table, i am using scheduler to load the data, when i run scheduler it is hanging and not processing. I have removed the file and tried to run the scheduler without the file and the scheduler is still trying to load the file even though there is no file to be loaded and it…
-
Is Navision 3.6 Compatible with SQL Server 2005?
After successfully restoring our clients database from SQL Server 2000 to SQL Server 2005, I attempt to connect and receive the following error in Navision: The Session table contains a Navision Attain field data type that is not compatible with the SQL Server data type: Field: Wait Time (ms) Type: Integer SQL type: BIGINT…
-
Company logo not printing on report
A picture is set in the company information form (which shows up on many reports already). I declared a global variable called "CompanyInfo" pointing on the "Company Information" record. Code in the "Report - OnPreReport" trigger: CompanyInfo.GET; CompanyInfo.CALCFIELDS(Picture); I added a Picturebox to the 1st section of…
-
System decomissioned, but need the data in SQL (date issues)
Until the 1st Jan 2008 the company I work for used 3.60 as their ERP system, they migrated to Vantage from Epicor and are still happily using it, so 3.60 is no no longer under maintenance. I joined the company just before this occured. and they used a local guy, not a partner, to get out their live data using ODBC (I…
-
Send email
When we run a report, we want to send sometimes the report via mail. Therefor we use the standard File --> Send --> Report by E-mail. Everything works fine, but sometimes (let's say: 1 at 20 times) he sends the mail but Navision 3.60 blocks and we have to kill the fin.exe the client to fix the problem. Is this a known…
-
Color change in Cust.Ledger Entry
Hy, I want change line color on Cust. Ledger entry, but I couldn't :( the basic code: IF "Document Type"="Document Type"::INVOICE THEN CurrForm."Document No.".UPDATEFORECOLOR(32768); It works when, but change only Document No.'s color, and not the whole line. I read "Color Change For Credit Memo's" topic, but it isn't…
-
Color Change For Credit Memo's
When I pay a Vendor I go to the Payment Journal, Enter the vendor #, blah blah & hit apply entries. In which all that vendors OPEN enties appear. I hit f9 to select which Invoices & credits I want to Pay & Use. Some Vendors Have A ton of Entries. How can I make the Apply Vendor Enties Form show the credits in red? 01/01/01…
-
Help required with cfront and asp
I'm trying to incorporate Cfront into an asp page. I've been able to retrieve records using Visual Basic. But in VBscript/ASP, I've been facing this issue. ======================= Error Type: Microsoft VBScript runtime (0x800A000D) Type mismatch: 'OpenTable' /Project3/TestConn.asp, line 63 ======================= 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…
-
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?
-
C/AL programmer error
Hi, Could any one help me on the below error what it means exactly. This message is for C/Al programmers. The call memeber send failed.microsoft office outlook returned the follwing message:Array index out of bounds Your help should be appreciated.
-
Navision native db - SQL Server Option
I know that SQL Server supports record level locking, Navision native db does not (table locking). Is it so that when we use the SQL Server option, the tablelocks will decrease, or will it be just te same as in the Navision Native db?? Is there some kind of paper the describes the differences (advantages and disadvantages)…
-
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…
-
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…
-
Exporting XML with some filters
Hello, I want to export the records . A Xml file must be created for every record. But it doesnt work. I created a function on the XML file(GelAllFilters). Firs I call this function after that I export xml file.. Do you have any suggestion about this ? Thank you XLabel.RESET; XLabel.SETRANGE(Resend,TRUE); IF XLabel.FINDSET…
-
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…
-
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.…
-
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.…
-
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…
-
Subcontract Item
Hi Friends, My client is an subcontract company, wherin the item/Raw material is given by Customer and after the respective Job work they sell it through Sale order. Hence the material will not be added to Inventory value. In Navision there is an option for Non stock, but that is mainly used for Drop shipment. Can some one…
-
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