-
No WareHousing and Location is blank but still Shipment is required?
Hi, We are using NAV 2009. We are not using Warehousing module. There is no Warehousing Setup exists apart from Number Series. But when we covert a quote to an order (Type G/L Account is used in the Quote Line), we have to do Ship & Invoice when order is posted. How to basically turn that off? The location in order line is…
-
Import Item Journal Error !!!!
Dear Everybody, I have a problem when i import item on excel in Config. Package and I want to Post in Item Journal card I got message error Please see below. i checked data in excel already have dimension all rows and Default Dimension already have Dimension also Please help me. i need to resolve this issue. Thanks
-
Inventory FlowField & Item Ledger Entry Table
Dear All, In one of my clients, I have seen a Custom Form in Navision (2009 R2) Database, where a SubForm editable Field contains Inventory/Stock Quantity of Items wrongly, because the CalcFormula is applied on Other Table instead of Item Ledger Entry Table(ILE). After seeing this I've made the required changes on the…
-
Email invoices from Nav - not using E Ship
Nav 2009 r2, no need to buy E Ship module as we would not use it. However; looking to email pdf's of invoices, credit memo's and statements right from Nav. Suggestions for a bolt on app to enable us to accomplish this? What are others using?
-
Dynamics NAV 2009 R2 Move next Line when Enter (Page List)
Is there a way to move to next record in a page list when pressing Enter Key ? Usually the regular behavior is to move to next field. The use wants to move to next field when pressing TAB (by design it's this way) and to next Line when pressing Enter. Any idea
-
If the posted purchase order has wrongly deleted by client..
Hi All, Please guide me, if the posted purchase order has wrongly deleted by client.. but the transaction is in the ledger.... how can we track these entries related to this purchase order... and how to post payment transaction without purchase order? what are the process require to do while year end? Thanks...
-
"Adjust Cost - Item Entries" not ran for 3 Years
Hello All ; I've recently been recruited in a Company working with Microsoft Dynamics NAV 2009 R2 (Classic only, no RTC) and i found thant "Adjust Cost - Item Entries" hasn't been ran for almost 3 Years. It's been about 2 Mounths thant I'm running the Batch Every Night & Week-end but it seems to be Endless because of the…
-
LS-Retail (Retail Item Card Barcodes)
Hello, I need to block a manually created barcode in Retail item card table no(99001451), the field is not editable maybe for a reason or another way to manage the block unblock, would you please help me in this issue? Thanks
-
cannot find correct 'host', using database server 2009 classic no sql
But I was so close....what do I do now?
-
this indexing 51 in the array is outside of the permited range
Hi experts!! This message appears when I run the test report to close the inventory period, and the report is blank so I can not know which products are in negative or open. when I activate the debugger, the code stops in the report 1004 AddError (Text) ErrorCounter: = ErrorCounter + 1; ErrorText [ErrorCounter]: = Text;…
-
Where can I find a CRM manual for Navision 5.01?
Hello all, I need a CRM manual or documentation for Navision 5.01 in english. Does anybody have an idea where I can find one? I am also okay to pay for it. Best regards
-
Windows 10 printerselection
NAV2009 classic - have used the classic method used by many - in codeunit having a printerselection by name and when job is done then restore the printer. IN Windows 10 - the selected printer (spec. PDF printer) then becomes the default printer and stays there until you manually alter it in the control panel. Testing with…
-
Find who renames a form
Hi to all, I'd like to know which user rename a form in Dynamics Nav 2009, is there any table or log to inspect to find which user perform the rename operation? Thank you in advance for your help. Best regards Fabrizio
-
C/Front vs direct SQL Server access
Hello, I need to gather some data from Nav 5 database using C# and since all the customers use SQL Server anyway I'm wondering is there a difference between using C/Front and SQL Server directly. Skipping C/Front obviously I loose possibility to access native database but using SQL Server directly I get all advantages of…
-
How to see the Page ID in NAV 2013
Hi All, I have opened the page in NAV 2013. So now as we see in form ctrl + f2 then we can see the form ID. Like that how to see the page ID in NAV 2013. If anyone knows how to see the page ID. Kindly let me know. Thanks in advance. Regards, chandru.
-
hidden menu options
In NAV I go to Administration then Application Setup then Company Setup. As a super user I can see/click the Data Migration optoin but as a regular user I cannot even see the option for data migration. Is there a reason why that option is hidden from regular users? How do I make it not hidden?
-
Microsoft Dynamics NAV 2009 - Error
I am using Microsoft Dynamics NAV 2009. When I tried to open the posted bank reconciliation, it shows "Microsoft.Dynamcis.Nav.client has stopped working. A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available". It doesn't popup solution or other…
-
Form.run & Form.runmodal i codeunit
Hi Have a special codeunit with update procedures (posting) and then I am not allowed to have a FORM.RUNMODAL unless I use a COMMIT before calling the Form. The Form is for users to add additional info in mail to customer before sending with attached document. Trouble: If user regret t order the mail - it is already too…
-
Sales unit of measure + warehouse pick
We are using WMS functionality and we are struggling with our unit of measure. We buy a certain product in a box, we would like to sell it in a box, but when used in a production-BOM we are using Pieces. We have setup our location with: Base unit of measure = Pcs Purch Unit of measure = Box Sales Unit of Measure = Box…
-
How can i validate a field from a codeunit?
Hi everybody, Im having a problem validating a field from a table from a codeunit: The code is serlines.SETFILTER(Document no, 'ps-60006'); if serlines.FINDFIRST THEN BEGIN Serlines.VALIDATE(Serlines.Shortcut dimension 1 code, 'SAT'); Serlines.MODIFY; END; Anyone can see the problem?, im begginer and i'm going crazy...…
-
Job Planning and Accrued Cost
In NAV 2009 and in Job Module I have a job for which I have created Job planning line as sales invoice of type G/L account. Unit Price is 80 and Unit Cost is 15 (Line type is 'Both Schedule and Contract') 15 is recorded as Accrued Cost. Now how can I link the purchase invoice that would come in later to clear the accrued…
-
Navision 3.70A in a Windows 2012 AD Domain
We are running a heavily-customised version of Navision 3.70A SQL Server Edition (SQL Server 2000 on Windows Server 2003 Std). We are not quite ready to move to a new version as of yet, and I want to update the domain controller from 2003 SP2 to 2012 R2. Anyone running Navision 3.70A as a legacy application in a 2012…
-
Work Date Security
Hello, How can i guarantee that my users don't change the work date of the system? For me to be sure that the date in all documents and entries are correct i must limit the access to the work date. Or just by saying in the Number Series configuration that i must have a "Date Order" is enough?! With only this I have…
-
POWER BI and Nav2009 SP1 Classic Client
Hi I'm running Nav2009 SP1 Classic Client and wanted to connect with POWER BI as said in https://powerbi.microsoft.com/en-us/documentation/powerbi-content-pack-microsoft-dynamics-nav/ I found this article https://msdn.microsoft.com/en-us/library/dd355398.aspx but think it's only suitable for role tailored client Any…
-
'XXXXXXXX' is not a valid date. Error when generating a report in NAV.
Hi Guys, Got this problem when generating a report from NAV 2009 RTC. (Please see attached file). Report is actually in excel, NAV only fill's in cells of that excel file. Said report is a localized functionality of NAV 2009RTC. Error only comes when the report is being generated from NAV RTC, however executing the same in…
-
Upgrading error from Nav 2009 R2 to Nav 2015
Hi, I'm working on an internal project of upgrading our Nav 2009 R2 to Nav 2015 by following this link: https://blogs.msdn.microsoft.com/nav/2015/02/23/upgrading-from-microsoft-dynamics-nav-2009-r2-or-microsoft-dynamics-nav-2009-sp1-to-microsoft-dynamics-nav-2015/ However, I sort of stuck at "Task 8: Run the Data Upgrade…
-
Enclosing a single quote within single quotes
I have an issue, where I need to put a single quote ' into C/AL, but not have it read as a close/start of a string. I am exporting a report to excel with the excel buffer. All I need to do is enter a formula of a cell to reference another one. the problem is that the other cell I need to reference is on another sheet. So…
-
How do I save the xmlfile from inside the XMLPort?
I have a scenario where a codeunit has been published, and all that the codeunit is doing is calling an xmlport that creates a purchase order based on the xml file being sent. Works like a charm and everybody is happy. However, every now and again there are strange data errors in the order being created; but I see nothing…
-
XMLPort 2009 - how to insert Sales Line Description lines from xml file lines
How do I import each of these fields as individual Sales Lines for Description only? The Sales Invoice import file has a few lines at the bottom for messages, text etc attached to the Sales Invoice. These do not have the normal nested layout for multiple fields, but have the Description content in the node. The file is…
-
Production order Start time and End time is same when I run Refresh option
Dear Friends, When my production order is run for REFRESH, the starting time and ending time showing same in Schedule tab. Please help.