-
SMTP setup is not working in nav 2009 R2
dear friends, I am getting an error when i give SMTP server name smtp.gmail.com. User id and password are correct. Please advice..Microsoft Dynamics NAV Classic(0x8004020E): The server rejected the sender address. The server response was: 530 5.7.0 Must issue a STARTTLS command first. c53sm20969672wra.16 - gsmtpOK
-
How to take auto backup in Navision using sql query?
Dear all, I want to know is there any way to take auto backup(.fbk) of navision using sql batch and then run as a service. If there is a way, kindly let me know the steps required for doing this. Thanks in advance. Regards, sekar.
-
Excel Buffer - Creating Multiple Sheets In 1 Workbook
Hi, I'm having a dabble creating a ProcessingOnly Report with the Excel Buffer and am trying to create 2 sheets in the same workbook, each populated from records in a different dataitem. My code is as follows : ExcelBuf Record Excel Buffer(370) Temporary=YesDataItem Name--------- ------------------G/L…
-
Cannot delete user in native server database
We have entered a database user with an empty userid, with only the name filled in. (NAV2009sp1, native server) The user never logged in. Now I try to delete this user but every attempt results in a hanging client. Tried to delete via form, codeunit, report, but nothing works. Can anyone please help me out here?
-
GET function
If a table has the primary key made up of three values, can I use get for only one value? e.g.: PK: (number,name,city). How can I use the GET function if I have only the number? Thank you
-
I/O error DOWNLOAD() function
Hi all, hope some1 can help TempExcelBuffer.CreateBook('Invoices Export'); vTmpFile:=TempExcelBuffer.RetrieveFileLocation; CLEAR(C419); vLocalFileLocation=C419.DownloadTempFile(vtempfile) Im trying to -Create excel book -Get the tmp file created by a custom function "retrieveFilelocation" -Pass to C419 so it gets me the…
-
How do I add field data from a table, to an exported file name?
I am working with a table and form which work as import/export engines when objects in NAV are run. From either table or form, the name of an exported file can be specified by text. I would like to have the file name include a field value from another table. I have tried to do this as a variable, but I do not know how to.…
-
Requisition Worksheet changes released purchase orders
Hi :) I have a small question about the requisition worksheet. I already searched the forums but I couldn´t find a solution. Please imagine the following situation... We are producing some goods in China (up to 5 levels). We are using the Planning Worksheet for MPS/MRP (combined). Input for this worksheet are sales orders…
-
Setrange with another table
How can I filter a table based on a set of values of another and different table? for example. Table1.setrange(name, "peu*"); Table2.setrange(name,Table1.name)... Thank you!
-
Prepayment Credit Memo Posting Date
We created a prepayment invoice from a Sales order In 09/2016 that was paid by the customer. Now in 04/2017 they have decided to cancel the order altogether. If I do a prepayment credit memo, it automatically posts it to 09/2016. This causes a problem because that is in a prior period that has already been closed. I need…
-
Item Unit Cost is very high
Hey there, One of our customers has an item that has consistently cost between 51 and 52 dollars per Base UOM. Over the weekend, after cost adjustment ran (as per usual) the Unit Cost for this item has exploded to 12,175.53191 per Base UOM. This is astronomical to say the least. The item uses FIFO costing, and at the…
-
How to remove characters from a string
Hi everybody! I have to delete a character from a string. My aim is to remove the _ from a string if the last char is a # for example: from "myText_#" to "myText#". "myText" is a string with variable lenght... Can anybody help me? Thank you!
-
Unrealized Tax Type in Tax Posting Setup
Dear expert I tried to search but was unable to find any information. Any suggestion would be appreciated. Unrealized Tax Type in Tax Posting Setup page has an option called Cash Basis. No help information about when this option should be utilized. Would you please let me know when Cash Basis should be selected and what is…
-
Dynamics Nav 2009 upgrade change company problem
Hi The company I work for has finally decided to upgrade our Dynamics Nav, currently we are at 2009R2 runtime with 5.0 (SP1) objects. We have many custom reports and I would like to know how many are actually used. I read that you could create a function (OnReportRun ID = 120) in codeunit 1 and this function would be…
-
Inventory to G/L Reconcile report (Report 10138)
Hi all, can someone help me ? I try to find report 10138 for version Nav 2009 R2 I know that report can be find in Cronus NA - North American version (USA, Canada and Mexico). But I can not find backup database Cronus NA - North American version (USA, Canada and Mexico) for Nav 2009 R2
-
Error when opening Excel workbook in NAS
NAV2009SP1 classic. I've created a codeunit which opens an Excel file, do some things and closes the excel file. This is running correcty, but not when I run this codeunit from a NAS. Just to isolate the problem i've create a new codeunit with the following code in the OnRun trigger…
-
Bank Payment Entry error
I have entered Payment Journal entry but error will come Account no. B001 (Bank Code) is not defined as bank Account for the voucher sub type bank payment book & document no. BP10000 (No.)' HOw to solve this error.
-
Reports - ProcessingOnly property
Hi! I have about 300 new reports in my nav database and I need to write down the names of only those that are not ProcessingOnly. Do you know any smart way how to do this quick? Can I filter my new reports somehow? It'll take some time to check every single new report. I'll appreciate any clues! :)
-
You do not have permission to read the Base Calendar Change
I'm fairly new to Nav and I've hit a problem setting up a db. When I enter purchase/order processing/invoices and try to add a line to an invoice of type G/L Account I get an error message 'You do not have permission to read the Base Calendar Change table'. Now I am doing this with the administrator account, which has the…
-
Add.Column Explanation
Hi, I don't understand how it Works this from REPORT 6 ExcelBuf.AddColumn( "G/L Account".Name,FALSE,'',"G/L Account"."Account Type" <> "G/L Account"."Account Type"::Posting, FALSE,FALSE,'@') Which are the parameters of addColumn? Thanks.
-
Transactional Operation
Hi, i am a new user on the forum, and i have a doubt about de transactions. I have some problems with registers.I understanding that i do more than one operation in a Code Unit, this will be transactional and unitary, but for example if i use the Code unit 13(Gen. Jnl.-Post Batch), in the end there is a commit then if…
-
NAV Classic Client and Excel 2016
Can export Excel from NAV to Excel 2010 but fails now that Excel 2016 is installed. Is it possible to integrate Excel/Word 2016 with NAV 5.0?
-
How to run multiple REPORTS in one REPORT
Hi all!! I need to run multiple reports in one report. First I create a new report blank, then I change the property of the report to (ProcessingOnly = TRUE) and last I put in the C/AL code: Report - OnPreReport() REPORT.RUN(10706); But nothing happends. (I try too with ProcessingOnly = TRUE). Thanks!!
-
Can I use FINDLAST function on date and time?
Hello guys, I have a question. I have to attach the last modify user's signature on report so l check it by this .. "ApprovalEntry" keeps the last Entry No. of Approval Entry that filtered by Sales Quotation No. and status = Released. we had no problem until this below happened by Last Date-Time modified Entry No. 2380 was…
-
Lot Sizes
Hi, I'm looking for some advice on using Lot Sizes. My client can setup a machine once and pass six different products through the machine at once. How should the lot sizes be setup on each of the six items? The production orders for each of the six items will be for one unit. So, if we set the lot size at six for each…
-
Undo whs. shipment
There were made Sales Shipment from Sales order.....then we moved to the Advanced Warehousing - with Directed Put-away / pick. And then it is created Undo to that shipment document, witch were booked before moving ... In result product appearing in stock but does not appear in any binary ... it is also the main problem ...…
-
Error on a simple inventory count import
Hi all, Can someone please tell me why my code would error out on CU 5402 UOM Mgmt, specifically at the Item.Testfield("No.) line under GetQtyPerUnitofMeasure function? Below is my code to import 6 columns of data: locationcode,item,variantcode,qty,UOM,BusinessEntity. I already set up a Item Journal template called Item…
-
Service Contract Line Value based on Currency Code
Hi, The Currency Code on Service Contract header is the code in which the amount value on the document related to this contract will be converted and NOT the code in which the Line Value on the Service Contract subform is to be entered. Am i right? One of my client has a requirement that he needs to manually do the…
-
Automate Backup of 2009 native database
Hi I have one client that is still running on the 2009 native database. They will be upgrading in January to 2017. Till now I have been using HotCopy which works well but the file size after compression is 2.5gb. A compressed fbk is only 161mb. I would like to automate the FBK backups and upload them to the cloud. There is…
-
C# COM dll - Could not create an instance of the OLE control or Automation server
Hello, I'm developing a report for Navision 2009 SP1, where the need for extra functionality unavailable in NAV has arisen. I have created a COM dll in C#, installed it and created an automation variable in NAV. When I try to CREATE it, I get the following error: "Could not create an instance of the OLE control or…