-
ODBC & MS Access
Hello, We use Navision 3.7. We do some custom reports pulling the Navision data into Access using CODBC 3.7. We have one problem with this process and hope someone can help us. We are unable to filter on dates using any of the standard Access data operands such as Between or > or <. We get an error "Invalid operand for…
-
Exchanging data between a form and a code-unit
I need to make a form where I can pass parameters to (that's no problem) and that can give the result back to the code-unit. The form should look exactly like the confirm dialog form of Navision, so I just want to know if the user pressed the OK button or the Cancel Button. If I call the form with form.runmodal it's not a…
-
migrate.fob
Hi, I have Navision 2.5 and 3.6. CD's don't have migrate.fob tool. I need an advice where I can find it migrate.fob? Thank you
-
How to integrate a S&OP Game plan ?
Hello, I try to understand clearly how to integrate a S&OP game plan within Navision. Actualy, I receive only partial answers from my Navision partner. Where to put sales forecast ? How to link sales backlog and sales forecasts (demand forecast) to a production forecast plan ? You see, these are basic questions, but the…
-
Link between cost of Salesperson and Customer????
My client has a request: to follow and track the cost of his salespeople (gas, cell phone...) per customer. For example: dedicated personnel does business with certain customer. They want to record all of the expensess occured, so later on they can do the analysis of profitability of the customer. Like, how much did the…
-
How to create a reservation on a requisition line
Within Navision Attain 3.60 we use reservations. I setup every item with reservation set to 'Always'. After inserting a new salesorder-line, the system reserves from current inventory first. When all available items are sold or reserved, reservation is made from existing purchase orders. In our former Navision 2.50 version…
-
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…
-
fifo costing
hi, i've just checked a customer,version 3.6, using fifo costing. bought 1 item A @ $10 bought 2 item A @ $4 each checked the average cost on the item card: $10 i ran the ajust cost the average cost was changed to $6 sold 2 items. ran ajdust cost.. the average cost should be 4 as the costing method is Fifo. seems to be the…
-
Hotcopy needs 29 hours for Backup of 40GB C/SIDE
Hi, Our Goal was to configure an "Optimum Performance System" for 40 GB C/SIDE Database, so that's what we use: Configuration: Attain 3.60 Database: C/SIDE 40GB, 78% Used split into 5 database files (*.fdb) of 8GB each. Each database file resides exclusive on a RAID1 array of 2x36GB HD (that's 10 Hardisks!) System has 4GB…
-
cyrilic characters in code field
We are doing an implementationin Bulgaria (W1 version). The cyrillic characters are ok in the text fields. But when typing a character in a code field (for example a searchname) the characters are changed (in something unreadable words) when leaving the field. It was also tested ona Bulgarian pc, with all the bulgarian…
-
Requisition Worksheets
We are using Navision 3.7, and find that the Requisition worksheet will only pull in items which are present on sales orders or purchase orders. We have our re-order policy set to Fixed Reorder Quantity, a reorder quantity in the field, units of measure, etc. Nothing comes up unless it there is demand. What are we doing…
-
Automation Data Type
I am having some trouble defining a variable as data type Automation. When I go to the global variables and look at the available datatypes Automation doesn't exist as an option. Is there a granule that is needed for this? I already have the Report & Dataport Designer, Form Designer, Table Designer, Application Builder &…
-
Table fields translations
Does anyone know in which table navision stores translations of table fields. Any advice welcome. :roll:
-
Date range for previous 7 days
Hi, Does anyone know how to set date range where by i want to access records from the current date to the last 7 days or 9 days. I don't want to manually specify the dates, as i want to use an automated program (expandit Launch Utility). to run a report whereby the script will put the current date minus the last 7 days…
-
Decimal to Fraction
Hi: Does anyone of you have a function to converter a decimal value to fraction?
-
index
Hi, I am new to Navision, we just finished implementation, and I am receiving an error. It is " Indexing 6 in the array is outside of permitted range." Can anyone tell me what this is and how I would fix it? Thanks :)
-
Older Versions of Navision
On the Partner web site ther are no available copies of 2.6 or earlier. Does any one have copies of Nav 2.6, Nav 2.5, 2.01 and 1.2. I am picking up the old clients and I need copies of unmodified databases and assoc. clients. Can anyone help. I would truly be greatful.
-
Pictures on Form
Good Day! I would like to ask if anyone can provide a solution on how I can fit in a picture (coming from the Picture Table) to a form. I saw in a previous post, here in Mibuso, that you can do this particular function by defining in the C/AL Global a temporary variable with BLOB datatype, where you can store the image. My…
-
printing duplex
Hi, I would like to print conditions (I've put them in a Wordfile) on the back side of our invoices ? Any idea ? I have Navision 3.60. Thanx
-
releasing license
I browsed the forum and i see a lot of threads about killing clients. But i have the following problem. The client crashes without releasing the license. When the client creates a new connection, it uses a new license. I want that the non-active connections that use license are freed. But i can't find a way to do that I…
-
Security in Navision
Hi, I want to set security for some users and it works great, only now, i also don't want them to create a new database. the systemobject(userrights) on object 1610(File,Database,New) are there, but they still can select it and create a new one. How can i disable this?
-
Fixed Asset - Picture display
I have been asked to look at bringing pictures into the Fixed Asset - Picture field. Considering we have over 20000 fixed assets though, I'm concerned about what this might mean for the space taken by the database even if most remain empty. I was thinking of using a graphical converter to store the images as JPG and…
-
Prevent Users of changing Report Lists
Good day to everybody. Can u help me please ? I'm trying to prevent some users of making changes (delete or edit) in the reports Lists (for all modules). I found that there is a "Reports - Modify" form (number 281) but i cant find in what permission is. With the "All" permision any user can delete objects from any report…
-
Adj. cost Item Entries - with Average Cost per Item&Loca
I have set up a company with Average cost calc. type = Item & Location & Variant. There are a few locations defined. Adj. cost Item Entries batch does not work as it shouls in this situation. Example: 10 Oct Receipt (Purchase) in Location X of Item 1 with costing method Average Cost (same posting date) 15 Oct Receipt…
-
Newbie here...storing and passing a value from/to dataports
After exporting information to an external file via a dataport I want to store the last entry id number. This stored value will be recalled when the same dataport is executed a second time to filter out records already exported. A detail explanation of how to accomplish this will be much appreciated. Thanks :P
-
Starting a function automatically when form opens
Hello, I've recently discoved the ability to URL launch a form. What I want to do is have a user function on that form start when I URL activate the form. Currently, the form has a button that the user clicks which has a call to the function. If I URL launch the form, I'm having issues when trying to call the function…
-
Technical question
Hi to all and thanks in advance for your attention and help... I have a technical question about Navision.. What happens when i specify a "Job No." in a Purchase Order Subform line and post the order? And instead what happens when i simply specify a Purchase Order Subform line and DON'T specify the "Job No." in the line,…
-
Call center for Navision
Our potential customer is lookking for a call center support application within Navision 3.60. The cusomer offers telemarketing services and would like to share their database with their customers. If anyone knows of an existing solution, please let me know.
-
NAS : Error 1 in module 5
Is anyone familiar with this kind of error in the application log ? What is Error 1, and, where do I find module 5 ? Event Type: Error Event Source: Period Event Category: None Event ID: 109 Date: 28-10-04 Time: 11:30:00 AM User: N/A Computer: BARNEY_RUBBLE Description: Internal error 1 in module 5. Contact your dealer if…
-
Need help with Text boxes
Hi folks, I already watched the solution out by myself, but YI don`t know how to delete this message. I would like to place a value in a textbox. Right now, a value is calculated via C/AL in the OnAcativate() Trigger of the textbox. But I have to use the Message function to display the value to the user. Instead, I would…