-
Release button logic
Hello! I have this code under the Release action button: Release - OnAction() IF PurchaseHeader.GET("Document Type","No.") THEN BEGIN PurchaseHeader.TESTFIELD("Purchase Contract"); //checks if the purchase contract field is filled PurchaseHeader.TESTFIELD("Posting Date"); //checks if the posting date field is filled…
-
Developer toolkit on NAV 2009R2 (Build 32012)
Hi Friends, I hope some1 can help. Im trying to connect but I get error, my database seems newer. I tried copying fin,exe and dll files from NAV directory to devtoolkit but still I get an error similar to wront STX file. Any clue how I can make it run? thanks! :# EDiT: Hi Friends, I made it work, fyi: following part of…
-
Sum of Amount for the same document no
Hi Experts, If same document number exist more than one time, how can i get the sum of Amount. Say in Vendor Ledger entry it consist of same documents may be twice or thrice how can i find the total amounts of the document.. Thanks in advance.
-
Codeunit 80 Sales-Post
Hi In codeunit 80 (Sales-Post) which line insert SalesLine Entryies to G/L Entry during posting Credit Memo? Best Regards Tomek Zakrecki
-
NAV 5.01 with Windows Server 2016
Anyone tried to load/run NAV 5.01 on Windows Server 2016 yet? If you have what were your results?
-
Sort ascending AND descending
Hello is there a way to sort either ways ascending and descending on different fields of course.. here is an example. i have this key: ILE.SETCURRENTKEY("Entry Type","Document Type","Posting Date",Quantity); I d like to sort all Ascending. so ILE.ASCENDING(TRUE) would be ok. BUT! For the Quantity i would like to sort in…
-
Dataport will export an extra blank line
The main purpose of this requirement is to export vendor and it's bank account data into file then import into another company after user has revised the file. I've define 2 dataitems in this dataport (Import = No) (1)Integer: CONST(1) (2)Vendor: Vendor Type=FILTER(EMPLOYEE) (1) to export the field name in first line, set…
-
Insert Data to a Table by Only Knowing The Table ID
Dear All, I am trying to insert a data to a table by only knowing the table ID. Let's say I have the number 18 at hand and I will do an insert to Customer table? Is it possible to reach the customer table and insert (or modify) data with only knowing the number 18? Thanks, Ararat
-
Windows 7 and Nav 4.0 SP3
Dear all, I'm not able to Open fin.exe[Nav 4.0 SP3] in Windows 7. It creates an error message in event log.. Faulting application name: fin.exe, version: 4.0.3.23305, time stamp: 0x4511b8e2 Faulting module name: fin.exe, version: 4.0.3.23305, time stamp: 0x4511b8e2 Exception code: 0xc0000005 Fault offset: 0x000aaef6…
-
NAV 4.0 SP3 running on NAV 5.0SP1 - What is the
We have a situation where i see on the About Dynamics NAV the following information about the version Version <Country> 4.0 SP3 (5.0 SP1) I have dynamics NAV client´s running 5.0 SP1 but this means that the NAV objects are still in the NAV4.0 SP3?
-
Options from another table
Hello! I've created this new table called 'Vendor Purchase Contract'. On it is an Option-type field 'Payment term', which is in relation to the 'Payment Terms' (ID 38) table and should allow the selection of options from that table. How can this be done? OptionString can't be empty, but what should it be filled with?…
-
works automation 'WinHTTP Version 5.1' for HTTPS?
Hello, I am trying to authenticate against vendors' server, but I still receive HTTP error 400 (bad request) After a time I think that automation 'WinHTTP Version 5.1' is not able to work with secure url: https:/ /xxxx.com/auth Does anybody have please experiences with calling secure https form NAV 2009 client? Thank you…
-
Issue with Extended Text (2009 R2 Classic)
In 2009 R2 Classic when attempting to use Extended Text I encounter this the error shown in the image. However, the debugger will not trap the error, nor can you catch it using "breakpoint on triggers". There are no fields in either of the Extended Text table named code, and there is not a table in the database named…
-
Sales invoice
Hii can anyone suggest me that how can I restrict the posting of sales invoice.As if I only want created sales invoice but not to post it.In which code unit or which function I have to restrict so that sales invoice doesn't get posted. Thanks...
-
Deleting all empty orders
Hello! In the table Sales Header (36) there are orders. Double-clicking on them opens the Sales Order (42) page for this order. There are fasttabs General, Lines, etc... I've created a button for deleting all orders that have 'empty' Lines. I have this code with a user prompt for Yes/No: UserPrompt := CONFIRM(Text001,…
-
In LS Retail, I want Net amount=Price-discount+VAT
Hi, In LS Retail, I want Net amount=Price-discount+VAT. will you help me to advice steps for If it is not right forum will you direct me to. please Warm regards Kris
-
Exceed option Sting character limit.
i have a option string which contains more than 250 character, so how can i exceed the option string limit.
-
ADCS VT100 Plugin problem
I've installed NAV 5.0 SP1 and I'm trying to get ADCS working. Followed all the setup instruction in the documentation. Event Log shows the NAV Server running without error and the ADCS NAS starts correctly without error. However when I connect with HyperTerminal it will not do anything but says that it is connected in…
-
Nav clients can't connect to server
Hello: Yesterday, we uninstalled the antivirus from the NAV server (Navision 2009) and since then the Navision clients can not connect to the server. The network is working fine, I can ping to the server from the clients. I checked and all the services seem to started fine: Database Server for Microsoft Dynamics NAV…
-
Get Key filter in subform Purchase Line
In a form of a Purchase, we have Purchase Header and the Purchase Lines on a subform. I want to get the key filter when you change de sort of lines on subform with hotkey SHIFT+F8, and then pass it to the header form where I will call a report to print the purchase. Thanks!
-
OLE control error NS Outlook Synchronization handler.OSendmail latest Windows 10 update
After the laterst Windows 10 updates are installed we get an error when an email is created from Navision. See screenshot I see that mapi dll has been updated in c:\windows\system32 to latest version. From 18-3-2017 to 29-09-2017 Are there maybe an incompatibility issues with the latest mapi32 DLLs? What can be wrong?…
-
regarding capturing error while transfering the data
Hi guys , I created two tables which are having same fields but in the second table the datatype for the first field is different from the first table and I created a form for these tables and in the form command button is used to transfer the data from the first form to the second form and while doing it so it throws some…
-
about codeunit 80
hi guys I want the transfer the posting description field to g/l entry with another field name in the g/l entry table.Can anybody let me know how can I do that and also which table i need to modify. Is there any necessary to change Gnl.journal line , cust.ledger entry,sales shipment ledger,sales invoice header or any other…
-
Using CodeCoverage from Command Line
Not a question really but just a hint for anyone else who runs into this. I have been struggling to run Code Coverage from the command line at a client's site using the command: FINSQL Coveragelog, Coveragefilename=c:\temp\coverage.log I could not get it to work while it worked fine locally it would not work at the client.…
-
XML IMPORT
Hi Reader, Can this be imported in NAV using XMLPORT? If it's possible may I know how would I create an XML with this kind of structure. Because I tried doing it but am having a hard time reading it with my XMLPORT. Hope you could help me.. Your answer will be much appreciated. :) Thanks!
-
Delete a record if a field is emptied
Hello, How can I assign values to these variables with the VALIDATE function? Also, if the Author field is emptied or values deleted, how can I delete the record "DefaultDimension"? Thanks in advance.
-
Update a field value if another field's value has been changed
Hello. How can I change a field's value in Table 2 based on the condition that another field's value in Table 1 has been changed? One has to update the other. And same with emptying or deleting the field. Any code examples? Thanks in advance.
-
Export To Excel
Dear Experts, I have tried searching the topic on how to export to excel but couldn't find any. I have a report (209 : Vendor Purchase List). and i want to export to excel. Is there any way that i could export to excel? How can i export it. Right now i am saving that report as an html and then opening it in excel. but it's…
-
Regarding the link between the G/L entry and the sales line
Hi guys, I would like to know the main link between the G/L entry and sales line and also how G/L gets updated once the sales line is posted in nav.... Thanks in advance
-
Changing the dimension values
Hello! I've created a new Code-type field in the General Ledger Setup table. I've also previously created a table "Author" for creating authors for books with all kinds of fields. There is a Code-type field "Sign", which represents the Author by "AB", "CD", etc. 1) By creating a new author with a Sign, the Code-type field…