-
What are these tables: [Company Europe$75832$1]
We use Nav3.6 since 2003 and use it for the administration of 7 companies. From 2003 to 2009 the size of the SQL Server 2000 database grew from 0 GB to 55GB. Since 2009 it grew to 160 GB. It seems that the number of tables with unclear names [Company Europe$75832$1] has grown significant the last few years. There are now…
-
Call to member send failed
I am using the XMLHTTP class of Microsoft XML V6 to do a SOAP send. When I execute it via the classic client it works fine but via the RTC I get the message "The call to member send failed: System error: -1072896763" This error occurs whether or not the server is on the same machine. I have searched but cant find any clue…
-
Adding Salesperson Code to Item Card?
Salesperson Code is on Customer Card. It's a drop down box with a list of choices. I can get a custom field for Salesperson Code onto my Item Card, but how do I get it to be a drop down box with a list of choices? I can get the little arrow to show up, but never opens up anything listing Salesperson. Someone requested this…
-
print a rotated image in a report
Im going to print a barcode image created by navibar. But how do I rotate the image 90 degrees? procedure: create the barcode image with navibar <= OK rotate the the image <= HOW? import the image into the database <= OK use the image in reports <= almost OK Any ideas how to rotate it?
-
Date format in code.
How to fill this place in the code (???), if c/al Globals has date format? IF ProductionOrderHeader."Outstanding Quantity" = 0 THEN Prod_FSC_Date := ProductionOrderHeader_FSC."Available Date" ELSE Prod_FSC_Date := ???; I inserted this: Prod_FSC_Date := ''; but then i get error, because it is date format.
-
Want to Run Report using NAS
We want to run Report using NAS in LS Retail 4.0. We have created one new job. We keep Object Type as "Report" & Object NO as "Report No" My NAS service is working fine but my report is not running. Please suggest any new modifications in single instance CodeUnit : 99001469(NAS Scheduler Service) or Codunit 1 or any new…
-
Patch Update
Hi All, How to update a patch in client database. Is it have to be done through Dev Kit or Arixs Merge. What are the steps to follow. Please Suggest Dev
-
Entries created by system
Hi all, Can you please help me out to give an explanation to one of my client. When reversing an invoice, system is generating 2 additional entries, which i cannot explain why. - Picture 1 The amount is the difference in unit cost * Quantity. - Picture 2 Expand Type Valuation Date Item No. Unit Cost Cost is Adjusted Entry…
-
Does Nav 3.10 need Virtual Machine on Win 7 machine?
First off, haven't been here in awhile. Hope everyone is well and had a good holiday. Should Navision 3.10 need Virtual Machine to run on Windows 7? I am just wondering because we had a computer die. Our computers were all on Windows XP Pro, but we have three computers now that run Windows 7. Navision is installed on an…
-
Marker field in SalesLine
How to mark Marker field from SalesLine in C/AL code. Fow example: IF "Sales Invoice Line".Marker = yes THEN... Which is correct: 1) yes 2) on 3) ...
-
Error message:
Hi everyone I have created a field Bar code on the Item table(27) of code 20. On validate of the Bar code field, i have put below codes: ItemCrossReference.SETCURRENTKEY("Item No.","Cross-Reference No."); IF ItemCrossReference.GET(Rec."No.",xRec."Barcode No.") THEN BEGIN RENAME(ItemCrossReference."Item…
-
The operating system returned the error (1450)
This is an old system runnign a C/Side 3.60 database with 5.0 SP1 cleints. The users have been reporting random occurences of the above error. I've finallly been able to isolate the problem to a set of what appears to be corrupt records in the Sales Line table. A test of the secondary keys succeeds. A test of the primary…
-
how to do a double filter
Hi everybody, i have a problem and i don't know how to resolve it. I want to do this : RECORD.SETFILTER(FIELD1,FIELD2,'=%1|=%2',VALUE1, VALUe2); This code is impossible to do in Navision but nobody knows how can i do this code in different way. Thanks a lot. :wink:
-
Problem with msxml3.dll
Hi guys, When I try to assign a password for a user on e-commerce or when I try to post some acknowledgments, the follow error appears: This message is for C/AL programmers: The call to member save failed. msxml3.dll returned the following message: The system cannot find the path specified. This problem is happen on my…
-
Get Temporary Record Filters in a Form
a running a report that processes and opens a form with temporary records. can i be able to get temporary records filter in the form?
-
Arabic Language
Hi everyone, Can you please guide me as to where i can download the Arabic Language module for NAV 2009 R2. thanks.
-
Navision automation variable parameter problem
Hello Everyone, I need your help. We have a COM object registered for our Navision system. It has a method that accepts two parameters: The first parameter is a string, the 2nd parameter is an integer. However, when I use the following code snippet, it pops up a message box as shown below at compile time IF ISCLEAR(MyObj)…
-
Microsoft Common Dialog Control 6.0 (SP3)
I imported some tables (from text format) and when i complile I receive the following error message: "This message is for C/AL programmers: The OLE control or Automation Server identified by 'Microsoft Common Dialog Control 6.0 (SP3)' .CommonDialog Requires a design time license. This license cannot be obtained. Make sure…
-
get data from external DB?
Hi, Navision Attain 3.1 - Native DB - with GoPro. Its required and at the time of POS sales, to validate certain criteria from an intermediate SQL DB. How can we do this? or what options are available? thanks
-
Logo in the report to Excel
Hello Everybody I m new to Navision.I have a report in which logo of the company is there.When I m Exporting the report to the Excel using Excel Buffer table,then logo is not exported. Can anyone give me some idea.... Thanx.
-
Can't post transfer order with tracking
Hi there, Still working on one 3.60 db, which obviously has a bug in handling tracking. The case is this: I posted shipment part of transfer order, but now I can't post receipt. I get a message "Qty. to Handle (Base) must be 4,5 in Tracking Specification Entry No.='1'.", I did some code review and the problem seem to be…
-
Windows Authentication failed
Hi Everybody! I have difficult situation with Windows authentication. I’m trying to resolve the issue for already a month, but still no results. I have tried to explain the problem as detailed as possible. I have Navision 3.60 server with native database. Before a month ago – the situation was following: - server is in…
-
Close By Entry Field on the Cust. Ledger Entry Table
I am querying a problem that I have replicated in both 3.10 and 3.70 where based off how a payment is allocated to an invoice, I have found instances where the Close By Entry, Close by Date, Close by Amount are all left blank when you look at the entries in the Cust. Ledg Entry Table. The method i am using to allocate…
-
Okidata 320 compatibility
Hi there, I am trying to find out what versions of navision are compatible for okidata 320. Do you know where i can get a list of compatible printers/devices for nav? Thanks in advance.
-
I need some documentation
Sorry for my english I am a beginner in Navision in the development. Especially in the creation of form in connection with tables. For example, I can not create a control that I will open the Customer table so I can choose the right customer. Does anyone have documentation to guide me? If it is in French, it's even better.…
-
Production BOM and Item card Bill of Material
I was trying to use the BOM Journal and it is filtering on items that have the BOM checked. We do not use these BOMS we use the Production BOMS for the manufacturing module. So do these 2 link? that is the purpose of both of them?
-
Item - UOM : autofill doesn't work in RTC
Suppose an Item with 3 UOM codes : PCE, BOX, EMB24 To select PCE, type "P" in FLD Sales UOP and then TAB to go to next field... You get an error "The Item Unit of Measure doesn't exist" NAV is looking for "P"... In the Classic Client, it works correctly, you type 'P' + TAB and the field is loaded with 'PCE'. Is it a way to…
-
What does the "Search Name" field actually do?
What does Search Name field actually do on a Customer Card? I was noticing some of the Name and Search Name were not the same. I've been looking and whenever I change Name, the field Search Name also gets updated. I'm unsure what others are doing that it doesn't get updated. Not that I'd go fix them all, there's a lot…
-
Matrix column
I am working with matrix column..I trying to do show the invoice amount and quantity monthly wise. In Matrix Header i set the jan to dec for the particular Year. What my question is can i set the both amount & quantity values in same Matrix header values.can anyone give the suggestion. For Example, No. Jan Feb March Amount…
-
Navision & SQL permission question
Hi, I've manually set up a user "report" with datareader access on Navision database in SQL2000. Time to time this user gets removed from this database "logins" and after that looses all access. Question: does Navision have some internal cleanup routine to remove all users which are not assigned using Navision UI? Maybe…