-
Aplying customer's entries
Hi I am looking for a documentation that describe how NAV applies custommer ledger entries? when i try to apply N positive amounts and N negative amounts, how does NAV work ? Thanks for your help
-
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)…
-
Multiprocessor / Multi-core
We have one 2.60 and one 3.60 database running, both native, on one server. Most clients use a terminal server client from which they connect to their Navision. So all TS’s have 2.60 and 3.60 clients installed and running. Because our users experience a drop down in performance several times a day we are investigating all…
-
Item Tracking Mess - Urgent!
I have a client on Navision 3.1 with a data problem. Somehow the SN Specific Tracking field became unchecked. Now they have thousands of tracking lines that are incorrect. Sales - These transaction created negative tracking entries but did not apply to the positive entry for that serial number. Now there is both a positive…
-
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…
-
Partially hidden toolbox
I don't know what happened but short of reinstalling Navision client, can anybody suggest how to move the form/report Toolbox when visible? Mine appears with top part partially hidden on the top of my screen. I have done some screen setting changes in windows to try to make it appear fully but to no avail. I have also…
-
Permissions for C/FRONT
Hi, I have a problem with C/FRONT. I have created some CFRONT formulas that I have validated with user that have SUPER role. I get the expected results from Navision. The problems arrive when I try to access to these formulas from Excel with an user without SUPER-role. In this case, when I try to use the formulas i can't…
-
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
-
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?
-
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
-
Web Users
We are trying to take advantage of the web users in Navision, but are unsure how to go about setting them up. Does anyone have any information about how to use or what is required? thanks in advance, Nicole
-
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…
-
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…
-
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..
-
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…
-
ANSI NULL default
When creating new columns I want them to be NULL-able. There is an option ANSI NULL Default in New/Alter Database (SQL), but the the columns are always created with NOT NULL. I have checked default settings on db, but nothing helps. What am I missing ? Now I go to EM and modify the columns there, but I would like to do it…
-
OnInputChange
Somebody posted this question back in 2002 but there were no answers so I am going to try again because now I have the same problem. The Help files say : OnInputChange The C/AL code in this trigger is executed while the user makes entries into a text box. You can use this trigger to check the entries the user is making as…
-
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…
-
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…
-
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.
-
Quantity on Hand for the Item Card
I understand its a Flow field but what tables/columns (sql2k) does it use to calculate this? Thanks.
-
Job Scheduler
Can Navision's Job Scheduler run automatically withou a user pressing the start button?
-
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.…
-
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…
-
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…
-
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?