-
Costing Expert Needed
We've recently had problems with our Inventory Valuation report not matching Inventory to G/L Reconcile. In researching, I was able to use the Inventory Valuation report from v4.0 and modify for 3.6 to fix this problem. These reports now match, but have exposed another problem. We now have some inventory items that have a…
-
How can I create a new company in Navision 3.10?
Please help me on how to create a new company using Navision 3.10 (Native) and can I create a new company using a client not a server computer? Thanks in advance................ #-o
-
Is there a schema browser provided for Navision 3.10?
Can anybody help me where can I find schema browser for Navision 3.10. Thanks in advance.......... [-(
-
Service Management - Service Order Query
hi guys, One of our customers is issueing Service Orders where the Service Invoice Lines are marked as non Chargable. What they are asking is when they post this Service Orders if there is way for the program not to create any Sales Invoice (Service) document. The reason for requesting this is because they don't want to…
-
Automated backup options
We are a new NSC and are looking at the options for doing an automated backup. We have done it using hotCopy, but this makes quite a large file because it does an actual copy of the whole DB. The backup function off the Tools menu creates a much smaller file. Is there a way to call that backup function in a batch file so…
-
Report Request Filter help
On the report I have a section based on the Product Group Code table. In the report request form I have added the filter field for Code, problem is that there is no lookup button to easily select the value. In the same report another section is based on the Item Category Code table, the corresponding request filter tab…
-
Codeunit Permissions / Synchronization Management
I have just installed MS-SQL Server 2000 and Navision 3.60 on a new server. I have also added all the latest Service Packs. I created the Database, companies etc, the "sa" user and other users and everytime I try to enter the company that I have created, I get the following error message: "You do not have permission to run…
-
How to show different forms depending numeration
It would want to know if it is possible makes a thing on Sales Order form. In this form, in the field number, I've created a different numeration. I've creacted also a Line Order form with some different fields. I want that when I choose a numeration it shows me the form that I want; Is it posible and how I can do it?.…
-
structure
Hi In the posted purchase invoice u had sructure in that u define excise, cess, fright, .......... Now I am creating sales order In that order if i select any posted purchse invoice i want the same Excise, fright, ces,,.... what ever i define in purchse invoice it should up date in Sales order. How to link to sales order…
-
Placement of alerts seach etc.
Hi I'm having 2 monitors on my desk and running Navision in one of them, but all of the dialog boxes is being placed with one half on each monitor. I try'ed to move the box but it return again, what can i do ? Lars
-
Report doesn't let to print from a print preview.. WHY?
I found that one report doesn't let to print from the print preview.. But I can't find the place, where this feature was determined. Is it a special function or may be report properties?.. I can't find anything. :(
-
Navision 3.10
Hello, I have navision 3.10, and just recently upgraded to SQL Server 2005. Everything works fine, except now I can't create new tables thru the navision client. I get a message stating that 'The ALL permission is deprecated and maintained only for compatibility. It does not imply ALL permissions defined on the entity."…
-
Block variant not whole item?!
Using Navision 3.10. Is there a way to block a variant?! I know you can block a whole Item Number, but we'd like to block just certain colors of an item. For instance last year we were doing some styles of clothing in Brown, Green, Coral, Lime, White, Turq, etc, etc. This year we are not going forward with any Coral or…
-
CASE sentence: Is there a DEFAULT value?
Hi, I'm making a CASE sentence like this: CASE no OF 1: foo(1); 2: foo(20); 3: foo(300); etc... Never mind what the foo() does or why I don't call foo directly with a variation of "no". Is it possible to add a DEFAULT value at the end, in case "no" has another value than the ones listed in the CASE sentence? I will…
-
Lines not refreshed for other users
We implemented a new Navision database at a customer and they face the problem that added lines are not allways refreshed automatically for other users, for example: when a user posts an invoice, and another user opens the posted invoices form, the header of the posted invoice is shown but not the lines. We implemented…
-
Service Access Layer
Whether it is possible to create a service access layer on top of navision to receive the xml/https via web services protocol? And also how to return feed the data after processing the request? Thanks a lot for your replies.
-
Data Ports
How to import xlsheets in data port fields=name,account type,income/balance, datatype will be g/l account how?
-
Permission issue on text export
We are doing an upgrade from Nav 3.10 and ran into an odd thing. I am using a DB login which has the SUPER role assigned and my developer license. (SQL back end) I tried to export an object text file and it starts out fine showing 'Exporting objects...' in the progress meter box, then I get an error indicating I do not…
-
Question on Filtering ?
It's a silly question. But I can' get it working, so I need your help. I have a lot of records in a table with ?(yes, question mark) as the value in one of the fields. How do I filter those records? I tried ?,'?',"?" but none of them work. I know ? is a wild card symbol so may be that is why but there has to be a way to…
-
EBPP Solutions
Is anyone doing EBPP? I'm looking to offer online bill pay and I wanted to get some war stories from others. Thanks.
-
Reading and writing in Attain 360 from external application
Does anybody have some simple code for reading data and modify data in Attain 3.60 from external application? Its not needed to insert records, only modify. Database is running as SQL. Any help?
-
Running a Report with Temporary records
Hi, I have a couple of Temporary variables that I've filled out with all the records I need. I want to run a Report that has as DataItems those two tables, but, how do I tell the Report that it has to run over my temp tables instead of over the real tables?
-
COMMIT for catching exception in IF CU.Run() THEN
Hi, i have a Codeunit 50007 with one function, in this function i try to run the codeunit 80 - "Sales-Post", but i want to control the exceptions of this call to Codeunit 80, so i need to put a COMMIT command (view the code). My question is, the use of the COMMIT could be dangerous? i explain mi question: this COMMIT could…
-
Where to put XML Schema Definition references
Hi, I am generating XML files using the XML Document Manager i Navision Attain. I have to add a local reference to some schema definition files (.xsd). It is not possible to make them available online, which would be the simplest solution. It's probably pretty simple, but I am not sure what to do. Can somebody help me…
-
Printing barcode
I have downloaded in the Mibuso download section "Barcode 128 with fonts" solution. All works ok but when I try to read lenght string > 8 it's fail! Example : 12345678 works but 123456789 NOT! Why this? How I can do it?
-
Navision 3.60 Attain Compatibility
Hi, I have question. Is Navision 3.60 compatible with 1. Windows 2003 2. Citrix Presentation Server 4.5
-
[solved]Error on opening newly created company
Hi, This is on 3.10 Native Nav. The license has unlimited companies. After created a new company(the 11th), user got error "tabledata 14020040 does not exist" on opening of the 11th company. Table 14020040 is payroll setup table and does not exist on 3.10 verison. It was wired to get this error and this never happened in…
-
Strange behaviour for one specific user
Hi, I have a rather frustrating problem. I am working with a workflow, where invoices come in as XML files. The values in the XML file is entered into a temporary table, then validated, and last Navision invoices are created from these data. It works perfectly fine... for me, my collegues, etc. Only one person reports to…
-
[Closed] Filtering on part of primary key results in error
Hi I have a table with three field (w1, w2, w3, all of type code) and the primary key is 'w1,w2,w3'. Field w1 has a tablerelation with organisation, field w2 has a relation with table department. I have a form that displays the records of this table in list form. When I haven't set a filter on any of the field, scrolling…
-
Form Error Message in German Language
I have created a lookup program using Form in Navision Attain. The program work in English Language, but when I switch the Language to German, I'm getting below error message.Die Datumsformel '-1M+CM' sollte eine Zeiteinheit enthalten. Zeiteinheiten sind: T,TW,W,M,Q oder J Die Bedeutung von 'L' ist 'Laufende (Zeiteinheit)'…