-
Microsoft XML' automation
Hi, I need to get information from an xml file. So I create 'Microsoft XML, v4.0' automations variables with subtype:DOMDocument, IXMLDOMNodeList, IXMLDOMNode and IXMLDOMElement. I create this variables, using CREATE() function. When I run my codeunit, an error is occurs on the creation of all automations variables, except…
-
problem with flowfilter
Hello to all, I have a problem with a flowfilter, hope someone could help. Our company manufacture some goods with unique codes (Item table, field "No."). Each Code can have a few variants (Item Variant table, field "Code"). I have a flowfilter in Item table (Variant filter) with table relation "Item Variant".Code WHERE…
-
Problem with FldRef.RELATION
I have a problem with FieldRef.RELATION. I want to know, if a Field has a relation to another table. Therefore I use the FldRef.RELATION to find out the Table No. If the field has a relation, all works fine. But if there is no relation, the fin.exe crashes. I use 3.70 incl. HF12 (newest Runtime). What's wrong?…
-
printing Report twice on a different printer
Hi, I would like to print a report to a printer I defined in the printerselection table and I would like to print that same report to a printer that I have defined in a parameter. He has to print that report always first to the printerselection-printer and then to the parameter printer. How do I do that ?
-
Import data from Excel format
Hi, I'm a beginner to use Navision system since my current company just bought the package. I need someone help for import data from excel worksheet. Our current system is using SQL database to store data and use excel format to export data before import into navision database using dataport. Can anyone taught me how can…
-
Grid on Reports
Is there any way to use a grid on a report. I need a report that looks like a Excel Spreadsheet. Visible borders is what I am looking for. We have been doing this report on Excel but I will prefer to have it on Navision. Thank you
-
Correcting consumption amount
We have released an order that used a raw material with a wrong unit price relative to its base UOM - ie base UOM is supposed to be sq in. but the price entered in the item journal positive adjustment when the item qty was adjusted was per yard. Needless to say, the consumtion amount shot up to tens of thousands of the…
-
The manual says...
that finished production orders are still part of inventory and can still be modified. Now, our problem is we have inadvertently changed an order status to finish but have skipped the Output Journal. How do we add or subtract an output record for Finished order? In another case, how do you correct an overconsumption of…
-
Rounding error
How do we solve a rounding errors in MTO items that uses SET as base uom but which our buyers prefer to buy in PCS. For example, Item A is our code for three kings which is sold in sets of three. Therefore, the base uom of Item A is SET, qty per 1 and the equivalent uom of PCS is qty per .33333, Navision having limited the…
-
Fastest way to find current servername?
I need to find the name of the SQL server, so I have made some simple code that finds it in the Server table:Server.SETRANGE("My Server",TRUE);Server.FIND('-'); However; this code is very slow. It takes at least 1 sec and sometime even more. Isn't it possible to find the information from the Database Information window…
-
Print to specify printer
what is the syntax to print a report to a specify printer? whihout using the user and printerselection table.
-
FlowFields
Hello All I have set up a new flow field for the item table/card. This works fine when using the item card. However, if I select the item from the item list from for example within a sales shipment, I get strange incorrect results for the flowfield. I checked and I am getting the correct item number pulled through but am i…
-
Send documents by Email
We are sending documents as HTML but they lose format when you open it in your email. Is there any way to keep the same layout? Paco
-
Using CALCFIELDS for just some Customers
Let me give you a brief explanation: We got two companies on Navision: USA and Mexico. We have one report call "Backorders by Customer" this report shows, Order Number, Customer No, Item, Qty, Oustanding Qty Qty Available and Qty on Purchase Orders. All these information is coming from Mexico Company. I am changing the…
-
Unexpectedly program termination
We have some weird problems with Navision Attain Client only on one workstation and in some particular cases. Sometimes but just sometimes, the program crashes down on module Warehouse Management – Shipments, when the user is about to print the shipments. It happens unexpectedly, just sometimes with different shipments but…
-
How does a form link its controls to a SQL table's fields?
Hi, New to Navision here. Hope someone can help. The Change Log Entries form of Cronus Int'l is using SQL's Change Log Entry Table as the source. I wish to ask how exactly does Navision link the form's controls to SQL table? I've noticed that the field names used by the form's controls as sources are not exactly named as…
-
MICR on checks
Hi, We've had problems with the MICR check from day one, now the bank has finally been able to give me the reason. Seems like the transit field and the account number are not printed in the right position. Does anyone else use this feature and has gotten it to work? Or should I just go back to preprinted checks. Thanks for…
-
Error 1190
What means error 1190 in modul 19?
-
Can anybody recommend...
an implementation/support partner for Navision 3.1. We happened to be customer no. 1 for our consultant and needless to say, we don't get the best support that we ought to get. Because of this, either the IT group gets blamed (ok, we agreed to buy the product, though under duress) or the product itself gets blamed. But the…
-
Lookup to Item Turnover Lines
Hello All Within standard Navision item card, within menu, there is an option to view Turnover within statistics. How do you call this if you are using a lookup button on a field? i.e. In code? This is strange because the source of the Form 354 is date. Ideas? Thanks
-
Adding days to a DateFormula field
I got a DateFormula field on the Item table. I use this field on Item List form to show Lead Time. That Leadtime applies only for the States so I want to add 4 days to Mexico. I've been having problems with this. How can I add those days? :(
-
Return receipt on credit memo problem (3.60)
Hi all, We have a problem with credit memos returning items to stock when posted - is there a way to prevent this from happening? There's an option in the Sales & Receivables setup called 'Return Receipt on Credit Memo' which would appear to be what controls this functionality, but this option is already unchecked. Any…
-
How to search for a global function
hi! i am new to navision attain and am doing my own study. i have a basic question which i can't seem to find the answer. i hope someone can help me. i am looking into the C/AL code of the form Chart of Accounts of Cronus Int'l (Navision's sample application), trying to understand how the form processes data. within that…
-
Report print out - Paper size
I want to print sales invoice in a preprinted stationary of paper size to 6x6 Inches, 4x6 Inches. Is there any possibility to set the paper size to 6x6 Inches, 4x6 Inches in Report Properties. Please help. Regards S.Sankar Ganesh
-
Change ObjectID automatically
Using processing only report, I want to change the name (objectid) of some forms, reports and a codeunit. is this possible?
-
Backup Restore Fails
Hello, i'm trying to restore a backup of 25 gig in a Native database of 90 gig. The diskspace is large enough but when it begin to create the keys i get an error "There is not enough disk space". I have a server with 2 partitions: C 2 gig (Windows, 750mb free) and D 198 gig (Data, 190 gig free). I saw that when the keys…
-
Flowfield - Table Filter
Hello All One other question I have, is with reference to a flowfield in a table that is being used to sum entries in the item ledger table. I have successfully applied criteria in the table filter to just sum those entries that are of entry type sale. However, I also want to narrow the sum, by only including sale entries…
-
Trapping of dialogs and error messages
Hi I am trying to design a C/AL procedure for automating posting of several lines. The problem is that if there is an error on one line Navison produces an errormessage which nobody can confirm. Is it poosible to disable dialoges that need user intervention? Even better: is it possible to trap the error and let the code…
-
ZetaFax
Hello All When using Zetafax, the document I print from Navision goes to the Zetafax printer but automatically puts a cross next to it and then deletes. This is the code I am using within my document in Navision, any ideas? GtxtFaxHeader := '%%[Fax:' + GtextFaxNo +'] %%[Name:' + GtextContactName + '-' + GtextCompanyName…
-
Multiple Sell-to Customer Nos. in Sales Lines
Sell-to Customer No. field in Sales Line is normally copied from the Sales Header. However, when generating a document via code different lines can be populated with different Sell-to Nos. So we end up with an invoice for eg. with more than one Sell-to cust. no. in its lines. I tried posting such documents and there…