-
Navision Integration
How to integrate Microsoft Navision in php
-
NAS ignores Report-Orientation
Hello! We want to printout some of our reports automaticly with the NAS (E.g. Fiscal Invoice). Now we've noticed, that the NAS ignores the orientation of the reports, and prints them out in portrait, though they are set up in landscape (in manual printout, they were landscape). Is there anywhere a standard setup for the…
-
zetafax printer selection
i have looked through the search answers, but cant find any specifically to this question ! :D we use zetafax to send p/orders and s/orders and this works fine (all fax numbers/contacts are sent through). one thing we do have to do is when printing a fax order, change the printer driver to the fax printer. As not all…
-
checkboxes and double sections
ok guys, here is what i am dealing with... i am working with a report and the situation is next. i made on a request form two checkboxes named "credit" and "debit". when i check "credit" i would like to see on the report only entries where i have Credit Amount values, also, when i check "debit" i would like to see only…
-
NAS taking more and more memory
I have 2 NAS running on a SQL-server database (3.60). They run a single-instance codeunit with a timer. So each time the timer is called, the nassql.exe process takes a bit more memory. This goes on and on, so in the end we need to restart the NAS because the server is slowing down too much. Anyone experienced this before…
-
Item Tracking Problem
I have problem about Item Tracking which tracking by Serial&LOT. The problem is :- User would like to issue Sales Order with this item, let say ItemA. When she select this item on Sales Line and try to select LOT/Serial on the Item tracking Line. There's something quite surprised. On the Item Tracking Summary of this item…
-
How to dispaly a report in two different ways depending on t
Hi everyone. Hope you are all well How to dispaly a report in two different ways depending on the filter selected. I have created a report in NAV and want it to filter in two different ways. First if I select a boolean called "SortByVendor" then I would like it to sort by vendor and place the data in vendor groups.…
-
Another User Has Modified the record for this ...
Hi Im new to Navision Development. I not to clue'd up with nav as yet and still getting used to the code but I have a slight problem I get the following error and I dont know how stop it. Another User has modified the record for this Sales Line after you retrived it from the database. Enter your changes again in the…
-
Blanket order problem
Hi everyone when we make an order from Blanket to Sales, it works fine. After making an order from Blanket to Sales, by some or other reasons we may have to increase the quantity. When we increase the quantity in the sales order, when we post the lines it gives the following error: "You cannot ship more than the blanket…
-
The TAB Base does not Exsists
Hello! I have this problem. I have no idea what this could be. If you like you could take a look at the picture I don't know what to do. Regards Thanks for everything !
-
First time setting up a server - Can't get NAS to run
Hi, I am installing 3.60 and have a database setup. The DB I have used is a copy of another server so has all our scheduled jobs setup. The service "Navision application server classic" is running from services.msc and I have configured it via the MMC console to use the same parameters as an existing working server we…
-
Form Focus
Hello, I hope I will explain my problem. I have a from that has a button.When you push the button , Another form opens. The focus in the 2.form is not on the 2.form,but on the toolbar.(If I arrow-left , I movetrought the menu's) How can I solve this? Thank you
-
RMI Rental Advantage 5.0 SP1 upgrade
I am working for a company that uses RMI's add-on Rental Advantage. Has anyone had any experience with upgrading to Rental Advantage version 5 SP1? Thanks.
-
Report selection
When I run an orderconfirmation-report in a salesorder, the report must select automatically the salesordernumber from the salesorder. How to do that?
-
Consignment or Vendor Managed Inventory
The distribution Co. I work for is trying to warehouse $1,700,000 of constantly changing consignment inventory. They have used the same "Item No."s for the consignment and Co. owned inventory. Now I have to figure out a way to isolate the consignment inventory and manage it without anything showing up on the G/L until…
-
hotcopy newbie
hi experts, I tried to backup db using hotcopy...but unfortunately dunno wher to start from. after read the w1s1ism.pdf i created a cmd file called bak.cmd Inside bak.cmd containing below lines: hotcopy source=C:\Documents and Settings\teckpoh\Desktop\customer.fdb destination=C:\Documents and…
-
Sales Stastistics
Hi Frds I have a small problem when the sales invoice has been posted, the Tax entry are correct in their respective entries in Navigate function in posted sales invoice but in statistics( press f9 in posted sales invoice) its is wrong. May i know wat would have caused this type of error. Regards, Vijay
-
Suggest a book..
Daniel had recommended reading Programming Microsoft Dynamics NAV book by David Studebaker. It says 5.0 on the cover. Is there a similar book recommended for 3.10?
-
How determine what database process.
Hello, We have two Navisions applications running on the same server. They both connect to the SQL Server database via Windows Authentication, so hence the database shows two connections by the same NT Login name. I would like to be able to identify which database connection (process id) belongs to each of the two…
-
Developer Toolkit Issue
I was using 'Where Used ' on a Table field to know where all it referenced and unfortunately the tool didn't find a TableRelation defined on another field on the same table. I also tried 'Where Used With' everything checked but still it didn't find the Tablerelation. I am using V2.0 SP3? Am I not using the tool correctly…
-
Form opening to wrong tab
I have made some modifications to my client's Customer Card. I have added one or two tabs and repurposed a couple more. Now when the form is opened, it opens to one of the new tabs instead of the General tab. My client is vexed. I have tried placing CurrForm."No.".ACTIVATE in the OnOpenForm() and OnActivateForm() triggers;…
-
Apply doc id and Apply doc type
Hi Gurus In a sales Invoice or Sales Order before a user Posts the same System must check the Amount Paid by a Cash customer. In my sales invoice or order i have added Apply doc id and Apply doc type but in this process i can only check if the receipt number exist or not but i am not able to compare the amount of invoice…
-
How do I add sequential numbers to G/L register table
Ver 3.1 I have created a new field in the G/L Register table, "Period Trans. No." and need to populate it with a sequential number based on the posting date range (another new field).. However, the code below is not doing it for me, I get one number for each date: 01/01/08 = 1 01/01/08 (next record) = 0 (not assigned a…
-
Ocx directprint
I've installed the dll without any problem, made a report in navision that creates an ascii-file with the necessary escape-codes and now I want to print my label with the next command pathtxtFile := 'c:\textNav.txt'; PrinterName := '\\FIPRI\PR36--BP1344'; NaviPrinter.DirectPrint(PrinterName, pathtxtFile); But this doesn't…
-
Ignore fields with the same value
hello all, I have added the sale invoice line as a data item indented under the TempCustLedgEntryLoop to the Aged acc report, so if an invoice is found to show the "Job No." on the invoice lines for that particular document and a few extra fields from the job table, as there can be several invoice lines with the same job…
-
line discount for resource
We give our customers discount on labour as well as items, can I automatically assign a discount when a resource is selected as we do when items are selected on a service order. Alan
-
Dataport Add Header
Is it possible to do a dataport export and add description headers to the export file? Example the first line for the Sales Header export would read: "Document Type", Document No.", "Sell to Number", "Name", "Address1", etc. etc.
-
View "Blob reference" field in object table in ASP
Hellooooooooooo, I was wondering if anybody out there has ever viewed the "Blob Reference" field from the object table in ASP before and how did you do it ?
-
Using older databases with newer clients.
I have a situation where I need to run an older database (ver 3.01) with a newer client (5.0 SP1 or maybe 2009) for a short period of time. Likely 1 or 2 months. We are talking the native database. I have a number of sites running with databases as far back as 3.60 but nothing this far back. I'm looking for…
-
Uninstalling 360 disables Windows Photo Print Wizard
Hi! We have a client who is migrating from 3.60 to V5. They have discovered an issue with some of their XP Sp2 machines they have uninstalled 3.60 on - That this has the side effect of damaging the inbuilt Windows Photo Printing Wizard so it no longer works properly. They have tried repair/replace of the Windows Photo…