-
Data replication and "Another user has change...". error
Dear Sir, I've written code in a table(Master) for data replication between companies(A,B,C,D) within a single database in NAV 2009. The table structure has a Composite PK, ReadyToUse(Boolean field) and Remarks[Text Field). When User clicks ReadyToUse (TRUE) field the current record is being replicated through allover the…
-
NAV 2015 Cue setup
Does anyone know what the Cue setup setting of 'Subordinate' does in the fields: Low Style Range, Middle Style Range, and High Style range I am not able to find anything on it.
-
Adding Total Button in Form No. 20 General Ledger Entries
One of our user is requesting a Variable Field called 'Total Amount' button on Form no. 20 General ledger entries, whenever user drills down from Chart of accounts to Form no. 20 at the bottom they want to see a Total of Amount field from G/L entry, even if they filter on the Form no. 20 G/L entry the Total amount should…
-
Error when sending email
Hi, I am trying to send email from NAV2009 classic client using codeunit 397 and get this error: Outlook Error: 2700 - An error has occurred while saving the mail item.. I have tried to debug the process, but the error comes from 'NS Outlook Synchronization Handler'.OSendMail automation. Does anybody knows why this error…
-
Danish IOIUBL validation error InvoicePeriod
I have downscaled the objects from "PS53491_DK OIOUBL Electronic Invoices" to a NAV4SP3. But during OIOUBL 2.02 validation test, the created e-Invoice failed with the following error: "The 'urn:oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2:InvoicePeriod' element is not declared" And so did the…
-
Calling a NAV 2009 Webservice from Debian Apache/PHP
I've been trying, for a week now, to connect to a NAV 2009 (no NTLM) Web Service from PHP. I've tried a lot of solutions, even the NTLM ones, but none of it worked. After trying all those solutions, I reverted to something simple (since i get the same errors anyway), hoping you could help me with that : 1/ Connecting to…
-
warehouse mgt and ordering
I have a question regarding warehouse mgt.: Is it possible to order items with a UOM of 'Each' (Qty. per UOM. = 1) and pick it using a warehouse shipment with a UOM of 'Case' (Qty. per UOM = 100). Currently when I try to create a warehouse shipment from an order it doesn't let me change the UOM on the warehouse shipment…
-
Average Cost Calc. Overview
Hello, Please can someone explain to me why the "Output Cost" amount is different from the "Consumption Amount" for the same produced item. The costing method for the item is average 1 Closing Entry 25-10-14 1101001C 0.38 Yes 5,038 8,488.00 -6,596.75 2 Increase 25-10-14 1101001C 0.39 No Output 92,000 0.00 35,634.13…
-
Dataport export boolean error
Hi, There is an issue we've been getting while exporting on dataport. Commonly the issue happens when the data type is Boolean. The results should be Yes|No , but at times the result is "2". Has anyone encountered this and if yes, what is the best solution when exporting? Thanks, Gil
-
Trigger form when changing post
Hi there is a problem with users changing data on item records and I have a request to setup a log to track who changes the data. The log is simple. I lock down the item card with Currform.Editable := false; And then have a button so a user can request edit rights and when pressing I insert a line into log table along with…
-
Table Locking issue while converting the Database
Dear Everyone, We are doing data migration from version 2009 R2 to 2013. After step 1 now we are trying to do the database conversion i.e opening the 2009 database in 2013 . I got the following error. Microsoft Dynamics NAV Development EnvironmentThe G/L Entry table cannot be changed because it is locked by another user.…
-
CreateBook in Excel Buffer Fails only for NAS user
Hello to everybody, I don't know if anyone has ever experienced what I am supposed to describe, but in case so, please come back with your suggestions because it is really driving me insane: Case Scenario: send an excel sheet attached to an email automatically to our internal compliance Team if the process is executed…
-
The Sales Header does not exist after posting invoice or CM
Hi, My customer is using NAV 2009 SP1 Classic Client via Citrix. On the Sales Invoice, after running Post & Print, it prompts error:The Sales Header does not exist. Identification fields and values: Document Type='Invoice',No.='SI0001' Document Type: Invoice, No.: SI0001 SI0001 is the invoice that just got posted and…
-
Dynamics NAV and Outlook 2010 64-bit
Hi guys, Do we have an update/hotfix for using Outlook 64-bit with Dynamics NAV or this is still not supported: > Sending emails from Microsoft Dynamics NAV is compatible with Outlook 2010 32-bit version, but is currently not supported for the 64 bit version. > Outlook Synchronization is compatible with Outlook 2010 32-bit…
-
Item was received in One Dimension n was sold frm another
Hi , I am Facing a issue where in Item was received in X business segment(Dimension) and was sold in from another say Y .It is causing Mismatch in P&L at Business segment level.Now I am not sure its a bug or not.Accounts team feels its a bug. If its not a bug how can I stop it from happening? If its a bug what can I do to…
-
service tax return (Form ST-3) in NAV2013 R2 IN
hello everybody, I am using NAV2013R2, in this version we have not found service Tax Return form, we found only old form - ST3 which is not consider Reverse charges functionality. If Form - ST3 not available then at least required data provide us for filling Form-ST3 Thanks in advance Regard
-
Change Log Management not working
Hello Everyone, One of our clients wants to track all tables associated with G/L Transactions. I have set 'All Fields' for Insert, Modify, Delete for the tables specified above. I have enabled Change Log Activated. I restarted NAV/Company. I tried Creating a SI, and Posted it, but the system did not create entries for G/L…
-
OnGlobalModify.... - EDIT: Change Log does not work
Hello, if i change a record i.e. in table 36, the OnGlobalModify-Trigger in Codeunit 1 is not run through. I am not changing the record by code. I am simply modifying a field in form 42. Is this a bug in version 6.00.30232 or am I doing something wrong? Thank you very much in advance MiSta
-
SOAP with SSL
A webservice i need to access with navision needs certificate authentication and navision also needs to accept the certificate sent by the webservice.Is there a way navision can send and accept a certificate? I saw that WinHttp has a setclientcertificate but when i use that the webservice returns a 'A certificate is…
-
report in PDF per document No.
Hello Experts, I tried to search this topic but couldn't find similar issue & solution so writing this. my requirement is to generate multiple PDF file (1 file per document no.) from a report (lets say Purchase order) by giving range (e.g. PO/14/0001..PO/14/0100). Currently i can print all 100 POs in single PDF file but i…
-
SQL error while Converting the Databse
Dear Everyone, I am doing Data migration from version 2009 to 2013. While converting the Database from 2009 to 2013 , i am getting the attached error for one customized table i.e 'Stock Take' Can any one suggest what has to be done in SQL side ?? I can't open the database in 2009 also, Its giving me 'Table data 200000054…
-
Using the exponential function in NAV
Hi everyone, I am developping a fuction for the need of a customer. The function involves the mathemathic exponential function (exp(x)). http://en.wikipedia.org/wiki/Exponential_function Is there an inner function to do that in NAV? otherwise,what shall I do??? Did anyone encounter this problem?? Thanks in advance :)
-
Problem to run table 32
Hello, I could encounter a problem when running the table 32. Navision (2013 R2) stops working and closes. Here are the details of the problem : Signature du problème : Nom d’événement de problème: DynamicsNavServiceException Signature du problème 01: Microsoft.Dynamics.Nav.Client Signature du problème 02: 7.1.36281.0…
-
Embedding external image in Nav report
Hello, I'm trying to use an embedded image on a "Nav Report". the image is a QR code generated on a local web server. I'm using Nav 2009 SP1 I Just need to retrieve the image using an http request and need to embed it on the report. The server that produces the QR code doesn't need any parameters The request URL is…
-
Slow reports performance NAV2009R2+LS Retail 6.4
there is a case where Navision 2009r2 with LS retail 6.4 is suddenly having a slow performance reporting issue! Reports based on TSE table (size=27GB). Its SQL DB (150GB) , simple recovery mode,where maintenance is frequently running along with update statistics. 32GB RAM Server, Raid 1+0 (6x300GB). Any suggestions?
-
Add field to a table with 20000000 records
Hi, Anyone has a better method to add a fields to a table with 20000000 records? Currently, NAV will take about 2 to 3 hours to add a fields to a table. thank you. regards, rachel
-
Problem in Sales invoice posting
Hi, everyone, I am facing one problem in posting of Sales invoice. When I am posting the invoice, it getting posted but entries not showing in some tables like customer ledger entry, detailed cust. ledger entry and tax entry. Plz help urgently.
-
Filter Suggest Vendor payments by Global dimension
Hi Suggest Vendor payments ignores filters set against Global dimension value. (Using Nav 2009 R2) Does anyone know how to do this without using the Option summarize by Dimension? We do not wish to summarise our payments by dimension just to filter the initial selection of Items for payment by dimension value Thanks for…
-
Limit open IE to one
Hi all, Hope someone can help me with this: In a very special case I want to check if IE (or Chrome or Firefox) is already open when calling HYPERLINK. Is there any way to check if an Explorer is already open?
-
Pentia DIBS automation control
I have a customer, who uses the Pentia DIBS automation control (DIBS.dll) to interface with DIBS, but they have lost the dll-file in a hardware upgrade. Does anybody have a copy of this automation control they can share? I have talked to Pentia, but they only have the DotNet dll and not the automation (COM) dll. However my…