-
Bug in procedure upgrading 3.10 -> 3.70 in Warehouse Acti
Hye, In the procedure of upgrade 310 -> 370, we must delete table 5766 et 5767 so all the allocation, reception and prelevement are removed and not transfered in the new database 370. It is a big problem . Have you already have this problem? And wat have you done for solution this? Thanks for your respond.
-
Problem with .bmp image format
Hello, I'm trying to change a .bmp image file in a form. I know that, in Attain 3.70, the image file can't be bigger than 32kb and it have to be in .bmp format. I make an image file of 10kb in bmp format and the same size that I already have in the form and put the route (c:\pic.bmp) on Bitmap value from the Image…
-
SetMessageShowHandler problem with CFRONT/C#
Hi all. First, I'm using cfront.dll for Navision 3.6 and C#. I'm trying to stop Navision from showing message boxes every time an error occurs. I know that in cfront.dll for Navision 4.0 you have the method DBL_HideMessageShowHandler but not in 3.6 that it's what I'm using right now. So I've discovered that assigning a…
-
Item booked
Hi All, How can I filter the ILE table to know That the Item is there but booked???
-
How filter several registers in sections
Hello everybody, I've the following code in a report: IF ("Gen. Prod. Posting Group"='001') AND ("Entry No."<>56920) AND ("Document Type"="Document Type"::" ") THEN BEGIN CurrReport.SHOWOUTPUT(FALSE); contador:=contador-1; END; But, on Entry No. section I want to put several entry numbers but I can't, I don't know what is…
-
Problems with a migration AD
Hi, i have a problem migrating my Navision Attain Server (SQL) to Windows 2003. I pass te users in the Active Directory, but the SID is not the same, then Navision don't recognize the user . Any idea??? Thanks. Miguel Angel.
-
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.
-
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…
-
Variable Validation
hai, i have a decimal variable associated to a text box. is it possible to call a validation trigger of that textbox from other controls (another text box)? can any one help me?
-
Doubt in List Form
hai , i have a doubt.. i have a List form. there are 5 fields. Field 3 and Field 4 have their captions and iam supposed to give a common label at the top for Field3 and 4 apart from their captions. Is it possible? can any one help me?
-
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…
-
Import data of diferent files
Hi, I want to import data of diferent files. The files alway have the same name but can be a lot of files. For example: File0001, File0002, File0003.... So i wan to know how i can know if there is files in the path to import and how many are. can help me someone ? please.
-
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.
-
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.
-
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…
-
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…
-
"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;…
-
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…
-
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…
-
Slow reports, especially the "Inventory to G/L Reconcil
We are running Navision Attain 3.6 with the Microsoft SQL Server (2000 STD ED) Option. The OS is Windows Server 2003 and the hardware is an HP Proliant DL560 G1 with great specs, including dual processors, 4 GB RAM (2 GB dedicated to SQL), multiple hard drives in more than one RAID 1 configuration, and with the database…
-
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?
-
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.
-
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…
-
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?
-
DateTime Data Types
Hi, What is the practical use of DateTime data type?
-
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…
-
Bank Rec. - Multiple Currencies
Hi - We currently have a client whose LCY is USD yet they have some Canadian customers, vendors and bank accounts. We are running into issues when trying to reconcile these Canadian bank accounts. The G/L Balance comes in at USD - what then are the Bank Rec. lines coming in at (my positive and negative adjustments) -…
-
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