-
RG 23 A Part II
Hi all, I am facing a problem related RG records. When I post purchase order only receive function then create RG 23 A Part I & II record. Now I Post two invoices against Purchase receipt then RG 23 A part II amount gone to debited I am not understanting that issue please anyone have related query then suggest me.
-
Navision Backup Error
dear friends, i have faced Navision backup time checksum error: The error is Microsoft Dynamics NAV ClassicThe following SQL Server error or errors occurred when accessing the Transfer Receipt Line table: 824,"HY000",[Microsoft][ODBC SQL Server Driver][SQL Server]SQL Server detected a logical consistency-based I/O error:…
-
Current Stock Position in Web Service
Hi, I am very new to Dynamics NAV. I want to create a webservice which will accept a item No and location code as filter and will return the available stock position of the Item. Please help me, how should I achieve the requirement. Thanks in advance. Kishore
-
My license doesn't permit me to, but is there a way...
Nav 3.10A. My license doesn't allow me to change the length of a field on the customer card. There's the main customer card with an E-Mail field. The field is Text80.. puhlenty of space for email address. There's also a tab with Contacts where we can enter more emails. For some reason they made that length only Text30.…
-
Windows 7 opening multiple copies of Navision
Has anyone ever seen this before? I have Nav 3.10A. I have a few people in the office who use Windows 7 and a few of us are still on XP. Windows 7 uses Virtual Machine. One lady in the office had this problem twice. I don't know the cause of the problem. Nor do I know what solution was last time as our Network Consultant…
-
Exploding BOM Destroys Sale Price
Hi, I'm the new product manager in my office, and we are running Navision 2.50. We have a newer version on the way, but in the meantime, I'm having some trouble with BOM's. I want to create a bundled item, such that customers can buy a package and get a deal. I have no trouble building the BOM, however when sales tries to…
-
There is not sufficient space available in database
Please guys can anyone assist to solve this problem. I try to login to Dynamics Nav I get this error attached. Please it is a bit urgent. Thanks in advance.
-
Developer License issue
Dear Team, One of our prospects have a database with Tables and Forms created in 130000 series. Since I was thinking till date that Tables/Forms/Reports/Data Ports/Code Units can be created only from 50000 to 99999 by Microsoft Partner. We cannot able to access the customization or design screen with our developer license,…
-
Insert data through SQL
Hi everyone, Part of the codes//Create client on another server SetupIntra1.RESET; SetupIntra1.SETRANGE("Main Server",FALSE); SetupIntra1.SETRANGE("Create Client",TRUE); IF SetupIntra1.FINDFIRST THEN REPEAT ServerName := SetupIntra1."Server IP"; NavDB := SetupIntra1."Database Name"; Companytxt:=SetupIntra1."Company Name";…
-
RUN MODAL error
Dear all, Error as per the image attached appears while running a batch or selecting a customer in Sales Invoice. Kindly advice required on the same.
-
Filter in report by post code with letters or without.
Should I create a filter by post code, but sometimes from beginning is letters, but sometimes not. How to use in filter only numbers? I need to find out Customers by post code (for example) NO-2100 and 5010. For me usable is only numbers like 2100 and 5010 - how to "delete" this "NO-"? p.s. Sometimes post code will be…
-
Database Backup restoring Issue
while restoring Nav Backup 2009 I am getting following error kindly advise on the same
-
NAS
Can anyone give link to easily knowing about NAS
-
Item qty received wrong
Nav 3.10.. not sure if someone can help this, because some of the you might not have part of my features, but I'll ask anyway. We have an item in Navision.. it was entered on an Purchases & Payables -> Orders. Somehow the Variant must have got deleted. So, on the Item Card it shows 318 in stock, but if you open up that…
-
Sorting not by alphabet?
Nav 3.10.. I don't think this is doable, but not sure. I have a report that shows Items, Colors, and Sizes. I know this is something people don't have but hear me out and maybe you know if it's doable or not. The problem with the report is that it does DataItemTableView SORTING(Item No.,Color Code,Size Code) -- it sorts by…
-
Zip/Compress files in C/SIDE
I would have to compress all files within a specific folder. Does anyone know how I can do this from within Navision C/SIDE. May be there is some kind of OCX or Automation Server I can use. I thought of using pkzip in a SHELL-command, but isn't there a better solution?
-
Nav 2013 License issues
Hello :) anyone just shred some light on 2013NAV license.In this we get limited user and full user license.if we have total 10 license(6 full access and 4 limited access).My question is where do we define these user rights??Thank you :)
-
read data from a database
[Some non-English text removed by Administrator] NavAdoConnection (Automation) 'Microsoft ActiveX Data Objects 2.8 Library'.Connection OConnection (Text ) 250 OSql (Text) 250 NavRec (Automation ) 'Microsoft ActiveX Data Objects 2.8 Library'.Recordset Puis voici le code à utiliser : // Connexion à la base de données.…
-
Image in RDLC report
Hello all, I need to convert a report from classic to RTC. But I have one problem. Image on Header is not show first page in RTC. But it is show next page in RTC and when I printed first page has image. Only preview first page is not show me. What happened? Please help. find attach picture
-
Convert a Code type to Text type
Hello All, I have one problem. When I export a report to excel, G/L account with code data type is converted into text. but result is wrong. What should I do? Please help me? Example: G/L account No. is 2-2200(code type) -> exported to excel G/L account is 109606 I used to export into excel "excel buffer table"
-
Insert data into NAV from another SQL db
Hi everyone, i would like to read data from an sql database - non nav db (X) from server (Y) and insert it in a nav sql db (Z). can anybody help from where i should start. i have already tried these but in vain http://dynamicsuser.net/blogs/waldo/arc ... s-nav.aspx http://erpnav.blogspot.fr/
-
Report based on a temporary table
Hi guys, i have a temporary table which am modifying and i want to get a report out of the values in it,is it possible?
-
Printer when Navision is calling word for merging of letters
-
Counting records
Hello all, I can count lines in the OnPostSection trigger of groupfooter. But I have to transfer it into DataItem trigger. because I need convert into RDLC report. I tried this issue. but it is counting all records. DataItem-OnAfterGetRecord() line:=line+1; How can I count lines on groupfooter in DataItem trigger?
-
Creating and updating Purch.Comment Lines using Web services
Hi, i consumed Purch.commenline page as a web service ,i am able to create and update Purch commentline page using web service based on the document type ,document no and Document Line No but when i am creating multiple lines it is giving Soap Exception Purch.comment line already exists for the particular document type…
-
Button not printing correct item..
Navision 3.10 Sales & Receivables -> Orders. On the print button there's stuff to print Picking Sheet, Sales Order, etc. I didn't want to mess with one of the reports, so I copied it and modified it. I went into the Menu Items of the Print button to add my report there, but it doesn't populate the No. For example, if I am…
-
Error in report "Date AND Integer"
Hi all, We have a problem in a report with Attain 3.01A, we have the report up and running fine, but now wants to add a filter. IF Orderoperation.Startdate = 0D AND SH."No. Printed" > 0 THEN CurrReport.SKIP; we have tried "Startdate" for itself and it works and the "No. Printed" also works when it stand alone. ? it comes…
-
Item Application Entries missing in 3.10
I am working with a 3.10 database that has missing Item Application Entries. The issue seems to be the same as a documented bug in 3.70 where under certain situations the ILE was applied correctly, but only one Application entry is made (the positive one) this means that the Inventory valuation report is a mess. There was…
-
Upgrade to NAV2013
I need to upgrade a version 5.0 database to NAV2013. To upgrade to NAV 2013, I believe I have to first upgrade the database to NAV2009R2 for all objects and then to NAV2013. However, my database does not have any customization in standard objects. Only a couple custom tables,forms and reports which I can recreate the…
-
Customer sales group
I have two Sell-To Customers with one Bill-To Customer and problem is - how to set up different sales prices for each Sell-To?