-
Batch with fin.exe as NT Service
Is it possible to run Navision client as an NT service ? So we can : - define a new NT user 'BATCH' as Logon account for this service, - enable the UnifiedLogin option - create a form with an TimeInterval property to launch a report or to scan a cron table - give the BATCH user this form as "Main menu ID" in user setup -…
-
Payment does not capture Job No
Why Navision does not want to capture "Job No." in Gene. Journal Line ? Is there any reason why it does so ?
-
Sumindexes SQL
When researching the use of Sumindexes in SQL, i found that they are stored in a table with a name like Company$Tableno$KeyNo. When you look at such a table, you find that the columns in that table corespond to the fieldnumbers as defined in the key in navision. What I cannot figure out, is what the field "Bucket" is...…
-
Bill of materials
If you post a BOM Journal, Item Ledger Entries are created accordingly. For the BOM, a positive adustment is created and for its components, negative adjustments. I now want to generate a list of these entries. The question the list has to anwer is:"Which entries where created, when i posted a certain BOM Journal Line?"…
-
Help with app testing and your feedback
Hello, I would like to see if anyone out there would be so kind as to test some software I designed and developed and provide some useful feedback. The product is called N-Fusion and uses Allaire ColdFusion to integrate Navision Financials 2.01B and above, C/SIDE or SQL, to the web. It is a real time system that attaches…
-
Excel Format with Automation
Hello again, I want to move some statistics to Excel. My Problem is, if i move a large Integer value, for an example "Serialno", Excel converts the Value into Power. It's only possible when i format the Columns manually to Text, before i move the value to the columns. Did anybody know how i format the Cell or Column in a…
-
Diskett Clearing
We are using the 2.60 German Standard Payment Objects. When one runs Report 393 "Suggest Vendor Payments" for checks one has the option of using the field :"Summerize per Vendor". This report is also used when you want to use disks for settling the payment. In that case however the field "Summerize per Vendor" can not be…
-
Foreign Currency Valuation
Does anyone have a solution to the problem created when an invoice is posted in month 1 and paid off in month 2, but after being paid off, a re-valuation is run for month 1. Currently Financials will re-value the invoice but not create the general ledger entry because the invoice is closed. This causes the subledger and…
-
User Portal for Navision:
Is anybody doing development work with the new UserPortal for Navision? What are the specifications so far based on the Danish version? Most web parts for Digital Dashboard are read access only, not able to write to a database on the server. But on a version of the demo on userportal.navision.com it seemed to be able to…
-
REPORTING WITH NAVISION
DOES ANYBODY KNOW OF A GOOD APPLICATION OR ANY DEVELOPMENT FOR CREATING REPORTS OR ADVANCED ANALYSIS FROM NAVISION. I AM CURRENTLY USING THE ODBC DRIVER TO CREATE EXCEL QUERY REPORTS BUT THIS IS A SLOW PROCESS AND THE ODBC DRIVER SEEMS VERY UNSTABLE. I HAVE HEARD VARIOUS OPTIONS ARE AVAILABLE BUT WONDERED IF ANY OF YOU…
-
Using Form.Runmodal in a table
I needed to perform a lookup on the Filing Status field from a new table I recently created. The lookup should restrict the Filing Status codes to those available for the Payroll Control Code contained on the same record in the table. This is exactly the same process that is used in the Navision Employee Tax Info table for…
-
Fixed Routing Run Time for An operation in NM2.60
Hello everyone, Can anybody suggest how do we fix an operation time on the routing lines per operation irrespective of the output we are producing. also is it possible to set up run time for an operation on the basis of Input rather than the output. Thanks karthik Kartikeya Pasumarti Karthik@datahelp.com +520 290 8870
-
Navision or Great Plains?
Hello everyone: Does anyone has experience with Navision and GreatPlains? We are an Apparel importer & distributor and are looking for a solution for our in-house DOS program. I have looked at the Navision and it's great. However, i'm also looking for an integrated EDI function and the demonstrator said it's a licenced…
-
Citrix with mail and automation
We set up a citrix installation at our client. They need to send mail directly from the cient card and we built a codeunit to export a sales document to Excel through an automation process. There seems to be a problem when trying to send a mail from the client card and I guess there will be a problem when using the…
-
ODBC fails on some tables
Hi All, I'm testing with the test database (Company Cronus) in NF 2.01.A via the provided ODBC driver (2.11.00.924). Using both Access 97 and also a program written in Delphi, ODBC fails on the (same) certain tables with "ODBC - call failed" (Access) and "Data provider or other service returned an E_FAIL status" (Delphi).…
-
Strange behaviour in group footers in reports
Hello again ;-)) I have an annoying problem that is causing me grief to do with totalling etc in reports. My report footer totals three data item fields to produce a total for sales amount and purchase amount. one fields source expression is ItemTotILE1Profit+ItemTotILEShipInv1Profit+ItemTotILECreditsProfit the other is…
-
Save values in request form fields - Can it be done
Does anybody have any hints on how to save settings / values in fields etc on request forms in reports ? On the data item's its not a problem, but on the request form it doesn't seem to be an option ? Bruce
-
filter a Tabular-Type Form
Hello, How can i filter a „Tabular-Type Form“ by the vaulues of a table? The problem is, 2 fields mußt be compared and when they are same they shouldn´t disappear. Greetings, Ralph
-
solution for a textile converter?
Has anyone created a solution for a textile converter? The requirement includes lot tracking, issuing multiple POs for processing, relief of inventory from a proceeing order, etc. Thanks,
-
Navision 2.60c (SQL2000) is very slow
We have big problems working with the Navision 2.60C, SQL Server 2000. If the Navision Table contains keys with SumIndexFields, or fields with FlowFilter, then sinks the performance (Navision forms/reports are very slow). Hardware Navision-Server: 1 GB RAM, 4x 550MHz Xeon Proc, DPT-Raid(0+1), Software: Win2000 Adv. Server,…
-
Where are the forms and code kept in SQL server version
Hi, I'm im wrong here feel free to slap me across the face with a damp haddock.... In the traditional version of Navision any code changes, new forms, amendments etc were / are written to a central location so all users can get at them. I guess this was in the DB itself... Now if you are using a SQL database, where are…
-
Partial check application
Hi Everybody, I think this is an issue many people have, but I haven't heard a useable solution yet. Here's the problem: I have several customers who instruct me how to apply their check. Let's say they have 3 invoices of $50 each open. They send me a check for $150. But instead of applying $50 to each invoice and closing…
-
Reports - particularly A/P and A/R ageing
Creating reports is tedious. There are not all that many ways clients want the information displayed, but Navision never seems to quite get there. Is there a repository of reports that can be shared? Does anyone have reports for sale or trade? Right now I need to modify the Purchases and Payables, A/P ageing report to…
-
ODBC & Navision Financials
I am having a problem connecting to Navision Financials via ODBC. Using the C/ODBC driver I get this error: ODBC error: [Navision Software a/s][Navision Financials ODBC Driver]ISAM Error I receive this error when trying to connect to the live database on the server. In the configuration screen for the C/ODBC Driver if I…
-
1099 Vendor
I have a client that forgot to classify multiple vendors as 1099 vendors until about half-way through the year. Now that they're trying to print the 1099's, the information is, of course, incorrect. I know that I can get the 1099's to print correctly by altering the vendor entries to show that they are in fact 1099…
-
Bank Reconciliation
When we do bank reconciliation in Navision, those line with type="Difference" will not affect to the G/L entry. Let say, bank does give us the interest and we reconciliate it in the Bank Reconciliation and post it. It wouldn't create any entry in G/L. So to balance our bank account, we need to do it separately on General…
-
Information on Future NF Releases
Can anyone tell me where I find info on future product releses from Navision? ie functionality in release 3.0 etc. It doesnt have to be written in stone and I won't be taking Navision to court if they fail to deliver, but it would be great to get more info.
-
Financially Void Cheque
When we do the Suggest Vendor Payment batch job, the system will automatically suggest the payment per vendor (if we tick it) that applied to all invoices. Let say I void the cheque in Bank Account - Check Ledger Entries. The system does reverse the amount, but the vendor invoices are not reopened !!!!! The system should…
-
Check register
Hi everyone How do you work with a bank account without having a bank register that shows you line balance.
-
Invert a field in the sections
i am trying to invert a field in the sections. but i can´t make it. i changed the background color and the font color. in the section designer everything looks fine. but when i print the report there isn´t any field inverted. had someone any idea to fix it? Regards Dennis