-
How filter several registers in sections
Hello everybody, I've the following code in a report: IF ("Gen. Prod. Posting Group"='001') AND ("Entry No."<>56920) AND ("Document Type"="Document Type"::" ") THEN BEGIN CurrReport.SHOWOUTPUT(FALSE); contador:=contador-1; END; But, on Entry No. section I want to put several entry numbers but I can't, I don't know what is…
-
Days between 2 Dates in C/AL
Hmmmm.... Anybody know how to do the eqivalent of the SQL DATEDIFF function in C/AL Code? Seems like a dead easy one - until you try and find a function :? Basically it's a date comparision with the result being the integer number of days between date1 and date2. Thanks (in advance) Rob.SELECT * FROM users WHERE clue > 0 0…
-
Contact Search Result.
Could anybody please explain me the result of a contact search on the string "Eddy" or "Piet" in a CRONUS database?
-
RecordRef / FieldRef
Hello, I wrote ethe following code : RecRef : RecordRef FldRef : FieldRef RecRef.OPEN(27); FldRef := RecRef.FIELD(1); // Item."No." FldRef.SETRANGE('70000'); RecRef.FIND('-'); FOR i := 1 TO RecRef.FIELDCOUNT DO BEGIN FldRef := RecRef.FIELDINDEX(i); CASE FldRef.NAME OF // Or you can use a case on FldRef.NUMBER…
-
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
-
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.");…
-
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
-
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…
-
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]
-
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…
-
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…
-
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?
-
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
-
Some drop down menu does not work in Purchase Order, example Purchaser Code, G/L Account.
Hi All Some drop down menu does not work in Purchase Order, example Purchaser Code, G/L Account. Any Ideas?
-
Barcode Scanning Functionality does not working at POS Screen
Barcode Scanning Functionality does not working at POS Screen, Basis of Barcode Input POS does not showing Item or Filter Item to select at POS Line.
-
Version NAV3.60A DK
I need a standard NAV3.60A DK database on a project, Microsoft cannot find it in the archives, does anyone have it or know where I can find it? I found the NAV3.60A US database on dynamicsuser.net but the dk version is very hard to find...
-
Adding section to C/AL Code..
Maybe a noob question, but I don't do a lot of coding, only has been with your help mostly. When I design a report and go into view C/AL Code I will get sections like: Documentation() OnPreDataItem() OnAfterGetRecord() etc. Along with code underneath. How do I add a section with code? In my other report that works properly…
-
Nav 3.6: Database size upgrade
Hi There. I saw a topic about the size limitations on Navision 3.6 being 64GB but that the license could be upgraded free of charge to 128GB. forum.mibuso.com/discussion/2719/the-naivision-db-size-limitation How would i go about getting this done. Please could someone point me in the right direction. Thanks in advance.…
-
Regarding Licensing Policy
Dear all I have a problem regarding Licensing in one of my client working on NAV in UK version but he has a factory in India so how to manage this because Indian taxation and UK Taxation both are different. Please suggest me
-
Error when trying the unapply Customer Entries due to Additional Currency
In our Navision solution we are running a setup with additional currency (EUR). When we try to unapply a Customer Ledger Entry with posting 08-08-16, we get this error: "You cannot unapply the entry with the posting date 08-08-16, because the exchange rate for the additional reporting currency has been changed. " I'm…
-
when we post item journal, xml file should be auto generated
Hi when we post item journal, xml file should be auto generated , path will be given in given in general ledger setup i have created a xml port and assigned it to the post buton the xml file is generated automatically. Now the problem is the file is saving in the given folder but the actually thing the path will be given…
-
How can we group lines in the general journal?
I should group the several lines of general journal lines into one line based on the documen number.If the document number is same. Thanks in advance.
-
how do I fix this when trying to receive?
I'm trying to receive a chemical. And when i try to post and print and receive it has a message that pops up saying "the general posting setup does not exist. Identification fields and values: Gen. Bus. Posting group=", gen. Prod. Posting group='COMP' " what does this mean and how do I fix it. I'm new at this job and the…
-
Timeouts..
I'm yuppicide. Sorry to have to create a second account.. since the switch to the new website/forums or whatever I can't seem to get back in. Anyway, I know Navision 3.10 doesn't really work with Windows 7, but we're doing it with Virtual XP Mode. I've got 3 computers in the office still using XP I believe, and 3 or 4…