-
Searching For A Sub string in a String
Hello All, I have a problem in that if i have a range of Itemcodes from "1000 to 9000" for example. Now on a form say a user enters "1170" in a text box.I want to be able to collect all Itemcodes that have "11" as the start of the code.So these would be "1110,1120,1135,1148" etc and it must then populate the relevant…
-
How to convert multiple requisition worksheets to a PO?
Dear all, I would like to know how to convert multiple requisition worksheets to a single Purhcase Order in Navision. Anderson
-
Automatic Emailing by linking various tables
Hello All I have created a new table that holds [no.] from table resource and two fields that are Technical and Commercial approver codes that links in with Salesperson/Purchaser table. When pressing a command button I need to refer to a new function within OnPush and then use this to send an automatic email to all…
-
Searching For A Sub string in a String
Hello All, I have a problem in that if i have a range of Itemcodes from "1000 to 9000" for example. Now on a form say a user enters "1170" in a text box.I want to be able to collect all Itemcodes that have "11" as the start of the code.So these would be "1110,1120,1135,1148" etc and it must then populate the relevant…
-
Displaying discount amount on sales invoice
Hi, Is it possible to display the early settlement discount amount on a sales invoice? At present the printout says something like "If paid by xx/xx/xx you get 1.5% discount", but I'd like the report to state the actual discount amount allowed (some of our customers work out the discount incorrectly).
-
Round selling price
Hi, I have to export some unit prices, but they must be rounded to nearest 9. Ex. Unit Price 152,- = export: 149,- Unit Price 156,- = export: 159,- Unit Price 14,- = export: 9,- Unit Price 218,- = export 219,- You get the idea? :wink: But how do I do that?
-
can C/ODCB refer to table and field names ?
I connect via C/ODBC to different Navisison-Databases in Germany, Austria and W1, so the table captions and field captions for the same tables are changing. Is is possible to refer to table- and field names, or better to table and field ID´s? Thanks for any idea Gerd
-
Migration to SQL Server
I have to do a migration to SQL Server (for the first time). Does anyone have tips & tricks to do this. I wanted to do following steps :oops: : 1) import migrate.fob from the CD 2) execute the codeunits 3) backup the database (dbsize = 3,5Gb) 4) create new database in SQL Server 5) restore in the new database
-
SMTP ocx 1.6 Not working ??
Hi All, last month i have downloaded the SMTP ocx 1.6 from general downloads - from Mibuso and its working. i'm using outlook 2000 , navision 3.10 and smtp ocx 1.6 . i'm executing the same utility in Navision codeunit, this is not at all working.. I have even checked it up at all the places.. the mail itself not hitting…
-
application of payments
Hello All, A client of mine has an application problem: she has big customers who usually have dozens of open invoices and pay them partially. This means that the payment is always less then the sum of invoice values. In these cases she would prefer a "manual" application method, where she would be able to determine…
-
Unicode-conversion
I am trying to convert a file when exporting from Navision - it should be converted into Unicode. I have seen the suggestions to use the ASCII->ANSI-codeunit and so on - and that is also the general idea! I just do not know how to convert for instance the sentence: [CONVERSION IS A LOT OF FUN] I need the brackets too....?…
-
Application developers license
Hi guys, Quick one. The App developers license does it allow for the editing of code associated with tables? Jim
-
Updating tables/fields not associated with a form
Hello All, What approach should I take to update a field on a table that is not associated with the form I am using? i.e. When pressing a button on my form, I want to update various fields in other tables within Navision. Any ideas? Thanks
-
Account Translation
Hello everybody, I got a problem with account translation. I have an account called Rounding, when I post an invoice, the system automatically count amount of rounding and put another line to the invoice, so the total amount is rounded. My problem is that I have a report called Order confirmation, where this automatic…
-
Multiple locations in Production Order
hi, Can anyone help me in this.Its emergency. I am creating a production order from a sales line. Its BOM components are located at multiple locations. now the firm planned production order that the system has created contains the BOM component lines where the location code is same as location code of the finished item in…
-
Client Installation Issue on Windows 2000
When installing the Navision Client, we are running into an issue. The client computers are running Windows 2000, and the end users do not have the rights to install software on thier computers. The administrator logs into the computer and installs the client software (he has all rights on the cpu). When the user then logs…
-
Create PDF in download section
I have found what maybe a useful download on this website, but does anyone know where I can get some information reagrding actually using this automation from within Navision ???
-
postdated checks
Hi, What is the best way to record the following transactions: 1. A customer pays you 3 postdated checks of different dates to settle his accounts. 2. You pay a vendor 3 postdated checks of different dates to settle your accounts. Thanks.
-
Integration with Fax
hi friends, There is one customer requirement , they want to send their customer statement through FAX, have any body done this sort of integration. reply me.If we run customer statement report then for those customer which have fax no. on customer card statement goes through FAx and which are not having fax no. statement…
-
Prevent Posting to G/L Accounts
I want to prevent posting to G/L accounts whenever a shipment or receipt is posted from sales and purchase order respectively in navision attain. Can anybody help me out?
-
Report design help
Hi all, *If it was not for this forum I'd be lost* ...to the point. I need to create a report that details item sales by salesperson. The general requirement is for a report that when run will show the quantities of individual items a saleperson has sold in a given time period (User defined). Could people point me in the…
-
Running a query on subform and main form
Within a subform, how do I access a field within the Main form and then use the value from that field to query a different table to obtain a value from another field? For example, i am in the quote lines and i want to retrieve the salesperson code and then use that code to obtain the email address from the…
-
Disable a field in a record based on a value in anoth field
Hello All, Should be simple this one but its not quite clicking... I have a field called Sentforapproval. This is boolean. This exists within the Sales Quote subform and within Sales Line. If this is set to TRUE, I want to make the entire record un-editable, if the user goes back into the quote. I have tried various…
-
Move window
When I start Navision Attain, I only se the right-lower corner of the main menu. How can I get hold of it and drag it back onto the viual part of the screen? I do not se the top segment of the window, hence I cannot select move or maximize. Thanks!
-
Intercompany
I have to make intercompany-functionality for my client. The idea is: When company A creates a sales order for a certain customer, they should have the opportunity to handle this sales order in another company in the database (comp B) . So, when creating the salesorder, a purchase order to comp B should be created, PLUS in…
-
Delete record without confirm
I like to delete a record (DEL-Key or F4) without the confirm window ("Are you sure to delete this record?"). How do I get this done?
-
Setting MaxIteration
Hi, Is it possible to set MaxIteration via C/SIDE code? What I am trying to do is look at the first record and based on the data in a given field decide wheter to print the rest of the records or not. Cheers Jim
-
communication among Navision systems
Hello All, We have a customer who has an HQ and several shops. They want to have a central system for back-office operations and separate systems in the shops for front-office (order processing, POS). Have you got any idea how to develop a reliable, automated, bidirectional data communication among these separated systems?…
-
SQL + Raid V
2 x Xeon 3 GHz 2,5 GB RAM 6 x 36.4GB HDD RAID V for database and system RAID I for log and temp Database: 64 GB SQL 2000 Sorry, its's an old question, but is it suicide to use RAID V for Navision SQL database?
-
Tablelocking by logged out user
:( Yesterday I had some trouble with a table (Dimension) locked by a user who was logged out from Navision and Citrix. The table was locked for about 2,5 hours. After that time it got automatically free again. We are running Navision 3.6 under Citrix in a Windows 2000 environment. Does somebody know what was going on ?