-
Inventory in Diff UOM
My problem is as below... 1. User will book the sales order in BaseUOM(e.g Pcs) 2. Manufacturing output will be posted in Pcs, Box(100), SmallPack(50). 3. While doing warehouse shipment, User will fetch sales order lines by using Get Source Document function. 4. At this moment shipment lines are in Base UOM, Bcoz Sales…
-
Scanning for Sales Order
We are getting interested in buying some scanners for our sales team can: go into stores scan products create orders then send the info to us so I can import the orders probably thru a dataport. Anyone using one of these scanners out there and what kind do you prefer -PDA scanners http://www.barcoding.com/wireless/pda-b…
-
report problem when moving from 3.10 to upper version
I have the following issue. I have a report which runs ok on Attain 3.10 However when I run it from 3.70 or 4.0 the first page is ok but the header of the rest pages is duplicated. Anyone encountered such a problem. Ideas? 10x
-
Geographic map
I would like to know if there are solutions to link Navision's customer database to a geographic map. For instance, when one of our employees travels to visit a customer, he'd probably want to know whether others are in the vicinity. Do you know if it's possible to extend Navision this way with some kind of application (;…
-
option field on report
i have a report which uses GET to get information from another table. The field i am trying to bring through is an option field, and this works. The only problem is i get 1, 2, 3 etc etc rather than the option name.. How do i get the option string through?
-
help with INVENTORY ON A CERTAIN DATE
hi everyone....can someone tell me if is there a way in navision to get the nventory on a certain date??? i mean, if i want to see the inventory of a certain product 7 days ago thanks in advance
-
Tablefield Property: Editable as Code
Hi, is it possible to use the Tablefield Property EDITABLE as Code? I want to check the user role and if the check fails, it has to set the property to FALSE. Because only users with the user role SUPER should be able to edit this field. Thanks for your help!
-
a question of navision license, expire date
is there a way to see when the navision license expires??? thanks
-
How to realize GROUP BY in Navision
Does anyone know how to realize in Navision constuction like SELECT SUM(field17) FROM table32 GROUP BY field2 ?
-
balance forward vs open item customer statements
We ran the customer statement report for a Canadian customer (we are in the US) using a statement style of Open Item and Balance. We have a discrepancy between the two reports, in Total amounts, ranging from $7 this month all the way to over $15000 6 months ago. What is the best way to go about trouble shooting this issue…
-
will use navision 3.0
i want navision 3.0's demo software. but now,at china. can't find. everybody i have. send to me. ok? Mail: ncqingyi@gmail.com
-
Changing Primary Key troubles
Hi, I changed the primary key of an empty table and now I want to save the table definition. I receive the message "The change in the primary key definition has resulted in two records with the same primary key value". This cannot be true, because there are no records in the table. Does anybody know how I should solve this…
-
Add company logo
:?: Dear Friend please can any body help me to upload company logo in a report regards Sallil
-
Connection error
This morning I suddenly started getting this error when logging in to the database in our server: "There was a time-out in an attempt to establish a connection with the server (TCP/IP error TIMEDOUT)." Since I seemed to be the only one having this problem (ten other users have no problem at all), I suspect it must be some…
-
Select All Selects Too Much
I have a list form that is used to assign orders to shipments. I filter my table data (the orders) and then write the valid records to a temporary table (gtmpTMSubprobill) and then I launch the list form using FORM.RUNMODAL(37005447,gtmpTMSubprobill); The list then allows the user to select some or all of the records and…
-
Dataport question
Hi, Is there a way I could export data from 2 related tables in either Fixed or Variable format to a text file? When I tried to link the tables by indenting the data items, I got a message(while compiling) that 'you indented data items but the file format is not UPDXML'
-
[Unsolveable] Evaluate Time or DateTime to a FieldRef (3.60)
Hi all, I'm using fieldrefs to fill a record. To source value is 'text' so i need to use an evaluate function to convert the string to a Time variable. Since there is no evaluate function for fieldRef's i used a function i found somewhere here on this forum. It works for all data type except for Time or DateTime variables.…
-
Manufacturing Planning Dampner
Hopefully this will be a common problem and others have already figured something out here. The problem is that the dampner (time) on production orders--which controls the window in which you will see new messages (reschedule in/reschedule out) is a two way setting--that is if the setting if set for 21days it ignors both…
-
Printer dialog
I have set up a printer in "Printer selection" form. Can I print skiping printer dialog but showing request filters window. I don't want to use REPORT.RUNMODAL(number, requestWindow, SystemPrinter,Table) , because I need it for whole application.
-
DATEPART In C/AL
Is there any way to return the datepart in CAL similar to how it can be done in SQL. I need to put something together that provides information on the earlier part of the week but need to somehow recognise from the date the user puts in what day of the week it is eg. If it is a Thursday i need to populate information for…
-
How to detect if a report send to printer for printing?
Hi All, Is there any method to detect a report has been sent to printer in stead of just preview only? Thank you. Regards Rachel
-
How to get a recordRef
Hi everybody, I want the to get the recordRef to the current Rec. I know there is no such thing as Rec.getRecRef. But what is the best way to get a RecRef variable to point to my Rec?
-
Application of Posted Payments to Posted Invoices
How can I apply a posted payment against a posted customer invoice? Our system is not applying payments against invoices. Is there a way to force a payment to be applied to the oldest open invoice? Thanks Dan Alpe Providing food for hungry people while striving to end hunger in our community.
-
Open files from Navision
We need to be able to open files from Navision. I would want to have windows take care of the file type. So I would have a file name in my database, click a button which launches Word for *.doc files, Excel for *.xls files, etc. It would also be acceptable to be able to launch windows explorer with a path that I store in…
-
Setting up user roles
I did read some documentation about setting user roles but I have some blanks. If I have line like this:Object Type Object ID Object Name Read Permission Insert Permission Modify Permission Delete Permission Execute Permission Security FilterForm 0 Yes Yes Yes Yes Yes that means that user with that role has all permissions…
-
Conversions
2 bad my other 2 topics arent solved yet but i bumped to another one. note: programmed in c#.net i use the stringbuilder to collect data from the database using cfront.dll (see here) but i have some troubles with the conversions (aka not getting the results i should have) so i made a small program to give a string, and…
-
Separating one field to two in dataport
Hi everyone! I have excel sheet that has contact names on one column, however most of them are too long for contact name field ( 30 char ). What kind of code do I need to cut name field and paste characters that exceed 30 to Name 2 field? Thank you!
-
making a subform noneditable
Hi, I have one form with 2 subforms in it. now I want to be able to say with some code in my form that the 1st subform is editable and the second one is noneditable ore vice versa. I have tried already many things but haven't succeeded yet. Can anyone help me with this? Thanks in advance
-
Changing Line no. in Reports list
Hi, I’m trying to keep some kind of order in my report list. But when I want to insert a new report in the list (with modify and F3) I get an error saying: The autosplitkey facility cannot find a key between the current and the previous record. When I use the zoom function on the report before and after where I want to put…
-
Chinese Characters
Hi! Anyone who knows how to import simplified chinese characters from an external document into the Navision? The chinese characters are actually in an MS Word document. I tried using simple copy and paste but all that is being pasted in the Navision are '?' characters. Thanks! Hope someone has an answer to this. [-o<