-
Editable No in table and Yes on Form unexpected behaviour
Hi to all, can someone explain me the behavior of flag Editable in table and form ? I have configured a table with Editable = No on a field and I have Editable = Yes on a Form field that point to the same field. I suppose that the field wasn't editable but I was able to save the new value. If I set Editable = No on a table…
-
NAV Client and Service Tier Crash using Events - system.reflection.ambiguousmatchexception
Hi, I wanted to use an event from a page e.g. OnOpenPage Of course, there is a standard one built into NAV but it only returns the “Rec” variable and I wanted to set some global variable in the base code which I can’t pass as a parameter with the in-built published event (it would be useful if you could get sight of the…
-
Cannot Rename a Record
We are using NAV 2009 SP1. We have a blank customer and we have transactions too. Now we want to rename a record. There is no code behind RENAME trigger except "Last Modified Date". I am getting an error. You cannot rename a record because the old value for the following field is ''. Field: No. Table:Customer How do we…
-
Web Service communication and Events
Hi All, Currently, I'm using Navision 2009 Classic and would like to integrated with hardware which is only provide Web Service (SOAP via HTTP) to do integration. How to do communication 2 ways between Navision and the hardware via Web Service? How to create events in Navision to receive event from the Web Service?
-
NAV 2009 Crashes while trying to export the Blob Field
Hi Experts, we are trying to export the table data using xmlport port. In the table we have Blob Field, we are using Customer.CALCFIELDS("NEW BLOB Field"); . The moment Cursor reaches this code, NAV Crashes and error comes as shown below (attached image). NAV VERSION is 'NL Dynamics NAV 6.0 R2' 2009 Build - '32012' DB is…
-
several internal error - NAV 2009 R2 classic
I have problem - customer has branch connected via some VPN and terminal services. On one workstation in this branch is sometimes displayed error "Several internal error" without any closer informations. After clicking OK, client crashes and ZUP file is damaged. This problem occurs only on one workstation; on other…
-
User Wise Kill IDLE Session
Hi All, I want to kill IDLE session User wise. Can i able to do that in NAV 2015.? Please advise.
-
Calculation of Suggest Item charge assignment on amount
Hi all, I want to know how Navision calculating values while booking freight entry for purchase invoice through Item charge Assignment and i am using below steps :- Navison Main Menu>>Purchase>>Invoices : then created new freight document with qty 1 & amt 9000. then click on Line button>>Item charge…
-
Question about TableRelation and OnLookup trigger
Dear all, I need an advice on how to modify an existing behavior, in a dynamics nav 2009 system we have a table with the following code in TableRelation field IF (Bank Payment Type=CONST(Bank Transfer)) "Bank Account" ELSE IF (Bank Payment Type=CONST(Computer Check)) "Bank Account" ELSE IF (Bank Payment Type=CONST(Manual…
-
Adjust Exchange Rate - Questions
1) Does Adjust Exchange Rate (AER) only adjusts open transactions? Or does it work on closed entries. I did some research and I got mixed answers: The batch job processes all open customer ledger entries and vendor ledger entries. (https://msdn.microsoft.com/en-us/library/hh167262(v=nav.70).aspx) I also found a knowledge…
-
New users to create to replicate
Dear Experts, i would also like to know that if i have new users for sales and their names are not there in the system. Is there any way that i could create those user names in server and then i replicate them to all the outlets???? IF possible Kindly let me know how to do it.what are the tables that i have to replicate to…
-
Further version of Microsoft.Navision.Mail.dll cannot be registered again?
Hello, currently I have the following problem: I have implemented a hotfix that concerns the table 409, the form 409 and the CU 400. Additionally, I have replaced the Microsoft.Navision.Mail.dll by a newer version and registered this new version with regasm (regsvr32 doesn't work completely). It has unfortunately been…
-
New field not saving to database.
I created a new field in Service Header (ID: 5900). This field has a type of Option. When I add the field to the Service Order Page (ID 5900) I can select a value and click ok and the value persists. However, when I add the Field from Service Header to the Service Item Worksheet Page (ID 5906), the selected value will not…
-
Report Data Source specifying field names
This might be a very basic one but I'm not getting the difference when you specify field names with Record prefixes and without prefixes under a data item. For example I select Data Item as Customer and in the next line I select Column and add Customer."No" instead of just "No" in Data Source Column. Why specifying this…
-
Store File into BLOB Field
Hi, What is the code to take file from disk (i.e. using Common Dialog Codeunit functionality) and store it in a field of Type BLOB? Thanks for any help.
-
Get Location with maximum inventory
Hi all, I am trying to get the location with the maximum inventory... how can I do this please? Currently, an item can have stock in more than one location. Till now I've tried to do something using the Item ledger entries but got stuck at how to compute and get the location with the maximum amount of stock in it. Any…
-
Getting errror message when posting guarantee service orders in Nav2016
In Nav 2016 it seems that System-created entry is not filled in on posting service orders. This gives error Messages when amount = 0. I find Change from 2013 in codunit 5987 - function PostGenJnlLineBalancing. Setting entry to System-Created entry is removed in the last versjone - seems to be removed after 2013 R2. Anybody…
-
no affect in sales invoice line when make return order
if I make return order to specified document it only make one line with negative amount for these document in cust ledger entry table but no affect made in sales invoice line table are these true when i make return order sales Marketing-Order Processing-return orders-write the data of these document then post -receive and…
-
How to export All objects without system tables?
Hi can anybody explain to me how to export objects without system tables?
-
Error when renaming Company
Hello I am trying to rename a company and I am facing the below error. A value in the filter 'CompanyName' in the No. field in the default dimension table is too long for the field type. Type: Code20 Nav Version: NAV 2009 SP1 Can anyone please advise how to proceed.
-
Conversion from base unit to purchase unit and vice a versa
Hi, One of our client maintaining inventory in numbers and purchase orders issued in kgs (or meters) (there is two unit of measures involved ie Base unit of Measurement & Purchase unit of Measurement). For example: Item X 1 NUMBER = 1.5 KG and vendor will give the price in kgs. If there is 2 number then kg will be 3.0 kg…
-
Setting filter range from record
Is it possible to set filter from a record with several entries? Then I would filter Table A, so that I have the ones I need. TableA.SETFILTER("Location", "Mibuso"); Then something like this:? TableB.SETFILTER("Table A No.", TableA."No."); So that I end up with Cheers /left
-
Please share link for download of TFS353595and HF377555 hotfix. I am unable to find them.
Please share link for download of TFS353595and HF377555 hotfix. I am unable to find them.
-
Upgrading Sage 1000 to nav 2009 R2
hi Evry body i need your help am going to upgradeing my sage1000 database to dynamics nav 2009R2 but i don't work with the sage erp so can you give me your openion and how can do that thank you
-
How to open NAV 2009 report in Visual Studio 2012 designer.
How to open NAV 2009 report in Visual Studio 2012 designer. It is giving error like 'Compatible version of Visual studio is not available. I have VS 2012 and also 2015 on another system. Will you advice please.. Warm Regards
-
How to delete "out of license" tables
Hi! We're the new Solution Center for a customer whos old SC went out of business. One of our customers first requests is/was to upgrade to 2016 (currently 2009 R2) and switch to our business solution. Which requires to remove the old - unused - Code & Objects of the former Solution Center. It was decided that we want to…
-
NAV 2009 NA build 27808
Dear all, Does anyone know where can I download demo database for NAV 2009 NA localization build 27808? Thank You
-
Already Reverse Transaction !!!!
Hi Everybody, I have problem when i reverse transaction please see below. I checked in table with fields Reversed, Reversed by Entry No & Reversed Entry No. from General Ledger Entries. They are blank. and I follow to this forum http://forum.mibuso.com/discussion/20506/you-cannot-reverse-the-transaction but not resolve…
-
Webservice works only after local request
Hi All, I have a strange Web Service issue. The functionality is kept very simple. Send a text and return the uppercase value of it. The webservice in installed on a separate server (ServerWS). Created a small C# program on my local machine that sends text and shows the result. I can get that working but……. After the…
-
Check if folder exists in 2015
Hey guys Is there a easy way to check if a folder exists? I have searched for it and tried the EXISTS('Path'\nul) and this always return No for me. Cheers /left