-
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…
-
Problem With Consolidation
Hi.. When I do a consolidation with the database using advance dimension it's always error : " The transaction cannot be completed because it will cause inconsistencies in the G/L Entry table. Check and how the CONSISTENT funtion is used in the transaction to find the reason for the error. Contact your system manager if…
-
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?
-
check text file existance
How do I check the existance of a text file in a directory? thank you hawwa
-
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…
-
breakpoint in Navision 3.01
how to set breakpoint in Navision 3.01. thank you hawwa
-
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…
-
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 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…
-
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
-
Post XML to Web page - help needed!
Hi! I am trying to post XML data to a web page via xmlHTTP30 automation object, and keep on getting "Invalid syntax" -message from MSXML3.dll. Here's the code: r := '<?xml version="1.0"?>'; r := r + '<AccessRequest xml:lang="en-US">'; r := r + '<AccessLicenseNumber>2BAFE9FA08C33352</AccessLicenseNumber>'; r := r +…
-
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…
-
Not wanted dimensions...anyone ?
Hello. I have a UK-customer who has created a few vendors and attached global dimensions to them on the vendor card. They made a few orders and the dimension are shown in the header (as expected) Now they have decided that it is no longer neccessay to have these dimensions attached to the vendor and deleted them. However,…
-
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! :)
-
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…
-
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.
-
Calculating VAT based on invoice value less discount
Hi, In Navision 3.60, is it possible to have the VAT on a sales invoice calculated based on the net amount of the invoice less the payment discount?
-
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…
-
difference in inventory valuation and G/L balance
hi , i've got a client using navision 3.6 and there are huge differences between the inventory valuation report and the balance reported in the general ledger. The costing method used is average cost. The automatic cost posting is activated. there are no direct postings in the general ledger account. ajust cost- item…
-
Should Inv. =Amount Rounding Precision for Local Currency
Navision : 3.7 SQL : SQL Server 2000 SP#3 Windows : 2000 Adv. Server I got a little problem while changing Inv. Rounding Precision of local currency from 1 to 0.001 (I think all you have configured this well in the first setup). After I traced, I found that it should be same with Amount Rounding Precision. But I also can't…
-
Error during Import of XML-Files
I try to import a XML-file like it is done in the example of romein. The "LoadnodeList"-function is successful. During "selectNodes" appears an error: "This message ist for C/AL programmers: This automation variable hast not been instantiated You can instantiate it by either creating or assigning it." Does somebody know…
-
Create pdf file without User Interface
Hello all, do you have any idea, how do I create a pdf file without Printer request windows? E.g. by pdfmachine or pdfcreator, I need the shell command in my Report to create it. Thanks!
-
Fax with Topcall
Hello, have anyone ever used Topcall to fax within Navision? Should I first convert my report to pdf file and then another text file to relocate the pdf file? Anyone have experience with it?
-
[REPORTS] Problems with COMPANYNAME and the Request Form
Some of my reports contain the following code: [GLOBAL VARS]sCompany: text[60];[REQUEST FORM]textbox, SourceTable = Company, SourceExpr = sCompany; // <-- creates a combo box[OnInitReport]sCompany := COMPANYNAME What does this code do? It places a combo box with all companies in our Navision implementation and sets the…
-
Formatting a Date field
Hi there!...Help please...What's the syntax in formatting a Date field into this format: dd/mm/yy Thanks in advance! :)
-
Convert String to Numeric
Can anyone please tell me the function to convert a string into numeric? Thanks in advance!
-
How Can I set the visible of a Text Box to False in Reports?
Hi I have a text box of Data type Decimal in a report and I want to set its visible to False. The reason I am trying to do something like that is that there is a need not printing 0,00 when that value is 0. Does anyone has done something like that before? Thank you in advance kkakl
-
Send XML File from MSMQ to NAVISION
I'm trying to make a connection between a website and navision v3.70 using MSMQ. This works fine with text files, I can send and receive text files but now I want to use XML files and it doesn't seem to work. This is the C/AL code for receiving XML files, does anybody know what the problem is. Comcom::MessageReceived(VAR…
-
Performing a CHANGECOMPANY on a dataport from a form?
I have a form with a button. When the button is clicked, a dataport should be called for each company in the company-table. This part is already working. The dataport that is being called in the loop, contains a dataItem which is not shared through the companies. I want to do a changecompany on that dataItem before I call…