-
NAV 2013 R2 Outlook Synchronization
Hi, I am trying the Outlook Synchronization in Microsoft Dynamics NAV 2013 R2 for our client. I have setup NAV Outlook Entities, Users and Salesperson. I have problem when i click on test connection in Outlook. I have this error "The Connection to Microsoft Dynamics Failed. The program returned the following error:…
-
Average Cost Period must not be in Accounting Period Start
We are in the process of upgrading a NAV 40SP3 installation to NAV 2009 R2. We have actually modified all objects on a fresh 2009 R2 W1 DB. did a tech upgrade on old db by opening with new .EXE. Imported Upgrade4002009.1.fob from Upgrade toolkit. Ran "transfer data "and took a NAV backup. and we restored this backup. all…
-
Inventory Valuation Process
Hi Everyone, Can anyone please share the process of Inventory Valuation that needs to be done at the end of the financial year, in NAV 2009 SP1? Thanks in advance Vivek
-
Production Order Material Variance Report
Good day! Is there a report that will show the standard material qty vs the actual qty used in a production order? This will help determine the source of material variance in terms of quantity. We are using NAV2009 SP1. Thank you
-
Retrieving data from table
Hello to all, First of all, I'm a newbie) I have some problem, here it is: For example I have a table and a card form, based on that table. Table has some Doc No. Field (key), with records 1,2,3... While I'm looking through those records on my form, I want to retrieve field value of Doc No. by pressing some button, and…
-
Compressed Item Ledger Entries & 3.7-to-2009 Conversion.
Hello, We are in the process of making the move from 3.7 to 2013, and I was hoping that I could get any feedback on the process from anyone that has made a similar move. Personally, I have never been a part of this sort of upgrade/conversion. However, my supervisor has experience with both installing Navision here back in…
-
Using Document Type blank in General Journal
Hi all I'm working on a integration between SAP and NAV and one of the things we bring in from SAP are Bank Statements. We post them through Web service and they pass through General Journal. As SAP guys have trouble matching the rules we have when checking postive/negative amounts in gen. journal, we thought of suggesting…
-
E-mail through NAV5: needs clarification
Hello all, I am a NAV developer. My client uses NAV5. I am working on a project to send e-mail through NAV. For sending e-mail I use codeunit 400. E-mail are send with the help of NAS. I have several questions which are not clear for me, so any help will be appreciated! 1. I added a timer to the standard NAV codeunit…
-
Rounding in NAV
Hi All, I'm working on a bit of code outside of NAV, which uses some price, discount and VAT data from NAV. And, now i'm looking at some minor rounding differences. Can anyone explain me how NAV does it's rounding? Only at the end of a calculation? Half way, before multiplying with the quantity? Or is there more to know…
-
This message is for C/AL programmers
P.S. This message copied from here http://community.dynamics.com/nav/f/34/t/44955.aspx In my case testers can't repeat error. Error message sometimes raise at client. Please give any idea, where to looking the problem.
-
Relate purchase header to sales line (Simple!)
Howdy, I'm quite new to Navision, and I'd like to know how to find the sales line(s) that's related to the selected purchase header. I'm pretty sure you can do this with some simple SetRanges, but I can't see the trail. I have found a subform that does this, which uses the following SetTableView: SORTING(Document…
-
Report printing issue
Hi need your advise urgently. Our printer which was used to print cheques was functioning properly before but suddenly it starts printing blank cheque when we launch cheque printing from Navision 2009 R2 - SQL Server option. When we launch text files or other things apart from reports from Navision, the printer functions…
-
SQL Mdf File is increasing rapidly.
Hi, We are facing issue with SQL DB size which is increasing very rapidly ( of course the customer do have multiple stores /locations and day today transactions/documents are huge )... with in 5 years of inception, the DB size has grown more than 300 GB ( MDF file only ). we are taking care of the Log file by shrinking on…
-
VersionCheck in 2013?
I'm slogging through the C/SIDE Solution Development book. One of the interesting "learning opportunities" I have while doing so is this: my book is for 2009, but I'm using 2013 for my "sandbox", so there are more than a few discrepancies between the map and the terrain, as I'm sure you can imagine. One such discrepancy…
-
Creation of New Nav-LS DataBase
Hi, I have installed MS Dynamics Nav 2009 SP1 Classic and Sql server 2008 with all licences.I have created a Database and Company as well, but I could not see all the tables,code units,Reports,dataports,forms etc in Object designer. I want to know what am I missing and from where should I get the Standard tables,code…
-
Reading xml from variable
I am using nav 2009 R2 US version I have taken one text variable containing xml data Strng := '<ERPItemCode><Value>Itm1</Value></ERPItemCode>'+'<ERPItemVariantCode><Value>BLABLU</Value></ERPItemVariantCode> ' ; I want to get ERPItemCode , So for that below code is used IF ISCLEAR(xmldomDoc) THEN CREATE(xmldomDoc);…
-
Correct Due Date
Hi Everybody, Please If someone can help me. So, On Vendor Card, I have all Payment Terms Code Blank for all records. So Now I want to insert the Payment Terms Code, but i have to correct the due date for all old documents. (I don't know what i must correct exactly) Someone can help me please ? Thanks a lot.
-
There is no value Entry within the filter.
I am using NAV 2009 SP1 IN Version. When we are running adjust cost Item Entries batch job, we are getting following error : There is no Value Entry within the filter. Filters: Item Ledger Entry No.: , Invoiced Quantity: <>0 Please do let me know how can I resolve this issue.
-
NAS + NAV 5.0 error
Ahoy! i have a problem: NAS displays err "F: ConnectServerAndOpenDatabase Autom.server has stopped or timeout occured", in DB-Information in current sessions "NAS user ID" is present, all settings as on other PC, where NAS working perfectly (all settings i checked out more times), i tried set NAS-service to log-in under my…
-
Link with production orders
Hi All, Require some expert advice on my below requirement My client is an automobile Brake Pad manufacturer and have an FG Item called DAF and its low level assembly is set in system as: DAF --> CA --> BA --> PCA --> COM. Which means when a customer order is received for DAF, all its sub-assemblies should also to be…
-
Source Type must not be 0 in Reservation Entry Entry No.='0'
Very simple, but could not find it anywhere on the net, If you get the error Source Type must not be 0 in Reservation Entry Entry No.='0', Positive='No' when trying to ship then check the reservation entry table for a line with source type = 0 Delete the tracking pair.
-
Upgrade to NAV2009
Hi, I am trying to upgrade from v4 to 2009 I got partner license I get this message when I import objects this field (130) is standard in cronus 2009 database Your program license does not allow you to create the Prepayment No. field in the Sales Header table. Contact your system administrator to update your program…
-
TAB doesn't work in Navision Report
Hi All, is this limitation of Navision? any workaround to solve this issue? I try this : chTAB is char datatype ChTAB := 9; CommonText = 'ABC' + format(chTAB) + 'BCD' I put the textbox in report with sourceExp = CommonText. It shows ABCBCD. Try using STRSUBSSTNO('%1%2%3','ABC',chTAB,'BCD') also doesn't work. Please…
-
G/L Entry Table Entry Number Jumped
Hi, Our G/L Entry table Entry No. suddenly jumped from 9 Million to 1000 Million when an user posted a Credit Memo with only 2 lines. We are not able to see any reason. We are using NAV 5.0 SP1, sql server 2012. Can you please suggest how this can happen? Thanks FH
-
Citrix colours Navision 2009
Hi Dynamics 2009 classic client on Citrix Terminal Servers Windows 2008 R2 I have a strange situation where Navision clients in Citrix are showing different clients. We've tried deleting zup files with no joy, it seems to force 16 bit colours on the terminal servers for some users and the better quality 32 bit (or better)…
-
Automatic Consumption via Output journal (Routing link code)
Hi Guys, How do I automatically consume from an output journal? I have set up a BOM where all components have Routing Link Code=100. The third operation step on my routing also has this routing link code (100). My expectation was that when I went to the Output Journal, exploded the routing to reveal all steps, and put…
-
Find File in folder - problem when using it twice
Hi, I want to find files from a specific directory from Navision. I have placed some code in table 38 (Purchase Header), which is called from Form 50 (Purchase Order). Following code is in table 38, where folfile is FILE variable: CLEAR(folfile); folfile.SETRANGE(folfile.Path,PurchaseSetup."Documentscanning Path");…
-
Choose Company in Navision web service 2009 R2
Hello Guys Since few days ago, i am getting a really strange error. I am using Navision 2009 R2. I have use the example from this link http://blogs.msdn.com/b/nav_developer/archive/2009/07/08/how-to-set-dynamically-the-key-and-sort-order-for-the-pages-using-nav-2009-web-services-feature.aspx to implement a sort order for…
-
How to lookup virtual table without create new form
Dear all, I believe someone will notice my topic is similar to the topic as below link. http://www.mibuso.com/forum/viewtopic.php?f=23&t=6720&start=0 Solution is work fine but so sad is not close enough because I not allow to create new form. My situation is: I have to insert new field to indicate the domain users in any…
-
Total Dim Value in a Global Dim Filter on Classic Report
This question applies to classic reports only in NAV version 2009 R2. I was looking for confirmation that specifying a Total Dimension Type Dimension Value in a Global Dimension Filter on the request form of a report does not work. My testing suggests this to be the case but was wondering (hoping) that I am missing…