-
you can not make any changes in the database until a transaction has been started
I am getting 'you can not make any changes in the database until a transaction has been started' this error when I want to visit the statistic. Can anyone tell me how to resolve this error.
-
Running a Worksheet page with parameter
Hi everyone, is it possible to run Worksheet page (for example Planning Worksheet) with parameter of Journal Batch Name? For example I don't wanna run this worksheet page with DEFAULT Journal Batch Name, but I wanna run my own created Worksheet. Thanks in advance.
-
1099 Magnetic Media with Section K
I am wondering if there are any updated reports or other objects for 1099 reporting in NAV (U.S. of course)? Is there an updated report that includes section K (State Totals) that is required by the IRS to be in the file? Any input on this would be much appreciated.
-
Waldopad Install Error
Hi guys, Quick question:- We have a client that needs the ability to store large amount of texts in a table. So WaldoPad seems to be a perfect fit. I am just having issues installing it on their server. Client Setup: 1 NAV Server 10 additional server that connect to the nav server. These 10 servers are used to do load…
-
Help with a serious problem NAV crashes
Okays, I got the xml import done and after I import the purchase invoices in, they dont seems to work properly. If I delete the line 0 or delete the whole invoice it crashes Navision. it just simply shuts down without warning.. I tryed to make normal purch invoice on the form and then delete it, it does not crash. It only…
-
Dev Client hangs when compiling
When compiling / saving / importing a user defined table my Dev client suddenly started to hang. I see several sessions then in the session manager. I use NAV 2013 Rollup9. The same table etc. doesn't make this trouble on another Service Tier at the same machine. Anny ideas beside technical update?
-
1099 Magnetic Media
I am wondering if there are any updated reports or other objects for 1099 reporting in NAV since 5.1 for the 5.X platform (U.S. of course)? The IRS changed to where it no longer accepts magnetic media, but it looks like the magnetic media report in NAV can be output and then saved as .txt to meet the demand from the IRS…
-
How can I register Microsoft.Dynamics.NAV.MX.dll on NAV 2009 R2 to create QR Data?
Hello Developers, I have QR Data and want to convert it to QR blob on NAV 2009 R2. I installed MicrosoftDynamicsNav2009SP1MXSignatureProvider.msi but I cant see it on NAV assembley list. How can I register on NAV 2009 R2? Is there left any step to register it? Regards, Undy
-
Error length of database is different from the length recorded
I am getting the following error: length of database is different from the length recorded by the operating system Navision.... I have tried everything and we do not have a backup for the last few weeks. I know shame on us. Is there any way at all to open the file even if we lose some of the data?
-
Security Filter
Hi, NAV2009R2 35179 I have set up Security Filters Sales Prices on a Role, so users only see sales prices applicable to their own store. The users also have other roles, where the roles have indirect read/modify or just read. Sometimes the Security Filter Works other times it doesn't. The database is on SQL with standard…
-
Error log
Hello! I have been asked to modify a function displaying errors from a dataport. When the dataport a messege is displayed showing the items with errors not imported. The function uses a Text-variable with the lenght 255 and if there are more errors than the variable can hold they don´t get displayed. Now I´m asked to make…
-
Voiding a check
How can I void a check when a discount was taken against the original invoice?
-
urgent probleme unapply scriptures
Hello my friends I 'm a block from Weeks in an error message in microsoft dynamics nav 2009 r2 then the message is as follows is a 2014 invoice is another in 2015, the accountant posted Scriptures normal but when would unapply the system will display a message ("the latest Transaction No,must be an application in vendor…
-
(Manufacturing and inventory&costing )
hello evry budy can help your openion it is important for me so my probleme in nav 5.0 with the model (Manufacturing and inventory&costing ), I need to understand the process of calculating the cost to the system level is applied to the item file. and the corctly source code of adjust cost item ,daily thank you
-
At some point SMTP stopped being reliable
2009 SP1. I'm sending emails during the night from NAS with SMTP codeunit. Since July/Aug it stopped being reliable. 80% of the cases it works, 20% of the cases I get an SMTP error message, transport failed to connect to server (not an authentication issue since the same auth usually works) or a the automation variable has…
-
Capacity U of M
Hi There, In our legacy ERP, we use seconds, minutes, and hours on our routings. In NAV, there is not option for seconds. Is there any out of the box way to use seconds on routings, or will we have to use a conversion factor when uploading our routings? Thanks, Steve
-
Question about updating a record in ProcessOnlyReport
Hi to all, I'm writing a ProcessOnlyReport, in OnAfterGetRecord I want to update a value adding a trailing A character to a record in a field that is the primary key. If I use the MODIFY statement I got an error because I cannot modify the primary key of the record. Looking at forum it seems that I have to delete the…
-
2009 R2 : SMTP Any combination of witchery to add Port Number and Secure Connection to this version?
I have someone who needs to send SMTP Mail through Office365 in 2009 R2 Classic. I have found some information around the internet that claims that this was added as a Hotfix around January, 2011. But I can't find out if that covers both the Port Number AND the "Secure Connection" (TLS) enhancement, or not. Edit: WIll…
-
Check report printed with different bottom margins
Hi, Has anyone encountered such problem? User A prints same check from her workstation and from remote-desktop session to the same printer from the same environment. The check printed from Remote desktop environment prints it all good. The margins match with the report layout. However, the check printed from the…
-
Job Queue Entry not working after applying hotfix (Microsoft.Navision.Mail.dll)
We are using NAV 5 SP1 with a technical upgrade to NAV2009R2. We have a codeunit which is generating a report and sending this as attachment through SMTP to some users. This codeunit is called though a NAS. Until yesterday this worked great. Today we have applied a hotfix which replaced Microsoft.Navision.Mail.dll so we…
-
Processing Only report with initial filters
Hi to all, I'm trying to create a Processing Only report to update the description of several records in a single command. I need to allow the user to specify a filter from interface to select this values and I've seen that the Process only report seems to fit well. Only one question, which trigger should I use to apply…
-
QR Code Files
I need to print a QR barcode on packing label. Microsoft has setup this for Mexico's localized version. The blog below points to required objects and install files, but the Customer Source links are broken: http://blogs.msdn.com/b/nav/archive/201 ... s-nav.aspx Has anyone setup these Qr codes functionality? Does anyone…
-
Question about OR condition on RunFormLink property
Hi to all, I need a little help to find, if possible, how to configure a RunFormLink property to use 2 conditions in OR. I've tried to define both condition using the wizard and the default operator seems to be AND Is it possible to specify an OR operator in this property. I need to create a button in a Form to open…
-
NAV2015/2016 classic client [dev] user privileges
Hello, i would like to ask if you know if there is any way and how to set permissions for user who should get access to the client and view the objects but can't modify them. many thanks
-
Role to create campaign card
HI, Can anyone please share the role needed to create a new campaign card in NAV 09SP1.?
-
SETSELECTIONFILTER for table sum?
Hi, i like to add a small code to a Form. Goal: the user select 1 to ? lines in a table and under the table i have a sum for this selection. OnAfterGetCurrRecord: CurrForm.SETSELECTIONFILTER(TerminBauteil2); dickesum := 0; IF TerminBauteil2.FINDSET THEN REPEAT dickesum += TerminBauteil2."Dicke (mm)"; UNTIL…
-
Trigger that gets also called by simple modify
Hello. I'm using NAV in a three company setup and want to sync table data to my other companies. Therefore I've created a simple CU that inserts/updates preselected tables in the other company. I want to call this method everytime when a record in the company was inserted or modified. Therefore I rely on the OnInsert and…
-
extract the minimum and maximum date of a date range
Hi experts, Is there a function that returns me the deadline for a range of dates and minimum? I have this range 01/01 / 2015..31 / 12/2015 (Spanish format) and need the sum of the movements 01/01/2015 and, apart but in the same report, the sum of the movements 31/12/2015 (FA ledger entry) thanks!!
-
Item revaluation => and now NAV puts NEW COGS on OLD Invoices :(
Hello, I've got that problem that cannot solve by myself :( NAV put the NEW COGS(2016) on Invoices from 2015! (on items with CostingMethod=Standard, that were revaluated) Here is what was done in sequence: 1. In december 2015 sales department posted some shipments, (StandardCosted-items were there) 2. On 04.01.2016 i have…
-
Strange behavior on a form
Hi to all, I need a little help to understand a strange (for me that I'm a total beginner :-) ) behavior in Navision 2009. I have a form that has several lookup fields that opens a list of child record to select one. The strange behavior for me is that when I click on the upper arrow the lookup correctly opens but when I…