-
Export to excel list part page
Can I add option "export to excel" to pages that were defined as list part pages? And how?
-
Bank Reconciliation - Foreign Currency
Hi All, I have been trying to carry out a bank reconciliation and when matching the entries I've come across one particular entry (payment) that was posted in foreign currency. The posting was done correctly i.e. Amount in USD is 10 while in LCY is 5.58. (Base currency of the company is EURO and currency in Bank Account…
-
EPCIS solutions for NAV?
We are thinking about implementing serial number tracking on the whole chain from our manufacturers to the customers to aftersales. But this is not something you do inside Navision, primarily because it is not about we ourselves scanning bar codes, but about our various partners uploading these data to our servers:…
-
NAV 2015 - Editing Super user permissions
Hi, We created new role SUPER2 by copying it from default profile SUPER. We try to edit SUPER2 -user permission because customer wants to use that role but that user profile cannot have access to edit vendors and vendor Bank Accounts. We added all Table Data objects for that profile and also all permission rights for those…
-
COMHttpRequest.dll need TLS 1.1 or 1.2 navision 2009 R2 classic client
We are using COMHttpRequest.dll ( written by Nuno Maia) to send XML requests from navision to UPS for price request. UPS is upgrading their servers and they will accept only requests send with TLS 1.1 or 1.2 protocol from 01-01-2018. At the moment we receive intermittent errors from UPS when we send our requests but this…
-
Factbox collapsed by default?
Hi all, Have a factbox that's visible in the RTC. What I want is for it to be collapsed by default so the user had to lick to expand and see the content. This is purely because it's an image that needn't be visible unless desired.
-
Global Search lost focus issue (BUG) [nav 2017 web]
We have a new issue, since the update of Opera (v49). The click on magnifier doesnt focus and we cant type any text in it... impossible to search something. This issue was existing on Google chrome; firefox was poor in JS performance we plan to choose Opera browser (fast an reliable). Does anyone has same bug, does anyone…
-
Manufacturing Planning: Safety Stock
Hi, I have a recurrent issue while planning with Safety Stock in an item. The story is an item which is replenished by Production Order, Reorder Policy Lot by Lot. It has a Safety Stock of 10, and Inventory right now is 0. If I plan this item, I will get an emergency Production order for 10 which is right. Lets say I…
-
Can not Get Response from Web Service
I send request to Web service from this code. Why I can not GET response from Web service ? What's wrong ? OnRun() CreateXML; InvokeNavWS; LOCAL InvokeNavWS() CLEAR(xmlhttp); CLEAR(xmldoc); CLEAR(xmlnode); CLEAR(xmlnodelist); CLEAR(xmlattributes); result := FALSE; // Create XML Document xmldoc :=xmldoc.XmlDocument;…
-
How to recover Data in Extension in Navision
I have created an extension and publish it. I have also installed the extension. After installing, i have enter few data in the table and then uninstall the extension. After uninstall, I have found that the field which is added to table is not there in table. If I am trying to Install extension back it is not allowing.…
-
Hedging functionality and dashboard in NAV 2016
How to developed Hedging functionality and dashboard in NAV 2016?
-
NAV Test Framework / Open/Close Sales Statistics from Sales Quotes
Hi, I Need to write a patch that does the following: Loop through all the sales quotes. For each sales Quote the sales statistics Action has to be launched (there is some code on page 160 that is executed). Then just Close sales statistics page again and proceed to the next sales Quote. To do it the traditional way I could…
-
VAT Annual Listing Belgium version
Hello, When running the report for VAT Annual Listing, I always get 0 lines . Nothing to be printed knowing that was no filters on running report. Any one have seen this issue for belgium version? When running the french or english version standard I have lines printed with the right amounts... Thabks for help!!!
-
Supplier Relationship Management (SRM) catalog
Does anyone has any experience with SRM Catalog Management. This is a system where purchasers and vendors can match their systems for purchasing products. Maybe there is some add on for this? Any tips are welcome. Thanks, Johan
-
RTC - some ribbon buttons not enabled
NAV2016 CU19 - NAV2017 CU06 RTC client Sometimes users complain that there are some buttons in the ribbon of a page are not enabled. They are grey and seem not to function. This appears for example in the customer card page and the sales quote page. Sometimes you can click them (even when they appear not enabled) and…
-
Downgrading Web Service Request Mgt. codeunit
I'm working on 2013 version. I need to call an external web service. On 2015 version there is a code unit to solve this. So I decide to importo object in previous version. I need: CU1290 (missing in my version) CU1291 (missing in my version) CU1292 (missing in my version) CU6224 (merge for missing code) But when I try to…
-
Excel Merge in NAV 2016
Hi, I can merge columns via Excel interop (Microsoft.Office.Interop.Excel.Worksheet) . ( I used the tip in this https://saurav-nav.blogspot.com.tr/2012/05/navision-export-to-excel-with-merge.html). this method requires that excel interop needs to be run on client on which Excel is installed. I want to merge fields via pure…
-
Pivot Data in report
Hello, Good day. Im new to NAV, Does anyone know how to make a pivot report in navision using RDLC? thanks in advance
-
SQL Statement
Hi All, I have a question here whereby i am trying to write an sql statement for the following as an example from Nav 1. Table: sales order (Asia Area) Sales Order Number Customer Date SO001 Singapore Faire Price 2017.1.14 SO002 China Wu Mei 2017.1.30 SO003 Singapore Giant 2017.3.8 2. Table: sales order Detail (Asia Area)…
-
OData Connected Services VS2017 End Points Error
Hi guys. I have published a web service OData and it works fine .xml and all is good. I’m going to Visual Studio to develop an APP, which will use this data. First off I can't, as I normally would, go to references and add a service reference. Now we have to use the OData connected Services. No big deal... Just to to tools…
-
Exchange with external systems using WEB service and XSD
I need to write export to external system using the WEB service,WSDL and XSD. I have never written an exchange using the WEB. Tell me where to start. There is a method CreateOrderToSupplier (OrderToSupplier) and XSD <xs: schema xmlns: tns = "http://www.aaaaaaa.com/Navision/package" xmlns: xs =…
-
Facing some transactions in inventory interim account in navision
Hello to all, I am using nav2013 and facing negative amount in inventory interim account. In interim account there so many transactions with positive and negative adjustment and at the end of year it shows negative amount. In inventory GL Reconciliation it shows Direct posting as warning. How to resolve this? Please…
-
Document No. on Gen. Jnl. Line
Hi We recently had support case where a client suddenly had a bunch of Genereal Journal Lines lose their Account No.'s. The culprit is the following code on Table 81 that is called in the OnDelete Trigger (among others). ClearAppliedGenJnlLine()
IF "Applies-to Doc. No." = '' THEN EXIT;
GenJournalLine.SETRANGE("Journal…
-
Help to make a NAV query: That show records from table 1 that does NOT exist in table 2
hi Can anybody help on creating this query in NAV? In SQL it could be either one of 2 queries: SELECT * FROM Table1 LEFT OUTER JOIN Table2 ON Table1.name = Table2.name WHERE Table2.id IS NULL OR SELECT name, id from Table1 EXCEPT SELECT name,id FROM Table2
-
Openstack and devstack
Does devstack completely install openstack? I read somewhere that devStack is not and has never been intended to be a general OpenStack installer. So what does devstack actually install? Is there any other scripted method available to completely install openstack(grizzly release) or I need to follow the manual installation…
-
MS Dynamics Connector error
Hello guyz. Actually I m trying to install MS Dynamics Connector as I want to Integrate CRM 2016 with NAV 2015.But when I m installing it I m facing and error.Below is screenshot of error.. Please help me out if anyone gone through this. Thanks
-
NAV 2017 configure profile error
From the profile card page, I click Configure. I get error "A call to System.__ComObject.Run failed with this message: The system cannot find the file specified. (Exception from HRRESULT:0x80070002" The text constants for the apppath use 71 in the path instead of 100. So one must edit the text constants to replace 71 with…
-
Using Standard NAV 2017 for Project Management
Happy Friday all! Client requirement is to track tasks and their completion using standard NAV or with little modification. Has anyone used Jobs or Workflow or other to solution a requirement like this? General setup they are looking for: Task with a resource assigned to a work order, the work order assigned to a project,…
-
how i can post Free Of Cost materiel Purchase against delivery challan in GST regime in 2016.
hi all , in GST regime FOC materiel movement against Delivery challan and only show only quantity & Value of Materail in Delivery Challan. (if supplier not charged GST on purchase then receiver will not charge GST but when Receiver want to sell that FOC item that time GST will charge & sell against Delivery challan. 1)…
-
Excel File to NAV2015 Webservice
Hi, Can I send an excel file to a NAV2015 Webservice. I want to import the data in some NAV tables. I created a codeunit to publish as webservice. I created a function with a bigtext parameter, but I cannot get this to work. Any ideas how to do this?