-
Staying with classic NAV
We are on the NAV 2009 R2, SQL, Classic client. And we are perfectly happy with it. With the customization we've done over the years, it's an very practical tool for our users. But not being current on the enhancement plan means we can not purchase new granules or objects. And recently we are trying to implement a mobile…
-
CUE : Pass param to page
Hello, I have a lot of sales cue in my Navision. All these cues have Page Sales Order List in the Drilldown Option, so that the Sales Order List opens when I click on a cue. In my Sales Order List, I have a lot of actions. I want to enable or not those actions in the Sales Order List regarding the selected sales cue.…
-
Append Body with MailMessage - Body longer than 1024 characters
We are using NAVISION 2009 R2. Our partner have modified the way NAV sends SMTP emails, thus we are now sending mail via a new CodeUnit using the DotNet variable MailMessage: 'System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.Mail.MailMessage In this CU, our partner created a AppendBody…
-
Basic v Advanced Inventory & Warehouse
Hi all, can anyone help with the above, I want to see what the difference is between both?
-
NAV2009 R2 build 6.00.33319
Dear All I am looking for NAV2009 R2 build 6.00.33319 installer Any one can suggest me on this Thanks & Regards gogi
-
Finance Set Up Checklist
Hi all, hopefully a sorry a simple question, can anyone send a list of what is required for a Finance setup? More along the lines of what i need to load for opening balances: I know Customer Open Ledger, Vendor Open Ledger, Sales Order, Purchase Order, what else is required?
-
Getting Error "Excel Not Found" while running the job queue
i have created a program for GL Data extraction and through job queue it should be automatically Email to user . While running the job queue i am getting error "Excel Not Found". I also tried by changing the Path to Network location but still its not working
-
Date Formula
HI, Is there any simple code to get the 3rd Monday of the month?
-
Outlook signature
Hello everbody, One of our customers send emails with navision. Does anyone know how I can add his signature to a new mail message when I choose the Email icon form the customer card? Greets, Frank
-
How can I disable the print in report on NAS?
The report should be run without printing.
-
Total sum per group
Hi everyone. I just started with C/AL navision. I want to create simple report thate contains two tables : Sales Invoice LIne and Resurce. I added a few globas variables , and report looks like this. (No. is Number of Resource, and at the same time No. of resource in Sales Invoice Line No. Name Price Qauntity Production…
-
Who i can disabled the preview in report
hello everyone, Who i can disable the preview in report.
-
Null in a function
Hello, i need to use a variant null in a function. The function has 5 parameters, and the first a second have to be null. how i put this null parameters ?
-
Navision 5.0 Support SQL Server 2019?
Dear all, One of my client want to run navision 5.0 in SQL server 2019. will Navision 5.0 is supported in SQL Server 2019? Please let me know. Thanks in advance. Regards, sekar.
-
Data Extraction
Hi, In Nav 5.0,Can we extract data to email on daily basis in Excel Format?
-
Download old versions
There used to be a nice archive of old versions on PartnerSource. Now PartnerSource is dead, does anybody know if it's still available somewhere? We have a new customer that wants to upgrade from v4 sp2 and doesn't have the original database... Thanks in advance!
-
How to export the Account Schedule data from multicompany
I got a requirement in Nav 2009 classic client, Not RTC, that the users want to export Account Schedule from Multiple companies, do you have some suggestion for that? thank you in advance, I have done some coding, it will change the account schedule description, but it will not change the data(Value), some guy have the…
-
Rapidstart error during import
I'm trying to import some data with RapidStart, I receive an error when applying the package. The error reports that a field contains a value that cannot be found in the related table; debugging I realized that the code breaks during the "FieldRef.Validate" . Obviously I've already checked that the value is contained in…
-
How to avoid order modification proposal in planning worksheet / MPS?
Dear all, when I'm using the MPS planning worksheet for resupply my stock, often I get the "modify" action. However if the purchased is already sent most of time I cannot change it and I have to create another one. Is there any way to force the MPS process to not modify existing purchase or production orders? Thanks
-
How to fill in dimensions on multiple lines (Physical Inventory Journals)
Hi, On the Physical Inventory Journals I have multiple lines. Every line has some dimensions. What would be the solution to fill in the dimension very quickly and not taking every line and inserting into Dimension page ? (it takes long time) I was thinking to create an action which runs a report and this report to receive…
-
inventory valuation 1001 Report
Hi experts , Do any one face a problem in low performance of this report if we have a big database? Navision 2009 R2 Thank you
-
XMLport - Import from CSV and COUNT
Hi, I am importing some records from .csv file with XMLport. Now, I want to put progress bar so I would need to count records that I need to import. Is there any way to count records even before processing all of them? And which trigger I should use? Thank you very much for your answers! Greetings
-
MS Dynamics NAV 2015 / LS 2015 - Replication issue - Job Queues always stop
Good day! MS Dynamics NAV 2015 / LS 2015 - Replication issue - Job Queues always stop - every time we turn-on or restart the client computer Job Queues always stop, we need to start it again OS: Windows 10 Pro 64bit and Windows 7 Pro 64bit MS Dynamics NAV version: Thank you.
-
Not able to connect to SQL server from NAV 2009 R2 in Windows server 2016 (Server cannot be found)
Working on a new migration of NAV 2009 R2. So, now we're using a new environment such as Windows Server 2016 and SQL 2017 and NAV 2009 R2. For now NAV client, NAV server and SQL server are all in the same machine(Windows Server 2016) for my troubleshooting. I've installed NAV 2009 R2 but when I go to NAV database open and…
-
How to increment a field value if it has same another field value
In Nav 2009, I am creating a dataport export where I am taking values from g/l entry table. My question is For suppose if we are having document no as 'qwerty123' I need to keep '1' in another field 'numbers' and again if I have the same same document no in next line the field 'Numbers' should be incremented by 1 and…
-
Sending request body of more than 1024 characters with POST request in NAV 2009 R2 Classic version
I have a solution in NAV 2013 where i Create a request body in JSON format for a POST request. In the solution i store all the body text into a Text variable. Now i have to implement the same solution in NAV 2009 R2 Classic version, but here the Text variable can store only 1024 characters. I have tried using String…
-
ne wimplementation
hello, for a new implemenation I have a couple of quesitons - do the clients need to do the period end and year end in new or old system. I think no because that would give them the option to post adjustments, right? Also what else do I need to check? Any advice is welcome
-
Sorting report by order type and order no. in NAV 2009 R2.
Hi Everyone, I have one report that has 2 dataitem: sales header & sales line. Inside report user need to add column 'order type'(Order channel) that is present in customer table, so i have created variable and assigned in sales line on after trigger. For sorting with order type(Option data-type: B2B, B2C, B2D), i have…
-
Call REST API with NAV 4.0
Hello, I plan to call a REST API in order to integrate data into NAVISION. I can't find anything for this version of NAV (4.0). Do you have any leads or advice to give me?
-
Run report without the request page
I want to run a report multiple times from a form. I know there is report.runmodal but then i can't set parameters from the form. can i skip the request page when the report is declared as a variable?