-
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 +…
-
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…
-
Virtual tables
Hi, does anyone know all virtual tables in Navision? i know of:- Date- File- Integer- Object Are there any others?
-
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…
-
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!
-
How to know the current record number
Please help. What function can I use to know the current record number? Thanks!
-
Convert String to Numeric
Can anyone please tell me the function to convert a string into numeric? Thanks in advance!
-
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! :)
-
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
-
How do I skip the first line when importing with a dataport?
I've written a dataport that should import a file with variable field length and a TAB as delimiter. The problem is that the file starts with a header that should not be imported. I tried to use a SKIP on both OnBeforeImportRecord and OnAfterImportRecord but it doesn't stop the error I get: The text 'column_name' is too…
-
Two subforms based on main form
Hello, I have a problem with two subforms. Let me try to explain. I have one main form (based on Rec1). I also have two subforms (both based Rec2) : Subform 1 (based on rec2) and Subform 2 (based on rec2) Now, when i change my record in subform 1. I also have to change to the same record in subform 2. Has somebody got a…
-
Navision Language Workbench
Greetings, i am trying to translate our custom reports using Language Workbench tool (or whatever is it called, cant recall right now :) . But them problem I' having, is that it doesnt seem to import already translated data.. I mean, I export the data from navision, then import it to the translation tool.. some of fields…
-
What means Err_DB_FrontLenTooLong DB_Err(1204)
Our customer is getting error 1204 "in the database structure" (module 19 (database), Err_DB_FrontLenTooLong DB_Err) while backing up the database. Does anyone know what the cause is of this error and how we can prevent it? (Navision 3.01A)
-
Application Server details?
Greetings, I would like to know where could I find more information about NAS. E.g., when it starts and fires 99 trigger, and it finishes, does it quit? If not, then what does it do? I'd like to know how exactly does it work, cause for now, it's causing me alot of problems.. :( I have it starting via task scheduler by now,…
-
Best solution for report?
Hi. Just wanted to ask, maybe someone have some good way to do it. I have to design a new report where data comes from single table. Sales line for example. I need create some totals on group footer. Only tricky part is, that I need totals for different time periods on the same row. Example: (Ahh seems that after posting…
-
Converting A string to Number
Hi I am trying to convert a string to number. Is there a system function in navision, or I have to create it on my self?
-
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…
-
Print problem 3.01
Hi, One of our customers has a problem in Navision 3.01. When they try to print a delivery note on one specific PC with OS Windows XP without SP 2 Navision gives a report that FIN.EXE has a problem and will be closed. We have installed all kind of drivers, but this didn't solve the problem. Does anyone have a suggestion?…
-
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,…
-
Reading XML file in Navision
Hi, something doesn't work in my code, but i don't see it... =========ImportXMLFile(pFilePath : Text[1024])=========IF ISCLEAR(lautXMLDocument) THEN CREATE(lautXMLDocument);lautXMLDocument.load(pFilePath);lautXMLNodeList := lautXMLDocument.getElementsByTagName('Results/ProposedPrices/ProposedPriceItem');lautXMLNode :=…
-
Error message "Item must be rserved" ???
Hi all, When I try to validate a negative entry for an item, the system show the error message "Item <Item_Code> must reserved"! Can any one help me ?
-
I need to manual for coding Thai language.Pls
pls
-
Decimal places..
Hi all, I'm new to Navision world. I have a problem that i wish to using example to explain which makes it more clearer. EG. Purchase item "A" with 10 units, total discounted cost is 100.01. Here, cost per unit will become 10.001 If you refer back to table<Value Entry>, "Cost Per Unit" is 10.001 which is correct but the…
-
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…
-
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…
-
Sending XML message to MSMQ
I have used MSMQ and NAS to receive messages from an external .Net application into Navision. Using a XML DomDocument Automation variable, I can easily extract the incoming XML wrapped message from a receive queue. Now I need to do the reverse communication, i.e. send an XML message back to the external application. If I…
-
XML and Version 3.60
There are many examples how to import XML-Files into Attain, but they alway use the data type "Automation". I can't find this type in my menu botton. How can I import XML in my Version 3.60?
-
Choose Folder
Hi, i would like the user select a folder, is there any way in navision they can select it in a dialog? thx in advance
-
Calc Consumption
In consumption journal form there is a function calc. consumption. Its opening a report. In the second tab of the report (Prod.Order Componnent) we select itmes to be consumed. but here list of all item is coming rather than list of items under that prod order order(means item that are in BOM should come here). how can i…