-
Budget/Actual % in Account Schedule (Show Opposite Sign)
Hello, On the Income Statement I have "Show Opposite Sign" selected for Revenue Accounts (since they are typically Credits) - This is done on my Row Layout. The Column Layout has 3 columns. Actual, Budget, % of Budget. My Percent of Budget Formula is 100*(Actual/Budget). Both my Actual and Budget amounts are negatives, but…
-
nav field issue
Hey, i have a 4.0 customized database. i'm trying to add a new field to the customer table, but i'm keep geeting following error;: the field "P'Billet Udlφbs" field on customer table does not exist in sql server or view. I checked sql, and the field is named as "P-Billet Udløbs". so the field name are different in nav and…
-
Update No Series last No Used
I have created a report to copy vendor from one company to another company, there are 3 field in request page 1.existing vendor no 2.new vendor no 3. company, the vendor is copied to another company but i want the new vendor no to be update in no series.last no used.
-
Error: Write to file failed
Hi friends, [Version: NAV 2009 SP1 Classic client] I am extracting data from NAV to text file through the automation from report using 'Microsoft ActiveX Data Objects 2.8 Library'.Stream'. When a file with same name already exists in the folder, I am getting below error: This message is for C/AL programmers. The call to…
-
How i can get no series of sales header table of one company into sales header of another company??
I am inserting sales header of Company A into sales header table of company B so I want to insert it with current document no series of company B's document not with document no of company A.
-
How to apply large filter in "Location Filter" field in Item table
I have to create a report that calculates the calc field "Net change" for some items in the Item table. The "Net change" field is function of the "Location Filter" flow filter field, so if, for example, you do "Location Filter" := 17 for a given item, the "Net change" is calculated just for Location number 17. My client…
-
Automation and Events
hi all I wonder is it possible to make a Navision client sit and listen for event from external module without a loop? I have a DLL that gets the data from the serial communication, process it, and set ready for use. Right now, I have Navision in infinite loop waiting for the data. What I need is some sort of event trigger…
-
Where can I find code written to flow data in Sales line table 113 when a sales order is posted.
Actually problem is that in sales line line amount value is in round figure .But after posting sales order, in sales invoice line Amount does not come in round value. How to resolve this problem. Plzzz help me guys!!! Thanks in advance!!!
-
maintenance cost
Hi all heavy duty vehicles, large scale machines under goes repairs and maintenance every now and then. management would like to know how much amount was spend on monthly/annual basic for each of this fixed asset. i would he to select vehicle/machinery while posting repair expenses through payment journal. what should be…
-
Format lost in report
Hi experts!! NAV2017. In the sales invoice report I have le field "Sales Invoice header".Amount in the table this field is decimal with value= 8.527,00 but the report shows 8527 Why the value has lost the format?? How to change it?? Thanks for all!!
-
Getting values with criteria from a field
Hello! I've created an option type field in the Item(27) table with options 1, 2 and 3. If I'm counting the number of objects with, let's say, option 2, then how do I get that object in code? I have: IF _Item.FINDSET THEN REPEAT _SoftcaseObjects += _Item.<this is where the option should be if I'm on the right track>; UNTIL…
-
Count the books of an author
Hello! I've created this table Author. In the classic client under the "Items" I've created some sample books for the author with some details (fields), including "Number of Pages", "Type of Cover" (Softcase, Hardcase, ), etc. I've also created pages Author List and Author Card, on each an action button called…
-
RTC reports are printed with smaller scale than classic reports in NAV 2009 R2
Hi, I have installed nav 2009 R2 on customer's new Win2012 server. Customer is using RTC client. Some NAV reports are old classic reports and some of are RTC reports. The problem is that print layout is scaled smaller on paper print (takes only part of the paper layout) when RTC reports are printed. If they print classic…
-
Exporting text file from Nav 2009 as UTF-8 encoded
Hi Friends, [For Version: NAV 2009 SP1] To export UTF-8 encoded text file from Navision the using variable Automation 'Microsoft ActiveX Data Objects 2.8 Library'.Stream I am trying to export data from NAV 2009 as a text file as UTF-8 encoded using a report. I am getting the output and I need to print in different lines.…
-
navision windows login id changes after login
Dear all, I am facing a strange situation here, my customer recently changed/renamed one of the user windows login (Eg: from 'abc' to 'abc.d'), The SQL Login is changed accordingly(deleted old and created new) , the citrix userid is also changed in citrix server (user claims). They restarted the user pc, reinstalled citrix…
-
Vendor Exchange Rate (ACY) Field
Hi Experts, In which localization of NAV 2009 R2 classic are we able to see the field Vendor Exchange Rate (ACY) in the purchase header and the related customization. It is missing in Singapore localization. I am unable to find it in SG objects. Thanks vineeth
-
Navision 2009 R2 , Cannot select Location Filter Report 406
Hello, we are having a problem in report 406 purchase-Invoice that user cannot select location code from the lookup menu it opens and when clicked ok it returns blank , the only way to do it is by copy and paste the code. Nothing is customized in code , did you face this problem?
-
How to skip a a Codeunit which is out of License Permission range in Navision?
Experts I have two Codeunits. First Codeunit is within the Range of License Permission, Second Codeunit is not within the range of License Permission. Scenario is like , Second Codeunit(Out of range of license permission) is recalled within the First Codeunit(Which is within the range of License Permission). By standard,…
-
notyhtkfduytasr
Error in page
-
redger bridge
hi i creat a interface application between serialport and scale weight so i have a value from it save in text file so wen i click in form in nav 2009R3 to read the value nav can be read the value the incorrect or the scale weight not stable this a specifque devoppment thank you
-
arabic number navision
i want to show arabic number into navision 2009 SP1 report
-
Automated Data Capture System
Hi all Is it possible to configure Automated Data Capture System on 2009 R2 classic client ? please help me with reference manual. thanks satish
-
Error to Import a CSV in a Form
Hello Guys: I created an XMLPort and it does not let me import the CSV, I created everything I think correctly, but I continuously get this error Could you help me ? Greetings and thanks
-
Joining two fields
Hello! I have a pretty simple question. If I have 3 fields - First name, Last name and Full name. Then how do I join First name and Last name for Full name to appear? I imagine it's something like: First Name - OnValidate() xRec."Full Name" := "First Name" + ' ' + "Last Name" ... But I can't quite get the code right.…
-
Sales Blanket Order - fully invoice at start?
Hi all, What's the best method to fully invoice a Sales Order and then create multiple shipments as required by customer to fulfil the order in NAV? I've had a look at the Sales Blanket order functionality which seems to be best suited for the task but not too sure about the invoicing process as I believe it's only…
-
Restrict Company
There are two companies in the database. I want a category of users(say branch users) to be prevented from accessing a company. They will access one company while HO will have access to both companies. How to acheive that.
-
Error Message When trying to complete a Prod.Order
When staff are trying to complete a Prod order the get the attached error message appear, However they have returned any tea's and WIPS they require too. Any suggestions on where to look or what to do to solve this? Please NOTE: I was in the Royal Navy for 10 years from 17 with a very high knowledge in IT/Networking an…
-
My Question
Create a simple report for customer list. The report should be in landscape with 15 or more columns. In the options tab, there should be 5 checkboxes indicating any 5 columns. If I select those checkboxes then they should not be printed and the columns should be moved. We are talking about moving of columns on the fly. can…
-
REPORTS
Create a simple report for customer list. The report should be in landscape with 15 or more columns. In the options tab, there should be 5 checkboxes indicating any 5 columns. If I select those checkboxes then they should not be printed and the columns should be moved. We are talking about moving of columns on the fly. can…
-
Receive data from barcode scanner by ethernet (not handheld)
Hello everyone, this is my first message in the forum. I need some help... I need to receive data from a barcode scanner by his ethernet port. It's a Datalogic DS2400N. The scanner reads a barcode every few seconds/minutes and I need Navision to wait for each data... I've been searching in a lot of barcode post around then…