-
Access Audit question
Good morning all! In NAV 2009 R2, I need to pull the user permissions for each component in the Nav Pane. Ctrl+F12 gets me to the right section to modify permissions but I think that information is all stored in the MenuSuite components. Is there any way to efficiently report against those permissions in a scheduled…
-
Cashflow Compare Report Missing?
Hello, I read somewhere that NAV 5 SP1 is supposed to include a Cashflow Compare report but I'm not seeing it anywhere. Is there somewhere I can download the fobs to import this report? Thanks!
-
Regarding a lookup field
Hi all, I created a field in sales header part very much like responsibility center in the header part.When ever we click on to the lookup the responsibilty list is opened but in my field i gave source table as dimension value ,So here i want the dimension values of AREA only to lookup in my field ,I tried using the…
-
NAV without warehouses; is it possible?
Hi mates, I hope some1 can help. s there any chance NAV can be set up so location does not generate any whse. entries and use an item as "template" so users can use it to enter whatever they want to invoice. In case of using a warehouse and it generates whse. entries, could this affect somehow? thx.
-
Can you get truly random numbers from Dynamics NAV?
I use random numbers for testing a lot, and I'm used to Excel, where you can get a lot of precision from '=RAND()' It seems like the easiest way to replicate the Excel RAND function in Navision is with this code:RANDOMIZE;x := RANDOM(2147483647)/2147483647) And, then this really isn't a true random number, but it's based…
-
Hi There, I have transaction header with Missing value on Staff ID, Sales type
The setup seems Fine, but there are random transaction without Staff ID, sales type Vat Bus. Posting group. Staff ID, can’t perform transaction without logging in first at POS, thus can’t be blank Sales type, if staff don’t pressed any hospitality type, thus the default type will be used in this case DINE IN. Statement…
-
not able to capture the error
Hi All, I getting the following error message when i try to capture the error while transferring of data from one field to other field whose datatype lengths are different .I want to capture the error in a separate field . totable.DELETEALL; fromtable.RESET; fromtable.FINDFIRST; REPEAT totable.INIT;…
-
SMTP mail is not working
Hi guys , i have just finished setting up the SMTP mail but when i tried to send the report by using mail it throwing some error .. Have anybody faced the issue earlier .. please advice Thanks
-
Insert carriage return in smtp email body
Hello everyone! I have searched the forums and I know this topic has been discussed a few times. The problem is that I have tried every suggestion I have come across and nothing is working. ](*,) I have defined two variables, CR and LF, as type char. I give them the ASCII values 13 and 10, respectively. When my code is run…
-
Delete a record when validate a field
I don't know if is possible this: I have a list Form. One field called Exclude is editable (Text 50) and in OnValidate for this field in the Form is called a new Function. This Function is in the Table with a local variable to the same Table (lvrec). This function do this: Primary Key in table is "Document No.", "Line No."…
-
Release to BizTalk error
One of our users when releasing a sales order to biz talk gets the attached error. However upon checking our Biz talk server this has infact been sent and on the Ecommerce tab of the sales order a date is filled into the BizTalk order sent field. Anyone know what this could be or how to fix this please
-
Odata Web Service Connection Problem
Hello I'm trying to use Nav 2017 Odata web service in my application. I can not connect Visual Studio 2017 c# application to nav 2017 odata web service. For Connection i'm using Connected Services. I got following error: Is any Solution?
-
You do not have permission to run the XXX table.
Hi all, I have a rather odd permission issue.. The error I'm getting is : You do not have permission to run the G/L Entry - GST Entry link table. Contact your system administrator to have your permissions changed. Ok, seems like an easy permission problem right..?!?? So I had a look at my permissions, and I have SUPER... I…
-
CHANGE WORKDATE
How best do i change the workdate such that every one logged in will use the same work date , THE WORKDATE SHOULD CHANGE AFTER IT CLOCKS A CERTIAN HOUR OF THE DAY
-
running a page from a form in classic client..
Hi all, Can anyone help me on how to run a page from a form where the form is of from a diffrent table and page is of different table. Any answer would be really helpful for me. Warm regads, Bharath.K
-
Regarding G/L entry
Hi all, I tried to insert a new field in G/L entry and tried it to get updated once a sales order is posted.But everything is working fine but the problem once i post a sales order multiple entries are created in g/l entry and my field is updated in only one field. Can anyone suggest what is the reason for this problem.…
-
Read CSV file as txt, char by char
Hi guys, I have a CSV file that looks something like this 23;tst;;;12;TEST;2;...... So, my delimiter is ; Using excel buffer is not an option so I need to read each line of this txt file char by char and write data to some tables because each line has cca 2500 characters so I cannot simply read whole line at once, as one…
-
How can i show default fields on table filter of FORM like we have option in report ReqFilterFields?
I want some specific fields to be shown in table filter pane when user opens the form.
-
Alternatives for Bullzip pdf printing (Nav2009)?
Hi experts, Is there any better or cheaper solution for Nav 2009 invoice pdf printing than Bullzip version? I mean product what do not require a lot of code actions to work. Thanks for advices.
-
Bank Reconciliation for Payments not recorded in navision yet
Dear all , We have scenario in bank reconciliation and I need some advise on that . While doing bank recon we found that some payment not recorded in Jan month in nav but are in bank statement. Since jan month is already closed we can enter the payment only in Feb. In this scenario what is the best way to do reconciliation.
-
Purchase Transfer Order Process.
How can I fix this msg. Entries applied to an Outbound Transfer cannot be un-applied. What possible solution for this msg.
-
How to import skip empty fields using Xml port in sales order..
I have created a XML port with sales header as a parent and sales line as a child and i want to import some data to it .But when i do this the empty records in the sales order must be skipped and move on to the next record . For Ex. In sales header I have a field called alternate number and i want skip the header which…
-
Entries applied to an outbound Transfer cannot be un-applied
Hi All, Our customer using Malaysia version NAV 5.0 SP1, encounter an error message " Entries applied to an outbound Transfer cannot be un-applied" in application worksheet. End user post the Item Reclass Journal from Bin A transfer to Bin B. Thanks in advance Kelly
-
Object Designer. Why Version List is blank with last modification date.
Dear colleagues, Could you advice the reason why some of modified objects have no Version Number at all. Is it possible that Navision 'recompile' some objects and update Modification Date by itself?
-
Error when modifying record on Form
Hello All, I have an error message when I try simply to update the field Shipping Agent Code on a form using the record 36. Here is the error message that I get. Knowing that I'm using a copy of Rec then modifying but still not working. Any suggestions!!!!!
-
Word Templates MS Dynamics NAV 2016
Hello all members, My customer was using NAV 5.0 and style sheet module to manage contract templates based on customer language and other criteria. Honnestly, I don't have any idea on this module, never used it. And now migrating to NAV2016 how should I handle this, using word templates? How can I do that based on specific…
-
Excel import - data distorted in Excel Buffer function
Hi, I'm importing Excel values to NAV and noticed may of the values get distorted... Value in excel stores as say 35.1 is saved to Excel buffer table as 35.100000002 this happens almost for every value. The value in Excel really is 35.01, no rounding issue there of decimal places hidden. This seem to be known issue,…
-
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.