-
Invoice Surcharge
Is there a way without custom code to add a line to the Sales Order/Invoice for a surcharge which is a percentage of the sales line total based on the country the customer is located. For example if the customer is a US customer then the surcharge would not apply but would apply to all other customers. Any ideas? NAV2009…
-
Payment Discount
We have been using Payment Discount Excl VAT but now we need to use Incl VAT so I checked Adjust VAT Payment Disc on GL Setup But when I post the new payment I get this error 'You must specify Payment Disc. Debit Acc. in Customer Posting Group Code=SOL' It was specified but I removed it because in the help it says 'if…
-
Gst Calculation
Hi experts I want to calculate GST sales tax on certain customer for indian localization . Please guide what are the various setup i need to perform? Give the steps in details.
-
What is SDK
Hi Microsoft Dynamics NAV 5.0 SP1 SDK Can someone tell me what SDK stands for? Thanks Best Regards Javaid
-
Best hardware specifications for NAV Server
Hi everyone I would like to know the opinion of fellow NAV consultants on the specification for the NAV Server (NAV Service Tier) 1) We are planning to deploy a 32GB RAM with Xeon 2.66GHz Quad Core E5430. Does anyone use anything more powerful? 2) Is there any way to add another server to the configuration to speed it up…
-
Select Multiple serial No. and Insert into Item Tracking Lin
How to Select Multiple Lines of Entry summary and Insert Into item Tracking Lines Table . I have used the SetSelectionFilter and getting the records also but the lines are not Inserted In item tracking Lines. Thanks In Advance
-
Access External Webservice From Nav 2009 - OANDA
Hi All, Anybody who has written code for OANDA web service access. URL for current Nav Code to access OANDA Web service: http://dynamics495.rssing.com/browser.p ... t=1&item=5 Now that OANDA is changing the technology to API. Is there any code reference for the new technology. URL for OANDA new Technology:…
-
Different reading barcode at POS
Hi .. i got issue from my customer that user when scan barcode of item XXXXXXX it gives in receipt different reading for barcode YYYYYYY which is belong to different item, so different description and price printed on the receipt. the user scan again after few time, correct description is coming , i reviewed the item and…
-
SQL error "column does not allow nulls, Insert Fails"
Hi, We've added a couple of custom fields to Vendor Ledger Entry. Currently, there is no code to populate these fields (working on that in development). But the fields do exist in the table. I'm getting an error when a non-SUPER user tries to post. They get the big error window that says (among other things) "Cannot insert…
-
Problem with CU5054 when using officce 2013
Hello, I have a problem when trying to use CU5054 with Office 2013.It gives this error :Microsoft Dynamics NAV ClassicThis message is for C/AL programmers: The call to member OpenDataSource2000 failed. Microsoft Word returned the following message: The OpenDataSource2000 method or property is not available because this…
-
Date Format dd/MM/yyyy in ApplicationMangment
Greeting for the day. I need to know that Where I need to write code where I check If System Date Format is not dd/MM/yyyy format then Stop Navision. Then Display message that you need to set dd/MM/yyyy format date and Navision should not start.
-
Permission Error Dynamics NAV Upgrade 4 to 2009
Dear all, I am doing Navision 4 to NAV2009 upgrade. I have merged navision 4.0 objects using Navision Developer's Tool Kit. Now I am going to import merged objects to my prepared database. But I am getting some errors. This is the error. Your program license does not allow you to create the Job No. field in the Sales…
-
Check before Committed
Sir, I try to read(check) the uncommitted data through a custom function called "ChkDimValue" & I called this function under the table OnInsert() trigger. It works when I called this way: IF INSERT THEN ChkDimValue; But it does not work when I remove "IF INSERT THEN"... Line. What is the reason ? Please inform. Thanks in…
-
Job Queue - how kill unwanted sessions and refresh the job
Hi there, we are setting the NAS with the job queue. We found that the job queue seem unstable in NAV2009R2. a) Day 1, the service has stopped due to ODBC error (we dont know the reason). b) Day 2, we are force to start the service (restart server and start service as well) c) Day 3, the job does not get trigger (suppose…
-
Dimension Restrictions
Hi, We want to restrict posting to a set of dimensions. For example on GL account '100000' we want Dimension 'Area' restricted to dimension values '10..50'. Is there an addon out there that takes care of this? Ideally we can use same restriction in dimension combination tool. Instead of defining what is not allowed (eg.…
-
LS retail Data Director
Hi, We are recently implemented the LS retail in store for POS billing. I internet is not working then how we can manually copy sales data and bring it to ho for transation register report. How LS data director works for data flow from POS to HO?
-
Temporary Table for Reporting
Need to create a temporary table with data from two or three tables, create my own fields in the temp table and key for sorting. I have read about creating temp tables, but based on existing tables. Can someone point me in the right direction. Thanks
-
NAV date field data with three characters month (31-Dec-14)
Hi Friends, Is it possible in NAV to enter data in date field as '11-Dec-14' format? To avoid confusion among users about date format - 'dd-mm-yy' or 'mm-dd-yy' - is it possible in NAV enter date as 11-Dec-14? I tried both in Classic as well RTC - not accepting. Can anyone confirm this how NAV works? Thanks Murugan
-
Renumbering the posted Entries in a GL
Dear All, Is there a way in Navision that we can renumber the Posted entries. In other words, i have posted some entries that goes back in time and i want the number series of the posted entries to get renumbered so that the entreis will be chronologically in order with time and number. Is there any way of doing so. Thanks…
-
customer license information
Hi, I am started upgrading NAV 4.0 sp3 to NAV 2009 sp1. I want to know whether customer needs to upgrade his license file. or we can use same 4.0 license file in 2009 spl version. hope some one could help me on this. and pls share any upgradation estimation template. Thanks, Shyam Kumar N
-
Shortcut for Database?
Is there a way we can create a shortcut to open Database. There is a simple shortcut to open Company (CTRL + O). I guess once nav is open you can press ALT + F+ B + O to open the database dialog box. But is there an easier one?
-
Item Location table
Hello experts, Can you please help me in understanding what "Item Location" table is designed for in NAV 2009? Which functionality/reports use this table? I tried to search some information about this table, but didn't succeed. Thanks in advance!
-
Prepayments in 2009 KB2779183
Hi, Initial issue I have a client that uses prepayments and they had problems invoicing a sales order where the shipment was less than the prepayment quantity. I have applied several hotfixes but have had to make some further changes myself. I have installed KB2779183 and all the KBs it referred to. KB2779183 refers to…
-
Convert to Unicode a text description in report
Hello Experts, We use Mongolian cyrillic in NAV2009 R2 classic version and it can not support some cyrillic characters. But some entries are already imported with unsupported characters into G/L entries. this fields is Description of G/L entry. It is shown with unknown characters. /?з??лэлт etc.../. I just to see this…
-
WSHShell CMD open silently?
Hi Guys/Gals, I am looking to running a few scripts silently with CMD. I want CMD to run in the background. Currently it opens the black promot screen while its working. Is there a way to hide it? IF CONFIRM('Do you want to Query Service?') THEN BEGINIF ISCLEAR(wsh) THEN CREATE(wsh); wsh.Run('cmd.exe /c SC \\'+"Server…
-
Service module. Next Planned Service Date
Just wanted to let you know for those who use the Service module, there is a hotfix for a problem with the "Next Planned Service Date" on a service contract line. http://support.microsoft.com/kb/2765202 A customer of mine had this problem in NAV 6 so the hotfix for NAV 5 was not build into NAV 6. ](*,) I haven't used the…
-
Navision, Emailing report with parameter for request form
Hi, I have a report that shows a particular section via a checkbox (l_checkbox) in the report's request form. I want to convert this report to pdf and email it using this line runmodal(reportid, FALSE, TRUE, table) my question is, how do i pass a value to the checkbox in the requestform before runmodal is called, if the…
-
maximum 17 lines in sales invoice line
Hello friends I still work with export to txt sales invoices Now they have totally changed the format and export sales invoice must not have more than 17 lines in sales lines I thought of limiting when the bill is recorded from order, pressing F11, if more than 17 lines a warning message is displayed, otherwise the…
-
Sending SMS using HYPERLINK,How to hide the POPUP window ??
Dear ALL, I'm sending the SMS through NAV application with help of 'Hyperlink', hyperlink='http://.......?userid=;pass=;sendto=;etc....' Everything is fine, but i don't want to show the POPUP window(internet explore). want to make silence. because this will be setting in NAV background process.. Plz Suggest me... Thanks &…
-
Possible? Linking Outlook email threads to NAV sales orders
Hello all, I hope somebody can point me in the right direction. Situation: 90% of our communication with customers on sales orders is done via email. Email at our office is Outlook 2010 and 2013. So a lot of info on a Sales Order is stored in individual Outlook users' mailbox. Information such as the original email-order…