-
Erasing Receipts in Navision 4.00
I was wondering if anyone knew a way to get rid of a receipt in Navision 4.00. We have several old receipts that we want to get off of our balance sheet. I've tried the undo receipt function in Navision but it only works for inventory items.
-
sum of the Sales Line
hi to all, I have a little problem here... I am working with a form 42 Sales Order and I would like to add one field in the header which will show me the Invoice Amount (don't need in the table). When I enter the Sales line, line by line, the new created field should be filled with the sum of all lines. The field "Amount…
-
Reading external file in Attain
I have this code in a CU to inform wheter there is a file you miss to import. Doing right first time, but even the file is removed it tells you it is there. If you after the client is started put a file in the library it does not tell. Works only if you every time leave Attain and then open again (Esc+F12) Can you avoid…
-
"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…