-
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…
-
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?
-
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…
-
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?…
-
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
-
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?
-
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…
-
How to format a decimal into a string?
hi!... new to navision here... in C/AL code, how will i format a number with data type of decimal into a string?... the output should be a string and should always have 2 decimal places... for example: the output of 5 should be 5.00 (in string) thanks in advance for your help! :D
-
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…
-
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
-
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…
-
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…
-
E-mail Logging using MS Exchange
I have setup the mail logging facility as specified in the White paper and have also setup a rule in outlook to copy the mail from a specific mail address into the public folder/Queue folder(I am not using NAS) I would like to know whether Navision 3.60 retrieves the mail by itself from this queue folder ? if yes then…
-
data model navision
I got a question. At the moment we have limited insight in the data adminstration of navision. We're looking for an ERD or anything in which we get an idea of how the data is structured. Does anyone know where you can get something like this. Maybe some of you have made such a thing for parts of Navision. I'm happy with…
-
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…
-
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…
-
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…
-
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…
-
SMTP-Mail Error 10035 bad recipient
Hello, i have a problem with the smtpmail 1.6. we have lotus notes as smtpmail server and a second Smtpmailserver (linux/firewall) when i send with smtpmail over the linuxbox, i receive only an error when i send to recipients outside our company. when i send with smtpmail over our lotus notes domino server i receive Error…
-
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 &…
-
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.
-
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…
-
Table fields translations
Does anyone know in which table navision stores translations of table fields. Any advice welcome. :roll:
-
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…
-
IC ERROR 11 - Journal is Not Supported, Dataport ERROR Help
Please Help, I was creating a simple DataPort for General Journal Batch in Navision 3.60A. I imported a CSV file into Navision using some global variables, everything works fine(Everything Imports), but when I tryed to import text into the InterCompany field, I got that IC Error 11 - Journal is not supported in this…