-
Field Permission 3.10
Hi, I have a problem. My customer want's to have a insert/modify permission for a field in a specific table. So I created a new table called "Field Permission", that look's like this: Enabled Field No. Field Name Data Type Length Description Da 10 Table ID Integer Da 20 Field ID Integer Da 30 User ID Code 20 Enabled Field…
-
Changing costing metod
Heja! Costumer wants to change costing metod form Average to FIFO. Does anybody have any expiriance with this? This change is planed at th end of the year. My plan is: 1. Create Item journal to negative adjust all inventory (and create a copy as positive adjustment). One line per item & location combination. Maybe also per…
-
I have a problem with dataport import.....
I want to import some records(from txt file - 2 "columns" separated by TAB Name, Address) into Customers table. I was made Dataport(with 2 fields(Name, Address), but without No. because I need automaticly generetaed ID from Customer table(General Ledger->Setup->No. series->Customer)) and nothing happened :( Why??? misha
-
9 signs after a comma in the Production BOM
It is possible to make 9 signs after a comma in the Production BOM line field "Qty Per". In native functionale 3.60 it is a maximum 5? On a Item card of the goods which it is specified in the BOM line and it is consumed in the Product Order in a field "Quantity" it will be possible to specify accuracy of a rounding off. I…
-
C/ODBC problem
Hi, I just installed C/ODBC without any errors, but when i try to connect via ASP to the database server i get an isam error. When i make a connection in the ODBC datasource administrator, i choose a company, it works, but when i try to change the company or try saving the connection then i get an error: Does anyone know…
-
Manufacturing
Is somebody using Navision Attain 3.6 or 3.7in the semiconductors industry ? :)
-
Invoicing without shipping
hi, i was wondering whether i could get any suggestions from you guys about how to do the following: A sales order for 10 item A was raised. I need to invoice the sales order for the 10 items without actually delivering the items. it is essential that the sale order be invoiced, so that the vat return can be filled etc...…
-
Temporary Table in Form
If i make a temporary table out of the table Sales Line (Temporary Property=Yes), And insert some records in it. Then how can i open the sales line form with these temporary records? And also do some changes on them without Attain saving the records back to the "real database"? I have looked for a property in the form that…
-
Email notification for HOTCOPY
In the hotcopy command there is a parameter called email, so you can mail notifications of the hotcopy command. Anybody knows how the email is send? Is it via Mapi, Smtp or something else. I suppose via Mapi, but which profile or so does it use then? Rgds Benny Giebens
-
Excel in Navision
hi....i'm creating an excel output using Navision's C/AL... i wish to know what property will i use to set the alignment of a cell in excel? for instance, i want to make a certain cell right justfied. ex. Worksheet.Range('A4').???????? thanks in advance! :)
-
Diagram
Does any one of you have a diagram. I need a diagram of how does GL it's affect it when you press F11 on sales orders. Thank you in advance Paco
-
3.10 Adjust Exchange Rates
Hey :D Question: does 3.10 Exchange Rates Adjustment, use dimensions?
-
Problem with instalation of Navison 3.60
I met the following problem: i wanted to install Navision 3.60 Client on a machine with OS: Windows Server 2003 and MS SQL 2000 with SP3a but I couldn't install him. The instalation wizard said only: "the program wasn't install because was an error. If want to acces teh program, make a other instalation" Knows someone if…
-
breakpoint in Navision 3.01
how to set breakpoint in Navision 3.01. thank you hawwa
-
importing images into forms
Hi folks, I would like to place a picture in a form. That is possible by the tool “images”. But I need to draw an arrow and to save it in a monochrome bitmap file. Does anybody know a simple program in which I can draw the arrow? It`s not possible in MS Paint because the whole page is saved in the .bmp-file. But I do not…
-
how can I take a photograph from a form ???
Hi folks, I would like to take a photograph from a form that I have made so that I can import this photograph into a word-dokument. Does anybody know how to do this? Thank you a lot! Blub
-
How to translate Options, Constants and Messages with NLW?
Hi all. Need help once again... I am trying to translate form from Lithuanian to English using Navision Localisation Workbench. I have exported translation file from Navision (thanks to HalMdy). In this file I can see some Opotion strings, some Messages, some Text Constant values, but when I import this file to NLW, they…
-
Navision Blocks
Since we start to work with navision, we have had a lot of problems with blocks... We are using MS-SQL Server that it is supposed that it does not block tables, only registers... There is not an unique table that it's blocked... it could happen while making an invoice, or while changing an item from a salesperson to…
-
How export translation file from Navision?
Hi all I'v just started to use Navision Localization Workbench and don't know many things jet. How to export STX or EXT files from Navision? And how to import them back to Navision when translated? I want to translate custom objects from Lithuanian to English. Thanks
-
Status bar
I have a 3.6 navision attain server. When i access the database with 3.6 12883 client de status bar is used to show information when a lookup takes time. When i use version 3.6 15069 the message is displayed in a screen that pops up and not in the statusbas anymore? Can anyone help me to get rid of the screen and get the…
-
check text file existance
How do I check the existance of a text file in a directory? thank you hawwa
-
delete txt file after import
Dear all, I have a dataport to import data from a text file. How do I delete the text file after importing all the file. Thank You, hawwa
-
How to get whole record from lookup table, not only a field
Hello everyone, pls help I have a table XYZ with option field. The selected option determines which table will be use for lookup, and it works. The problem is when i raise the lookup table, and select a record, a certain value is inserted in tbl XYZ in field2, and I would like automaticallly to fill one more field in tbl…
-
List of functions in a codeunit
Hi all I'm creating something for a customer to schedule tasks. Those tasks are specific functions of a codeunit. To give the customer the possibility to schedule tasks himself, I want to give him a form with an overview of all the functions of the chosen codeunit. In this form he can select witch function he wants to…
-
upper
Hi, I know with sql you can use upper and lower in your sql statement like: sql = "select * from tbl where upper(field)='" & ucase(value) & "'" i just can't make it work with codbc, could anyone help me on this one? i want to make login non case sensitive, but i can't change fields in navision, so it has to be done in asp…
-
MSMQ error, The stream has returned a read error
Hello, I have created a codeunit (code see below) and a form with a button. The OnPush trigger of the Button calls the function SendMSMQ() of the codeunit. If I run the codeunit and I click the button in my form, an error message comes up: The stream has returned a read error I spent already one whole day to find out whats…
-
Server and client do not have the same program version numbe
Hi, We have a 3.60 database that runs on a 3.70 server, no problems for this to work, only now we need a NAS which requires a windows logon and apparently this doesn't work now, or at least in half of the time doesn't work, some times it goes, but mostly not. We get the above error, anyone knows how to solve this? For the…
-
Navision Attain Training
hi!...any chance you might know training centers that provide Navision Attain training?....particularly for advanced programming and those that are partners of microsoft...any location is ok... thanks in advance! :)
-
Pmt. Disc. Excl. Vat
Hi, in our version, checking or unchecking the field "Pmt. Disc. Excl. VAT" in General Ledger setup doesn't change anything. version = BE 3.10.A Anyone an idea? I compared with the W version 3.10 and there it works, but i don't know how i can make it work in the BE version.
-
Tax calculation on specific customer
Hi all: Let me tell you I got the following problem I got some customers using an special kind of tax, that tax it's show on the invoice but it does not adds the tax to products it is just informative. My problem is that that tax and products are being shown on the agging. I need only subtotal to appears there. Why should…