-
Export a Sub to Excel
Hey there. Maybe I wont get help to my other topic so I just try to find an alternativ solution. How do I export an VBA-Code to Excel while using the standard funktion (CTRL+E in a List Page) to export to excel. I would like to export following code: Private Sub Worksheet_SelectionChange(ByVal Target As Range)…
-
Is it important to have FDB files in different drives, when using a SAN?
NAV5 with an old native (*.fdb) database in 10 parts of 20 gb. The virtual table "Database File" say each database file has an average read and write delay of 0-3 msec, while users are working. The underlying disc system is a huge SAN, so the hardware people say it is not an issue having all the database parts on the same…
-
How to excel export with information from different tables
Hi mubuso followers, I have a question for my following problem and code. This code will export a Excel list with different Row's and information on different tables. Now RowNo 6 and 14 will not set data and will be empty. Does someone knows why? Thanks for answer. IF ExportToExcel THEN BEGIN RowNo := RowNo + 1; WITH…
-
Add new field to Employee table - Starter Pack, Customer License
I would like to know if a customer of Dynamics NAV 2016 with Starter Pack functionality is allowed to add a new field to a specific table, and then display this field on the associated page. For example, adding a field called MyNewField to Employee table, with Field No. = 50000 (in the customer range). AFAIK, this should…
-
Excel-Export - column width - autofit
Hey, there is a Problem when exporting lists into Excel. At our Clound the autofit-Funktion does not do its Job correctly. it seems like it just fit the width to the Header, however, not to the records them self. In Addition, it seems that this Problem just appears when we just an enviroment where the Server and the Client…
-
NAV 2009-Classic version-Can be installed on Tablet having Windows 7 as Operating System
HI, My client has Nav 2009 Classic clinet & needs to install NAV on tablet.Can NAV 2009 be installed on the tablet or is there any other process for the same. Also any pre rqeuisite for the tablet OS to be in place? Kindly help
-
get value with non-primary key field
i'm new in navision , i want to get data without using primary key. example:= table:-service tax entry(str-record variable) -vendor ledger entry(vle-record variable) -variable(date-datatype) (i want 'document date' field from vendor ledger entry through 'party code' and store it in variable) MyCode:…
-
Sales Invoice Discounts not working
I can't seem to get sales invoice discounts to work in our environment. I've set up a new customer and gone to Sales --> Invoice Discounts. I've set up a discount for the customer of 15% with a minimum amount of 0.00 and no service charge. I've gone over to Financial Management --> Setup --> Sales and Receivables Setup and…
-
Setrange vs setfilter
Difference between them...
-
Why does showing the Automation Server table require RunAs Administrator?
(NAV2009R2 build 35179, Classic, SQL) We have solution running at multiple sites without any issues, but now one of the sites changed the security settings for their Citrix Servers. This caused the following code to fail: AutomationServers.SETRANGE(GUID,'{3B311C81-140E-11D5-8B18-00D0590B4EC5}'); // 'Navision Timer…
-
Unable to download hotfix
Hi, I can access Ms Partner source. I login to MS Partner source , I try to down load the MS Dynamics NAV 4.0 SP3 Feature Pack 3 (HF-6) Indian localization. When I down load this I am getting the below message , but I am not getting that Hotfix. “ Microsoft Dynamics File Exchange System Your file will begin downloading…
-
Salesman Name
Hi, Currently under customer card we can see Salesman Code and when we do lookup it takes us to the salesperson/purchaser screen and here we can see the salesman name in full my question is how to display this salesman name next to the salesman code field in the customer card. I have tried using FlowField but I guess I am…
-
Which CodeUnit is used for Posting of amount??
Hi, Please help
-
Date type changes
I want to change the data type.
-
how to create a blank database in nav 2009 r2
can any one explain me how to create a blank data base using nav 2009 r2...
-
Export Data
Hi, How to add export functionality in Report
-
Delete
Hi, How to delete the records except first record based on document no please suggest me the code
-
ERROR IS NOT A FUNCTION
NAV2009 DB New table trying to write an Error dialog. It will not compile gives message ERROR is not a function, and only functions can be called with ('... No variables or functions have been created, just a simple table.
-
Error on CALCSUMS function
Hi experts, can any one please tell me how to sum the amount of vendor payment records for vendor 10000 I want to sum the amount of all the records and the added amount should be displayed to the first record after that next records should be eliminated please suggest me to achieve this
-
User level menu
Hi, I had searched for more than 2 hours, for a way to get a list reads like below: Menu A UserA Enabled Menu A UserB Enabled Menu A UserC Disabled ..... Any clue???
-
How to change data base
How to change DB
-
In Navision how to get added cost of service tax on Purchase of fixed asset.. is there any way??
In Navision how to get added cost of service tax on Purchase of fixed asset.. is there any way to service tax amount get added on FA card.
-
ship to address form
Hi, I create a new option on Ship-to Address
-
Payment
Hi Experts, I want to combine the vendor payment records into one In that for vendor account no. 10000 the amount field should be 3000 which is the sum of two records amount and it should show one record of vendor 10000 instead of two Same as for 20000 also while exporting electronic payments into a file , the vendor…
-
Whse. Receipt lines
Hello, I have a function which when you re open a Purchase Order it deletes any Whse. Receipt Lines related to it. How ever I keep receiving this error. Here is my code.. How can I alter the code to fix this error? Thanks
-
Automatic Posting of item charges
Hi All, I have created a field carrier charges in sales line and in sales order sub form I added this field, when I am posting the item in sales order the carrier charges should come as item charges, the new line of item charges should be post in background while posting the item and I have written the code for adding the…
-
Consolidate
Payment consolidation
-
how to create a new user in microsoft dynamics nav classic with sql server..?
can any one explain me how to create a new user in microsoft dynamics nav 2009 r2 classic with sql server...
-
Menu suite
Hi, Which menu suite contain ship-to address form. plz tell me
-
To eliminate error when report is running.
Hi, Vendor Invoice number field on Purchase Invoice Header table 122 is 35 characters, where as the Cross Reference Number field on the Purchase Invoice Line is only 20 characters. Thus the error