-
"Code expression can’t turn to a Option value”
Dear folks, I want that, when a purchase invoice is registered and the VAT Prod. Posting Group field, from Purchaser line table, is VAT16, automatically it goes to a form that I’ve created. I put the following code in the OnPush form the register button: purchaseline.INIT; IF purchaseline.GET("Buy-from Vendor No.") THEN;…
-
Discounts..
Navision 3.10: What is the easiest way to apply a discount to a sales order?! Normally what we do is just calculate 10% or whatever off the original price of an item via calculator and manually enter them ourselves. I'm thinking there has to be an easier way.
-
Nav 310 FDB with service-can't access
this is the error Navision AttainThe operating system cannot load the DLL module C:\Program Files\[...navision installation folder...]\nc_2.DLL. Please check that the DLL module exists, and that any other DLL modules that it will use also exist. well...where is this nc_2.dll file?my colleague hasn't got it either...and his…
-
Pbm in user rights without explanation!!!
The same user with the same rights works and validate documents normaly,one day he cant's validate a document with these rights and an other user who have the same profil continue to work normaly. I try to delete the zup file but the same problem? NB:we use SQL authentification. I want an explanation for this problem? It's…
-
Changing salesperson code?
Is there a way in Navision 3.10 to change all customers with salesperson code SH to say HOUSE instead? I'd rather not do it one by one if I don't have to. I have three diffferent salespersons I want to take all them and turn them into HOUSE.
-
Licences Issues
Dear All, : :) I had a problem in client side . the Issues is when i import the client license it does not support som eof the tables in navision. The Tables are 1 Ship-To Address For Example : You do not have permission to read the Ship to Address table 2 Customer Discount Group :D 3 Req. Wksh. Template 4 Requisition…
-
Permission Error
My customer can't launch a report on his 3.10 native db... "you do not have permission to launch...contact system administrator..." I tried to launch the same report on my db with their license. Customer's using a db login with "super" role... anyone have ideas?
-
Jet Reports
I am currently using Jet Reports to create reports from my Navision Database. Does anyone know how to do the following? after the creation of the jet report using the scheduler, the saved document includes the jet functions (hidden if i choose) After the file is saved, i do not need the extra hidden cells. all i need is…
-
Database Multiple Sessions
Hi All I posted earlier a query regarding Multiple Sessions of same user in Nav. 3.6. In my observation I found that when there is a break in network signal the database is not refreshing the session or closing the session and creating a new session automatically. Ex. If the user id is "Michael" and IP is "192.168.1.12" I…
-
Change Posting Date
I have a sales credit memo posted with a wrong posting date. How do I correct the date on the credit memo and also on all the related ledger records? Or is there a way to cancel that credit memo and create another one with the correct date?
-
Rename
Is there a way to bypass the OnRename trigger of the table while renaming the primary key of a table from a report? I know for INSERT (also for MODIFY & DELETE) you could specifiy INSERT(FALSE) to bypass the table trigger but I couldn't find anything like that for RENAME. Thanks for any help.
-
Job Scheduler
Can Navision's Job Scheduler run automatically withou a user pressing the start button?
-
windows server 2008
Hi, We would like to upgrade our navision 3.60 native to sql server 2008. This will be not a full upgrade. but only data store upgrade. We are also planning to switch the servers. Now windows2008 is out. We want to use this instead of buying 2003. Is navision ready for Server 2008? Thanks in advance.
-
Print temporary text on report
Hi to all... I've created a new form and put there few fields, etc.... From one field (dropdown) I choose the Contact No. and I temporarily get some data in the fields temp1(Name), temp2(Address), temp3(...) which I can see in the Form Header. The Source Table for the form is NOT Contact. I am havin' a problem when I want…
-
Pbm in connecting SQL DB with Navision3.10
Hello to all, When I want to connect to my DB(SQL2000),an error said: 'The file DCMENSTREAM contains a record that connot be read ',althougt all informations of identification are correct. I want to know what is the origine of this file,and how to resolve this problem? Please help me because it's very urgent!!! Slah.
-
PeopleCo BI+
Has anyone expored a BI solution name PeopleCo BI+? www.peoplecosoftware.com. Please give me some feedback of this BI software. TQ
-
Posting Inventory Cost to GL
There is this function Named as "Posting Inventory Cost to GL" under Inventory module. My is Question is, how can i improve its performance because its extreamly slow. Regards.
-
USPS Api's
With USPS being extremely competitive now for small shipments I have been looking into the Postal Services API's to get: -Calculate Rates -Find Zip Codes -Verifing Addresses -Track & Confirm http://www.usps.com/webtools/welcome.htm I finally got my USPS registration Username & password but i was wondering if anybody has…
-
Database - Current Sessions
Hi All I am finding a strange problem with Navision 3.6. When a new user trying to log in its shows message as license has reached the limit. when I check the Database Current sessions I can see one user name showing in multiple sessions. Ex. Satish user shows 2 times or 3 times. like that.. now I hve to restart that…
-
NAV 3.6 Shortcut Keys
Hi all How do i find list of short cut keys that i can be used in Ms Nav 3.6 version. i hv been to the help but its different keys in different modules. is there any help document listed with all the short cut keys. Pls help Thanks & Regards satish
-
[S] When did Microsoft stopped providing support for NAV 3.7
I'm running around with google, but it seems hard to find precise date. Maybe anyone of you remember? Thanks.
-
Deleting a list of items via a report called from a dataport
I am working in Navision 3.6 (SQL Server Version). Our customer has a list of 14,000 obsolete items that they want to delete due to lack of activity. I want to read this list and delete the corresponding record from Navision. I understand that you cannot delete from a dataport so I am passing the record to a processing…
-
printing reminder
hi there... is it possible to do this somehow? i have added one check box on the Sales Order form. what I would like to do is, when I push the button Print (for the first time), that check box should change it state to checked, and stay like that, just like reminder that this document is printed, nothing else. (i should be…
-
GETLASTERRORTEXT in NAV 4.0 SP3
Hello, I used the function GETLASTERRORTEXT in version 5.0. Now I should use the same function in a db ver 4.00 sp 3 but I don't have this function. I need it to log if a codeunit goes wrong, returns false: Following is the code running on 5.0 IF NOT CODEUNIT.RUN(CODEUNIT::"Item Jnl.-Post Batch",gRecItemJournalLine) THEN…
-
Another Form Question : Purchase Statistics
I have added a variable to the purchase stats form, which shows the LCY vat amount, as this helps with the invoice authorization process. (We buy "local" products in different currencies). I have bascially put TotalVATAmountLCY := TotalPurchLineLCY."Amount Including VAT" - TotalPurchLineLCY.Amount; Which works fine, but…
-
error during undo shipment
Today one of user posted a Sales Shipment but after posting he get to know that by mistake he has selected different Bill to customer and it should be same as Sell to customer. Now he wants to post undo Shipment. When he is trying to do Undo Shipment He is getting foloowing error: Item No. must be 1050018 in Reservation…
-
Is it ok to dataport sales records?
We are using Navision 3.10A and we want to transfer our existing sales orders to a newly created database. Is it ok to simply use dataport with all field validation off to do this? I will be transferring all fields with their contents anyway so I figure there's no need to validate the contents. There are quite a lot of…
-
Report to pull up no sales customers..
Using Navision 3.10. What report is used to pull up a list of all customers (with as much information as possible, ie: address, contact, phone number) who have not have sales since 06/01/07? We want to pull up a report of everything who we haven't done business with in awhile and contact them. Thought I've done this…
-
[solved] Error after uninstalling Navision 3.6 client
We had a strange experience last week after uninstalling Navison 3.6 client: Some application didn't work anymore and there was always an internet explorer script error. Also problems when printing from Outlook and when using mmc. Quite similar to http://www.mibuso.com/forum/viewtopic.php?t=21371 By the way, reinstalling…
-
Exit
Hi, i am an apprentice in the first year of apprentice and i have only a very small problem i have to check a code and i found something like this: exit(true) or exit(false) i havt never seen it before and i didn't found anything in the internet i hope someone can tell me, what this means