-
Two Database files on One Server
Dear all With one server and 2 database files on it, if a client want to access any of the database file. How to configure client and sever in such situation. Thanks satish
-
Idle Users - Auto Logout
Dear all My database users logins are more than the licenses I have. So generally if the sessions reaches to maximum it won’t permit new users to login. I see some of the user’s are idle for a long time . My question is Can I set a cut off time to close the session automatically to those logins idle for 15min. Thanks satish
-
Cannot set up database logins
Hello, Customer runs Navision 3.01. Until now they haven't had any database logins set up, but now they want it. They have granule 3010 in their license, which includes: 1 * 1400 - User IDs & Passwords 1 * 1410 - Permissions But when choosing Tools -> Security, all choices (Roles, Database logins, Windows Logins, Password)…
-
Explaining Setrange
Hi, can somebody explain me what the following code line means: SalesOrderLine.SETRANGE("No.","No."); While the meaning of the first "No." is clear to me, the second one is confusing me. The second one should be a value or not?
-
Item and Item Description Error on entry
I have stumbled on a peculiar situation in our Navision 3.6 environment that I cannot explain. It relates to the Item Number and Description field that can best be described by example: Item Number = 1117335 Description = VPL-8503 24X24X12 Filter Here is the problem: A sales line is entered and the Item No. value VPL-8503…
-
Where is NODBC
i don't know if i'm doing something wrong...tell me if it is so... BTW a client of ours needs to connect to his (native) navision 310 db from an outer program (i don't know which one, if it is important i'm going to ask him)...is it correct to use nodbc in order to connect to navision db?if so, where is this dll? I…
-
Transcation server
HI.... can i used Transaction sever in ls.retail..i have faced one prob..that prob is how can i replicate the customers in store to headoffice.I have succesfully replicated transcattion header table and other tables but customer table is not replicated.plz tell me the ans..
-
Navision/Citrix - fin.zup file error
Hi, When i try to login to navision thru citrix i am getting this error: "There is something wrong with the file C:\Documents and settings\user1\application data\fin.zup. To continue you must delete or rename the file". Can someone tell me why i am getting this error? And is there any way to avoid this error. Your reply is…
-
Report Heading
I have created a report to show production order component quantities in order for the production dept to check requirement vs stock. The first data item is the prod order component, and i have then linked this to the production line (plus reservation entry for order tracking) in order to allow filtering on certain…
-
Translation import error
Hi all, We are trying to import translation file in navision 4.0 SP3, generated from Navision Localization Workbench 2.5.0. The problem is that we get "There is a syntax error in a Translation Import. The text is too long", followed by the line that is too long. Is there any solution to this, because we don't want to cut…
-
Sales Line "Line No." field issue
Within the past week, a strange issue is sporadically occurring. When entering a new quote/order, the first sales line "Line No." is assigned 10000. (Like it should be) However, Navision is occasionally assigning lower "Line No." numbers for subsequent line items. For example, the 2nd line item is assigned 5000. It's…
-
report.RUN vs. report.RUNMODAL
Hello everybody, In standard Navision report.RUN is used to print documents while posting. Is this a correct statement? Some report.RUNMODAL statements were added by our former NSC to also print documents while posting from codeunit 82. We experience deadlocks that might be caused by report.RUNMODAL waiting for the printer…
-
Restrict Posting for Credit Memos only
Hello: I need people from Accounting to be able to CREATE but DO NOT POST credit memos. Currently they can create AND post. Do you know what permissions (in a data table or form) should I change to restrict them to do not POST??? They should be able to post other transactions (checks, invoices, etc) but not post credit…
-
Posted Credit Memo Lines gets deleted
The lines gets deleted from a Posted Credit Memo,the header is still there but in the lines its showing 'lines deleted'. How can i retreive the lines and update the table or please suggest me an alternative solution.
-
Deposit-Post Codeunit Question
What's so bad about partially applying a credit to an invoice? Say and inv is $100 and they pay me $90. They have a $20 credit. Why can't I apply the $20 along with the $90 and pay off the $100 inv. Then leave $10 open on the credit to be applied somewhere else? Codeunit 14017060 Deposit-Post.…
-
Importing DateTime from Access to Navision 3.60
Hi all, I'm looking for some help. I'm developing a process which reads some data from an access database. This database has some information about employee's entrance and exit, to calculate how many hours they work a day, extra time, pluses and many other things... The date and time is kept in a DataTime field. I have to…
-
problem Adjust Cost-Item Entry
Dear Admin, our Navision using version SG 3.01.B starting from july 2002 and now we have problem when running program Adjust Cost-Item Entry, the message is "item ledger entry entry no. xxxxxx does not exist" there was 30 items has problem and we havn't find this problem before. So what cause had making it happen and what…
-
Adding Manufacturing Costs to Item Costs
I am hoping to get some advice about adding manufacturing costs to the cost of items at the end of each month. The company uses Navision 3.6 with SQL server. The company manufactures items with up to 3 BOM levels. At the end of each month they want to be able to equally distribute the manufacturing costs to all items that…
-
Fax in navision CRM
Dear All, I tried to use fax in the interaction (segment) in nav crm function. When I log the interaction, the system generate the mail merge in word 2007. However, there is error message from word 2007. something like "Microsoft Mail Local Fax is not installed on your system." Is it hopeless to use fax function in NAV…
-
Reservations for Purchase Order partially received
Version 3.10 If I create a PO I can reserve the quantity from sales orders without a problem. If I partially receive the product I can no longer reserve any of the unreceived quantity either from the sales order or the PO. Why?
-
Bug in procedure upgrading 3.10 -> 3.70 in Warehouse Acti
Hye, In the procedure of upgrade 310 -> 370, we must delete table 5766 et 5767 so all the allocation, reception and prelevement are removed and not transfered in the new database 370. It is a big problem . Have you already have this problem? And wat have you done for solution this? Thanks for your respond.
-
Problem with .bmp image format
Hello, I'm trying to change a .bmp image file in a form. I know that, in Attain 3.70, the image file can't be bigger than 32kb and it have to be in .bmp format. I make an image file of 10kb in bmp format and the same size that I already have in the form and put the route (c:\pic.bmp) on Bitmap value from the Image…
-
SetMessageShowHandler problem with CFRONT/C#
Hi all. First, I'm using cfront.dll for Navision 3.6 and C#. I'm trying to stop Navision from showing message boxes every time an error occurs. I know that in cfront.dll for Navision 4.0 you have the method DBL_HideMessageShowHandler but not in 3.6 that it's what I'm using right now. So I've discovered that assigning a…
-
Item booked
Hi All, How can I filter the ILE table to know That the Item is there but booked???
-
Variable Validation
hai, i have a decimal variable associated to a text box. is it possible to call a validation trigger of that textbox from other controls (another text box)? can any one help me?
-
Doubt in List Form
hai , i have a doubt.. i have a List form. there are 5 fields. Field 3 and Field 4 have their captions and iam supposed to give a common label at the top for Field3 and 4 apart from their captions. Is it possible? can any one help me?
-
Bank Acct Legder Entries Edit Field
I need to add a boolean to the Bank Account Ledger Entries Table. It will do nothing other than tic yes/no. I don't need to modify anything else nor should I or want to. I simply want to called it "Reviewed" or something, my new form will only show the entries that are not checked (or Reviewed) Regular license will not…
-
Import data of diferent files
Hi, I want to import data of diferent files. The files alway have the same name but can be a lot of files. For example: File0001, File0002, File0003.... So i wan to know how i can know if there is files in the path to import and how many are. can help me someone ? please.
-
Comma and strmenu
Hi I have a codeunit which modify a table field with a decimal. And i need use a strmenu for my different option. But strmenu doesn't allow title or string that explain the situation, so i put my decimal in the first option. However in french 3.6 is replaced by 3,6 so the strmenu believe it's a new separator. I had a…
-
Finding highlighted rows?
Hello, I would like to do something simple like loop through the rows on the current form/tablebox and find the current selected/highlighted rows. I've searched the help and a property something like IsSelected doesn't pop out, nor a function to test if row is highlighted. Appreciate any tips/suggestings to this seemingly…