-
Integration between 3.70 & UPS Worldship
Anyone has an out-of-the-box Integration between 3.70 & UPS Worldship that they sell?
-
trigger in a table
in OnInsert trigger of a table I Have inserted some code. The trigger is not always executed. Why it is not always executed every time I insert a new record? Thanks.
-
Problem in Form!!!
Hello all, i have got an problem in a form, i want the onaftergetrecord trigger to run only once on opening the form, but later when you scroll through your lines it should run every time. THX 4 Help
-
OnInit on Table
How can I see then OnInit section on Table 36. As you see I am learning Navision. Thank you in advance :oops:
-
Matrix box
I've been learning hos to use a mtrix box control in a form, but don't understand. Please, i need help how to use this control. I want to fill a matrix with a determinate values, but not all cells of matrix are value. Help me!!!!!!!!!1 Please.
-
Outlook Calendar
Hi ALL, I have a question for who of you that use the Outlook integration feature. 1 - Is it possible to import meetings from the outlook calendar for all the salesperson with the Outlook Synchronization enabled at once? I mean... also for who that's not currently logged in. (Navision for them export everything very…
-
alternative to Marked Only on Forms?
Just completed a project for a client where there is a form similar to the one below. It contains a tabcontrol for filtering and a subform based on table 15. The client requires the ability to enter filters in the tabcontrol and when the flowfields are calculated, only if at least one of the following fields (“Net…
-
Automatically filtering records when user opens a form
Hello All, I have used the table filter within SourceTableView to automatically apply a filter on the open field when the user opens the customer ledger entry table. However, when they press SHOWALL button, I want all entries to be displayed including entries that are not open. But at the moment, pressing SHOW ALL just…
-
problem in data import
hi... i am trying to import some data like "document type","sell to customer","no." from a text file through dataport into sales header table. but the problem is that only these three fields get updated. But, i want to update all the fields as it happens in sales order form. I have also tried the option, callfieldvalidate…
-
OCX Mapx for Navision
I need to manipulate maps created in mapx from navision somebody knows like doing it
-
CODBC Question
Hello and good day to you all. I'm new here, so I don't know you, but it seems that this place is full of good people so I'm happy to have found you. I'm trying to code a procedure that dumps certain data from the Native Attain database to an access database. The database I'm working on is the danish version so table and…
-
Filter/Search on Form Field
Hi, I added two new field on the Sales Order form Sell-To Customer Phone No. and Ship-To Phone No. They fields dont exist in the sales header table. The code is written on the onaftergetrecord. Can anyone please suggest me ideas on how to provide filter or searching on these fields in this form. That is if the user wants…
-
Grouping and Sorting in Reports
Hi All I have a report that has Item has the first data item and item ledger entries at the second data item that is indented. I want to generate the report firstly by GPPG from Item and then by Location from Item Ledger Entry. I have got the report subtotalling by GPPG but I cannot find a way of grouping by GPPG and then…
-
Import license everytime then access to navision
I don't understand,after I setup new win2000 server,and I setup everythings and navision,and then I access to navision everytime,why must to import license to navision evertimes. Please.........
-
I need "User Portal Developer Guide.pdf" file
Hi, I need "User Portal Developer Guide.pdf" file. If you have or know where I can find, and if you send it to me I will be so pleased. Good Works.
-
job report
Hi, is it possible to see the sum of working hours for some jobs? I mean: I'd like knowing how many hours my colleagues worked on all the jobs. I need this because we have many sub-jobs refering to a pricipal job, and i want to know total hours. Is there a report or a way to have this result? In reports as 1203 (job…
-
Killing a process
Hi, does anybody know how you can kill a running program from within code? Ex: how can I end the Acrobat Reader from within Navision Code? (Without working with "automation". Just an independent program!) Thanks a lot!! Greets, R.
-
C/ODBC , Date Problem in SQL Server
Using Navision 3.7, CODBC 3.60 connecting to SQLServer, we have problems in trying to export tabledata containing date format fields from Navision to SQL Server. It seems that records containing 0D cause the error. Insert Error, Column 120 "Order Date" , "DB_TYPE DBTIMESTAMP" Status6 Overflow Does anybod know how to solve…
-
Manufacturing - Registration
Good Morning, I have a problem with Manufacturing Window in Attain 3.60 and in Attain 3.60 SP1. In my test i've met various results: - in Attain 3.60 when i insert a row in Output Journals and i Register It, Navision Insert in Table 32 a number of line that are equals to the number of lines present in Assembly List. - In…
-
Use Current Record
Hello :D I guess this is a simple question if one knows "how-to"! But in the very old Navision (3.56 DOS) there was a function called "GetCurrentRec" meaning get the current record for further processing. On a form I have created a button calling a report. I want this report to pick up the current record from the form and…
-
Problem in posting invoices
I have a problem. We were previously using 2.0 W version. Now we have upgraded to 3.6 Indian. In the previous version, when we post sales invoice, if any error comes it does not post. If no error is found, then it will be posted, then the invoice will go out from the sales line to sales invoice line. Now in 3.6 in some…
-
Refreshing subform
Hello All I have a form with a button and a subform with a table box. When pressing the button in the main form, i want to automatically update the subform with the added information. I have tried to use currform."subform".UPDATE but i receive a message that says i cannot do this. Any alternative?
-
Exchange Rate
hey guys, today i have come across with a problem and i just can't find the answer. If you create multiple companies in the same database is it possible if you make a change to the exchange rate amount column and in the adjustment exch. Rate adjustments the rest of the companies to be affected by this change :?:Hope you…
-
Import from textfile using Codeunit - Trim spaces?
I have a problem using this code to import a fixed-length textfile into a temporary Navision-table: ... Number := COPYSTR(ptext,18,20); Name := COPYSTR(ptext,38,30); "Search Name" := COPYSTR(ptext,68,30); "Address line 1" := COPYSTR(ptext,98,30); "Address line 2" := COPYSTR(ptext,128,30); City := COPYSTR(ptext,158,30);…
-
Default value for new field in a form
Hello All I have added a new field to the Sales Header Form (orders). This is ship-to territory. I want this to default to the value already selected in the territory field in the Customer card. If required the user can then change this value by looking up the territory code (already done this). What is the best approach…
-
Traffic
I have a customer that wants to connect a branch to the server via terminal server. Do someone knows approximately how much will be the internet traffic in MB per day?
-
Navision database, C/ODBC and SQL Server 2000
Could anyone help me with referencing Navision proprietary database tables from SQL Server 2000 using C/ODBC. Apologies for the essay !! I have a 3.10 Navision installation with C/ODBC installed. The configured data source successfully retrieves information from the Navision database file for the chosen company via Access…
-
Slow Triggers in Dataport
Hello everybody !!! First message, first problem, first help needed ... here we are : I have one Export Dataport based on several tables. This dataport doesn't use a Request Form. Unfortunatelly, it takes a lot of time ( more than 1 minut) between OnInitDataport trigger and OnPreDataport trigger. :?: Do you have any idea…
-
Writing to Navision Attain from outside of Navision
When writing to Navision from outside of Navision is it possible to execute the code in the validate triggers?
-
problem in dataport
Hi, I have a query regarding dataport. I have a text(csv) file which looks like this No,Name,Address Item No,Quantity,Price Now i want to push 1st line to the customer table & 2nd line to the item table. Please help me in this regard. Thanks, Vikas S. Shettar