-
Decimal to Fraction
Hi: Does anyone of you have a function to converter a decimal value to fraction?
-
Fixed Asset - Picture display
I have been asked to look at bringing pictures into the Fixed Asset - Picture field. Considering we have over 20000 fixed assets though, I'm concerned about what this might mean for the space taken by the database even if most remain empty. I was thinking of using a graphical converter to store the images as JPG and…
-
index
Hi, I am new to Navision, we just finished implementation, and I am receiving an error. It is " Indexing 6 in the array is outside of permitted range." Can anyone tell me what this is and how I would fix it? Thanks :)
-
Performance problems on Navision 3.60 SQL
We are having serious performance problems in our Navision Attain 3.60 SQL implementation. This is how our server is configured: - Compaq Proliant DL380 Dual Processor P4-3.2-Hyperthread - 4 Gb memory - QLogic 2300 series 2 Gb HBA connected to EMC Clariion CX400 SAN with 1 Storage controller set to RAID-1 high performance…
-
Pictures on Form
Good Day! I would like to ask if anyone can provide a solution on how I can fit in a picture (coming from the Picture Table) to a form. I saw in a previous post, here in Mibuso, that you can do this particular function by defining in the C/AL Global a temporary variable with BLOB datatype, where you can store the image. My…
-
Adjust Cost Job...
Hi, :P I’m trying to solve an Adjust costing problem on a Retail Navision 3.60 SQL BD based on Infostore 4.22. :? Here is my problem: As you can guess DB size is huge. Actually, it’s close to 70Gbites. All hot fixes linked to Stock management are implemented on the system. Items are manged in Fifo. Adjust Cost Job have…
-
printing duplex
Hi, I would like to print conditions (I've put them in a Wordfile) on the back side of our invoices ? Any idea ? I have Navision 3.60. Thanx
-
releasing license
I browsed the forum and i see a lot of threads about killing clients. But i have the following problem. The client crashes without releasing the license. When the client creates a new connection, it uses a new license. I want that the non-active connections that use license are freed. But i can't find a way to do that I…
-
Security in Navision
Hi, I want to set security for some users and it works great, only now, i also don't want them to create a new database. the systemobject(userrights) on object 1610(File,Database,New) are there, but they still can select it and create a new one. How can i disable this?
-
Prevent Users of changing Report Lists
Good day to everybody. Can u help me please ? I'm trying to prevent some users of making changes (delete or edit) in the reports Lists (for all modules). I found that there is a "Reports - Modify" form (number 281) but i cant find in what permission is. With the "All" permision any user can delete objects from any report…
-
Call center for Navision
Our potential customer is lookking for a call center support application within Navision 3.60. The cusomer offers telemarketing services and would like to share their database with their customers. If anyone knows of an existing solution, please let me know.
-
SMTP emailing problem
Hey, I got a problem with SMTP OCX v1.6, how it's possible send e'mails to different recipients if I dont know their host's, this OCX needs it: SmtpMail.SetHost('studif.ktu.lt'); How I could solve this problem? Thanks.
-
Newbie here...storing and passing a value from/to dataports
After exporting information to an external file via a dataport I want to store the last entry id number. This stored value will be recalled when the same dataport is executed a second time to filter out records already exported. A detail explanation of how to accomplish this will be much appreciated. Thanks :P
-
Starting a function automatically when form opens
Hello, I've recently discoved the ability to URL launch a form. What I want to do is have a user function on that form start when I URL activate the form. Currently, the form has a button that the user clicks which has a call to the function. If I URL launch the form, I'm having issues when trying to call the function…
-
Filtering operator for NOT EQUAL
Hi There, Anyone know how to do filtering for NOT EQUAL at the report filtering? say, i would like to print all customer except the customer code start with M. What is the syntax to exclude the customer code start with 'M'.? I put the filtering as <>M, but the records still show those customer code start with M. Appreciate…
-
Technical question
Hi to all and thanks in advance for your attention and help... I have a technical question about Navision.. What happens when i specify a "Job No." in a Purchase Order Subform line and post the order? And instead what happens when i simply specify a Purchase Order Subform line and DON'T specify the "Job No." in the line,…
-
NAS : Error 1 in module 5
Is anyone familiar with this kind of error in the application log ? What is Error 1, and, where do I find module 5 ? Event Type: Error Event Source: Period Event Category: None Event ID: 109 Date: 28-10-04 Time: 11:30:00 AM User: N/A Computer: BARNEY_RUBBLE Description: Internal error 1 in module 5. Contact your dealer if…
-
Msg from system : Your activity was deadlocked
Hi THere, msg from system was : Your activity was deadlocked with another user modifyong the G/L Entry table. Start again. The system prompt my user the message when the user post the applied entries in Applied Customer Entry. At the point of time, there was only one user doing the posting and there were no any…
-
Auto log in/form launching
Hi everyone. Is there a typical/suggested way if I want to be able to launch Navision via a batch, to automatically log in and start up a specific form, aside from the main menu. The main menu can launch as normal, however I want another form to launch, too. I guess I see the issue of auto-filling/performing the logon as…
-
Problems with BOM
Hello! We have problems with Items witch are using BOM. Procedure: 1.step : We make Purchase - Receipt for 2 new Materials. Materials "Unit Cost" = 0; 2.step : Then we make BOM for new Product with these two Materials. "Unit Cost" for Product is 0. 3. step : Then we post BOM journal. "Unit Cost" for Materials and Product…
-
Need help with Text boxes
Hi folks, I already watched the solution out by myself, but YI don`t know how to delete this message. I would like to place a value in a textbox. Right now, a value is calculated via C/AL in the OnAcativate() Trigger of the textbox. But I have to use the Message function to display the value to the user. Instead, I would…
-
Saving Sales orders
I am aware of the Archive Sales Order Functions, but am unclear how you can keep a copy of an order that has completely shipped. For instance, if I create a Sales Order, create two shipments off of this sales order, then close it, how can I look at my original order. Can Navision 3.7 be set up so that every sales order…
-
How can i pass variables to a form with form. runmodal.
hi, Is there any way to pass value of some variables to a form whereas I am running that form with the help of form.runmodal. We can do so with the help of formvariable.function and formvariable.run, But i specifically need this with the help of RunModal becz I want to check the LookupAction of this form. Pls help. Thanks…
-
Page-number printing on report
hi! i'm glad to join in this forum... my problem is how to determine the total number of pages that will be printed from a print preview of certain filtered data. for example: printed on every page: Page 1 of 5 ...how can i get the value of 5 (total pages) which i can print on every page?
-
problem with using DDE (Dynamic Data Exchange)
I use DDE in my program. All DDE function use expect DDEPoke. DDEPoke must send data from Navision to other sysem, but don't send. Please help me.
-
PDF format
Is possible to export from Navision in PDF format?
-
Detecting and avoiding table locks
Does anyone have any code that can detect a table locks and return this information in code, i.e. without generating a user visible error. i.e Result =fn(Table) Where fn returns the lock status of a table, Result being Boolean. This is required for Native database, Financials pre 3.7. Background:- We have a site with 120+…
-
Geting value from fieldRef.Value ?
Here is my problem: Let's say I have variable refFieldRef of type fieldRef. Using statment TmpValue := refFieldRef.Value; I get field's value but variable TmpValue contains data of type Variant. I can check data type using functions like TmpValue.IsBoolean() but I don't know how to convert data from variant to simple…
-
Help me please.........
I cheked to SQL Server and tick "Select , update" already but I cannot posted to Item. Now I feel bad. The following SQL Server error(s) occured while accessing the Item table: 229,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE permission denied on object 'Premium$Item', database 'my-navision',owner 'dbo'.…
-
Successfully stopping the NAS.
Hello, In one of our applications we're using the Navision application server in combination with Windows Task Scheduler and some batch-files to read and process some files every 2 hours. At the end of our codeunit a batchfile is called that will stop the NAS, the way it always worked: NET STOP %NASNAME% since a few weeks,…