-
How to make a field mandatory...newbie question
Hi, I'm quite new with Navision so please don't shoot me :-) I want a field in a table to be mandatory (let's say 'Email Adress'). Also when creating a new record in that table through a form and the user forgets to fill in the 'Email Address' and wants to enter another new record or closes the form I want to inform the…
-
The call to member SuretaxserviceRequest failed. mscorlib - Nav 2009
I am currently running Microsoft Dynamics Nav 2009 v US Dyanmics 6.0 and was running (2) different RDP servers for users to access, then open Navision. After retiring ONE of those RDP servers and setting up a new RDP server with Navision installed, any time I have a user try to verify an address in Navision on the new…
-
Table 87- Date Compr. Register
Is there an issue if I clear this table? Does it effect anything? Or is it just a "record holder" of what "was" done. Thanks
-
How to count a particular Character in a String
Hi, How can i find the Count of a character appeared in a string. For example suppose i have a string ABCDEFG@Yahoo.com,XYZ123@Yahoo.co.uk then if i want to find the Number of '@'. how can i do this using string function.
-
Renumbering objects
Hi all, I would like to re-number objects in a database. What do I use to make it? I've tables with a lot of data (it's not clear database) and I'd like to re-number and open form and no have in the sourcetable = TableXXXXX (and I no open the form). Is it possible? Thank you. Regards
-
Lot No does not work when it is generated by code in transfer lines
I am creating transfer order by code and it works but i want to assign lot no also i wrote this code procedure AssignLotNO(transLine: Record "Transfer Line") var EntryNo: Integer; begin if LastTRackingSPecs.FindLast() then EntryNo := LastTRackingSPecs."Entry No." + 1; GetItem(transLine."Item No.");…
-
Report Execution Error using German Language
Hello All, I have created a Navision report and the output is Excel format, when I run the report using English Language, it works fine, but using the German Language, I'm getting below error message. Can anyone please advise how to fix below error. Also I apologize, I can't read the error message. "Die Wahlmöglichkeit…
-
How to get the "Temporary Navision Path"
Hi, Does anybody know how to get the "Temporary Navision Path" (TempFilePath from Navision options) within Navision. I need this path to save a Temporary file. If this is not possible I would like to get the Windows Temporary path. Thanks, Emiel Romein
-
How do I use Job Queue in Attain?
Hello all, I see that Job Queue is not available in Nav Attain(3.6). Is there any alternative that will allow me to run a specific codeunit periodically? Thank you!
-
Select a Specific Name/string from Table
Hi Friends, How to select a specific name or string from table columns in C/AL code OR how to achieve if want to get a particular name or string by searching in multiple columns alongwith. Example search a name let's say rahul among two or three columns e.g. Name and Name 2 in customer table.
-
Does anyone have the client download for Attain 3.01?
Hi all. I need to get the above client installed on a local PC but all I can find on MIBUSO and the web are links to Attain 3.10 and 3.60. I need Attain 3.01 client and preferable the GB version. Does anyone have the client or know of web link that has the client? Many thanks. Neil
-
what is meant by test case and how to write it
Please!Explain it Clearly Thanks in Advance
-
How do i find the developer?
Have an add-on to an old version of Navision 3.6. The ID range is 14017060 to 14017065 "Posted Deposits". Version # BC.FCR.01.05 Is there anyone who knows which company owns this range or somewhere I can look it up? .. Would like to delete old Posted Deposits (Say 2003 to 2010) just wondering if it effects anything or does…
-
How to evaluate a value into a FieldRef?
I tried to evaluate a field from a record into a FieldRef. I use 3.70 (HF12) client and get following error message: The cursor is set to EVALUATE(|Fldref.Value,Record.Field); Can anybody tell me how to evaluate a value into a FieldRef?
-
Programming with the "Navision Socket Bus Adapter"
Hello, I’m trying to create a winsock client application with the "Navision Socket Bus Adapter". I’m having trouble with the “MessageReceived” trigger in my client. There’s no way to get the client to receive a message. Here’s my code: OnRun//Check if ComCOm is clear IF ISCLEAR(ComCom) THEN IF NOT CREATE(ComCom) THEN…
-
Cancel Reservation Entry
Hello , The Entry BT19-04603 in Production Order are delete. and I can't cancel Reservation in page Reservation Entry. i have this message error [Removed link by moderator. It doesn't work. Please put the picure in the forum and not using a link]
-
item copy
Is there a way to copy item card with some of its datas, as you do with orders, invoices........? Or any time I have to build another item card? thanks Alberto
-
Upgrade Toolkit for Dynamics NAV 2009 SP1/R2 to NAV2015
Hi, I am looking for country/region-specific Upgrade Toolkit (specially for US-United States) to upgrade from Microsoft Dynamics NAV 2009 R2 and Microsoft Dynamics NAV 2009 SP1 to Microsoft Dynamics NAV 2015. Can anybody tell me, where is the link to download it? Thanks,
-
What is the cost/benefit ratio for ACE Warehouse Management? Admin Overhead > Savings?
We use Lanham's Eship and really like it. We are exploring ACE Warehouse management and have received a demonstration. I'm concerned about the amount of setup time and overhead involved in managing the Outbound Requests Management table. I would like to know if someone has some experience with ACE and has some input into…
-
Set focus on the subform record
Hi all. There is a purchase order form. There is a button with some code on it. I need to set cursor in purchase lines subform to a definite record. Anybody know how can i do such thing? The only solution that i have is to use timer. But it is very bad solution i think. I also try to use CurrForm.PurchLines.FORM.SETRECORD…
-
Database in use !
Hope someone can help - I will try to make the problem description short. 1. have license for 2 users 2. client can open 2 copies - no problem (running tcp) 3. server can start 2 copies - no problem 4. if one copy started on client - can't start a copy on server (database in use message) 5. if one copy started on server -…
-
Reading barcode of Datamatrix
Hello! I read out the Datamatrix code in a text box, it looks so 104602824023324214NPL5XDUWMXBK10310917171910012403004 In it it is coded (01) 04602824023314(21)1NPL1XDUWMXBK _ (10)250817 _ (17)190801(240)3004 (01) (21) (10) (17) (240) - it is AI assignment identifiers _ is FNC1, in its quality the character <gs>, a code 29…
-
Error:: Item #### is not in Inventory
Hi All, In one of clients who is using NAV 3.6 whenever I am trying to Post a Transfer order of a item, it says the item is not in Inventory. The ledger of the items displays enough balance to make the transfer. Has anyone came across such error or has the solution of the same, please revert back. Regards Diptish
-
Reading XML file in Navision
Hi, something doesn't work in my code, but i don't see it... =========ImportXMLFile(pFilePath : Text[1024])=========IF ISCLEAR(lautXMLDocument) THEN CREATE(lautXMLDocument);lautXMLDocument.load(pFilePath);lautXMLNodeList := lautXMLDocument.getElementsByTagName('Results/ProposedPrices/ProposedPriceItem');lautXMLNode :=…
-
Brattberg FTP
I have a client with lots of integrations. One of them is Brattberg FTP that reads files from a FTP site and then processes them and so forth. If those files have special letters like øæå in the name, those are not interpreted correct. This results in the files being dumped into a error folder. Does anybody know if it is…
-
Navision Attain 3.01 Client + demo database
I am looking for a Navision Attain 3.01 Client and demo database. Can anybody help?
-
Formula's in Excel using automation
When working with formula's in Excel using automation, you have to know what language-version of Excel is installed (English, Dutch, French, etc.) in order to write your formula (eg. SUM/SOM/SOMME, ROUND/AFRONDEN/...). The functionxlApp.International(lxlCountryCode)); (with lxlCountryCode = 1) returns the language being…
-
Creating new fields and passing them to tables
i was wondering how i can pass a new field from one table to another. example, i created a new field in gen. line journal and i wanted to pass it to the G/L entry table. I created the fields exactly the same in each table with the same field #, name and settings. but when i post, the information doesnt show up on the G/L…
-
Date Format Dataport
How to encrypt this date format: 21-03-2017 for 3 new fields with these values: Day = 21 Month = 03 Year = 2017 It's a data port where I'm going to export Posting date from Item Ledger Entry. Version of Navision is 3.70
-
Vertical for absence tracking and employee expenses
Hi guys , anyone could tell me about a vertical for Nav 2017 that manage the users absence and expenses? (the standard HR module is not complete for us) Thank you