-
Segment Interaction Language
Hi I have run a database test and one of the problems I have is an entry in Segment Interaction Language but not in Segment Line. However, there are thousands of entries in Segment Line, and very few (about 10) in Segment Interaction Language. Does anyone know in what circumstances the Segment Interaction Language table is…
-
Changing the active record of the parent form
Hi all. I have the following situation. I have created a SubTable that is connected to the Sales Lines. When the user edits a specific sales line, he can press Shift-F9 and open the table SubTable in a form called SubForm that displays info relative to the specific Sales Line record. The client has requested that the wants…
-
hardware configuration for navision sql option
Does anyone have documentations on this? the situation: 130 concurrent users 60G database 3.6 Navision Questions: 1) Can we use windows 2003? What about SQL 2005? 2) I guess 4 CPU is required. What about RAM? I think we need 4G, but SQL 2000 Standard edition can only use 2G. To upgrade to SQL 2000 Enterprise will cost a…
-
BUG NAVISION? TableRelation & INSERT
BUG NAVISION? TableRelation & INSERT I Have the table with field Ship-to-Code. Ship-to-Code have propertiesTableRelation="Ship-to Address".Code WHERE (Customer No.=FIELD(Cust No.))ValidateTableRelation=Yes 1) I change "Cust No." (Ship-to-Code remain from old customer) 2) insert (not with C/AL. With my hands). The system…
-
Navision Job Scheduler - Backup problem
Hi guys, We're running 3.60, and currently have various routines which mean the Job Scheduler is running 24/7. But the Scheduler gets disrupted by our backup system. Anyone know how I can schedule a job to cancel the Scheduler at a certain time of day (so the backup can run), and what sort of command i'd need to get the…
-
How to enable the New Database Option in Business Analytics
Hi, I am not able to create a New Database in Business Analytics W1 4.0 basic version. I am trying to create a database in BA Enterprise Manager/Console/AntServer/Databases/..... The option to create a New Database is disabled. We contacted Microsoft on this issue, but still waiting for a reply. Can anyone throw some light…
-
Is there somthing wrong with EVALUATE...?
Hi, I have some problem with this part of my code: IF EVALUATE(StatusValue,ValueArray[1]) THEN BEGIN SETRANGE(Status,StatusValue); END StatusValue is global variable, type Option; ValueArray is type of text Something is wrong with EVALUATE, because if I put only EVALUATE(StatusValue,ValueArray[1]) I have a messagebox: You…
-
How to dowload Business Analytics from the Microsoft Site?
Hi Everybody, I have problem in downloading the Business Analytics W1 4.0 version from Microsoft site. One of my customer has bought the BA module and also has a valid link provided by microsoft to dowload, but still i cannot download the same. We have contacted Microsoft Customer Service team and still got no reply from…
-
Internal errors-descriptions
Hi all, Have somebody descriptions of internal errors or from where i can get them.
-
compressing item ledger entries...
I have been trying to compress item ledger entries it is working fine on demo database where as in production environment it just skips all the ILEs.....I've checked all the filters i'm applying, but in vain..... please help...... regards anoop
-
Navision, SQL and sychronization
Navision 3.70, SQL database. My shop has 5 countries connected to one central location. Same SQL server, separate databases. They connect via citrix. We want to setup a redundancy or synchronization of each countries database locally, as a backup for lost communications. Does anyone have experince with doing this with SQL…
-
How to ceate and coding object in Navision Attain 3.6.?
How to ceate and coding object in Navision Attain 3.6.? and ,How coding to connecting to SQL? and where are document or web site ? Sorry about My english language :oops: Thanks
-
Global Update / Rename
I wish to extend prices in our Item Price Table. In order to set an ending date, we use this table by putting in a starting date with price, followed by another starting date at 0 - this then flags up when entering sales prices up. We wish to extend our prices, and therefore require to extend the zero prices.. If i was to…
-
Manufacturing
I have problem in creating Production order. I have entered a line in the sales order. The item has its own Base unit of measure and has its own Bill of materials. When I enter the sales line I change the unit of measure with respect to its packing. The unit of measure in sales line is has the "Qty per unit of Measure" in…
-
how to delete the dimension value that aready use in entry
hi, i am fresh in using navision, thank you for all your help i create the dimension value 3100-mbs(berjaya) in dimension after i use this dimension to post in the general journal. when i want to view the account that i post using dimension detail report. come out the message say that the filter 3100-mbs(berjaya) is…
-
Cursor position after compilation error
Hi All, When you save and compile an object and there is a compilation error in it, usually the cursor is brought to a code line or a property value with the incorrect syntax. However, sometimes this doesn’t work thus making it difficult to locate an error. Does anyone know the cause and how to bring Navision C/SIDE back…
-
Average Cost at Item Card
Hi there, my Customer is having some problem with the Average Cost at the Item Card when the stock level become negative. However, this problem does NOT happen to all Items. The Average Cost will become Blank and Unit Cost displayed the last Average Cost and certain Item's Average Cost still remain. Anyone have any ideas…
-
XML export
How to make a XML from navision – export from navision table to xml.. Is there any example or book anything??? Configuration navi. 3.6
-
Tracking Information in Warehouse Shipment from code
We want to transfer item tracking data from hand terminal (ascii file) to the Warehouse Shipment Tracking Lines (table Reservation Entry). Does anybody know if there is a special function for that. The function that can be used for item journal does not work correctly, becouse of Order Tracking.
-
Error with Navision VT100 plugin
Hi all, a customer has some problems when running Navision VT100 plugin. Sometimes connection between radiofrequency devices and Navision server is lost and the following message is registered on the Windows event log: Event ID: 110 Source: Navision VT100 No se encuentra la descripcin del Id. de suceso ( 110 ) en el origen…
-
Posted Documents
Dear All, Can anyone please direct me to any official documentation/article/papers which would explain to why Navision deletes/archives documents (i.e. Sales/Purchase Orders) once posted. I have exhaustively looked around yet can't find anything, can anyone remember seeing it anywhere? Appreciate your input. Many thanks
-
delete txt file after import
Dear all, I have a dataport to import data from a text file. How do I delete the text file after importing all the file. Thank You, hawwa
-
Trapping Navision Error
On an insert or modify error I would like to trap the Navision error message. Is this possible?
-
MBS Customer Source
Does simply paying maintenance to an MBS reseller entitle one to Customer Source access, or is there a requirement to pay Microsoft directly?
-
Subform fields uneditable
We have a subform where we turn on/off the Editable property of the fields on the subform via a command button [CurrForm.ExtItemSubForm.FORM.SetModStatusTrigCode(TRUE)] ...but only checkbox fields turn on/off, not the text fields. Is there a way to turn on/off the Editable property of these text fields on the subform via a…
-
Account Schedule - 3rd / 4th dimension
Hi, we are trying to use the 3rd and 4th dimension. It doen't retrieve the values from the account. What object needs to be changed in general. Thanks Dino
-
jump to new record
hi all! i'm looking for a possibility to jump to a new record. i've tried out several ways but had bad look so far. at last i did the following: rec.FIND('+'); rec.NEXT; but navision ignores the next command. and a function likerec.NEW; does not exist! can anyone help me?
-
Error message "The expresion Code cannot be type-conver
Error message "The expresion Code cannot be type-converted to a Option Value" This is the code I got: SalesHeader.GET("Tax Area Code"); IF SalesHeader."Tax Area Code" = '0000000000' THEN BEGIN
-
Codunit 5763 Whse.-Post Shipmen- end of transaction (COMMIT)
Codunit 5763 have version NAVW13.60.00.26 in our database. Code() function have strings: REPEAT SETRANGE("Source Type","Source Type"); SETRANGE("Source Subtype","Source Subtype"); SETRANGE("Source No.","Source No."); InitSourceDocumentHeader; InitSourceDocumentLines; COMMIT; CounterSourceDocTotal := CounterSourceDocTotal +…
-
Problem In Double grouping in report
How can i make double grouping in my report?Like i have a table and i wnt to generate a report with grouping upon Document No. and then grouping upon Operation No. so that i can generate total of quantity under same operation no. with same Document No.Kindly reply as soon as possible.