-
You do not have permission to modify the codeunit
I have using Nav 2009, I am able to modify the object on the Production server but in the development server using the same license when I try to save any changes in the code unit I modify, it shows the message as "you do not have permission to modify the code unit." I am not creating new code unit, neither modifying the…
-
Update Form from SubForm
I have a form Customer with a field Has Comment(boolean) and a button Comments that opens another form where i can put comments in. When i close the comments form, Has Comments field in my Customer form should be updated but i cant find a way to do it i have tried different triggers on my Customer form using…
-
Some Customer is breaking the line.
Hi Everyone, I am exporting some fields of Customer record, using running report. But, For some Customer, records are breaking the line. I want that it should not break the line. eg. 1, Mohan, City, 394839, selam 2, Sohan, City,39834, Salem here, the Customer no. 2 breaking the line.(In 100 line, approx 4 or 5 record are…
-
Validate Email filed in customer card.
Hi Everyone, I would like to create/validate input mask for "Email" field for customer card(Customer Card-form>Communication-Tab>Email). ie. when user Copy and paste any mail to "Email field" ,and if that contain commas, carriage returns or tabs; Its should show error(remove commas, carriage returns or tabs). I tried this…
-
Printer Selection Doesn't Work After ANY Object Upload!
This issue is killing me now and I have no answer... Hope there is an expert who can help! The problem going like this; My client has define set of userid to report to network printer under NAV4.0 Printer Selection table. It all work fine until recently, now once we upload ANY NAV object into their database (btw the are…
-
How can I Filter a dataset with fields from 2 tables.
Hello, I am a newbie on NAV. Would like to ask for your expertise. Created a form with a TableBox control. also set a table name "A" as its 'SourceTable' properties, in the TableBox I also add 2 fields " B1,B2" which from Table "B", It's OK,but user want to filter the data with B1.B2, Now question is: I can get the filter…
-
copying from one table to another table with existing records
Hi I'm a beginner in Navision and have a quick question, I want to copy records from OtherTempHeader table to rec but rec might have some records already... So far my code looks like this: if not IsEmpty then begin FindLast(); if OtherTempHeader.FindSet() then repeat rec := OtherTempHeader; Insert(); until…
-
Inventory Value
Hi What is the best report to calculate the Inventory Value on a specific date. One consultant points to report 5808 another, says 5801 and while searching online most common is 1001. I tried all 3 and all 3 give a different value? Thanks for your feedback.
-
how to create a duplicate company with all the existing info
Good day, NAV 5.0, can we create a new company and import all existing information from the existing company to that. Tried copy info from, : having issues , getting message accounting period already exists. Also ,no individual entries show up in that. Thanks
-
Line Breaks in export Customer record in Csv format.
Hi Everyone, I am exporting some fields of Customer in Csv format via running report.For some Customer, records are breaking the line. This is the code , I am using to export in report. Customer- OnAfterGetRecord() For almost all Customer record is coming correct but for some customer, record is breaking the line: I…
-
SETFILTER crashes FORM.RUNMODAL ...except it shouldn't!
Hi, so this is the code ChangeLogEntry.SETCURRENTKEY("Table No.","Primary Key Field 1 Value");
ChangeLogEntry.SETFILTER(ChangeLogEntry."Table No.",'287|5050');
ChangeLogEntry.SETRANGE(ChangeLogEntry."Primary Key Field 1 Value",'5618354'); FORM.RUNMODAL(595,ChangeLogEntry); "Table No." is an Integer field. The '287|5050' is…
-
File.CREATE with a relative path ( to desktop )
Can anyone help me with creating a relative path to the current users desktop ? ( i am struggling with the path format ) ... right now i am building an abolute path which works since our windows login is the same as the USERID but i'd rather work with a relative one cheers
-
Upload file and create hyperlink
I have a field in which through the "OnAssistEdit" I would like to be able to call the Windows assistant to select a file, create a hyperlink in the field and take that file to another default folder.
-
Pass Records to XMLPort
Hi there, I'm trying to pass Records as a Parameter to a XMLPort: RefundsXML.SetRecord(RefundsL); TempBlob.Blob.CREATEOUTSTREAM(OutStrL); RefundsXML.SETDESTINATION(OutStrL); RefundsXML.EXPORT; RefundsL contains a few records (depending on the filter). WithRefundsXML.SetRecord(RefundsL); I'm passing them over to a function…
-
data migration from nav 5.0 to business central 365
all, is it possible to export data alone from the tables in navision 5.0 and import to business central. we don't want any reports etc. we have gl entries, bank accounts, vendors, customers, fixed assets. which tables would be export. how do we know which forms are the corresponding ones to the tables. response is highly…
-
Interpay Payment File
Hi All, I'm study how to generate ClieOp03 file from Nav4.0 to Interpay. Please advise if there is any limitation or important issue i should take note. Please advice what kind of file i should generate? is it .csv file? Any member have sample of ClieOp03 file? can i have a copy as reference? Thank you for all advise. [-o<
-
Remove "Override and order stock" permission for some user.
Hi Everyone, I want to remove permission for some user from "Override and order stock" ie. for insufficient inventory item, create order. How can i remove this permission for particular users. As, i am thinking to remove the user that have "Post Item Journal" role permission. Is it good idea? And Some user have SUPER…
-
Open Form 393 - Item Reclass. Journal with predefinied Batch and Template
Hello, I want open the Item Reclass Jnl with code and predefined Template and Batch My code is : But my form is opened in another batch as if SETTABLEVIEW don't work with the form 393 For information the same code works fine with other tables/forms Someone can help me ?
-
Disallow cancellation
hello , I can't cancel Reservation in page Reservation Entry. i have this message error. How i can Cancel Reservation Entry ? Thanks
-
Skip particular codeunit during import from worksheet.
Hi everyone, I want to skip one codeunit during import. But After reading the file, when I select skip in worksheet, its store 100% but after that during processing its not skipping that particular codeunit, its showing the error[Same like, During the comilation of this paticular codeunit]. (Error is: There is not enough…
-
transfer to and from location restriction
I want to restrict transfer To and From location as details mentioned below Have a glimpse of the form given below I have 100 locations. now when initiating a transfer order I want to give permission to users so that user can enter only one permitted location at transfer from location...(may be through security filter) Now…
-
xmlport can't insert barcode in table
Hi everyone, I need to export table data from item/barcodes and item unit of measure table from one store to another. My idea is to always have the same info in this table in both of stores. In order to do this I've created a xmlport to export data to a text file from item table. If table don't have the record it will be…
-
Restoration of Nav 2009 database.
Hi Everyone, I am trying to restoration process for NAV 2009 database using SSMS 2017 version, but I am not able to do. Will you please guide me for NAV 2009 Database restoration, which version of SSMS is suitable. Thanks, Mani.
-
Keeping Nav 2009 / Classic Client alive two more years?
Hi, I hope this is the correct section to post this. We are still running our ERP system in a NAV 2009 / Classic Client Environment. I know that the support for this version has expired and there are no more updates coming. Unfortunately we are in a situation where - considering all options - it would be best to keep the…
-
Set Up NAV 2018 OCR service with Kofax
Hi, I have an interesting topic, which can be useful to automate some manual work, but until now I didn't found any solution to it. The difficulty of setting up OCR service in NAV 2018 with KOFAX. This service theoretically allows me to send to KOFAX documents, like a purchase invoice, it can recognize the information and…
-
NAV Classic Install build 38655
Hello, My first post here - we have an older installer for NAV 2009 R2 - BUILD32012 however. Our database was upgraded to 38655 about a year ago and we moved servers to Azure and then just recently decided to move them to an On prem configuration. But - I cannot get the Job Queues running because the 32012 build for NAS is…
-
Microsoft.Navision.Mail.dll locks attachment file
Hi everyone, I have developed functionality to send sales documents by SMTP mail as PDF attachments. Everything goes fine, but when I want to delete sent files, Navision locks all sent files and these locks remains till Navision client has been closed. Then are files released and can be deleted (moved). Environment: NAV…
-
Date
Hi I'm a developer in NAV 2009 classic. I wonder how I will do if I had a date that says 2018-01-01. Can I change it to 01-01-2018 and still have a Datefield?
-
Hi, I got a problem in roles of SA in microsoft NAV Dynamics with sql server 2009
Hi, I am relatively new to Microsoft Navision 2009. My Company still uses it and wants me to customize it. I have read online that Microsoft Dynamics NAV 2009 Classic with SQL server is the right tool to do that and i am able to connect the database to this software as well. Now upon successful login yesterday, i have…
-
Asynchronous function call
Hi All, I have created a codeunit and published the same with a function that is having a parameter as a text datatype. a third party application is pushing text values to this function asynchronous method. once I receive the text value I am doing some internal customizations for inserting the text values to two other…