-
Excel Macro Sample retrieving Navision Data
Hi there, anyone having excel macro sample code for retrieving Navision table record using ODBC. Thanks. BHT
-
Stock Keeping Units
Hello, Would someone be able to tell me what a Stock Keeping Unit is and what they are used for? - I always thought SKU's were like an extension of the item card. Thanks! :)
-
French Implementation of Navision
Hi all, Well i am implenting navision at a french client. since some of the processes are different from the english one, would very much appreciate sme help. I have a AllFR4.00Protected database, and would like to see how the Bank Account Reconciliation Report works behind. thankx
-
Database Test output to disk file or printer
Does anyone know how to pipe the results of a Navision 3.6 database test to either a disk file or a printer ?
-
SQL server: SA user-id login
All, today we had an issue with the user-id SA as it was blocking all the other users in the DB, then it came to my mind that SA is always logged in to SQL server but it is not clear to me the reason for those session opened to the master DB. Could anyway through some light over topic? Thanks, Ch.
-
fin.exe/Navision problem..
We use Navision and it shows our version is 3.10.A One of the ladies here opens an order in Navision, selects to print to Acrobat PDF. It gives us the message that fin.exe has created an error. The program will need to be restarted. We click OK and it closes Navision. Any ideas of what we should do?! This has been working…
-
2 reports, one trigger
firstly, can i say thank you for all your previous help on here! im actually *enjoying* working on our development server! as part of our item setup, we have various indicators for different things. one of these is an option - say ,a,b,c and i want to trigger a report using this. i am planning on bringing this field though…
-
Create Instance of TextStream
Hello Everybody, In navision, how file system is used.I mean to say how instances of 'Microsoft scripting Runtime' classes.Actually I want to access text files through navision.I m able to create the files but cann't access them.I want to read,write and copy etc. in the files thru navision. Anyone having idea... thanx.
-
FIFO to Standard
How can I change Costing method from 'FIFO' to 'Standard' if I have more than one entries in ledger entries for those records.
-
Find First Record - Label Report
I am creating a label report (based on Report 110 - customer labels) which looks at the Ship-To Address Table. The report will be run by filtering on the ship to table postcode, and the labels will contain the customer address. This works fine however, as customers will have multiple ship-tos, I will receive mulitple…
-
UK Based Navision Re-seller/Support/Training
Hi, I would like some advice on a good Navision Re-Seller/support/training consultancy. We are running Attain 3.6 on SQL server and previously had it set up by a german company. We would like a local point of contact (preferably local to London) for support, training and poss development. If any UK based Navision users…
-
XML-Command to create a '<IDOC BEGIN="1">' n
I am searching for a command which generates a node like: '<IDOC BEGIN="1">'. There are always problems with blanks and special characters if you use "CurrNode.ownerDocument.createNode".
-
FlowFields problem?
I have problem. I do not understand FlowFields. Can somebody explain me. (Ako ima neko da zna srpski, hrvatski..., bilo bi ekstra.) Thanks to all.
-
Credit Memos calculating tax incorrectly
Wondering if anyone has seen this and already and knows of an easy way to fix. I'm guessing this is occuring in codeunit 398 (sales tax calculate). I've noticed where a credit memo will get posted, let's say a month after the original invoice, and instead of calculating sales tax off of the original posting date from the…
-
Navision Attain 3.6 to 4.0 SP1 Executables (Roles/Perm..)
Hey! I needed to upgrade the customers executables from Attain 3.6 to MBS-N 4.0 SP1 to get the ODBC communicate with there .NET Web application. After doing so I encountered some problems regarding roles and permissions. I thought that wouldn't happen since all the objects are the same, except some obviously. In the role…
-
Navision Online help: ActiveX problem
Hello, we are working with Navision over TerminalServer on W2003 server. Our users get a warning whenever they try to open any chapter/topic of the online help, a warning pops-up. It seems to be linked to the registration of the ActiveX controls used by the help, however, how many ActiveX controls could we find in a…
-
Application Management Codeunit Cached?
I have an odd error where I've put a hook into the LogInStart function in Codeunit 1 (Application Management). This was for a custom idle session handling solution. I trapped the code for errors as follows:IF IdleHandler.RUN() THEN; //trap for any errors I appended this section of code to the end of the function as an…
-
Lotus Notes and Attain
What actually works when using Notes instead of Outlook. The simple E-Mail buttons in the contact and customer cards? The mail-merge if having Word installed? Word uses mapi, so it should work? And which requirements does it have? Anything special needs to be installed or configured? Can anything be solved by having…
-
The last date of the month
How to find the last date of the any month?
-
Year End Close
We currently have our General Ledger configured with [Global Dimension 1] as Profit Center and then G_L Account. As a result of this settings, we would have a G_L Account that would be used by multiple Profit Center When we do a Year End Close, the Transaction that would zero out the G_L Account Balance (Rev/Expense) would…
-
Automation error
Hi! I'm trying to execute following code : VAR xlChar = 'Microsoft Excel 9.0 Object Library'.Chart xlRang = 'Microsoft Excel 9.0 Object Library'.Range xlChart := xlBook.Charts.Add; xlRang := xlSheet.Range('CL1:CL27'); xlChart.ChartWizard(xlRang,4,4,1,0,1,1,'Chart'); I have a runtime error, something about : There is a…
-
Account Schedule Detail
I am trying to setup a report that will show details of Totaling Accounts for analysis. The problem I have is that each time a new account number is added to the totaling account I have to update all of the Account schedules that show detail for that Totaling account. Example: Account number 4190900 is a totaling number…
-
Account Schedule
How Can I set the formula to get Last period amount at Row Level in Account Schedule e.g. date filter 010105..311205 at this row should show the amount as at 311204? ](*,)
-
Error 1053 in modul 19
What means this error - Err_DB_DoubleReff DB_Err(1053) and what is possbile to corect this error? This error is received from a native databease 3.60
-
Suggest Vendor Payments pulling credit balances
Our finance staff just made me aware of an issue where the Suggest Vendor Payments report in the Payment Journal brings in entries when the vendor balance is a credit. For example, Vendor ABC has two ledger entries due for payment. One is an invoice for $100. The other is a credit memo for $125. This makes the total check…
-
job sheduler
I have problémes with the job sheduler for the execution of 5 dataports for some dataports, sometimes its work and sometimes it doesn't work: "arret provoqué par une erreur" ](*,) can you help me thank you
-
Font-size in tables
Hello Everybody, I bought a TFT and on the native resolution of 1280x1024 I'd like to have bigger letters in my table-views than by standard. Maybe the question's totally dumb, but can somebody tell me where I may adjust these settings? Thanks a lot in advance, Ralf
-
How to configure Drives for Optimum performance with SQL
I am running Navision 3.6 on a Dell 6600 Quad Xeon machine with 4GB of Ram. I'm using PERC 4 hardware RAID 10 with 4 drives dedicated to the Database files. RAID 1 with 2 drives dedicated to the Log files and RAID 1 with 2 drives for the Temp database. There are two database files, a primary (.mdf) and a data file (.ndf).…
-
How to count pages of report ?
Hi again I would like to know how much pages the reports will print ? I only know Currreport.Pageno. Thanx in advance
-
How to calculate navision performance ?
Hi again I have problem with navision, navision run normally in my computer, sometimes in another computer run slowlly. How to calculate navision performance by seeing these parameters : server ability/specification, client ability/specification, network ability, client count, client session or anything that can effect to…