-
Create email with plain text
Hi all! I´m trying to create an email with plain text (no HTML or rich text). The email window must pop up in plain text and then the user click on send. I have tried the following: CU397.NewMessage("E-Mail",'','Pedido compra: '+FORMAT("No."),Conte, PathFichero,TRUE); //Last parameter to show window and also I have tried…
-
Summarizing Item Tracking for Warehouse Receipt Lines
I'm working on some custom programming, and one of the requirements is to summarize the quantities for an item on a Warehouse Receipt based on the Item Tracking associated with the line. If the Item on the line is lot tracked, for example, I need to summarize the quantity by lot. I'm going through the code that calls the…
-
Table update from external SQL application
Hi everybody i have an external app writing to "staging" tables in a NAV 5 DB - then i have a CU that reads data and updates some standard NAV tables. Everything works fine if i run the CU once. But i need to execute it in a loop, eg every minute for 1 hour. When i launch it this way the records that are already in the…
-
G/L entry and G/L Register
URGENT i want to export G/L entry records for specific period , i create the data port and add all items i need from G/L fields , How can i add also the Register ( "No." ) from G/L Register table against each entry No.
-
Print BLOB file to Printer
Hi All, 1. Is blob field only for 1 file? 2. Is it possible to get blob data (pdf file, image file, text file, etc) and print it to default printer without open the file ? If No 2 = Yes then please let me know the pseudocode.
-
2013 R2 Upgrade There must not be empty base unit of measure
Am trying to complete Navision upgrade and got the following error on running step 2: There must not be empty Base Unit of Measure. Please fill it in for Temp Item ItemNo before updating.
-
Problem reading sql table from nav.
Hi Guys!!! We are facing some problems when we try to read from nav a table that is shared with other applications and it is filled every day with dat from POS. It seems that findset/findsfirst instructions don't work. Furthermore, if we open page and we try to set filters they don't work either. The primary key of the…
-
Classic Database server (2009SP1) on Windows 2012 server
Hi all, First of all, i like to say i like this forum alot. As a sys-admin for several Nav customers this forum helped me out alot of times. Actually it helped me today, toward a solution at a customer and a colleague told me to add to this community, my efforts / solutions for today, so it might help others in the future.…
-
Safety Stock Quantity by Item Variant
Hi; How can i manage Safety Stock Quantity by Item Variant: define Safety Stock Quantity for each Item Variant Thanks
-
Password Enforcement In NAV
whenever i create a new user using SQL i tick on password enforcement so that on first login it says the user to change it while using SQL. But How to do the Same when a user logs in using database server authentication in NAV 2009 R2, So that the user Must Change the password for the first time he/she logs in NAV. Please…
-
history
Hi expert, where to get the info for the data transaction of each day for the system? Thank you?
-
Missing the ntimer dll
Hi everyone, I am running through an automation error whenever I am trying to run a certain form. After debugging, I discovered that the missing dll is NTimer.dll What shall I do? If I copy the dll from another computer, would that be enough? Thanks in advance :)
-
Sending multiple pdfs by-email
Hi everyone, I want to be able to send many pdf invoices by e-mail in the same time (each invoice is related to a different customer). I know how to do that for a single invoice(generate pdf and then send it by e-mail), but what shall I do if I want to send 3 or 4 at the same time? Thanks in advance :)
-
Skipping records when dispalying a form
Hi everyone, I have a form for which I want to skip certain records. In the OnAfterGetRecord trigger, there is a code that calculates a decimal varaiable X. I want to be able to display only the records for which X > 0. How can I achieve that? Thanks in advance :)
-
Transform XML to Text file using XSLT
Dear All I used the below XSL to transform the XML to text <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output omit-xml-declaration="yes" indent="yes"/> <xsl:output method="text"/> <xsl:strip-space elements="*"/> <xsl:template match="*">…
-
Requisition Worksheet Create PO
Hi, I might have miss important information in this forum related with Requisition Worksheet creating Purchase Order where the Vendor No. having different Pay-to Vendor No. in the Vendor Card. My situation as following I have Item X in Requisition Worksheet for Vendor Y and Purchase Price in Vendor Y for Item X is setup…
-
SourceTablePlacement: Saved - doesn't work sometimes?
Hi Mibuso, Hoping for some help with an odd problem. In 2009 R2 client (Cronus database), when looking up the "Customer Ledger Entries" form from the Customer Form, no matter what I do I can't get the record position to save. To my understanding, the default setting of "Saved" for the property "SourceTablePlacement" should…
-
Navision 5.0 SP1 Last Direct Cost vs Puch Price Table
I am having a strange issue on Navision 5.0 SP1. For certain items, when I create a PO it will only use the last direct cost to populate the unit cost on the PO lines. I have verified that the entry on the Puchase Price Table is for the vendor I am selecting and for both more than the minimum quantity (MinQ = 0) and in the…
-
Filter item no sales price table tha not start (AR-)Problem
Hi guys i want to filter sales price table filed item no as example AR-AGG AR-AGG1 AR-CEMENT AR-SAND SAND CEMENT AGG I need only show only items not start AR- MEANING result what i need is SAND CEMENT AGG I make filter but it not work why : Item.No. WHERE (Item Category Code=FILTER(FG),No.=FILTER(<>AR*)) after this i…
-
Image types in NAV
Hi everyone, I have a question about the image types that we can import into a navision database. Does the image have to be a bmp file, or can I use other types? Thanks in advance :)
-
Flowfield strange problem
I hav a simple flowfield in Item table that sum quantity value (similar table 32) in custom table. So every item display sum quantity in this flowfield. But for same reason there are items that shows wrong sum. Example Item ABC shows value 100 but when i drilldown flowfield it's shows an empty table. Also if I filter…
-
Item Ledger Entry => Warehouse Entry
Please could someone help, I have been searching and trying for weeks to resolve this issue but I have yet to find an answer that works. I need some way of reporting inventory with a bin locations, that's it in a nutshell, every other warehouse system I have used in the past this has been simple and out of the box but like…
-
Matrix in navision
Hello we are using Navision 5.0 SP 1 and i am trying to enhance a matrix form for Item Demand and Supply analysis. The Demand and supply analysis shows the Inventory ,Prod Order ,and the other categories for an Item in a matrix form. It can be viewed by various Period types(Day ,week ,Month etc). My enhancements are for…
-
Waldopad Install Error
Hi guys, Quick question:- We have a client that needs the ability to store large amount of texts in a table. So WaldoPad seems to be a perfect fit. I am just having issues installing it on their server. Client Setup: 1 NAV Server 10 additional server that connect to the nav server. These 10 servers are used to do load…
-
Digipoort and ICP declaration
Hi there, Is there anyone who did the declaration ICP with the digipoort successfully ? I'm trying to get this work, but each time the client closes itself. They work on NAV 2009 R2 Classic and RTC. In the digital port tab, I have filled the 1st and the 2nd field with the same Common Name: example. http://www.klantnaam.nl…
-
SMTP-Problem
I tried to send E-Mails via CU 400 / SMTP using a HTML-template filled with some specific data. Sending in-house works fine ! :) But if i try to send the mail to a recipient outside i get the error message from the mailing-System: 5.5.0 smtp;500 Line limit exceeded. Sending only some lines of text works ! Can anyone help…
-
How to Import data from Excel file
Dear All, I am migrating the database in same version NAV 4.0.3. I am taking all data in excel from old database & filtered only required data. Now I want to import the data in table without using dataport. No. of records might be 50000-60000.. So any other way to import data in New database from excel file.. like SQL etc.…
-
Some other questions
Hi, some other settings/questions: 1. Where TempDB resides? 2. Why RAID 5? 3. Are D: and E: on different drives? 4. Run terminal services at same server?
-
Check if record is inside a defined filter
Hi, I need a fast solution to check if a record fits a defined filter definition. Example: Filter "No." = "1000..2000" Rec."No." = 1010 How can I check if the record would be inside the filter result? #-o
-
Navision Style Sheet Tool cuts off macros
I want to provide a marco into a document template used by the Navision Style Sheet Tools (for creation of some bulk/merge field mails). The macro itself works fine and the Style Sheet Tool itself works also fine, we use it for a lot of documents. But the combination of both don't work at all. If i assign the macro to the…