-
Filtering records
Hi all, Can any one pls tell me how to filter records in a table in Navision based on starting record number and ending record number of the table
-
Method 'SendWaitForReply' of object 'IOutMessage' failed
hi, this error: Error Number: -2147220978 Error Description: Method 'SendWaitForReply' of object 'IOutMessage' failed I get when I try to communicate with Navision with MSMQ and Navision Communication Components. I send a XML message... Option Explicit Private WithEvents CC2 As NSCOMCOM2Lib.CommunicationComponent Private…
-
Price increases
Hi all , Im doing my first price increase in Nav 3.01 this weekend, is there anything i should watch out for ? I will be filtering out customers and applying it to only certain product ranges then modifying the expiry dates on those prices. Does the start date within Suggest item Price.Chg(price) work as it sounds, i.e.…
-
form 355 is just wacked out
when i go to: G/L Chart of Accounts Account button at bottom select Receivables-Payables it displays one line every second...this is crazy. what is wrong and how can i fix it...i've already imported the 'cronus' version of that form and this 2.5 gig database still all but dies. thanks for help in advance, Trint
-
posted sales credit memo mistake
Hello, I have a small problem, we have posted sales credit memo with mistake, Problem is that credit memo is issued by posted shipment, not by posted invoice. The goods were released only with shipmnet document, not invoice. And when returning goods instead of doing only "undo shipment" credit memo was done and posted. How…
-
Valuation Rounding
I have problem as follows: When run the Adjust Cost - Item Entries bath job, only rounding entries with amount >1LCY are inserted to the table 5802. Entries with amounts <1LCY are missing. I have Nav3.7PL. Are there some good hotfixes for valuation rounding problems? Did anyone meet the same problem? Karol
-
incremental backup
does the navision database support incremental backup? I mean will the whole database (when changed) seen as one file or just the changes? grtz
-
How can I fix this error?
In the g/l, chart of accounts, receivables-payables, that form is soooo slow that something has to be wrong. Well, I ran a test and got this error on so many accounts that I had to cancel the test: 'Dimension Value' does not exist. Code:SKH, Global Dimension No.:1 The Global Dimension 1 Code field in the G/L Entry table…
-
Excel Automation Problem
Hello, I have a problem with Excel Automation. I've tried to design a report which exports some items to an excel-file. If i try to compile my Report, following Message occurs: "The variable XLAPPLICATION::WORKBOOKPIVOTTA is defined more than once." "An example could be: 'File' exists as both a data type and a global…
-
Revalue overall value of inventory item
I'm trying to use the Revaluation Journal to revalue the ENTIRE inventory value of one item. I don't want to choose a past ledger item to correct which is all I can seem to do. All I want is to take for example: If I have four items in inventory at a value of $1000, but I want the overall value to equal $100. So how do I…
-
Navision Date Format
Hi all, I just got a job in Accounts Payable a week ago and we're using Navision to print reports, etc. I'm a first time user and I'm trying to change the date format shown in Navision Attain from mm/dd/yy to dd/mm/yy. I heard that by changing the system date format, Navision will reflect the change. So I tried changing my…
-
SQL Stored Procedures and NAV Sync
I need to advise a client what stored procedures are run when performing Permission synchronisation in Nav 3.60. This is to assist me in justifying to the IT Manager why they should give one of thier users high SQL level permissions. Can anyone point me in the direction of a tool or some way of showing this ? As for SQL…
-
user filter on report.
Report 10540 stock received not invoiced. We wish to be able to filter on the inventory posting group so the report can be used to select different categories. The IPG is available on the Value Entries, filterning on this does not work (due to it being the 2nd data item?) I thought about putting a lookup to the IPG table…
-
Calculation of data
Hi expert, I have a little trouble in one program. We added some persons (Sales Assistant) in the Salesperson/Purchaser table and added extra field Sales Assistant which we added in the Salesperson/Purchaser in the Sales Order form. We need to create a report and calculate how many sales sold by each salesperson and sales…
-
Hold The Value In A Variable
Hello, I was wondering if someone could help me. I have a work in progress report that reports on what the current situation within the company is. This report outputs into a weekly grid. When this is run on a Monday for example it populates loads of different variables. I want the report to hold the value of these…
-
The date is not valid
Hi does anyone have this problem? An error happens when we run the Cash Applied today. It' strange when we enter the posting date of today (09/01/06), the system pops up an error "the date is not valid". What caused this problem? Thanks in advance!
-
Licence Limitation Expanding Database
Hi, I'm working on a native navision database 3.60. When i want to create a database with more than 64GO space, i have a message that my licence can't create a database more than 64 go. My NSC tell me to backup the databse and restore it in navision version 4 and working with navision 4. But nothing change !! Can someone…
-
Contact from accountant to accountant searched (US)
Dear all, we are looking for a contact between our accountants to other accountants in similar situation. Our accountants are located in New York and I would highly appreciate if we can estabish a phone call or other kind of contacts. We are a software company with a yearly revenue of ca. 10.000.000 $ and looking for…
-
How to set flag after first printing of document
Hi all! Is it possible in Navision to set a flag after the document was printed first time? I mean, if users were making a print preview of document, the flag has not be updated, only after first printing.. I have no ideas how to make it... Thanks for any help!
-
Printing with NAS and Navision 3.10
Hello, can i print via NAS with Navision Attain 3.10 ??? all i want to do is executing a report and printing it at default printer. My partner sais that it is not possible, somebody knows how?? Thanks Nacho
-
Upgrading from 3.1 to 3.6
Are there any words of wisdom that you can offer before I embark on this journey? Any problems / methods or ideas would be greatly appreciated. Thanks.
-
Navision Process flowchart
Hi Everybody. Has anybody made a Navision Process flowchart or is it available in any of the manuals. Can any one share it with me. Thanks in advance. regards, Vijay
-
The Purchase Header already exists
Hi all, When I insert a new record getting message The Purchase Header already existsDocument type='Order' , No.='PO0100'. In no. series Default checkbox is true. Manual is false. Increment by no. is 1. what could be the solution for this? Thanks, Sandip.
-
Lock Table
Hello, I would like to lock a specific table during the runtime of a function. If there is set a flag, this lock should be reset. I tried 2 ways: 1. Locktable Loop that check if the parameter ist set if yes, reset the lock 2. I made a little form and in the onTimer Trigger i write a dummy record to the table and after that…
-
System Slow during Posting and Freezing Other Sessions
Hello All, Could someone tell what could be done to Speedup the system's Posting routine and Prevent Freezing other Sessions? we have the following settings: Version : 3.60 SQL Option Database Size : About 46GB Observation: Client Session 1 tries to Post a Sales Invoice. Other Client Sessions are Prevented from making…
-
Sum a Text Field
Can someone tell me how i can sum a text field. I have a text variable that i pass into number values although these values are held as text within the database. I want to be able to sum the quantity. Any help would be appreciated.
-
Journal templates functionality
Can Journal templates be used to show only selected fields on one template for all users? If yes, where are those settings stored. Thanks in advance!
-
G/L Entry NIL!!!
Hello I'm using Navision 3.60, I found some entries in the table G/L Entry with nil values? Is it a problem? Why does the program generate such entries?
-
Printing problems
Hi, I am new to Navision and I got a big problem. I also tried several times the search engine but I could not find a solution :( In my fathers company we have several Navision v3.60 Clients based on Win98. I just upgraded one computer to Windows XP and installed Navision. I was happy that I could implement it to the…
-
Problem when posting Inventory Costs to G/L
Hello When i run the Post inventory Cost to G/L batch job i got some entries in the table G/L Entry with null values for Debit Amount and Crebit Amount. The two columns are null for the same G/L entry!! Is it an error? What could be the problem?