-
Report.RunModal seems to be dropping the record parameter
I'm passing a record to the report, but it seems to get dropped. Not sure why?? Here is the code from the debugger. OnPush CodeCurrForm.SETSELECTIONFILTER(SalesCrMemoHeader);SalesCrMemoHeader.COPY(Rec);SalesCrMemoHeader.PrintRecords(TRUE) PrintRecords Function in SalesCrMemoHeaderWITH SalesCrMemoHeader DO BEGIN COPY(Rec);…
-
Export certain Purchase Lines with DP
Hello @all, I have a really noob Problem. :( I want to export certain Purchase Lines depending on a criteria from the Purchase Header. Where do i have to set the filter on the Header? (in C/AL? Which Dataport-function?) How can I filter the Lines with the Headers ?
-
Attain 3.6a Multiple Employer w2 problem
Hello, We are having a problem which I am hoping someone might be able to lend some insight into. We have been running attain 3.6a for the last several years without major problem, about 10 months ago we opened another facility in another state and so to handle the new payroll requirements for different state taxes etc…
-
When was a report last run?
Hello, Is there anyway I can see when a report was last run in the system? // Regards Tomas
-
Report filtering
when running a report, is it possible to set a value for a particular field in a dataitem?? if yes, how thankx
-
Date reminder..
Using Navision 3.10.. Let's say I enter 50 orders into Navision and let them sit there.. I don't do anything with them. The cancel date on all the orders is 01/13/07. Meaning all orders must ship by then. Is there anyway to set a reminder that when I go into Navision it will remind me which orders are getting near their…
-
[ZetaFax Integration] - Errors when sending multiple faxes
We use Navision 3.60 and I'm sending sales order confirmation to our customers & sales persons using ZetaFax V10. It's working fine , but sometimes I get the following errors when multiple faxes are sent to the spooler : :bug: :bug: :bug: :bug: :bug: :bug: :bug: :bug: :bug: :bug: Please wait while Zetafax finished…
-
Purchase order performance report
In order to analyse our vendors, I have created a report that compares the promised receipt date with the posting date of the last GRN against this order. I have then set it if promised < GRN posting date then late if promised > GRN Posring date then early etc One thing I have noticed is that our purch department seem to…
-
Date Calculation
Hi All, Here I am facing some problem in calculating dates. Here is my scenario. I have three fields like Starting Date (mm/dd/yy) Ending Date (mm/dd/yy) Invoice Period (with a value like Month, Two Month, quarter, Half year, year). So, If I give the value of starting date as 12/13/06 and ending date as 04/30/07 and…
-
Find date in a range of records
hi all, is there a quick way to find the LATEST date in a range of records?? thanks
-
Navision Form (Orders) Field Color Change
Hello, How do you perform changes (ie Properties) for Navision Form? I would like to change the color of Customer Name Field (ie Yellow, light blue, etc) to flag that said customer requires a Sales Order Acknowledgement. Is there a standard field that I can used for abow mentioned purpose? Also, I would also like to show…
-
help please...messed up a form
i'm a vs.net programmer. however, my boss wanted me to see if i could fix a navision program. we have several customers using navision, so i thought i would use what looked like an exact form to fix another database...i went to: sales & receivables orders did object designer selected form 573 and copied it...deleted the…
-
Disconnect Navision users and lock database
HI, I would like to do the following: Notify User to LOGOUT and stop everybody from LOGIN again. Is there any way to do this in Navision? Actually I think it would be a great feature to communicate with other users in Navsion with a simple messaging. The only solution I came up with from stopping people to login again is…
-
Report Totals
I have a report that is grouped by two fields. I am trying to get a total for the entire report. It works fine for each grouping but not for a report total. The total I get is the total of the last group total and not a report total. Is there something that I'm missing?
-
Econnrefused
Hello, a several days ago, the Navision client runs correct. But now, when I want to login, I get the message: The TCP/IP connection's `host` is not answering (TCP/IP error ECONNREFUSED). You can see how to make changes......... I've copied the hostfile and the services file from another working computer. All other clients…
-
Change Worksheet in exiting Excel-File
Hallo, my Problem is really specific. All Topica wich I found to deal with Export Data to a new Excel File. My Problems are that I Have to export Data in a exiting Ecxel File with more than 1 Worksheet. I can open the file an write data in the first Worksheet but when i try to change the worksheet and write Data, Navision…
-
trouble with logins after restore
We are on Navision Attain 3.01B, on SQL Server 2000. I try to be prepared for a restauration of our production database (8 GO, 200 user in windows login). So we will work with a complete backup plus tansactions logs. This should run without problem. But after some testing I wonder what should be the procedure to get all…
-
decimal and recorset
Hello, I tried to import datas from a SQL database to navision using ADO. My new record is inserted correctly for text or date or integer values, except for decimal values which are always equal to 0. ](*,) Note that I use a view in SQL and not a table. I also tried to pass through a variant but I have this error…
-
Execute process in several companies
Helo! In a Native Navision database, For execute a batch proces in 12 different companies which are all in the same database, I need to have open one session on each company = 12 sessions!! Does anybody knows a way to do it using only one session?? Thanks very much! All the best, Alberto.
-
Data Compression & Deletion In Navision 3.10
Has anyone got any hints or tips on the best use of the data compression and deletion tools in Nav 3.10?? I am currently working with a customer who has had this problem previously, during the first attempts a while back we found that that there was some items with a discrepancy between the inventory and no. of stock units…
-
Merging Data Fields From Crm To Excel
Using the Interaction template in Navision 3.60 you can import documents that are to be used, with this in mind I have imported an Excel document that I then want to use to merge customer address details with as is possible with Word, can this be done, I can't see of any way within stan dard Navision. Cheers
-
authority problem
Hello, I am pretty new to Navison and now I have a problem. I have made a new report but the user cant run because the dont have permission to. I have made a role and to that role I have made proper authorititys. "You do not have permission to run the 'xxxxxxxxxx'" Regards
-
Navision v/s Outlook
Hi All, A client of ours is using Terminal Services to connect to Navision and sending emails through Outlook (from Navision - using Authorization module that we have designed). Outlook has been setup with its own profile but multiple users are sendoing email (each with its own profile). Does anyone know if this is the…
-
Another user has modified...
Hi There, msg prompted : Another user has modified the record for this analysis View after you retrieved it from the database. Enter your changes again in the updated window, or start the interruptted activity again. Identification fields and values: Code : 'B52' My user got the msg above when the user doing the posting of…
-
Finding out who was logged in
Hallo, is it possible to find out who was logged in at specific date? Someone has all data from one table deleted and I want to know who. In order to do that I should know who was logged in today.
-
RAID Question
I am wondering whether I would get better performance from RAID 10 with 6 disks and with one database file, or having 3 database files RAID 1 with 2 disks each. This is using Navision Database Server. Has anybody tried this combinations? TIA, Damir
-
Urgent:Interaction Template Code Email attachment in body
Hello to everybody, I am relatively new to Navision and have searched for over an hour to find a solution to my problem on the forum but haven't found one: Problem is, I want to make an interaction that sends an email, but not as an attachment, the letter that is in Word and that is connected to the interaction should be…
-
Item charge assignment problem
The story: In Purchases & Payables area I create a new order. I create a line with an item. Then, another line with an item charge. I choose Functions/ Item Charge Assignment - the window that opens is empty !?(it should contain a line with the item, shuldn't it?). If I choose further Functions/ Get receit lines, this…
-
To add fields to an existing subform
I need to add two fields into the sales order subform. The first field is the date when the article is expected to be delivered and the second one is the amount on purchasing order. The task is surely very easy, but I have just started to make changes in Navision and don’t have too much experience. My problem is that I…
-
Transfer Data from One Table To Another
I've done this many a time but just can't get my brain to work on this one. I think I'm still suffering from that crushing NY Giants loss!! I have a table called NewTable, It has 2 fields 1)Vendor Item No 2)UPC I want to run a report that will check if the NewTable Vendor Item No matches an items Vendor Item No and if it…