-
Request Form in a dataport
Hi All, As you all know, when we run a dataport, a option tab with the file name and direction will be available for user to locate the import or export file path. However, these will not be availble at the option tab when there is a control is added to the request form. The file name and direction are not available, the…
-
Bar Code
Hello, I want to transfer data to and from Navision with an other application. The application is on devices of read bar codes. In the other application are reading the quantyties and item barcode. The process is like this: the items are received based on a Purchase Order which came from Navision into application, in…
-
Internal Error in Module 11
Help - has anyone ever seen this error? It seems to happen when a user is in a form that has many filters, and then they click out to Email and back in. The complete message is "Internal Error in Module 11 - Contact your dealer if you need assistance." Any suggestions would be great!
-
Backup crash
Hello all, When I do a backup of both Data and Application objects, sometimes the backup crash. Is it because there are users performing posting actions inside the application? :?: Navision Attain 3.60 PT SQL Database Regards Afonso
-
Re-open Ledger entries
Hi. We have a problem at one of our clients. Payments that was applied against one or more invoice, is rejected. We can handle the un-apply, but can we just go to the (Cust. Ledger) table and click on the "Open" field to make the Invoice line open again for future applies, or is there more to the "Open" field?
-
Navision and to-dos
HI ALL, I'm using Nav 3.70. Is it possible to make Navision Synchronize with Outlook calendar of more than ne salesperson per session. I mean... Now Navision synchronize the to-dos using all the data from the salesperson card. But, before all, it verifiies the Navision User ID to recognize who is currently logged in and…
-
Cfront
Is possible to open two database/server connection at a time whit cfront? thanks for your help!
-
TAPI without Windows Dialer
The Standard TAPI uses the Dialer from Windows. Is it possible to connect directly the TAPI Interface without Dialer? Thanks a lot for your response.
-
Problem with filter expression "*.."
Hello, i got a problem with a filter expression: I want to start a report about invoices and filter that report for special invoice-id´s. For example there is an invoice with the number D1503999, another with D1504000, and so on. and i wanted to filter some invoices, so i set a filter like this: D1503*.. And whats the…
-
Format CSV
hello, I export navision data to a CSV file. this works fine, the only problem i have got is formatting data. For example, if i want to export the value 00001 i got in my CSV file 1. So I thougt, lets make all the sheet set as text. But no effect. anybody got a solution ? Thx
-
building reports from a form
Good morning, i want to open a ledger entry report starting from the item card (form). how can i transfer the filters from form to report. Is there any idea ? Thank's in advance Steve
-
A link from Production Order to Sales Order
Hi, The following is the scenario. We have done a customization such that the 'Quantity' field in the Finished production order header updates the 'qty. to ship' in the sales order.so that that we could exactly ship only those items converted as finished production order. But in some cases the production department…
-
import of datas
Hi, I'm using Navision on a shared server (i'm the super user). I'm trying to import a fob with some datas. The system says that I have imported the fob (form, report.....) but when i open them, there aren't any datas. The only way to import some datas is to copy and paste from a local database.................... Any…
-
Fax
Hello, I'm looking for a solution to directly fax Purchase Orders instead of printing them on paper and afterwards sending them one by one on fax. I'm NOT looking for sending a fax by a solution where I need to send it one by one and adding everytime the fax number manually. I want to develop a possibility to send several…
-
OCX generated in Delphi 6 - navision fails at compile time
I've been just started in navision. I made a simple ocx in delphi 6, registered it, and tried to use in navision attain 3.7: - opened an existing code unit - made a global var. type of OCX - set the subtype - tried to compile the unit: navision failed - restart needed i have done the above steps with an other - not self…
-
dataport export into txt file : wrong characters
I've written an export dataport, where I export some item data. When executing the dataport, everything works fine in Navision, but in my txt file, the following occurs: I export for instance the description of an item with value: 10 pièces In my txt file I find: 10 pi??ces. This also happens with the following characters:…
-
How to do "trade-in" in Attain
Q. I want to record "trade-in". I believe that I should record sale of my old item and record purchase of the new one. That's ok. But now I can't apply customer ledger entry to vendor ledger entry to "close" trade in. What shoul I do? Thank you, Timofei.
-
How can I write a application which automaticly run itself
Hi; I want to write a report which works like a listener program. For example; It must run in every 5 minutes by itself, without any control of any user, This report will just read informations from an XML file and import these informations to the navision database; it will work like dataport, Do you have any idea about…
-
Upgrading Navision
Whenever I go through an upgrade of Navision I have to Import all my forms/reports/Tables/Code Units. Is there a way not to have to do that every time? My usual process is ot backup my entire database and then restore it after upgrading. There must be a better way! Thanks
-
Planned Production Order -Manufacturing
Manufacturing queries 1. while creating a planned production order, the due date field in the header is mandatory. what is the process of forward scheduling the job,with a starting date and no end date? 2. Also when scheduling,the system auto calculates the dates taking into account 100% of the machine load . is there any…
-
SQL and Table Locking
Using Navision 3.6 SQL I have a form that is filtered on the Session ID of the each user's session that runs off a common table. For example the Data could look(simplified) like this (primary key is Session, Line): Session --- Line --- Description --- Quantity 24 --- 10000 --- Line 1 --- 10 24 --- 20000 --- Line 2 --- 20…
-
Returning Items With Item Tracking Funcionality
Hello, i want to return a item from a customer, with item tracking funcionality, but when i'm in the Receipt Document, i can't see the original Serial N.º of the Item i send to the customer, to return exactly the same item i send to the customer. I don't want to create a new serial number, but get the original one and…
-
Navision 3.70 Financial Reporting Query
Hi Can anyone help with detailing how Navision 3.70 can best address the following financial period reporting? Requirement for weekly accounting periods based on a Thursday /Wednesday week, and monthly summary accounting periods based on four or five weeks. All Navision enquiries and reports to reflect these accounting…
-
Using same Ext Doc No twice on sales invoicing
Hi all, Is it possible to use the same External Document Number twice when doing sales order invoicing? At the moment the number can be used multiple times when doing shipping, but only once on invoicing. Thanks in advance.
-
Location wise Item Pricing
Can location wise item sales prices can be maintained. If there is any solution please let me know. Or even a work around. Thanks, Ramya
-
How to show a zero which is NOT a default value ?
In a table I have a decimal field. Default value is by system zero. I would like this field to be blank, because we use this field as a result e.g. 0.00. But the default zero is not a result for us. So we will only like to see the zero when we have entered the zero by ourselfes and not the default. Can anyone help ? :wink:
-
Source Code Control
8) I have a SQL trigger set up on the Object table. (note SQL trigger not C/AL trigger) This records the object number, who changed it, when changed and the VersionList (so I can check that we are documenting changes correctly) :arrow: Now I would like to record WHAT was changed inside the code (or even check if any code…
-
Command Line...
Hi all, Is there a guide to all the Navision command-line parameters... I would need to start Navision as a specified user feeding UID and PW from the Command Line. Is it possible? Is it possible to start a codeunit or a batch job from the command line and then quit Navision? Your help would be very very Appreciated... Bye…
-
Inserting Sales Order when form + subform non-editable
Hope someone can help with this.... I have set the Sales Order form and subform to be editable only when the order is open. To achieve this I call the following SETEDITABLE function IF Status = Status::Open THEN BEGIN CurrForm.EDITABLE := TRUE; CurrForm.SalesLines.EDITABLE := TRUE; END ELSE BEGIN CurrForm.EDITABLE :=…
-
Conditional Labels In a Report
I am working on creating a new invoice which will have three labels: Unit Price Base, Discount, and Unit Price. The Unit Price Base is the selling price, the discount is the discount and the Unit Price is the net of the two. I am trying to set it up to only show the Unit Price Base and Discount if there is an item on the…