-
Check Value in External Document inside General Journal if its existing in GL Entry (posted) or Not
Dear guys, i need to make code to check value for External Document No. in enter the value in journals or while posting the journal line to checks the value if its already posted in G/L Entry or not. Best Regards,
-
Moving files from network drive(Only accessible on client) to locally (on server).
Hi. I'm currently trying to browse a network drive to attach some files to a mail. Currently I'm using the DotNet System.Object and System.IO.Directory and System.Collections.Generic.List to find the filepaths in the following way: SysObj := SysDir.GetFiles(DirectoryPath); SysList := SysList.List; SysList.AddRange(SysObj);…
-
Transfer Nav Exported file to Website.
Hi All, I have exported a Customers details to my location and the process will continuously run for everyday automatically with the help of the Job queue. I have completed this. Now I want to extract the information from NAV and transported to Website. Can you please guide me to transfer the exported file to Website...…
-
Problem email attachment
Hello, in NAV 2009 when I try to send a quote my quote goes to attachment not the email body.When I click Print then preview>>>file>>>send >>>Report by Email I see the quote in the email attachment but I want to the quote in email body. How do I do this?
-
UK - HMRC - MTD Making Tax Digital
Hi, we have to submit our UK VAT returns via MTD to HMRC. Is there a good way to do this via MS Dynamics 2009 R2? Is there a possiblity doing this out of the box or is an addon required? Do we need an external software?
-
is the runtime of global variables always the entire session?
EDIT: So i have debugged a little bit and even though i have declared the variables globally , as soon as i leave the codeunit by calling another codeunit and try to use the getfunction , everything is unitialised according to this post…
-
Decimal Values not exported !!
Hi All, I have created a process only report to export Cust. Ledger Entry table details as CSV. Here Customer no, Name, Posting date is exported correctly. But, Decimal values (like Amount, Remaining Amount)exported as Zero. I don't know why these decimal values are not exported... Please suggest me some idea to export the…
-
Client sessions returns error "the connection to the server is no longer responding"
This is occurring with a job is running on the job schedular at around the same time that a back up is running on the SQL server. Is there a timeout setting that can be adjusted to allow for a possible slow response when the backup is running.
-
Export Customers as a CSV file using Codeunit or Report
Hi All, I want to export customers as a CSV file using Jobqueue. Can you please provide me a piece of advice, whether i am creating code unit or report to run a jobqueue. If it's possible through codeunit or report, please suggest me some piece of code to export a CSV file. Thanks in advance, Jacob.A
-
Event Id : 20010. The date is not valid.
Hi All, I have created a Jobqueue. And try to run this through NAS. But if I am trying this I got the below warning in Event viewer log as Event Id : 20010. The date is not valid. Can you please help me to resolve this issue. Thanks in advance, Jacob.A
-
the sign does not correspond with the outstanding entry :S
Hi, If I do a proposal entrie for a bank account I get the error message "the sign does not correspond with the outstanding entry" Please help :S
-
Adding validation in Purchase Order
Hello All, Is it possible to add validation in Purchase Order, if GRN Posted on particular Purchase Order then the system should not be allowed to reopen or modify Purchase Order. Thanks in advance.
-
TableData 2000000002 does not exist error
Hi What is TableData 2000000002 does not exist error in Navision 2009 R2 Thanks
-
Digital signature on the invoice.
we are doing signature by hand on the invoice hard copy. can be possible digital signature on the Invoice copy? ERP2016
-
Week Setup Nav 2009
Hello, How can I setup week in Nav 2009 from Sunday to Saturday? Currently, it is Monday to Sunday. We are using LS Retail Nav 2009 (Version W1 6.00) Thanks in advance Prasoothan
-
Automatic posting date to be changed user-wise
while posting, system takes today's date as per setup in the "general ledger setup". our few user need yesterday's date or few need 1 week back date. how can be possible? can you help us?
-
Getting error while running a Jobqueue via Jobqueue dispatcher code unit
Hi All, in NAV 2009,I am getting a below error while running a Jobqueue via Jobqueue dispatcher code unit(448) Microsoft Dynamics NAV ClassicThis message is for C/AL programmers: Could not create an instance of the OLE control or Automation server identified by GUID={3B311C81-140E-11D5-8B18-00D0590B4EC5}…
-
How can I remove a lookup?
LookupMood is Already NO FormID is empty too
-
How to Skip the first column from importing Csv via Dataport
Hi All, I have created a dataport with some fields to import.It was working properly. But now,some unwanted data is there in my import file's first column(csv file which ready to import). So, i want to skip the first column without affecting the import file. Please suggest me some code or steps to implement this... Thanks…
-
Can be Possible to give print command for 500 Nos Invoice which are in the sequence 001 to 500
Can be Possible to give print command for 500 Nos Invoice which are in the sequence 001 to 500
-
Print shorcut key ctrl+p don't work as page action
Hi everyone, So I want to print my current page of vendors or items and I press ctrl+p and prints what I want. But If i create a page action with shorcutkey "ctrl+p" this don't work... there is no simple way of doing this without creating report?
-
Jobqueue is not starting
Hi All, I have set the jobqueue for codeunit object and make the status as 'Ready'. I have given the service's setupparameter as JOBQUEUE in registry editor. But its not starting .. Please suggest me some ways, Thanks in advance, Jacob A.
-
Making Tax Digital (MTD)
Hi, I am thinking to make a Making Tax Digital (MTD) solution on NAV 2009 classic as well as in excel and may be an app to submit vat returns via phone some work is already done like calling hello world. Do I need client id and token, I put my client id and token on NAV 2017, it does not work, I believe it is Microsoft…
-
Need Navision.Mail DLL version 7.3.0.1
Hi All, I am working on a NAV project and I need the Navision.Mail DLL, version 7.3.0.1. This was available as a hotfix from Microsoft, but it was taken down. I can’t find it anywhere on the internet. If you happen to have it can you please send me the DLL and the TLB files? I need this specific version, because it’s the…
-
Export a last 6 months records.
Hi All, I have created a Dataport with 'Cust. Ledger Entry'.I want to export the last 6-month invoice records. Can you please suggest me some code to retrieve last 6 months records. Thanks in advance, Jacob A.
-
Get the file path from Sales and Recievable setup field for Dataport export.
Hi all, I have exported customers as a CSV file with the help of Dataport. Here I have to give the path for the file to export. But, I want to get the file path from a 'Sales and Receivables Setup' table's field (I have created one field called 'file path' in 'Sales and Receivable setup' table). So how to code to get the…
-
Filtering value on the report using dataitem
Hi Guys, I have a issue on report filtering data using dataitem. I 'm not sure that NAV will support it. Could you give some advices? Example: I have the report as below: I want filter the value of No. base on the Account Type. Ex: If I select Account Type = "Posting", No. only show value has Account Type = "Posting"…
-
Adding BLOB image to JSon request
Hello professionals, I'm trying to add BLOB image to JSon request send to API. First of all I'm converting that photo to BigInteger and after that it's converted into base64string. APIUploadProductImage(ProductID : Text) CLEAR(ImageBigText); recItem.SETRANGE(recItem."No.", '10000'); IF recItem.FINDFIRST THEN BEGIN…
-
NAV 5.0 | Report queue
Hey there, I am trying to implement a Report queue. I allready have my Reports (f. e. Invoice), which work well so far. But in case, the "Document Date" is in future, I don't want the Report to be printed. The Report should be printed (or run), when the Document Date <= TODAY. What is done so far: There is a table In my…
-
Lot 4 Lot and Safety Stcok
Hi All In the context of using MRP and the Planning Worksheet is anyone using Lot 4 Lot and Safety Stocks to successfully manage inventory of purchased items? The issuer is after placing an order to re3plenish the safety stocks MRP responds by suggesting cancellation of the order and a new order raised for immediate…